1、先编写html页面<!DOCTYPE htm盟敢势袂l><html><head><met锾攒揉敫a charset="UTF-8"><title>Insert title here</title></head><body><div><form action="add" method="post"><fieldset><legend>添加员工</legend>姓名：<input type="text" name="name"><br>年龄：<input type="text" name="age"><br>工资：<input type="text" name="sal"><br><input type="submit" value="提交"></fieldset></form></div></body></html>
2、public class add extends HttpServlet {// 继承HttpServlet类protected void service(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setContentType("text/html;charset=utf-8");PrintWriter out = response.getWriter();
3、// 获取参数String name = request.getParameter("name");// postname = new String(name.getBytes("iso-8859-1"), "utf-8");int age = Integer.parseInt(request.getParameter("age"));Double sal = Double.parseDouble(request.getParameter("sal"));addEmp(name,age,sal);//重定向response.sendRedirect("show");System.out.println("添加成功");out.close();}
4、public static void addEmp(String name,int age,double sal) {Connection con=null;PreparedStatement pstm=null;ResultSet rs=null;String sql="insert into t_emp value(?,?,?)";try {数据库连接con=DBUtil.getConnection();编译sql语句pstm=con.prepareStatement(sql);pstm.setString(1, name);
5、pstm.setInt(2, age);pstm.setDouble(3, sal);pstm.executeUpdate();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}
6、编写xml文件<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"version="2.4"><servlet><servlet-name>add</servlet-name><servlet-class>web.add</servlet-class></servlet><servlet-mapping><servlet-name>add</servlet-name><url-pattern>/add</url-pattern></servlet-mapping><servlet><servlet-name>emp</servlet-name><servlet-class>web.Emp</servlet-class></servlet><servlet-mapping><servlet-name>emp</servlet-name><url-pattern>/show</url-pattern></servlet-mapping></web-app>
