java页面交互jsp，添加员工到数据库
1、先编写html页面
<!DOCTYPE html><html><head><meta 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"); // post name = 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 block e.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>
