📄 updateservlet.java~6~
字号:
package iterp;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import iterp.conpack.ExecData;public class UpdateServlet extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GBK"; private ExecData mybe=null; //Initialize global variables public void init() throws ServletException { } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String proid=new String(request.getParameter("proid").getBytes("8859_1"),"gb2312"); String starttime1=request.getParameter("select2");//年 开始时间 String starttime2=request.getParameter("select3");//月 开始时间 String starttime3=request.getParameter("select4");//日 开始时间 String endtime1=request.getParameter("select5");//年 结束时间 String endtime2=request.getParameter("select6");//月 结束时间 String endtime3=request.getParameter("select7");//日 结束时间 String starttime=""+starttime1+"-"+starttime2+"-"+starttime3;//进行字符串连接 String endtime=""+endtime1+"-"+endtime2+"-"+endtime3;//进行字符串连接 String promemo=new String(request.getParameter("promemo").getBytes("8859_1"),"gb2312"); String select=new String(request.getParameter("select").getBytes("8859_1"),"gb2312"); String xmcy=new String(request.getParameter("xmcy").getBytes("8859_1"),"gb2312"); response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>UpdateServlet</title></head>"); mybe=new ExecData();//声明并初始化Bean的对象 out.println("<body bgcolor=\"#ffffff\">"); String s=("update proid set starttime='"+starttime+"',endtime='"+endtime+"',promemo='"+promemo+"',xmfzr='"+select+"',xmcy='"+xmcy+"' where proid='"+proid+"'"); try{ java.util.Date date=new java.util.Date(); String userName1=null;//定义操作人员变量 userName1=request.getSession().getAttribute("name").toString();//对操作人员变量赋值 String opTime=date.toString();//操作日期 String opModel="项目更改";//操作模块 int i=mybe.getUpdate(s,userName1,opTime,opModel); if(i==0) { //out.println("更新失败!"); out.println("<script>"); out.print("alert(\"数据重复更新失败！\");"); out.print("window.location=\"xmgl_xmgg.jsp\";"); out.println("</script>"); } else { //out.println("更新成功!"); out.println("<script>"); out.print("alert(\"更新成功！\");"); out.print("window.location=\"xmgl_xmgg.jsp\";"); out.println("</script>"); } } catch(Exception e){e.printStackTrace();}; out.println("</body></html>"); //out.println("<input type=\"button\" name=\"Submit\" value=\"返回\" onclick=\"fanhui()\">"); //out.println("</input>"); } //Process the HTTP Post request public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } //Clean up resources public void destroy() { mybe.close(); }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -