📄 updateservlet.java
字号:
package update;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import Bean.*;
import dao.*;
public class UpdateServlet extends HttpServlet {
public UpdateServlet() {
try {
jbInit();
} catch (Exception ex) {
ex.printStackTrace();
}
}
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();
// HttpSession session = request.getSession();
// String uid = (String)(session.getAttribute("id"));
// System.out.println(uid);
//////////////////////////////////////////
String id = request.getParameter("txtid");
String firstName = request.getParameter("txtFirstName");
String lastName = request.getParameter("txtLastName");
String jobTitle = request.getParameter("txtJob");
String department = request.getParameter("txtDepartment");
String teloff = request.getParameter("txtOffTel");
String moblie = request.getParameter("txtMobile");
String email = request.getParameter("txtEmail");
byte [] by=id.getBytes("ISO-8859-1");
id = new String(by,"GBK");
byte []byfName = firstName.getBytes("ISO-8859-1");
firstName = new String(byfName,"GBK");
byte [] bylName = lastName.getBytes("ISO-8859-1");
lastName = new String(bylName,"GBK");
byte [] byJob = jobTitle.getBytes("ISO-8859-1");
jobTitle = new String(byJob,"GBK");
byte [] byMent = department.getBytes("ISO-8859-1");
department = new String(byMent,"GBK");
byte [] byTeloff = teloff.getBytes("ISO-8859-1");
teloff = new String(byTeloff,"GBK");
byte [] byMoblie = moblie.getBytes("ISO-8859-1");
moblie = new String(byMoblie,"GBK");
byte [] byEmail = email.getBytes("ISO-8859-1");
email = new String(byEmail,"GBK");
String sql = "update myaddress set firstname='" + firstName +
"',lastName='" + lastName + "',jobtitle='" + jobTitle +
"',department='" + department + "',offph='" + Integer.parseInt(teloff) +
"',mobile='" + Integer.parseInt(moblie) + "',email='" + email +
"' where id='" + Integer.parseInt(id) + "'";
myaddressDao dao = new myaddressDao();
int n = dao.Update(sql);
out.println("<html>");
out.println("<head><title>UpdateServlet</title></head>");
out.println("<body bgcolor=\"#ffffff\">");
// out.println(id+firstName+lastName+jobTitle+moblie+email);
if (n > 0) {
out.println("<h1>成功更新！</h1>");
out.println("<h2><a href=myaddrbook>回到主页!</a></h2>");
} else {
out.println("<h1>更新失败！</h1>");
out.println("<h2><a href=myaddrbook>回到主页!</a></h2>");
}
response.addHeader("refresh", "5,url=myaddrbook");
out.println("</body>");
out.println("</html>");
out.close();
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request, response);
}
//Clean up resources
public void destroy() {
}
private void jbInit() throws Exception {
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -