DeleteAction
package com.sjsq.servlet; import com.sjsq.dao.CourseDao; import com.sjsq.dao.JoinDao; import com.sjsq.dao.UserDao; import javax.servlet.ServletException; import javax.servlet.annotation.MultipartConfig; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.PrintWriter; import java.sql.SQLException; @WebServlet("/DeleteAction") @MultipartConfig public class DeleteAction extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); PrintWriter out = resp.getWriter(); String ope = req.getParameter("ope"); if (ope.equals("userdel")) { // 删除用户 String user_id = req.getParameter("user_id"); UserDao userDao = new UserDao(); if (userDao.DelUser(user_id) == 1) { out.println("<script> alert('删除成功'); location='toaudit.jsp'; </script>"); } else { out.println("<script> alert('删除失败'); location='toaudit.jsp'; </script>"); } } else if (ope.equals("useradd")) { // 用户审核 String user_id = req.getParameter("user_id"); UserDao userDao = new UserDao(); try { if (userDao.Check(user_id) == 1) { out.println("<script> alert('审核通过'); location='toaudit.jsp'; </script>"); } else { out.println("<script> alert('操作失败'); location='toaudit.jsp'; </script>"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); out.println("<script> alert('操作失败'); location='toaudit.jsp'; </script>"); } } else if (ope.equals("coursedel")) { // 课程删除 String c = req.getParameter("course_id"); String type = req.getParameter("type"); int course_id = Integer.valueOf(c); CourseDao courseDao = new CourseDao(); if (courseDao.DelCourse(course_id) == 1) { if (type.equals("admin")) { out.println("<script> alert('课程删除成功'); location='show_all_courses.jsp'; </script>"); } else { out.println("<script> alert('课程删除成功'); location='my_courses.jsp'; </script>"); } } else { if (type.equals("admin")) { out.println("<script> alert('课程删除失败'); location='show_all_courses.jsp'; </script>"); } else { out.println("<script> alert('课程删除失败'); location='my_courses.jsp'; </script>"); } } } else if (ope.equals("joindel")) { // 退出选课 String c = req.getParameter("course_id"); String user_id = req.getParameter("user_id"); int course_id = Integer.valueOf(c); String from_ = req.getParameter("from_"); JoinDao joinDao = new JoinDao(); if (joinDao.Delete(course_id, user_id) == 1) { out.println("<script> alert('退出成功'); location='" + from_ + "'; </script>"); } else { out.println("<script> alert('退出失败'); location='" + from_ + "'; </script>"); } } } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { super.doPost(req, resp); } }
LoginAction
package com.sjsq.servlet; import com.sjsq.bean.User; import com.sjsq.dao.UserDao; import javax.servlet.ServletException; import javax.servlet.annotation.MultipartConfig; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.PrintWriter; import java.sql.SQLException; @WebServlet("/LoginAction") @MultipartConfig public class LoginAction extends HttpServlet { private static final long serialVersionUID = 1L; public LoginAction() { super(); } @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { resp.sendRedirect("login.jsp"); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); PrintWriter out = resp.getWriter(); String user_id = req.getParameter("inputUser_id"); // 从name属性中获取 String userPass = req.getParameter("inputPassword"); User user = new User(); user.setId(user_id); user.setPassword(userPass); UserDao userDao = new UserDao(); User user2; try { user2 = userDao.Query(user); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); out.println("<script> alert('登陆失败'); location='login.jsp'; </script>"); return; } if ((user2.getId()).equals("")) { // 用户不存在 out.println("<script> alert('用户不存在'); location='login.jsp'; </script>"); } else if (user2.getPassword().equals(userPass)) { // 登陆成功 req.getSession(true).setAttribute("User", user2); out.println("<script> alert('登陆成功'); location='index.jsp'; </script>"); } else { // 密码错误 out.println("<script> alert('密码错误'); location='login.jsp'; </script>"); } } }
LogoutAction
package com.sjsq.servlet; 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 javax.servlet.http.HttpSession; import java.io.IOException; @WebServlet("/LogoutAction") public class LogoutAction extends HttpServlet { private static final long serialVersionUID = 1L; public LogoutAction() { super(); } @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { HttpSession session = req.getSession(false); if (session == null) { resp.sendRedirect("login.jsp"); return; } session.removeAttribute("User"); resp.sendRedirect("login.jsp"); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doGet(req, resp); } }
MulAction
package com.sjsq.servlet; import com.sjsq.bean.Join; import com.sjsq.dao.CourseDao; import com.sjsq.dao.JoinDao; import com.sjsq.dao.SigninDao; import com.sjsq.dao.SigninStuDao; import javax.servlet.ServletException; import javax.servlet.annotation.MultipartConfig; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.PrintWriter; @WebServlet("/MulAction") @MultipartConfig public class MulAction extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); PrintWriter out = resp.getWriter(); String ope = req.getParameter("ope"); if (ope.equals("joincreat")) { String c = req.getParameter("course_id"); String user_id = req.getParameter("user_id"); int course_id = Integer.valueOf(c); Join join = new Join(course_id, user_id, "checking"); JoinDao joinDao = new JoinDao(); int result = joinDao.Creat(join); if (result == 2) { out.println("<script> alert('课程已经选过'); location='show_all_courses.jsp'; </script>"); } else if (result == 1) { out.println("<script> alert('加入成功'); location='show_all_courses.jsp'; </script>"); } else { out.println("<script> alert('加入失败'); location='show_all_courses.jsp'; </script>"); } } else if (ope.equals("joinaccept")) { String c = req.getParameter("course_id"); String user_id = req.getParameter("user_id"); int course_id = Integer.valueOf(c); String from_ = req.getParameter("from_"); JoinDao joinDao = new JoinDao(); int result = joinDao.Update(course_id, user_id, "true"); if (result == 1) { out.println("<script> alert('通过成功'); location='" + from_ + "'; </script>"); } else { out.println("<script> alert('通过失败'); location='" + from_ + "'; </script>"); } } else if (ope.equals("signincreat")) { String c = req.getParameter("course_id"); int course_id = Integer.valueOf(c); String from_ = req.getParameter("from_"); SigninDao signinDao = new SigninDao(); int result = signinDao.Creat(course_id); if (result == 1) { SigninStuDao signinStuDao = new SigninStuDao(); CourseDao courseDao = new CourseDao(); int signin_id = signinDao.FindLast(course_id); signinStuDao.Creat(signin_id, course_id); courseDao.Update(course_id, "true"); out.println("<script> alert('签到已开始'); location='" + from_ + "'; </script>"); } else { out.println("<script> alert('开始失败'); location='" + from_ + "'; </script>"); } } else if (ope.equals("signinstop")) { String c = req.getParameter("course_id"); int course_id = Integer.valueOf(c); String from_ = req.getParameter("from_"); CourseDao courseDao = new CourseDao(); int result = courseDao.Update(course_id, "false"); if (result == 1) { SigninDao signinDao = new SigninDao(); signinDao.Update(signinDao.FindLast(course_id)); out.println("<script> alert('签到已停止'); location='" + from_ + "'; </script>"); } else { out.println("<script> alert('停止失败'); location='" + from_ + "'; </script>"); } } else if (ope.equals("signin")) { String stu_id = req.getParameter("stu_id"); String c = req.getParameter("signin_id"); int signin_id = Integer.valueOf(c); String from_ = java.net.URLDecoder.decode(req.getParameter("from_"), "UTF-8"); SigninStuDao signinStuDao = new SigninStuDao(); int result = signinStuDao.Update(signin_id, stu_id, "true"); if (result == 1) { SigninDao signinDao = new SigninDao(); signinDao.AddNum(signin_id); out.println("<script> alert('签到成功'); location='" + from_ + "'; </script>"); } else { out.println("<script> alert('签到失败'); location='" + from_ + "'; </script>"); } } } }
RegisterAction
package com.sjsq.servlet; import com.sjsq.bean.User; import com.sjsq.dao.UserDao; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.annotation.MultipartConfig; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.PrintWriter; @WebServlet("/RegisterAction") @MultipartConfig public class RegisterAction extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; public RegisterAction() { super(); } @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); RequestDispatcher rd = req.getRequestDispatcher("register.jsp"); rd.forward(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); PrintWriter out = resp.getWriter(); String user_id = req.getParameter("inputUser_id"); String userPass = req.getParameter("inputPassword"); String Confirm = req.getParameter("confirmPassword"); String name = req.getParameter("inputName"); String type = req.getParameter("type"); int flag = 0; for (int i = 0; i < user_id.length(); i++) if (user_id.charAt(i) < '0' || user_id.charAt(i) > '9') flag++; if (flag != 0) { out.println("<script> alert('学号只能含有数字'); location='register.jsp'; </script>"); } else if (!userPass.equals(Confirm)) { out.println("<script> alert('两次密码不相同'); location='register.jsp'; </script>"); } else { User user = new User(user_id, userPass, name, type); UserDao userDao = new UserDao(); int result = userDao.create(user); if (result == 1) { out.println("<script> alert('注册成功'); location='login.jsp'; </script>"); } else { if (result == 0) out.println("<script> alert('注册失败'); location='register.jsp'; </script>"); else out.println("<script> alert('该账号已被注册'); location='register.jsp'; </script>"); } } } }
UpdateUserAction
package com.sjsq.servlet; import com.sjsq.bean.User; import com.sjsq.dao.UserDao; import javax.servlet.ServletException; import javax.servlet.annotation.MultipartConfig; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import java.io.IOException; import java.io.PrintWriter; import java.sql.SQLException; @WebServlet("/UpdateUserAction") @MultipartConfig public class UpdateUserAction extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { super.doGet(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("utf-8"); resp.setContentType("text/html;charset=utf-8"); PrintWriter out = resp.getWriter(); String oldPass = req.getParameter("oldPassword"); String newPass = req.getParameter("newPassword"); String Confirm = req.getParameter("confirmPassword"); if (!newPass.equals(Confirm)) { out.println("<script> alert('两次密码不相同'); location='update_user.jsp'; </script>"); } else { User user = (User) req.getSession().getAttribute("User"); if (!user.getPassword().equals(oldPass)) { out.println("<script> alert('原密码错误'); location='update_user.jsp'; </script>"); } else { UserDao userDao = new UserDao(); int result = 0; try { result = userDao.Update(user.getId(), newPass); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if (result == 1) { HttpSession session = req.getSession(false); session.removeAttribute("User"); out.println("<script> alert('修改密码成功'); location='login.jsp'; </script>"); resp.sendRedirect("login.jsp"); } else { out.println("<script> alert('修改密码失败'); location='update_user.jsp'; </script>"); resp.sendRedirect("update_user.jsp"); } } } } }
四、其他
1.更多系统
Java+JSP系统系列实现
Java+JSP实现学生图书管理系统
Java+JSP实现学生信息管理系统
Java+JSP实现用户信息管理系统
Java+Servlet系统系列实现
Java+Servlet+JSP实现航空订票系统
Java+Servlet+JSP实现新闻发布系统
Java+Servlet+JSP学生宿舍管理系统
Java+Servlet+JSP实现图书管理系统
Java+Servlet+JSP实现停车场管理系统
Java+Servlet+JSP实现房屋租赁管理系统
Java+Servlet+JSP实现学生信息管理系统
Java+Servlet+JSP实现学生选课管理系统
Java+Servlet+JSP实现宠物诊所管理系统
Java+Servlet+JSP实现学生成绩管理系统-1
Java+Servlet+JSP实现学生成绩管理系统-2
Java+SSM系统系列实现
Java+SSM+JSP实现网上考试系统
Java+SSM+JSP实现宠物商城系统
Java+SSM+JSP实现超市管理系统
Java+SSM+JSP实现学生成绩管理系统
Java+SSM+JSP实现学生信息管理系统
Java+SSM+JSP+Maven实现网上书城系统
Java+SSM+JSP+Maven实现学校教务管理系统
Java+SSH系统系列实现
Java+SSH+JSP实现在线考试系统
Java+SSH+JSP实现医院在线挂号系统
Java+Springboot系统系列实现
Java+Springboot+H-ui+Maven实现营销管理系统
Java+Springboot+Bootstrap+Maven实现网上商城系统
Java+Springboot+Bootstrap+Maven实现景区旅游管理系统
1.更多JavaWeb系统请关注专栏。
https://blog.csdn.net/helongqiang/category_10020130.html
https://blog.csdn.net/helongqiang/category_10020130.html
2.更多JavaSwing系统请关注专栏。
https://blog.csdn.net/helongqiang/category_6229101.html
https://blog.csdn.net/helongqiang/category_6229101.html
2.源码下载
sql在sql文件夹下面
Java+Servlet+JSP+Mysql实现Web学生选课签到系统
3.备注
如有侵权请联系我删除。
4.支持博主
如果您觉得此文对您有帮助,请点赞加关注加收藏。祝您生活愉快!