为员工管理添加增加、删除和修改的功能,即在查询结果页面中提供删除、修改的操作链接,并实现在删除或修改后回到查询页面的效果。如下图所示:
步骤
step1: 添加ListEmpServlet,添加删除链接、修改链接和添加链接
代码如下:
package web;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ListEmpServlet extends HttpServlet{
protected void service(HttpServletRequest request,
HttpServletResponse response)
throws ServletException,IOException{
//保证正确读取Post提交来的中文
request.setCharacterEncoding("utf-8");
//保证正确输出中文
response.setContentType("text/html;charset=utf-8");
//获取输出流对象,并输出信息
PrintWriter out=response.getWriter();
//获取表单提交的数据
//String name= request.getParameter("name");
//double salary = Double.valueOf(request.getParameter("salary"));
//int age = Integer.valueOf(request.getParameter("age"));
//将数据插入到数据库t_emp表中
Connection conn = null;
PreparedStatement stat=null;
try {
//1、加载MySQL的JDBC的驱动
Class.forName("com.mysql.jdbc.Driver");
//2、取得连接的URL,能访问MySQL数据库的用户名和密码
String url="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";
String username = "root";
String password = "123456";
//3、创建与MySQL数据库的连接类的实例
conn=DriverManager.getConnection(url,username,password);
stat=conn.prepareStatement("select * from t_emp");
ResultSet rs = stat.executeQuery();
//4、输出表格之前的页面标记
out.println("<HTML>");
out.println("<HEAD></HEAD>");
out.println("<BODY style='font-size:30px'>");
out.println("<table border='1' cellpadding='0'"+
"cellspacing='0' width='600px'");
out.println("<tr><caption>员工信息列表</caption></tr>"); //定义表格标题
out.println("<tr><td>编号</td><td>姓名</td><td>薪水</td>"+
"<td>年龄</td><td> 操作</td></tr>");
//3、遍历结果集,以表格形式输出数据
while(rs.next()){
int id=rs.getInt("id");
String name=rs.getString("name");
double salary=rs.getDouble("salary");
int age=rs.getInt("age");
out.println("<tr>");
out.println("<td>"+id+"</td>");
out.println("<td>"+name+"</td>");
out.println("<td>"+salary+"</td>");
out.println("<td>"+age+"</td>");
out.println("<td><a href='delete?id="+id+"' "+
"onclick=\"return confirm('是否确定删除"+name+"');\">删除</a>");
out.println("<a href='load?id="+id+"'>修改</a></td>");
out.println("</tr>");
}
out.println("</table>");
out.println("<a href='addEmp.jsp' style='font-size:20px'>>>添加员工信息</a></td>");
out.println("<