1、首先建立一个html文件，用来添加员工<!DOCTYPE html><html><head><m髫潋啜缅eta charset="UTF-8"><title>Insert title here</title></head><body><div>跳转地址以及提交方式<form action="addEmp" 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="提交"><br> </fieldset></form></div></body></html>
2、package web;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;
3、public class AddEmp extends HttpServlet{继承Httpservlet类或者实现servlet接口protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//web服务器的默认编码格式是iso-8859-1，为解决乱码问题，设置格式 request.setCharacterEncoding("utf-8");
4、//决定浏览器将以什么形式、什么编码读取这个文件 response.setContentType("text/html;charset=utf-8"); PrintWriter out=response.getWriter();//获取参数name对应的值 String name=request.getParameter("name");
5、 int age=Integer.parseInt(request.getParameter("age")); double sal=Double.parseDouble(request.getParameter("sal")); add(name,age,sal);//重定向，处理完逻辑后跳转路径 response.sendRedirect("listEmp");//out.println("添加成功！"); out.close();}
6、//数据库处理添加员工public static void add(String name,int age ,double sal){Co荏鱿胫协nnection con=null;PreparedStatement pstm=null;String sql=null;try {con=DBUtil.getConnection();sql="insert into t_emp(name,age,sal)values(?,?,?)";pstm=con.prepareStatement(sql);pstm.setString(1, name);pstm.setInt(2, age);pstm.setDouble(3, sal);pstm.executeUpdate();} catch (SQLException e) {System.out.println("连接异常");}finally{DBUtil.closeConnection(con);}}}
