java中servlet处理页面的修改
1、首先建立一个html文件，用来添加员工
<!DOCTYPE html><html><head><meta 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){ Connection 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); } }}
