首页下载资源后端学生管理系统(java+mysql)

ZIP学生管理系统(java+mysql)

juantjyu1.82MB需要积分:1

资源文件列表:

StudentSystem.zip 大约有140个文件
  1. StudentSystem/
  2. __MACOSX/._StudentSystem 176B
  3. StudentSystem/StudentSystem/
  4. __MACOSX/StudentSystem/._StudentSystem 176B
  5. StudentSystem/.DS_Store 6KB
  6. __MACOSX/StudentSystem/._.DS_Store 120B
  7. StudentSystem/img/
  8. __MACOSX/StudentSystem/._img 176B
  9. StudentSystem/StudentSystem/database/
  10. __MACOSX/StudentSystem/StudentSystem/._database 176B
  11. StudentSystem/StudentSystem/.DS_Store 6KB
  12. __MACOSX/StudentSystem/StudentSystem/._.DS_Store 120B
  13. StudentSystem/StudentSystem/lib/
  14. __MACOSX/StudentSystem/StudentSystem/._lib 176B
  15. StudentSystem/StudentSystem/src/
  16. __MACOSX/StudentSystem/StudentSystem/._src 176B
  17. StudentSystem/img/info.png 17.83KB
  18. __MACOSX/StudentSystem/img/._info.png 176B
  19. StudentSystem/img/add.png 5.41KB
  20. __MACOSX/StudentSystem/img/._add.png 176B
  21. StudentSystem/img/update.png 18.79KB
  22. __MACOSX/StudentSystem/img/._update.png 176B
  23. StudentSystem/img/login.png 5.24KB
  24. __MACOSX/StudentSystem/img/._login.png 176B
  25. StudentSystem/img/an2.png 30.27KB
  26. __MACOSX/StudentSystem/img/._an2.png 176B
  27. StudentSystem/img/an3.png 7.69KB
  28. __MACOSX/StudentSystem/img/._an3.png 176B
  29. StudentSystem/img/12.png 27.2KB
  30. __MACOSX/StudentSystem/img/._12.png 176B
  31. StudentSystem/img/find2.png 14.15KB
  32. __MACOSX/StudentSystem/img/._find2.png 176B
  33. StudentSystem/img/find.png 10.08KB
  34. __MACOSX/StudentSystem/img/._find.png 176B
  35. StudentSystem/img/add2.png 10.2KB
  36. __MACOSX/StudentSystem/img/._add2.png 176B
  37. StudentSystem/img/an.png 147.31KB
  38. __MACOSX/StudentSystem/img/._an.png 176B
  39. StudentSystem/img/update2.png 19.18KB
  40. __MACOSX/StudentSystem/img/._update2.png 176B
  41. StudentSystem/img/1.png 262.55KB
  42. __MACOSX/StudentSystem/img/._1.png 176B
  43. StudentSystem/StudentSystem/database/StudentSystemDao.sql 11.2KB
  44. __MACOSX/StudentSystem/StudentSystem/database/._StudentSystemDao.sql 176B
  45. StudentSystem/StudentSystem/lib/mysql-connector-java-5.1.6-bin.jar 686.78KB
  46. __MACOSX/StudentSystem/StudentSystem/lib/._mysql-connector-java-5.1.6-bin.jar 176B
  47. StudentSystem/StudentSystem/src/indi/
  48. __MACOSX/StudentSystem/StudentSystem/src/._indi 176B
  49. StudentSystem/StudentSystem/src/2.png 310.83KB
  50. __MACOSX/StudentSystem/StudentSystem/src/._2.png 176B
  51. StudentSystem/StudentSystem/src/1.png 265.08KB
  52. __MACOSX/StudentSystem/StudentSystem/src/._1.png 176B
  53. StudentSystem/StudentSystem/src/indi/wrenn/
  54. __MACOSX/StudentSystem/StudentSystem/src/indi/._wrenn 176B
  55. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/
  56. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/._studentsystem 176B
  57. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/util/
  58. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/._util 176B
  59. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/bean/
  60. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/._bean 176B
  61. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/dao/
  62. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/._dao 176B
  63. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/
  64. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/._frame 176B
  65. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/model/
  66. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/._model 176B
  67. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/run/
  68. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/._run 176B
  69. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/util/WindowUtil.java 770B
  70. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/util/._WindowUtil.java 176B
  71. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/util/CreateSql.java 2.97KB
  72. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/util/._CreateSql.java 176B
  73. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/util/Tools.java 703B
  74. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/util/._Tools.java 176B
  75. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/bean/User.java 547B
  76. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/bean/._User.java 176B
  77. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/bean/Student.java 1.85KB
  78. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/bean/._Student.java 176B
  79. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/bean/AnalyzeResult.java 777B
  80. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/bean/._AnalyzeResult.java 176B
  81. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/dao/ManageHelper.java 8.94KB
  82. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/dao/._ManageHelper.java 176B
  83. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/dao/JdbcConfig.java 237B
  84. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/dao/._JdbcConfig.java 176B
  85. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/dao/JdbcHelper.java 19.46KB
  86. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/dao/._JdbcHelper.java 176B
  87. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/DetailsFrame.java 4.19KB
  88. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._DetailsFrame.java 176B
  89. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ConditionsQueryScoreFrame.java 4.76KB
  90. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ConditionsQueryScoreFrame.java 176B
  91. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ScoreAnalyzeOption.java 7.05KB
  92. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ScoreAnalyzeOption.java 176B
  93. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/QueryScoreFrame.java 2.29KB
  94. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._QueryScoreFrame.java 176B
  95. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ConditionsQueryFrame.java 4.48KB
  96. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ConditionsQueryFrame.java 176B
  97. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/AddStudentFrame.java 9.65KB
  98. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._AddStudentFrame.java 176B
  99. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/UpdateScoreFrame.java 3.73KB
  100. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._UpdateScoreFrame.java 176B
  101. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/UpdateStudentScoreFrame.java 3.85KB
  102. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._UpdateStudentScoreFrame.java 176B
  103. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/QueryStudentScoreFrame.java 7.63KB
  104. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._QueryStudentScoreFrame.java 176B
  105. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ModifyFrame.java 11.63KB
  106. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ModifyFrame.java 176B
  107. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ScoresRankingFrame.java 835B
  108. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ScoresRankingFrame.java 176B
  109. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/StudentSystemRegisterFrame.java 5.06KB
  110. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._StudentSystemRegisterFrame.java 176B
  111. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ImagePanel.java 488B
  112. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ImagePanel.java 176B
  113. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/QueryStudentFrame.java 3.87KB
  114. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._QueryStudentFrame.java 176B
  115. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/StudentSystemLoginFrame.java 4.42KB
  116. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._StudentSystemLoginFrame.java 176B
  117. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ScoreAnalyzeFrame.java 6.01KB
  118. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ScoreAnalyzeFrame.java 176B
  119. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ScoreConditionsQueryFrame.java 4.86KB
  120. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ScoreConditionsQueryFrame.java 176B
  121. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/DeleteStudentFrame.java 4.13KB
  122. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._DeleteStudentFrame.java 176B
  123. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/ModifyStudentFrame.java 4.08KB
  124. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._ModifyStudentFrame.java 176B
  125. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/AddScoreFrame.java 3.85KB
  126. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._AddScoreFrame.java 176B
  127. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/UpdatePasswordFrame.java 4.83KB
  128. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._UpdatePasswordFrame.java 176B
  129. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/AddStudentScoreFrame.java 3.85KB
  130. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._AddStudentScoreFrame.java 176B
  131. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/StudentSystemMainFrame.java 7.73KB
  132. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/frame/._StudentSystemMainFrame.java 176B
  133. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/model/ScoreModel.java 2.56KB
  134. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/model/._ScoreModel.java 176B
  135. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/model/ScoreAnalyzeModel.java 2.43KB
  136. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/model/._ScoreAnalyzeModel.java 176B
  137. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/model/StudentModel.java 2.1KB
  138. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/model/._StudentModel.java 176B
  139. StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/run/TestLogin.java 240B
  140. __MACOSX/StudentSystem/StudentSystem/src/indi/wrenn/studentsystem/run/._TestLogin.java 176B

资源介绍:

该系统主要功能有: 学生基本信息和学生成绩的管理 学生基本信息:姓名、学号、专业、班级、所属院系。 各科成绩:高等数学、英语、数据结构、计算机组成原理、面向对象程序设计 系统可以完成对各类信息的添加、修改、删除等功能。 成绩的统计汇总 可以计算班级平均成绩,某科最高成绩,最低成绩,优、良、中、及格、不及格各个成绩等级的人数,每位同学的总成绩、班级总成绩,总成绩排名等。 成绩信息查询 查询功能是系统的核心功能之一。在系统中既有单条件查询也有多条件查询,可以精确查询和模糊查询。可以按照班级、成绩范围、科目等查询。可以自己根据需要合理设计。 系统登录功能 进入系统,需要登录。可以注册用户,有完整的用户注册、用户登录和密码修改功能。 系统管理模块:因为本系统是用来管理学生成绩的,所以系统运行的正常和安全性非常重要,为了达到此目的本系统需要一个管理系统安全的系统管理模块。其任务是维护系统的正常运行和安全性设置。该模块的主要任务是维护系统的正常运行和安全性设置包括注册、登录、修改密码、退出登录等等。 教师管理模块:该模块的主要任务是维护系统的正常运行和安全性设置,实现对学生的个人信息的管理工作
package indi.wrenn.studentsystem.dao; import indi.wrenn.studentsystem.bean.AnalyzeResult; import indi.wrenn.studentsystem.bean.Student; import indi.wrenn.studentsystem.bean.User; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; //与数据库通信的类 import java.util.HashMap; import java.util.LinkedHashMap; import java.util.Vector; public class JdbcHelper implements JdbcConfig{ //定义连接数据库所需要的对象 private PreparedStatement ps = null; private ResultSet rs = null; private Connection ct = null; //获得数据库的连接 private void init(){ try { Class.forName(DRIVER); ct = DriverManager.getConnection(URL, USERNAME, PASSWORD);// 获得数据库连接 } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //无参构造函数 public JdbcHelper(){ this.init(); } /** * 获取用户对象 * 根据传入的用户名,获取对应的用户,并返回用户对象 * @return 用户对象 */ public User getUser(User user){ User newUser = new User(); try { ps = ct.prepareStatement("select * from tb_User where User_name=?"); ps.setString(1, user.getUsername()); rs = ps.executeQuery(); if(rs.next()){ newUser.setUsername(rs.getString(1)); //设置用户名 newUser.setPassword(rs.getString(2)); //设置密码 newUser.setIsLogin(rs.getInt(3)); //设置是否登陆 } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return newUser; } /** * 注册处理 * @param user 用户对象 * @return 返回是否注册成功 */ public boolean register(User user){ boolean b = true; try { ps = ct.prepareStatement("insert into tb_User(User_name,Password_) values(?,?)"); ps.setString(1, user.getUsername()); ps.setString(2, user.getPassword()); if(ps.executeUpdate()!=1){ //执行sql语句 b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 修改用户"是否"登陆状态 * @param user * @return */ public boolean update_IsLogin(User user){ boolean b = true; try { ps = ct.prepareStatement("update tb_User set IsLogin=? where User_name=?"); ps.setInt(1, user.getIsLogin()); ps.setString(2, user.getUsername()); if(ps.executeUpdate()!=1){ b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 修改密码 * @param user 用户对象 * @param new_Password 新密码 * @return 返回是否修改成功 */ public boolean update_Password(User user,String new_Password){ boolean b = true; try { ps = ct.prepareStatement("update tb_User set Password_=? where User_name=?"); ps.setString(1, new_Password); ps.setString(2, user.getUsername()); if(ps.executeUpdate()!=1){ //执行sql语句 b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 获得所有院系 * @return 返回所有院系的HashMap集合 */ public HashMap getAllDepartment(){ HashMap map = new LinkedHashMap(); map.put("", "");//添加一个空的元素 try { ps = ct.prepareStatement("select * from tb_Department order by Department_ID"); rs = ps.executeQuery(); while(rs.next()){ map.put(rs.getString(2),rs.getString(1)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return map; } /** * 获得对应院系的专业 * @return 返回Vector对象 */ public Vector getMajor(String department_ID){ Vector vector = new Vector(); vector.add("");//添加一个空的元素 try { ps = ct.prepareStatement("select * from tb_Major where Department_ID=? order by Major_ID"); ps.setString(1, department_ID); rs = ps.executeQuery(); while(rs.next()){ vector.add(rs.getString(2)); //获得专业名称 } } catch (SQLException e) { e.printStackTrace(); } return vector; } /** * 获得所有专业 * @return 返回所有专业 */ public HashMapgetAllMajor(){ HashMap map = new LinkedHashMap(); map.put("", "");//添加一个空的元素 try { ps = ct.prepareStatement("select * from tb_Major order by Major_ID"); rs = ps.executeQuery(); while(rs.next()){ map.put(rs.getString(2),rs.getString(1)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return map; } /** * 添加学生 * @param student 学生对象 * @return 返回是否添加成功 */ public boolean addStudent(Student student){ boolean b = true; try { ps = ct.prepareStatement("insert into tb_Student(Student_Id,Student_Name,Student_Sex,Classe,Grade,Major_ID,Department_ID,Major_Name,Department_Name) values(?,?,?,?,?,?,?,?,?)"); ps.setString(1, student.getStudent_ID()); ps.setString(2, student.getStudent_Name()); ps.setString(3, student.getSex()); ps.setString(4, student.getClasse()); ps.setString(5, student.getGrade()); ps.setString(6, student.getMajor_ID()); ps.setString(7, student.getDepartment_ID()); ps.setString(8, student.getMajor_Name()); ps.setString(9, student.getDepartment_Name()); if(ps.executeUpdate()!=1){ b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 修改学生信息 * @param newStudent 新学生对象 * @param oldStudentID 旧学生信息 * @return 是否修改成功 */ public boolean updateStudent(Student newStudent,String oldStudentID){ boolean b = true; try { //update ps = ct.prepareStatement("update tb_Student set Student_Id=?, Student_Name=?, Student_Sex=? ,Classe=? ,Grade=? ,Major_ID=? ,Department_ID=? ,Major_Name=? ,Department_Name=? where Student_Id=?"); ps.setString(1, newStudent.getStudent_ID()); ps.setString(2, newStudent.getStudent_Name()); ps.setString(3, newStudent.getSex()); ps.setString(4, newStudent.getClasse()); ps.setString(5, newStudent.getGrade()); ps.setString(6, newStudent.getMajor_ID()); ps.setString(7, newStudent.getDepartment_ID()); ps.setString(8, newStudent.getMajor_Name()); ps.setString(9, newStudent.getDepartment_Name()); ps.setString(10, oldStudentID); if(ps.executeUpdate()!=1){ b = false; } } catch (SQLException e) { b = false; e.printStackTrace(); } return b; } /** * 根据学生学号从数据库移除该学生 * @param studentID 学生学号 * @return 返回是否删除成功 */ public boolean deleteStudent(String studentID){ boolean b = true; try { ps = ct.prepareStatement("delete from tb_Student where Student_Id=?"); ps.setString(1, studentID); if(ps.executeUpdate()!=1){ b = false; } } catch (SQLException e) { // TODO Auto-generated catch block b = false; e.printStackTrace(); } return b; } /** * 根据sql语句返回特定的学生集合 * @param sql sql语句 * @return 返回Vector对象 */ public Vector getStudent(String sql){ Vector students = new Vector(); try { ps = ct.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()){ Student student = new Student(); student.setStudent_ID(rs.getString(1)); student.setStudent_Name(rs.getString(2)); student.setSex(rs.getString(3)); student.setGrade(rs.getString(4)); student.setClasse(rs.getString(5)); student.setMajor_ID(rs.getString(6)); student.setMajor_Name(rs.getString(7)); student.setDepartment_ID(rs.getString(8)); student.setDepartment_Name(rs.getString(9)); students.add(student); } }catch(SQLException e){ e.printStackTrace(); } return students; } /** * �
100+评论
captcha