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

2401_83916030

于 2024-04-23 15:29:58 发布

阅读量602

点赞数 8

分类专栏：程序员文章标签： java intellij-idea servlet

本文链接：https://blog.csdn.net/2401_83916030/article/details/138128020

版权

程序员专栏收录该内容

349 篇文章 0 订阅

订阅专栏

user_id varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,

password varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,

name varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,

type varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,

checked varchar(45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,

PRIMARY KEY (user_id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

– Records of tb_users

INSERT INTO tb_users VALUES (‘1001’, ‘123456’, ‘同学1’, ‘stu’, ‘true’);

INSERT INTO tb_users VALUES (‘1002’, ‘123456’, ‘同学2’, ‘stu’, ‘true’);

INSERT INTO tb_users VALUES (‘101’, ‘123456’, ‘教师1’, ‘teach’, ‘true’);

INSERT INTO tb_users VALUES (‘102’, ‘123456’, ‘教师2’, ‘teach’, ‘true’);

INSERT INTO tb_users VALUES (‘103’, ‘123456’, ‘教师3’, ‘teach’, ‘true’);

INSERT INTO tb_users VALUES (‘104’, ‘123456’, ‘王老师’, ‘teach’, ‘true’);

INSERT INTO tb_users VALUES (‘105’, ‘123456’, ‘李老师’, ‘teach’, ‘false’);

INSERT INTO tb_users VALUES (‘admin’, ‘admin’, ‘管理员’, ‘admin’, ‘true’);

SET FOREIGN_KEY_CHECKS = 1;

二、系统展示

======

1.登录系统

2.注册系统

3.管理员-首页

4.管理员-管理用户

5.管理员-管理课程

6.管理员-修改密码

7.教师-创建课程

8.教师-我的课程

9.教师-修改密码

10.学生-加入课程

11.学生-我的课程

12.学生-修改密码

三、部分代码

======

CreateCourseAction

package com.sjsq.servlet;

import com.sjsq.bean.Course;

import com.sjsq.bean.User;

import com.sjsq.dao.CourseDao;

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(“/CreateCourseAction”)

@MultipartConfig

public class CreateCourseAction 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 courseName = req.getParameter(“courseName”);

String day = req.getParameter(“day”);

String courseTime = req.getParameter(“courseTime”);

String Day = day + ", " + courseTime;

User user = (User) req.getSession().getAttribute(“User”);

String teach_id = user.getId();

Course course = new Course(0, courseName, teach_id, Day, “false”, 0);

CourseDao courseDao = new CourseDao();

int result = courseDao.Create(course);

if (result == 0) {

out.println(“”);

} else if (result == 1) {

out.println(“”);

} else {

out.println(“”);

}

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(“”);

} else {

out.println(“”);

}

} 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(“”);

} else {

out.println(“”);

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

out.println(“”);

}

} else if (ope.equals(“coursedel”)) {

// 课程删除

String c = req.getParameter(“course_id”);

String type = req.getParameter(“type”);

int course_id = Integer.valueOf©;

CourseDao courseDao = new CourseDao();

if (courseDao.DelCourse(course_id) == 1) {

if (type.equals(“admin”)) {

out.println(“”);

} else {

out.println(“”);

}

} else {

if (type.equals(“admin”)) {

out.println(“”);

} else {

out.println(“”);

}

} else if (ope.equals(“joindel”)) {

// 退出选课

String c = req.getParameter(“course_id”);

String user_id = req.getParameter(“user_id”);

int course_id = Integer.valueOf©;

String from_ = req.getParameter(“from_”);

JoinDao joinDao = new JoinDao();

if (joinDao.Delete(course_id, user_id) == 1) {

out.println(“”);

} else {

out.println(“”);

}

@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(“”);

return;

}

if ((user2.getId()).equals(“”)) {

// 用户不存在

out.println(“”);

} else if (user2.getPassword().equals(userPass)) {

// 登陆成功

req.getSession(true).setAttribute(“User”, user2);

out.println(“”);

} else {

// 密码错误

out.println(“”);

}

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©;

Join join = new Join(course_id, user_id, “checking”);

JoinDao joinDao = new JoinDao();

int result = joinDao.Creat(join);

if (result == 2) {

out.println(“”);

} else if (result == 1) {

out.println(“”);

} else {

out.println(“”);

}

} else if (ope.equals(“joinaccept”)) {

String c = req.getParameter(“course_id”);

String user_id = req.getParameter(“user_id”);

int course_id = Integer.valueOf©;

String from_ = req.getParameter(“from_”);

JoinDao joinDao = new JoinDao();

int result = joinDao.Update(course_id, user_id, “true”);

if (result == 1) {

out.println(“”);

} else {

out.println(“”);

}

} else if (ope.equals(“signincreat”)) {

String c = req.getParameter(“course_id”);

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(“”);

} else {

out.println(“”);

}

} else if (ope.equals(“signinstop”)) {

String c = req.getParameter(“course_id”);

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(“”);

} else {

out.println(“”);

}

} else if (ope.equals(“signin”)) {

String stu_id = req.getParameter(“stu_id”);

String c = req.getParameter(“signin_id”);

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(“”);

} else {

out.println(“”);

}

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(“”);

} else if (!userPass.equals(Confirm)) {

out.println(“”);

} else {

User user = new User(user_id, userPass, name, type);

UserDao userDao = new UserDao();

int result = userDao.create(user);

if (result == 1) {

out.println(“”);

} else {

if (result == 0) out.println(“”);

else out.println(“”);

}

UpdateUserAction

自我介绍一下，小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。

深知大多数Java工程师，想要提升技能，往往是自己摸索成长或者是报班学习，但对于培训机构动则几千的学费，着实压力不小。自己不成体系的自学效果低效又漫长，而且极易碰到天花板技术停滞不前！

因此收集整理了一份《2024年Java开发全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友，同时减轻大家的负担。

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上Java开发知识点，真正体系化！

由于文件比较大，这里只是将部分目录截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且会持续更新！

如果你觉得这些内容对你有帮助，可以扫码获取！！（备注：Java）

总结

蚂蚁面试比较重视基础，所以Java那些基本功一定要扎实。蚂蚁的工作环境还是挺赞的，因为我面的是稳定性保障部门，还有许多单独的小组，什么三年1班，很有青春的感觉。面试官基本水平都比较高，基本都P7以上，除了基础还问了不少架构设计方面的问题，收获还是挺大的。

经历这次面试我还通过一些渠道发现了需要大厂真实面试主要有：蚂蚁金服、拼多多、阿里云、百度、唯品会、携程、丰巢科技、乐信、软通动力、OPPO、银盛支付、中国平安等初，中级，高级Java面试题集合，附带超详细答案，希望能帮助到大家。

蚂蚁金服5面，总结了49个面试题，遇到的面试官都是P7级别以上

《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取！
intln(“”);

else out.println(“”);

}

UpdateUserAction

自我介绍一下，小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。

因此收集整理了一份《2024年Java开发全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友，同时减轻大家的负担。[外链图片转存中…(img-11Pj8mrE-1713857386789)]

[外链图片转存中…(img-Q7Rc1BqT-1713857386789)]

[外链图片转存中…(img-CSADs3B9-1713857386790)]

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上Java开发知识点，真正体系化！

由于文件比较大，这里只是将部分目录截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且会持续更新！

如果你觉得这些内容对你有帮助，可以扫码获取！！（备注：Java）

[外链图片转存中…(img-pUYDx1oo-1713857386790)]

总结

[外链图片转存中…(img-IxDhFrVe-1713857386790)]

《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取！

2401_83916030

关注

8
点赞
踩
29

收藏

觉得还不错? 一键收藏
0
评论
IDEA+Java+Servlet+JSP+Mysql实现学生选课签到系统

蚂蚁面试比较重视基础，所以Java那些基本功一定要扎实。蚂蚁的工作环境还是挺赞的，因为我面的是稳定性保障部门，还有许多单独的小组，什么三年1班，很有青春的感觉。面试官基本水平都比较高，基本都P7以上，除了基础还问了不少架构设计方面的问题，收获还是挺大的。经历这次面试我还通过一些渠道发现了需要大厂真实面试主要有：蚂蚁金服、拼多多、阿里云、百度、唯品会、携程、丰巢科技、乐信、软通动力、OPPO、银盛支付、中国平安等初，中级，高级Java面试题集合，附带超详细答案，希望能帮助到大家。
复制链接

扫一扫