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

2301_76232361

于 2024-05-02 18:15:47 发布

阅读量44

点赞数 16

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

本文链接：https://blog.csdn.net/2301_76232361/article/details/138396750

版权

程序员专栏收录该内容

268 篇文章 3 订阅

订阅专栏

《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
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

最后

整理的这些资料希望对Java开发的朋友们有所参考以及少走弯路，本文的重点是你有没有收获与成长，其余的都不重要，希望读者们能谨记这一点。

其实面试这一块早在第一个说的25大面试专题就全都有的。以上提及的这些全部的面试+学习的各种笔记资料，我这差不多来回搞了三个多月，收集整理真的很不容易，其中还有很多自己的一些知识总结。正是因为很麻烦，所以对以上这些学习复习资料感兴趣
《一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码》，点击传送门，即可获取！
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 {