📄 pronumservlet.java
字号:
package com.nextier.web;
import java.io.IOException;
import java.sql.Date;
import java.sql.SQLException;
import java.util.Vector;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.nextier.dao.DAOpronum;
import com.nextier.model.*;
public class pronumServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void service (HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException{
int action= Integer.parseInt(request.getParameter("action"));
System.out.println("action:"+action);
request.setCharacterEncoding("GB2312");
//添加plan_num表信息并对realnum表初始化
if(action==1){
String products_id=null;
if(ParamUtils.getParameter(request, "products_id")!=null){
products_id=ParamUtils.getParameter(request, "products_id");
System.out.println("products_id:"+products_id);
}
String products_name=null;
if(ParamUtils.getParameter(request, "products_name")!=null){
products_name=ParamUtils.getParameter(request, "products_name");
System.out.println("products_name:"+products_name);
}
int plan_num1=0;
if(request.getParameter("plan_num1")!=null){
plan_num1=Integer.parseInt(request.getParameter("plan_num1"));
System.out.println("plan_num1:"+plan_num1);
}
int plan_num2=0;
if(request.getParameter("plan_num2")!=null){
plan_num2=Integer.parseInt(request.getParameter("plan_num2"));
System.out.println("plan_num2:"+plan_num2);
}
int plan_num3=0;
if(request.getParameter("plan_num3")!=null){
plan_num3=Integer.parseInt(request.getParameter("plan_num3"));
System.out.println("plan_num3:"+plan_num3);
}
int plan_num4=0;
if(request.getParameter("plan_num4")!=null){
plan_num4=Integer.parseInt(request.getParameter("plan_num4"));
System.out.println("plan_num4:"+plan_num4);
}
Date date=null;
if(ParamUtils.getParameter(request, "date")!=null){
String date1=request.getParameter("date");
date=SkinUtils.convertToDate(date1);
System.out.println("date:"+date);
}
int real_num1=0;
int real_num2=0;
int real_num3=0;
int real_num4=0;
String instruction1="";
String instruction2="";
String instruction3="";
String instruction4="";
pronum pro=new pronum();
pro.setproducts_id(products_id);
pro.setproducts_name(products_name);
pro.setplan_num1(plan_num1);
pro.setplan_num2(plan_num2);
pro.setplan_num3(plan_num3);
pro.setplan_num4(plan_num4);
pro.setdate(date);
pro.setreal_num1(real_num1);
pro.setreal_num2(real_num2);
pro.setreal_num3(real_num3);
pro.setreal_num4(real_num4);
pro.setinstruction1(instruction1);
pro.setinstruction2(instruction2);
pro.setinstruction3(instruction3);
pro.setinstruction4(instruction4);
DAOpronum pronumDAO=new DAOpronum();
pronumDAO.insert(pro);
//获取plannum表的最大id号
//DAOpronum pronumDAO1=new DAOpronum();
int pid=pronumDAO.queryid();
System.out.println("pid"+pid);
pro.setid1(pid);
//对realnum表进行插入
DAOpronum pronumDAO2=new DAOpronum();
pronumDAO2.insert1(pro);
response.sendRedirect("./plan_num.jsp");
}
//修改plan_num表信息
if(action==2){
String products_id=null;
if(ParamUtils.getParameter(request, "products_id")!=null){
products_id=ParamUtils.getParameter(request, "products_id");
System.out.println("products_id:"+products_id);
}
String products_name=null;
if(ParamUtils.getParameter(request, "products_name")!=null){
products_name=ParamUtils.getParameter(request, "products_name");
System.out.println("products_name:"+products_name);
}
int plan_num1=0;
if(request.getParameter("plan_num1")!=null){
plan_num1=Integer.parseInt(request.getParameter("plan_num1"));
System.out.println("plan_num1:"+plan_num1);
}
int plan_num2=0;
if(request.getParameter("plan_num2")!=null){
plan_num2=Integer.parseInt(request.getParameter("plan_num2"));
System.out.println("plan_num2:"+plan_num2);
}
int plan_num3=0;
if(request.getParameter("plan_num3")!=null){
plan_num3=Integer.parseInt(request.getParameter("plan_num3"));
System.out.println("plan_num3:"+plan_num3);
}
int plan_num4=0;
if(request.getParameter("plan_num4")!=null){
plan_num4=Integer.parseInt(request.getParameter("plan_num4"));
System.out.println("plan_num4:"+plan_num4);
}
Date date=null;
if(ParamUtils.getParameter(request, "date")!=null){
String date1=request.getParameter("date");
date=SkinUtils.convertToDate(date1);
System.out.println("date:"+date);
}
int id=0;
if(request.getParameter("id")!=null){
id=Integer.parseInt(request.getParameter("id"));
System.out.println("id:"+id);
}
pronum pro=new pronum();
pro.setproducts_id(products_id);
pro.setproducts_name(products_name);
pro.setplan_num1(plan_num1);
pro.setplan_num2(plan_num2);
pro.setplan_num3(plan_num3);
pro.setplan_num4(plan_num4);
pro.setdate(date);
pro.setid(id);
DAOpronum pronumDAO=new DAOpronum();
try {
pronumDAO.update(pro);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
response.sendRedirect("./plan_num.jsp");
}
//删除plan_num表信息
if(action==3){
String id1=request.getParameter("id");
int id=Integer.parseInt(id1);
System.out.println("id:"+id);
DAOpronum pronumDAO=new DAOpronum();
pronumDAO.delete(id);
response.sendRedirect("./plan_num.jsp");
}
//查询信息
if(action==5){
Date date=null;
if(ParamUtils.getParameter(request, "date")!=null){
String date1=ParamUtils.getParameter(request, "date");
date=SkinUtils.convertToDate(date1);
System.out.println("date:"+date);
}
String sql="";
sql = "select plan_num.*,real_num.* from plan_num INNER JOIN real_num ON plan_num.id=real_num.pid";
if (date!=null) {
if (sql.indexOf("where") == -1) {
sql = sql + " where plan_num.date1 = '" + date +"'";
} else {
sql = sql + " and plan_num.date1 = '" + date +"'";
}
}
System.out.println(sql);
DAOpronum pronumDAO=new DAOpronum();
Vector vec=pronumDAO.query(sql);
HttpSession session=request.getSession(true);
session.setAttribute("vec",vec);
String flag="T";
//request.setAttribute("flag", flag);
response.sendRedirect("./real_num.jsp?flag="+flag);
}
//修改real_num表信息
if(action==6){
String[] id1=request.getParameterValues("id");
String[] pid=request.getParameterValues("pid");
String[] products_id=request.getParameterValues("products_id");
String[] real_num1=request.getParameterValues("real_num1");
String[] real_num2=request.getParameterValues("real_num2");
String[] real_num3=request.getParameterValues("real_num3");
String[] real_num4=request.getParameterValues("real_num4");
String[] instruction1=request.getParameterValues("instruction1");
String[] instruction2=request.getParameterValues("instruction2");
String[] instruction3=request.getParameterValues("instruction3");
String[] instruction4=request.getParameterValues("instruction4");
int count=id1.length;
System.out.print("count"+count);
for(int i=0;i<count;i++){
int id11=Integer.parseInt(id1[i]);
System.out.println("id11"+id11);
int pid1=Integer.parseInt(pid[i]);
System.out.println("pid1"+pid1);
int real_num11=Integer.parseInt(real_num1[i]);
System.out.println("real_num11"+real_num11);
int real_num22=Integer.parseInt(real_num2[i]);
System.out.println("real_num22"+real_num22);
int real_num33=Integer.parseInt(real_num3[i]);
System.out.println("real_num33"+real_num33);
int real_num44=Integer.parseInt(real_num4[i]);
System.out.println("real_num44"+real_num44);
pronum pro=new pronum();
pro.setid1(id11);
pro.setid(pid1);
pro.setproducts_id(products_id[i]);
pro.setreal_num1(real_num11);
pro.setreal_num2(real_num22);
pro.setreal_num3(real_num33);
pro.setreal_num4(real_num44);
pro.setinstruction1(instruction1[i]);
pro.setinstruction2(instruction2[i]);
pro.setinstruction3(instruction3[i]);
pro.setinstruction4(instruction4[i]);
DAOpronum pronumDAO=new DAOpronum();
try {
pronumDAO.update1(pro);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
response.sendRedirect("./real_num.jsp");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -