基于javaweb+mysql的jsp+servlet选课管理系统(java+jsp+servlet+javascript+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet选课管理系统(java+jsp+servlet+javascript+mysql)
项目介绍
一款简单的Servlet + mysql + jsp的选课系统,主要有三大模块,管理员模块,教师模块,学生模块。管理员模块主要功能模块有系统管理,课程管理,教师管理,课表管理,学生管理;教师模块和学生模块的主要功能模块有个人信息和课表信息的查询,其中学生包括选课的功能。
软件架构
Servlet、mysql5.7、jsp、jdk1.8、tomcat8.0
安装教程
1.导入数据库xuanke.sql 2.导入项目,找到文件中util下的DB.java,修改你自己数据库的帐号和密码
@RequestMapping("/login")
public String login(){
return "login";
@GetMapping("/")
public String index() {
return "success";
@GetMapping("/manager")
@PreAuthorize("hasAuthority('admin')")
public String manager(){
return "manager";
//@RequestMapping("/error")
UserService userService;
@RequestMapping("/login")
public String login(){
return "login";
@GetMapping("/")
public String index() {
return "success";
@GetMapping("/manager")
@PreAuthorize("hasAuthority('admin')")
public String manager(){
return "manager";
//@RequestMapping("/error")
public class UserController{
@Autowired
UserService userService;
/**
* 获取全部用户
* @param page
* @param limit
* @return
*/
@PostMapping("getUsers")
return "login";
@GetMapping("/")
public String index() {
return "success";
@GetMapping("/manager")
@PreAuthorize("hasAuthority('admin')")
public String manager(){
return "manager";
//@RequestMapping("/error")
//public String error(){
public class LoginController{
@Autowired
AdminService adminService;
@Autowired
UserService userService;
@RequestMapping("/login")
public String login(){
return "login";
@GetMapping("/")
public String index() {
return "success";
@GetMapping("/manager")
@GetMapping("/getCode")
@ResponseBody
public Object getCode(HttpServletRequest request) {
/* 生成验证码字符串 */
String verifyCode = VerifyCodeUtil.generateVerifyCode(4);
String uuid = UUIDUtil.GeneratorUUIDOfSimple();
HttpSession session = request.getSession();
session.setAttribute(uuid,verifyCode); //将验证码与生成的uuid绑定在一起
System.out.println("生成的验证码为:" + verifyCode);
int width = 111,height = 36;
@GetMapping("/info")
@PreAuthorize("hasAuthority('student')")
public String info(){
return "studentInfo";
@GetMapping("/getCode")
@ResponseBody
public Object getCode(HttpServletRequest request) {
/* 生成验证码字符串 */
String verifyCode = VerifyCodeUtil.generateVerifyCode(4);
String uuid = UUIDUtil.GeneratorUUIDOfSimple();
用户管理控制层:
@RestController
@RequestMapping("user")
@Api
public class UserController{
@Autowired
UserService userService;
/**
* 获取全部用户
* @param page
* @param limit
* Excel表格导出接口
* http://localhost:8080/ExcelDownload
* @param response response对象
*/
@GetMapping("/ExcelDownload")
@PreAuthorize("hasAuthority('admin')")
public void excelDownload(HttpServletResponse response) throws IOException{
adminService.excelOut(response);
/**
* 课程管理
* @return
*/
@GetMapping("/courseManage")
@PreAuthorize("hasAnyAuthority('admin')")
map.put("totalCount" , pageInfo.getTotal()); //总条数
map.put("currentPage" , page); //当前页数。
map.put("data" , pageInfo.getList()); //获得的数据量
return JSON.toJSON(map);
管理员管理控制层:
@Controller
@Api
public class AdminController{
@Autowired
AdminService adminService;
/**
* Excel表格导出接口
* http://localhost:8080/ExcelDownload
public String info(){
return "studentInfo";
@GetMapping("/getCode")
@ResponseBody
public Object getCode(HttpServletRequest request) {
/* 生成验证码字符串 */
String verifyCode = VerifyCodeUtil.generateVerifyCode(4);
String uuid = UUIDUtil.GeneratorUUIDOfSimple();
HttpSession session = request.getSession();
session.setAttribute(uuid,verifyCode); //将验证码与生成的uuid绑定在一起
System.out.println("生成的验证码为:" + verifyCode);
map.put("currentPage" , page); //当前页数。
map.put("data" , pageInfo.getList()); //获得的数据量
return JSON.toJSON(map);
管理员管理控制层:
@Controller
@Api
public class AdminController{
@Autowired
AdminService adminService;
/**
* Excel表格导出接口
* http://localhost:8080/ExcelDownload
* @param response response对象
@Autowired
UserService userService;
/**
* 获取全部用户
* @param page
* @param limit
* @return
*/
@PostMapping("getUsers")
@PreAuthorize("hasAuthority('admin')")
public Object getAll(@RequestParam(value = "page", defaultValue = "1") int page ,
@Autowired
UserService userService;
/**
* 获取全部用户
* @param page
* @param limit
* @return
*/
@PostMapping("getUsers")
@PreAuthorize("hasAuthority('admin')")
public Object getAll(@RequestParam(value = "page", defaultValue = "1") int page ,
@RequestParam(value = "limit", defaultValue = "10") int limit ){
return "addCourse";
登录管理控制层:
@Controller
@Api
public class LoginController{
@Autowired
AdminService adminService;
@Autowired
UserService userService;
@RequestMapping("/login")
public String login(){
List<User> list = userService.selectAll();
if(list == null){
return Msg.fail();
//System.out.println("=="+username+"==");
PageInfo<User> pageInfo = new PageInfo<>(list);
map.put("totalPage" , pageInfo.getPages()); //总页数
map.put("totalCount" , pageInfo.getTotal()); //总条数
map.put("currentPage" , page); //当前页数。
map.put("data" , pageInfo.getList()); //获得的数据量
return JSON.toJSON(map);
管理员管理控制层:
@Controller
@Api
return "studentInfo";
@GetMapping("/getCode")
@ResponseBody
public Object getCode(HttpServletRequest request) {
/* 生成验证码字符串 */
String verifyCode = VerifyCodeUtil.generateVerifyCode(4);
String uuid = UUIDUtil.GeneratorUUIDOfSimple();
HttpSession session = request.getSession();
session.setAttribute(uuid,verifyCode); //将验证码与生成的uuid绑定在一起
System.out.println("生成的验证码为:" + verifyCode);
int width = 111,height = 36;
try (ByteArrayOutputStream stream = new ByteArrayOutputStream()) {
VerifyCodeUtil.outputImage(width, height, stream, verifyCode);
return Msg.msg("data",new ImgVO("data:image/gif;base64,"+ Base64Utils.encodeToString(stream.toByteArray()),uuid));
@GetMapping("/")
public String index() {
return "success";
@GetMapping("/manager")
@PreAuthorize("hasAuthority('admin')")
public String manager(){
return "manager";
//@RequestMapping("/error")
//public String error(){
// return "error";
//}
@Api
public class LoginController{
@Autowired
AdminService adminService;
@Autowired
UserService userService;
@RequestMapping("/login")
public String login(){
return "login";
@GetMapping("/")
public void excelDownload(HttpServletResponse response) throws IOException{
adminService.excelOut(response);
/**
* 课程管理
* @return
*/
@GetMapping("/courseManage")
@PreAuthorize("hasAnyAuthority('admin')")
public String courseManage(){
return "courseManage";
/**
* 添加课程
PageInfo<User> pageInfo = new PageInfo<>(list);
map.put("totalPage" , pageInfo.getPages()); //总页数
map.put("totalCount" , pageInfo.getTotal()); //总条数
map.put("currentPage" , page); //当前页数。
map.put("data" , pageInfo.getList()); //获得的数据量
return JSON.toJSON(map);
管理员管理控制层:
@Controller
@Api
public class AdminController{
@Autowired
AdminService adminService;
@PreAuthorize("hasAnyAuthority('admin')")
public String courseManage(){
return "courseManage";
/**
* 添加课程
* @return
*/
@GetMapping("/addCourse")
@PreAuthorize("hasAuthority('admin')")
public String addCourse(){
return "addCourse";
登录管理控制层:
@Controller
@Api
//}
@GetMapping("/info")
@PreAuthorize("hasAuthority('student')")
public String info(){
return "studentInfo";
@GetMapping("/getCode")
@ResponseBody
public Object getCode(HttpServletRequest request) {
/* 生成验证码字符串 */
String verifyCode = VerifyCodeUtil.generateVerifyCode(4);
String uuid = UUIDUtil.GeneratorUUIDOfSimple();
* 获取全部用户
* @param page
* @param limit
* @return
*/
@PostMapping("getUsers")
@PreAuthorize("hasAuthority('admin')")
public Object getAll(@RequestParam(value = "page", defaultValue = "1") int page ,
@RequestParam(value = "limit", defaultValue = "10") int limit ){
Map<String,Object> map = new HashMap<>();
PageHelper.startPage(page , limit);
List<User> list = userService.selectAll();
if(list == null){
public Object getAll(@RequestParam(value = "page", defaultValue = "1") int page ,
@RequestParam(value = "limit", defaultValue = "10") int limit ){
Map<String,Object> map = new HashMap<>();
PageHelper.startPage(page , limit);
List<User> list = userService.selectAll();
if(list == null){
return Msg.fail();
//System.out.println("=="+username+"==");
PageInfo<User> pageInfo = new PageInfo<>(list);
map.put("totalPage" , pageInfo.getPages()); //总页数
map.put("totalCount" , pageInfo.getTotal()); //总条数
@PreAuthorize("hasAuthority('admin')")
public void excelDownload(HttpServletResponse response) throws IOException{
adminService.excelOut(response);
/**
* 课程管理
* @return
*/
@GetMapping("/courseManage")
@PreAuthorize("hasAnyAuthority('admin')")
public String courseManage(){
return "courseManage";
/**
* 添加课程