📄 insertservlet.java
字号:
package myBookServlet;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import dao.*;
import Bean.*;
public class InsertServlet 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 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("txtJobTel");
String moblie = request.getParameter("txtMoblie");
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");
myaddressDao dao = new myaddressDao();
String sql = "insert into myaddress values('" + Integer.parseInt(id) + "','" + firstName +
"','" + lastName + "','" + jobTitle + "','" + department +
"','" + Integer.parseInt(teloff) + "','" + Integer.parseInt(moblie) + "','" + email + "')";
int n = dao.InsertInf(sql);
out.println("<html>");
out.println("<head><title>InsertServlet</title></head>");
out.println("<h1>哈哈大笑</h1>");
if (n > 0) {
out.println("<h2>添加成功!</h2>");
response.addHeader("refresh", "3,url=myaddrbook");
} else {
out.println("<h2>添加失败!</h2>");
response.addHeader("refresh", "3,url=myaddrbook");
}
out.println("<body bgcolor=\"#ffffff\">");
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() {
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -