记得要加上数据库jar
Employee.java:
package com.atguigu.withsql;
public class Employee { private int id; private String name; private String sex; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; }}
DBCon.java:
public class DBCon { private static Connection conn=null; public static Connection getConn() { try { Class.forName("com.mysql.jdbc.Driver"); String user="root"; String pwd="admin"; String url="jdbc:mysql://localhost:3309/te"; conn=DriverManager.getConnection(url,user,pwd); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn; } }
EmployeeDao.java:
public class EmployeeDao { public static EmployeeDao instance=null; public static EmployeeDao getInstance() { if(instance==null) { instance=new EmployeeDao();//建立一个对象,,保证单例 } return instance; } public boolean saveEmployee(Employee emp) { boolean result=false; Connection con=null; try { con=DBCon.getConn(); String sql="insert into Employee(id,name,sex)values(?,?,?)"; PreparedStatement stmt=con.prepareStatement(sql); stmt.setInt(1, emp.getId()); stmt.setString(2, emp.getName()); stmt.setString(3, emp.getSex()); int i=stmt.executeUpdate(); if(i==1) { result=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return result; } }
charu.jsp:
<body> <form action="<%=request.getContextPath()%>/InsertServlet" method="post"> <table align="center"> <tr> <td colspan="3" align="center"> <b>录入员工信息</b> </td> </tr> <tr> <td>员工号:</td> <td><input type="text" name="id"/></td> </tr> <tr> <td>姓名:</td> <td><input type="text" name="name"/></td> </tr> <tr> <td>性别:</td> <td><input type="text" name="sex"/></td> </tr> <tr> <td colspan="3" align="center"> <input type="submit" value="submit"/> </td> </tr> </table> </form> </body> </html>
InsertServlet .java:
public class InsertServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String ID=request.getParameter("id"); int id=Integer.parseInt(ID); String name=request.getParameter("name"); String sex=request.getParameter("sex"); Employee emp=new Employee(); emp.setId(id); emp.setName(name); emp.setSex(sex); boolean s=EmployeeDao.getInstance().saveEmployee(emp); if(s==true) { System.out.println("录入信息成功！"); } else{ System.out.println("录入信息失败。"); } } }
web.xml
<filter> //filter见前一篇 <filter-name>CharactorFilter</filter-name> <filter-class>com.atguigu.charactor.CharactorFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>CharactorFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping>
<servlet> <servlet-name>InsertServlet</servlet-name> <servlet-class>com.atguigu.withsql.InsertServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>InsertServlet</servlet-name> <url-pattern>/InsertServlet</url-pattern> </servlet-mapping>
