📄 compservlet.java
字号:
list=dao.mohuselect(strmohu);
else list=null;
request.setAttribute("allcomp", list);
request.getRequestDispatcher("comp.jsp").forward(request, response);
}
else if(select.equalsIgnoreCase("11"))
{
String like=request.getParameter("LIKE");
if(like.equalsIgnoreCase("UserUnit"))
{
String strcount="select UserUnit,count(ID) from comp group by UserUnit";
list=dao.count(strcount,1);
request.setAttribute("countcomp", list);
request.getRequestDispatcher("compcount1.jsp").forward(request, response);
}
else if(like.equalsIgnoreCase("HouseID"))
{
String strcount="select HouseID,count(ID) from comp group by HouseID";
list=dao.count(strcount,2);
request.setAttribute("countcomp", list);
request.getRequestDispatcher("compcount.jsp").forward(request, response);
}
}
else if(select.equalsIgnoreCase("12"))
{
String Unit=change.getString(request.getParameter("Unit"));
String NumberID=request.getParameter("NumberID");
bankapply bvo=new bankapply();
bvo.setNumberID(NumberID);
list.add(bvo);
request.setAttribute("Unit", Unit);
request.setAttribute("writeapply", list);
request.getRequestDispatcher("compwriteapply.jsp").forward(request, response);
}
else if(select.equalsIgnoreCase("13"))
{
String Unit=change.getString(request.getParameter("Unit"));
String NumberID=request.getParameter("NumberID");
String ApplyWorker=change.getString(request.getParameter("ApplyWorker"));
String Talk=change.getString(request.getParameter("Talk"));
System.out.println(ApplyWorker);
System.out.println(Talk);
bankapply bvo=new bankapply();
bvo.setNumberID(NumberID);
bvo.setApplyWorker(ApplyWorker);
bvo.setApplyReason(Talk);
dao.applyinsert(bvo);
request.setAttribute("Unit", Unit);
request.getRequestDispatcher("compapply.jsp").forward(request, response);
}
else if(select.equalsIgnoreCase("14"))
{
String NumberID=request.getParameter("NumberID");
bankapply bvo=new bankapply();
bvo.setNumberID(NumberID);
list=dao.applyselect(NumberID);
request.setAttribute("detailapply", list);
request.getRequestDispatcher("compdetailapply.jsp").forward(request, response);
}
else if(select.equalsIgnoreCase("15"))
{
String NumberID=request.getParameter("NumberID");
bankapply bvo=new bankapply();
bvo.setNumberID(NumberID);
dao.applydelete(NumberID);
request.getRequestDispatcher("compapply.jsp").forward(request, response);
}
else if(select.equalsIgnoreCase("16"))
{
String NumberID=request.getParameter("NumberID");
dao.applydelete(NumberID);
dao.compstateupdate(NumberID);
request.getRequestDispatcher("compselectapply.jsp").forward(request, response);
}
else if(select.equalsIgnoreCase("17"))
{
String NumberID=request.getParameter("NumberID");
String Talk=change.getString(request.getParameter("TALK"));
bankapply bvo=new bankapply();
bvo.setNumberID(NumberID);
bvo.setRejectReason(Talk);
dao.applyupdate(bvo);
request.getRequestDispatcher("compselectapply.jsp").forward(request, response);
}
else if(select.equalsIgnoreCase("18"))
{
String str=request.getParameter("LIKE");
String strname=request.getParameter("strname");
String Unit=change.getString(request.getParameter("Unit"));
System.out.println(Unit);
if(str.equalsIgnoreCase("NumberID"))
{
vo.setNumberID(strname);
list=dao.select(vo, str);
}
else if(str.equalsIgnoreCase("ComputerType"))
{
vo.setComputerType(strname);
list=dao.select(vo, str);
}
else if(str.equalsIgnoreCase("UserID"))
{
vo.setUserID(strname);
list=dao.select(vo, str);
}
else if(str.equalsIgnoreCase("UserUnit"))
{
strname=change.getString(strname);
vo.setUserUnit(strname);
list=dao.select(vo, str);
}
request.setAttribute("allcomp", list);
System.out.println(list.size());
request.setAttribute("Unit", Unit);
request.getRequestDispatcher("sanjicomp.jsp").forward(request,response);
}
else if(select.equalsIgnoreCase("19"))
{
String str=request.getParameter("LIKE");
String strname=request.getParameter("strname");
String Unit=change.getString(request.getParameter("Unit"));
System.out.println(Unit);
if(str.equalsIgnoreCase("NumberID"))
{
vo.setNumberID(strname);
list=dao.select(vo, str);
}
else if(str.equalsIgnoreCase("ComputerType"))
{
vo.setComputerType(strname);
list=dao.select(vo, str);
}
else if(str.equalsIgnoreCase("UserID"))
{
vo.setUserID(strname);
list=dao.select(vo, str);
}
else if(str.equalsIgnoreCase("UserUnit"))
{
strname=change.getString(strname);
vo.setUserUnit(strname);
list=dao.select(vo, str);
}
request.setAttribute("allcomp", list);
System.out.println(list.size());
request.setAttribute("Unit", Unit);
System.out.println(Unit);
request.getRequestDispatcher("sijicomp.jsp").forward(request,response);
}
else if(select.equalsIgnoreCase("20"))
{
String NumberID=request.getParameter("NumberID");
String ComputerType=request.getParameter("ComputerType");
String IPAddress=request.getParameter("IPAddress");
String UserName=change.getString(request.getParameter("UserName"));
String BuyTimestart=request.getParameter("BuyTimestart");
String BuyTimeend=request.getParameter("BuyTimeend");
String UseTimestart=request.getParameter("UseTimestart");
String UseTimeend=request.getParameter("UseTimeend");
String Unit=change.getString(request.getParameter("Unit"));
String strmohu="select * from comp where ";
String strmohu1="select * from comp where ";
if(!NumberID.equals(""))
{
strmohu+="NumberID like '%"+NumberID+"%'";
}
if(!ComputerType.equals(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="ComputerType like '%"+ComputerType+"%'";
else
strmohu+=" and ComputerType like '%"+ComputerType+"%'";
}
if(!IPAddress.equals(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="IPAddress like '%"+IPAddress+"%'";
else
strmohu+=" and IPAddress like '%"+IPAddress+"%'";
}
if(!UserName.equals(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="UserName like '%"+UserName+"%'";
else
strmohu+=" and UserName like '%"+UserName+"%'";
}
if(!BuyTimestart.equalsIgnoreCase(""))
if(!BuyTimeend.equalsIgnoreCase(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="BuyTime between '"+BuyTimestart+"' and '"+BuyTimeend+"'";
else
strmohu+=" and BuyTime between '"+BuyTimestart+" 00:00:00.0' and '"+BuyTimeend+" 00:00:00.0'";
}
System.out.println(strmohu);
if(!UseTimestart.equalsIgnoreCase(""))
if(!UseTimeend.equalsIgnoreCase(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="UseTime between '"+UseTimestart+" 00:00:00.0' and '"+UseTimeend+" 00:00:00.0'";
else
strmohu+=" and UseTime between '"+UseTimestart+" 00:00:00.0' and '"+UseTimeend+" 00:00:00.0'";
}
if(!strmohu.equalsIgnoreCase(strmohu1))
list=dao.mohuselect(strmohu);
else list=null;
request.setAttribute("allcomp", list);
request.setAttribute("Unit", Unit);
request.getRequestDispatcher("sanjicomp.jsp").forward(request, response);
}
else if(select.equalsIgnoreCase("21"))
{
String NumberID=request.getParameter("NumberID");
String ComputerType=request.getParameter("ComputerType");
String IPAddress=request.getParameter("IPAddress");
String UserName=change.getString(request.getParameter("UserName"));
String BuyTimestart=request.getParameter("BuyTimestart");
String BuyTimeend=request.getParameter("BuyTimeend");
String UseTimestart=request.getParameter("UseTimestart");
String UseTimeend=request.getParameter("UseTimeend");
String Unit=change.getString(request.getParameter("Unit"));
String strmohu="select * from comp where ";
String strmohu1="select * from comp where ";
if(!NumberID.equals(""))
{
strmohu+="NumberID like '%"+NumberID+"%'";
}
if(!ComputerType.equals(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="ComputerType like '%"+ComputerType+"%'";
else
strmohu+=" and ComputerType like '%"+ComputerType+"%'";
}
if(!IPAddress.equals(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="IPAddress like '%"+IPAddress+"%'";
else
strmohu+=" and IPAddress like '%"+IPAddress+"%'";
}
if(!UserName.equals(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="UserName like '%"+UserName+"%'";
else
strmohu+=" and UserName like '%"+UserName+"%'";
}
if(!BuyTimestart.equalsIgnoreCase(""))
if(!BuyTimeend.equalsIgnoreCase(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="BuyTime between '"+BuyTimestart+"' and '"+BuyTimeend+"'";
else
strmohu+=" and BuyTime between '"+BuyTimestart+" 00:00:00.0' and '"+BuyTimeend+" 00:00:00.0'";
}
System.out.println(strmohu);
if(!UseTimestart.equalsIgnoreCase(""))
if(!UseTimeend.equalsIgnoreCase(""))
{
if(strmohu.equalsIgnoreCase(strmohu1))
strmohu+="UseTime between '"+UseTimestart+" 00:00:00.0' and '"+UseTimeend+" 00:00:00.0'";
else
strmohu+=" and UseTime between '"+UseTimestart+" 00:00:00.0' and '"+UseTimeend+" 00:00:00.0'";
}
if(!strmohu.equalsIgnoreCase(strmohu1))
list=dao.mohuselect(strmohu);
else list=null;
request.setAttribute("allcomp", list);
request.setAttribute("Unit", Unit);
request.getRequestDispatcher("sijicomp.jsp").forward(request, response);
}
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void init() throws ServletException {
// Put your code here
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -