记得要加上数据库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>