基于java+mysql的Swing+MySQL学生管理系统java基础gui(java+gui)

基于java+mysql的Swing+MySQL学生管理系统java基础gui(java+gui)

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于java+mysql的学生管理系统Java基础Gui(java+Gui)

功能介绍：

学生信息管理，姓名，编号，性别，成绩，学号住址

登录控制层：

@Controller

public class LoginController {

private static final Logger LOGGER = LoggerFactory.getLogger(LoginController.class);

@Autowired

AdminService adminService;

@GetMapping(“/cs”)

public String cs() {

return “cs”;

@GetMapping(“/login”)

public String login() {

return “login”;

@PostMapping(“/login”)

@ResponseBody

public Msg login(String name, String pwd, HttpSession httpSession) {

name = name.trim();

// LOGGER.info(“{}–{}”,name,pwd);

return adminService.login(name, pwd, httpSession);

角色业务处理：

@Authority(roles = {Role.STUDENT})

@Controller

@RequestMapping(“/student”)

public class StudentController {

private static final Logger LOGGER = LoggerFactory.getLogger(StudentController.class);

@Autowired

private StudentService studentService;

@Autowired

private HttpServletRequest request;

@Autowired

private LoginServiceImpl loginService;

@Autowired

IndexServiceImpl indexService;

@Autowired

AdminService adminService;

@Autowired

TopicsService topicsService;

//Session过期时间

private final Integer SAVE_TIME = 606024;

@GetMapping(“/login”)

public String login(){

return “student/login”;

@PostMapping(value = “/login”)

@ResponseBody

public String login(String name, String pwd, Model model, HttpServletResponse response) {

name = name.trim();

List student = studentService.selectByName(name);

if (student.size() >= 1) {

if (student.get(0).getPwd().equals(pwd)) {

request.getSession().setAttribute(“student”,student.get(0));

request.getSession().setMaxInactiveInterval(SAVE_TIME);

User user = new User();

//-1表示为超管

user.setId(1L);

user.setRole(“student”);

user.setUserName(name);

//生成Token 存到 Cookie

Cookie cookie = new Cookie(“token”, TokenUtil.createToken(

user

));

//该Cookie无法被js读取

cookie.setHttpOnly(true);

cookie.setPath(“/”);

response.addCookie(cookie);

model.addAttribute(“student”, student.get(0));

return “200”;

}else {

return “0”;

} else {

return “300”;

@RequestMapping(“/index”)

public String index(Model model, HttpSession httpSession) {

Student student = (Student) request.getSession().getAttribute(“student”);

Subject project = indexService.indexinfo(student.getId());

String str = null;

Long flag = null;

if (project == null) {

model.addAttribute(“projectName”, “未选课题”);

model.addAttribute(“flag”, “未选题”);

model.addAttribute(“teacher”, “无”);

httpSession.removeAttribute(“”);

} else {

httpSession.setAttribute(“XZproject”, project.getProjectname());

model.addAttribute(“XZproject”, project.getProjectname());

model.addAttribute(“projectName”, project.getProjectname());

flag = indexService.projectselectedstuflag(student.getId());

if (flag == 0L) {

str = “未选题”;

} else if (flag == 1L) {

str = “选题待审核”;

} else if (flag == 2L) {

str = “选题未通过”;

} else if (flag == 3L) {

str = “选题通过”;

model.addAttribute(“flag”, str);

model.addAttribute(“teacher”, project.getTeachernames());

request.getSession().setAttribute(“filePath”,project.getFilepath());

//用来判断当前页是否为首页

model.addAttribute(“path”,“1”);

//判断是否修改了个人信息

// request.getSession().setAttribute(“modifyFlag”,0);

return “student/index”;

/**

• 查看个人信息

*/

@RequestMapping(“/studentinfo”)

public String studentinfo(Model model) {

Student student = (Student) request.getSession().getAttribute(“student”);

MyClass idclass = indexService.studentinfo(student.getIdClass());

model.addAttribute(“tclass”, idclass);

return “student/studentinfo”;

/**

• 将查看的个人信息放到信息修改页面

*/

@RequestMapping(“/modifyinfo”)

public String modifyinfo(Model model) {

Student student = (Student) request.getSession().getAttribute(“student”);

MyClass idclass = indexService.studentinfo(student.getIdClass());

model.addAttribute(“tclass”, idclass);

return “student/modifyinfo”;

/**

• 修改个人信息

• 根据班级(className)修改

*/

/*@RequestMapping(value = “/modifyinfodao”, method = RequestMethod.PUT)

@ResponseBody

public String modifyinfodao(Student student, String className, Model model) {

Student Tstudent = (Student) request.getSession().getAttribute(“student”);

MyClass Tclass = indexService.selectByclassName(className);

int count = -1;

student.setIdClass(Tclass.getId());

System.out.println(“******”+Tstudent.toString());

System.out.println(“******”+student.toString());

if (student.getStunum().equals(Tstudent.getStunum())) {

student.setStunum(null);

if (student.getIdClass().equals(Tstudent.getIdClass())) {

student.setIdClass(null);

if (student.getName().equals(Tstudent.getName())) {

student.setName(null);

if (student.getGender().equals(Tstudent.getGender())) {

student.setGender(null);

if (student.getGender() == null && student.getName() == null && student.getIdClass() == null && student.getStunum() == null) {

} else {

student.setId(Tstudent.getId());

count = indexService.updateBymodifyinfo(student);

student = indexService.selectByid(Tstudent.getId());

model.addAttribute(“student”, student);

if (count > 0) {

request.getSession().setAttribute(“student”,student);

request.getSession().setAttribute(“modifyFlag”,1);

return “200”;

} else {

request.getSession().setAttribute(“modifyFlag”,0);

return “201”;

}*/

/**

• 跳转页面(修改密码)

*/

@RequestMapping(“/changepsw”)

public String changepsw() {

return “student/changepsw”;

/**

• 200修改成功

• 201对不起密码错误

• 202对不起输入框为空

• 203新密码不一致

• 204修改失败

*/

@RequestMapping(value = “/changepassword”, method = RequestMethod.PUT)

@ResponseBody

public String changepswdao(String oldpassword, String newpassword, String newpassword1) {

if(!verifypassword(newpassword)){

return “206”;

if(!verifypassword(newpassword1)){

return “206”;

Student student = (Student) request.getSession().getAttribute(“student”);

Student studentdao = loginService.selectByName(student.getUsername());

int result;

if (newpassword.equals(newpassword1) && !newpassword.equals(“”) && !newpassword1.equals(“”)) {

if (studentdao.getPwd().equals(oldpassword)) {

if(oldpassword.equals(newpassword)){

return “205”;

}else{

result = indexService.updatepassword(newpassword, student.getId());

if (result > 0) {

return “200”;

}else{

return “204”;

} else {

return “201”;

} else if (newpassword.equals(“”) && newpassword1.equals(“”)) {

return “202”;

return “203”;

//密码验证

public boolean verifypassword(String password){

if(password.length() < 6 || password.length() > 16){

return false;

for(int i = 0;i < password.length();i++){

if(!(password.charAt(i)>=‘A’ && password.charAt(i)<=‘Z’)){

if(!(password.charAt(i)>=‘a’ && password.charAt(i)<=‘z’)){

if(!(password.charAt(i)>=‘0’ && password.charAt(i)<=‘9’)){

return false;

return true;

//退出

//清除Session数据

@RequestMapping(“/exit”)

public String exit(HttpServletResponse response,HttpSession httpSession) {

// httpSession.setAttribute(“XZproject”, null);

// 清除Session

Enumeration em = request.getSession().getAttributeNames();

while(em.hasMoreElements()){

request.getSession().removeAttribute(em.nextElement().toString());

//将Cookie 中的token 置空

Cookie cookie = new Cookie(“token”, null);

cookie.setPath(“/”);

response.addCookie(cookie);

return “student/login”;

/**

• 查看班级选报信息

*/

@RequestMapping(“/classinfo”)

public String classinfo(Model model,HttpSession httpSession) {

Student student = (Student) request.getSession().getAttribute(“student”);

removeSession();

List<Static_student> list = adminService.select_student(null, null, student.getIdClass(), null, null);

System.out.println(list);

model.addAttribute(“list”, list);

return “student/classinfo”;

/**

• 查看课题

*/

@RequestMapping(“/topics”)

public String Topics(Model model,HttpSession httpSession) {

Student student = (Student) request.getSession().getAttribute(“student”);

removeSession();

List topicsinfolist = topicsService.topics(student.getIdClass());

System.out.println(topicsinfolist);

model.addAttribute(“topicsinfolist”, topicsinfolist);

return “student/topicsinfo”;

/**

• 课题具体信息

*/

@RequestMapping(“/topicsto”)

public String Topicsto(Long project_id,int selectFlag,String projectName, Model model, HttpSession httpSession) {

List topicstos = topicsService.topicsinfo(project_id);

Student student = (Student) request.getSession().getAttribute(“student”);

Long flag = topicsService.state(student);

Long flagto = topicsService.flag(project_id);

if (flagto != 0) {

flag = 3L;

model.addAttribute(“selectFlag”,selectFlag);

model.addAttribute(“flag”, flag);

model.addAttribute(“topicstos”, topicstos);

model.addAttribute(“projectName”, projectName);

model.addAttribute(“project_id”, project_id);

model.addAttribute(“XZproject”, httpSession.getAttribute(“XZproject”));

return “student/topicsinfoto”;

/**

• 选报课题

*/

@Autowired

SubjectselectedMapper subjectselectedMapper;

@RequestMapping(“/enroll”)

@ResponseBody

public String enroll(Long project_id, HttpSession httpSession) {

String projectName = topicsService.selectprojectname(project_id);

Student student = (Student) request.getSession().getAttribute(“student”);

List subjectselected = subjectselectedMapper.selectBystudentid(student.getId());

if(subjectselected.size() == 0){

studentService.updateselectnumAdd(projectName);

topicsService.insertproject(projectName, student.getId());

httpSession.setAttribute(“XZproject”, projectName);

return “200”;

}else {

return “201”;

/**

• 取消选报

*/

@RequestMapping(“/cancel”)

@ResponseBody()

public String cancel(Long project_id, Model model, HttpSession httpSession) {

System.out.println(1);

String projectName = topicsService.selectprojectname(project_id);

Student student = (Student) request.getSession().getAttribute(“student”);

List subjectselected = subjectselectedMapper.selectBystudentid(student.getId());

if (subjectselected != null && subjectselected.size() != 0 && subjectselected.get(0).getStuselectFlag() != 3

&& project_id.equals(subjectselected.get(0).getIdProject())) {

topicsService.deleteprojectselectedid(student.getId());

httpSession.removeAttribute(“XZproject”);

model.addAttribute(“XZproject”, null);

httpSession.setAttribute(“XZproject”, null);

studentService.updateselectnumReduce(projectName);

return “200”;

} else {

return “203”;

/**

• 清除session中存的项目名

*/

public void removeSession(){

Student student = (Student) request.getSession().getAttribute(“student”);

Subject project = indexService.indexinfo(student.getId());

if(project==null){

request.getSession().removeAttribute(“XZproject”);

---