IDEA+Java+Servlet+JSP+Mysql实现学生选课签到系统(下)

本文涉及的产品
云数据库 RDS MySQL Serverless,0.5-2RCU 50GB
云数据库 RDS MySQL Serverless,价值2615元额度,1个月
简介: IDEA+Java+Servlet+JSP+Mysql实现学生选课签到系统

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.支持博主

如果您觉得此文对您有帮助,请点赞加关注加收藏。祝您生活愉快!


相关实践学习
基于CentOS快速搭建LAMP环境
本教程介绍如何搭建LAMP环境,其中LAMP分别代表Linux、Apache、MySQL和PHP。
全面了解阿里云能为你做什么
阿里云在全球各地部署高效节能的绿色数据中心,利用清洁计算为万物互联的新世界提供源源不断的能源动力,目前开服的区域包括中国(华北、华东、华南、香港)、新加坡、美国(美东、美西)、欧洲、中东、澳大利亚、日本。目前阿里云的产品涵盖弹性计算、数据库、存储与CDN、分析与搜索、云通信、网络、管理与监控、应用服务、互联网中间件、移动服务、视频服务等。通过本课程,来了解阿里云能够为你的业务带来哪些帮助 &nbsp; &nbsp; 相关的阿里云产品:云服务器ECS 云服务器 ECS(Elastic Compute Service)是一种弹性可伸缩的计算服务,助您降低 IT 成本,提升运维效率,使您更专注于核心业务创新。产品详情: https://www.aliyun.com/product/ecs
相关文章
|
3天前
|
消息中间件 缓存 Java
java基于云部署的SaaS医院云HIS系统源码 心理CT、B超 lis、电子病历
云HIS系统是一款满足基层医院各类业务需要的健康云产品。该产品能帮助基层医院完成日常各类业务,提供病患预约挂号支持、病患问诊、电子病历、开药发药、会员管理、统计查询、医生工作站和护士工作站等一系列常规功能,还能与公卫、PACS等各类外部系统融合,实现多层机构之间的融合管理。
36 12
|
4天前
|
存储 缓存 前端开发
Java串口通信技术探究3:RXTX库线程 优化系统性能的SerialPortEventListener类
Java串口通信技术探究3:RXTX库线程 优化系统性能的SerialPortEventListener类
19 3
|
8天前
|
监控 Java BI
java基于云计算的SaaS医院his信息系统源码 HIS云平台源码
基于云计算技术的B/S架构的HIS系统源码,SaaS模式Java版云HIS系统,融合B/S版电子病历系统,支持电子病历四级,HIS与电子病历系统均拥有自主知识产权。
31 5
|
11天前
|
Java 关系型数据库 MySQL
基于swing的java物业管理系统
基于swing的java物业管理系统
19 5
|
5天前
|
SQL 关系型数据库 MySQL
【MySQL-3】图形化界面工具DataGrip安装&配置&使用
【MySQL-3】图形化界面工具DataGrip安装&配置&使用
|
5天前
|
关系型数据库 MySQL Linux
【MySQL-2】MySQL的下载&安装&启停&配置环境变量【一条龙教程】
【MySQL-2】MySQL的下载&安装&启停&配置环境变量【一条龙教程】
|
6天前
|
弹性计算 关系型数据库 MySQL
在线安装MySQL5.7和MySQL8.0
【4月更文挑战第30天】
21 0
|
6天前
|
存储 关系型数据库 MySQL
docker安装mysql8忽略大小写
docker安装mysql8忽略大小写
|
6天前
|
Ubuntu 关系型数据库 MySQL
Ubuntu 20.04 + mysql8 安装以及配置大小写不敏感
Ubuntu 20.04 + mysql8 安装以及配置大小写不敏感
|
6天前
|
关系型数据库 MySQL 开发工具
Docker安装mysql8.0
Docker安装mysql8.0