增删改servlet的简化
package com.yzr.web.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.yzr.pojo.Student;
import com.yzr.service.StudentService;
import com.yzr.service.impl.StudentServiceImpl;
/**
* Servlet implementation class StuServlet
*/
@WebServlet("/all")
public class StuServlet extends HttpServlet {
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// 防止乱码
req.setCharacterEncoding("UTF-8");
resp.setCharacterEncoding("UTF-8");
resp.setContentType("text/html;charset=utf-8");
String action = req.getParameter("action");
// 判断
if ("add".equals(action)) {
// 获取学生的注册消息
String cname = req.getParameter("cname");
String cpass = req.getParameter("cpass");
// System.out.println("接收到的学生账号是:"+cname);
// 调用业务层操作,将客户信息保存起来
// 将获取的数据封装到一个学生对象中
Student student = new Student(cname, cpass);
StudentServiceImpl studentServiceImpl = new StudentServiceImpl();
boolean add=studentServiceImpl.addStudent(student);
// 通过相应对象获取打印流
PrintWriter writer=resp.getWriter();
if (add) {
writer.write("注册成功");
}else{
writer.write("注册失败 <br><a href='register.jsp'></a>");
}
}else if ("del".equals(action)) {
// 防止乱码
req.setCharacterEncoding("UTF-8");
resp.setCharacterEncoding("UTF-8");
resp.setContentType("text/html;charset=utf-8");
// 获取用户请求的编号
String sid=req.getParameter("sid");
// 调用
StudentService studentserviceimpl = new StudentServiceImpl();
PrintWriter writer=resp.getWriter();
boolean del=studentserviceimpl.deleteStudentBySid(sid);
if (del) {
writer.write("删除成功<br><a href='query'>查询学生信息</a>");
}else{
writer.write("删除失败!");
}
}else if ("query".equals(action)) {
// 调用service业务层实现查询所有的客户信息
StudentServiceImpl studentServiceImpl = new StudentServiceImpl();
List<Student> list=studentServiceImpl.queryAllStudent();
// 将List集合数据回显到页面中
PrintWriter writer=resp.getWriter();
// 通过表格table选择数据
String data="<table align='center' width='80%' border='1px' cellspacing='0px' cellpadding='0px'><tr><th>学生编号</th><th>学生姓名</th><th>学生密码</th><th colspan='2'>操作</th></tr>";
// 表的内容是根据list集合 遍历
for (int i = 0; i <list.size(); i++) {
// 获取每一个学生信息
Student student = list.get(i);
data+="<tr><td>"+student.getSid()+"</td><td>"+student.getName()+"</td><td>"+student.getPassword()+"</td>"+
"<td><a href='del?sid="+student.getSid()+"'>删除</a></td><td><a href='update?sid="+student.getSid()+"'>修改</a></td></tr>";
}
data+="</table>";
writer.write(data);
}
}
}