📄 testservlet.java~4~
字号:
package iterp;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import iterp.conpack.ExecData;public class TestServlet extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GBK"; //Initialize global variables public void init() throws ServletException { } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); String proid=new String(request.getParameter("proid").getBytes("8859_1"),"gb2312"); String proname=new String(request.getParameter("proname").getBytes("8859_1"),"gb2312"); String select1=request.getParameter("select1"); String select2=request.getParameter("select2"); String select3=request.getParameter("select3"); String select4=request.getParameter("select4"); String select5=request.getParameter("select5"); String select6=request.getParameter("select6"); String select=new String(request.getParameter("select").getBytes("8859_1"),"gb2312"); String promemo=new String(request.getParameter("promemo").getBytes("8859_1"),"gb2312"); String xmcy=new String(request.getParameter("xmcy").getBytes("8859_1"),"gb2312"); String starttime=""+select1+"-"+select2+"-"+select3; String endtime=""+select4+"-"+select5+"-"+select6; out.println("<html>"); out.println("<head><title>ProidServlet</title></head>"); out.println("<script>"); out.println("function fanhui(){document.location=\"xmgl_xmld.jsp\";}"); out.println("</script>"); request.setCharacterEncoding("gb2312"); ExecData mybe=new ExecData(); out.print(promemo); out.println("<hr>"); String sql2=("select * from proid where proid='"+proid+"'"); //String sql3=("insert into proid values('"+proid+"','"+proname+"','"+select1+"-"+select2+"-"+select3+"','"+select4+"-"+select5+"-"+select6+"',+'"+promemo+"','"+select+"','"+xmcy+"')"); String sql3=("insert into proid values('"+proid+"','"+proname+"','"+starttime+"','"+endtime+"','"+promemo+"','"+select+"','"+xmcy+"')"); System.out.println(sql3); System.out.println("***********"+sql2); System.out.println("************"+sql3); java.util.Date date=new java.util.Date(); String userName=null; userName=request.getSession().getAttribute("name").toString(); String opTime=date.toString(); String opModel="项目立定"; int i=mybe.getInsert(sql2,sql3,userName,opTime,opModel); System.out.println("i=========="+i); if((i==5)||(i==0)) { out.print("记录重复插入失败"); out.println("<h1>"+"记录插入失败!"+i+"</h1>"); } else { out.print("记录插入成功!"); out.println("<h1>"+"记录插入成功!"+i+"</h1>"); } out.println("<hr>"); out.println("<body bgcolor=\"#ffffff\">"); out.println("<input type=\"button\" name=\"Submit\" value=\"返回\" onclick=\"fanhui()\">"); out.println("</input>"); out.println("</body></html>"); } //Process the HTTP Post request public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } //Clean up resources public void destroy() { }}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -