登录学生管理简单部分功能未实现.zip

package com.student.servlet; import java.io.IOException; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.omg.CORBA.PUBLIC_MEMBER; import com.course.bean.Course; import com.course.dao.CourseDao; import com.mysql.cj.conf.PropertyDefinitions.ZeroDatetimeBehavior; import com.student.bean.PageStu; import com.student.bean.Student; import com.student.dao.StudentDao; public class StudentServlet extends HttpServlet { protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String z = req.getParameter("z"); if(z.equals("add")) { this.add(req, resp); }else if(z.equals("query")) { this.query(req,resp); }else if(z.equals("edit")) { this.edit(req,resp); }else if(z.equals("query_dele")) { this.query_dele(req,resp); }else if(z.equals("update")) { this.update(req,resp); }else if(z.equals("select")) { this.select_nas(req, resp); }else if(z.equals("select_page")) { this.select_page(req, resp); } } //按条件查询学生 protected void select_nas(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String name = req.getParameter("stuname"); String age = req.getParameter("stuage"); String sex = req.getParameter("stusex"); StudentDao dao = new StudentDao(); List<Student> ls =dao.selectStudent(name,age,sex); req.setAttribute("list", ls); req.getRequestDispatcher("studentList.jsp").forward(req,resp); } //修改 跳转到 修改页面 protected void edit(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String id = req.getParameter("id"); StudentDao dao = new StudentDao(); Student s = dao.editStudent(id); req.setAttribute("stuedit",s); req.getRequestDispatcher("editstudent.jsp").forward(req,resp); } //查询学生 protected void query(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { StudentDao dao = new StudentDao(); List<Student> ls =dao.queryStudent(); req.setAttribute("list", ls); req.getRequestDispatcher("studentList.jsp").forward(req,resp); } //录入学生 protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String name = req.getParameter("stuname"); String age = req.getParameter("stuage"); String sex = req.getParameter("stusex"); StudentDao dao = new StudentDao(); boolean b = dao.addStu(name, age, sex); this.dispatch(req, resp, b, "录入"); } //删除 protected void query_dele(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { //获取id req.setCharacterEncoding("utf-8"); String id = req.getParameter ("id"); StudentDao dao = new StudentDao(); dao.deleteStudent(id); List<Student> ls =dao.queryStudent(); req.setAttribute("list", ls); req.getRequestDispatcher("studentList.jsp").forward(req, resp); } protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); String stuid = req.getParameter ("stuid"); String name = req.getParameter("stuname"); String age = req.getParameter("stuage"); String sex = req.getParameter("stusex"); Student s =new Student(); s.setStuid(Integer.parseInt(stuid)); s.setStuname(name); s.setStuage(Integer.valueOf(age)); s.setStusex(sex); StudentDao dao = new StudentDao(); boolean b = dao.updateStudent(s); this.dispatch(req, resp, b, "修改"); } //分页 protected void select_page(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { PageStu p = new PageStu(); //接受用户希望显示的页数（pageNow） String s_pageNow=req.getParameter("pageNow"); if(s_pageNow!=null){ //接收到了pageNow p.setPageNow(Integer.parseInt(s_pageNow)); } StudentDao dao = new StudentDao(); List<Student> ls = dao.select_page(p.getPageNow(),p.getPageSize()); int pagecout = dao.select_cout(p.getPageSize()); p.setPageCount(pagecout); req.setAttribute("page", p); req.setAttribute("list", ls); req.getRequestDispatcher("studentList.jsp").forward(req,resp); } protected void dispatch(HttpServletRequest req, HttpServletResponse resp,boolean b,String msg) throws ServletException, IOException { if(!b) { req.setAttribute("message", msg+"失败"); } else { req.setAttribute("message", msg+"学生成功"); } req.getRequestDispatcher("ok.jsp").forward(req, resp); } }