📄 updateservlet.java~11~
字号:
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+"'");
int i=0;
try{
java.util.Date date = new java.util.Date();
String userName1 = null; //定义操作人员变量
userName1 = request.getSession().getAttribute("name").toString(); //对操作人员变量赋值
String opTime = date.toString(); //操作日期
String opModel = "项目更改"; //操作模块
i = mybe.getUpdate(s, userName1, opTime, opModel);
}
catch(Exception e){System.out.print("*********插入数据错误********"); e.printStackTrace();}
if(i==0)
{
//out.println("更新失败!");
out.print("<script>alert(\"数据重复更新失败!\");window.location=\"xmgl_xmgg.jsp\";</script>");
}
else
{
//out.println("更新成功!");
out.print("<script>alert(\"更新成功!\");window.location=\"xmgl_xmgg.jsp\";</script>");
}
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 + -