public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String id, name, belong;
String sql;
String dbID = request.getParameter("formID");
String dbName = request.getParameter("formName");
String dbBelong = request.getParameter("formBelong");
try {
Statement stmt = con.createStatement();
sql = "INSERT INTO SHAIN (ID, NAME, BELONG) VALUES("
+ dbID + ",'" + dbName + "','" + dbBelong + "')";
stmt.executeUpdate(sql);
sql = "SELECT ID, NAME, BELONG FROM SHAIN";
ResultSet rs = stmt.executeQuery(sql);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>Servlet1</title></head>");
out.println("<body>");
out.println("<table border>");
while (rs.next()) {
id = rs.getString("ID");
name = rs.getString("NAME");
belong = rs.getString("BELONG");
out.println("<tr><td>" + id + "<td>" + name + "<td>" + belong);
}
out.println("</table>");
out.println("</body></html>");
out.close();
rs.close();
stmt.close();
} catch (Exception e) {
e.printStackTrace();
}
} |