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

于 2024-05-04 11:53:33 发布
阅读量631 收藏 8
点赞数 26
分类专栏： 程序员 文章标签： java intellij-idea servlet
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2401_83412172/article/details/138438278
版权

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

int course_id = Integer.valueOf©;

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

int course_id = Integer.valueOf©;

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

int signin_id = Integer.valueOf©;

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

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

} else {

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

if (!user.getPassword().equals(oldPass)) {

out.println(“”);

} else {

UserDao userDao = new UserDao();

int result = 0;

try {

result = userDao.Update(user.getId(), newPass);

最后

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

深知大多数Java工程师，想要提升技能，往往是自己摸索成长，自己不成体系的自学效果低效漫长且无助。

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

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上Java开发知识点，不论你是刚入门Android开发的新手，还是希望在技术上不断提升的资深开发者，这些资料都将为你打开新的学习之门！

如果你觉得这些内容对你有帮助，需要这份全套学习资料的朋友可以戳我获取！！

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

String oldPass = req.getParameter(“oldPassword”);

String newPass = req.getParameter(“newPassword”);

String Confirm = req.getParameter(“confirmPassword”);

if (!newPass.equals(Confirm)) {

out.println(“”);

} else {

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

if (!user.getPassword().equals(oldPass)) {

out.println(“”);

} else {

UserDao userDao = new UserDao();

int result = 0;

try {

result = userDao.Update(user.getId(), newPass);

最后

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

深知大多数Java工程师，想要提升技能，往往是自己摸索成长，自己不成体系的自学效果低效漫长且无助。

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

[外链图片转存中…(img-MRFHUr1P-1714794800463)]

[外链图片转存中…(img-VZPvnh5O-1714794800463)]

[外链图片转存中…(img-3p5LQh5a-1714794800464)]

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上Java开发知识点，不论你是刚入门Android开发的新手，还是希望在技术上不断提升的资深开发者，这些资料都将为你打开新的学习之门！

如果你觉得这些内容对你有帮助，需要这份全套学习资料的朋友可以戳我获取！！

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

2401_83412172
关注
  • 26
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值