1、精選優(yōu)質(zhì)文檔-傾情為你奉上學(xué)生管理系統(tǒng)實(shí)驗(yàn)報(bào)告學(xué) 期：2018-2019課程名稱：Java程序設(shè)計(jì)實(shí)驗(yàn)專心-專注-專業(yè)1、 實(shí)驗(yàn)?zāi)康?. 掌握J(rèn)DK的安裝與環(huán)境變量的配置，熟練使用Eclipse、WindowBulider插件、navicat和MySql。2. 熟練掌握J(rèn)ava基礎(chǔ)語(yǔ)法與程序結(jié)構(gòu)，了解面向?qū)ο蟮木幊趟枷耄莆辗庋b、構(gòu)造方法和訪問(wèn)權(quán)限。3. 理解繼承的概念和意義，掌握繼承關(guān)系。4. 理解接口的概念和意義，掌握實(shí)現(xiàn)接口的方法。5. 掌握異常處理的方法。6. 掌握J(rèn)ava Swing，學(xué)會(huì)創(chuàng)建GUI界面，熟練使用MVC結(jié)構(gòu)，掌握事件處理。7. 掌握MySql基礎(chǔ)語(yǔ)句，操作MySql數(shù)

2、據(jù)庫(kù)。2、 實(shí)驗(yàn)內(nèi)容a. 管理系統(tǒng)功能1. 實(shí)現(xiàn)登錄界面與相應(yīng)功能。用戶填寫正確賬號(hào)與密碼并選擇用戶身份后即可實(shí)現(xiàn)登陸并跳轉(zhuǎn)至主界面。2. 實(shí)現(xiàn)主界面與相應(yīng)功能。此界面功能包括學(xué)生管理、成績(jī)管理、教師管理、系統(tǒng)設(shè)置和幫助。其中系統(tǒng)設(shè)置包括修改密碼，退出賬號(hào)和關(guān)閉系統(tǒng)。幫助包括關(guān)于作者、版本信息和意見(jiàn)反饋。3. 實(shí)現(xiàn)管理學(xué)生界面與相應(yīng)功能?？蓪?duì)學(xué)生信息進(jìn)行添加、查詢、修改和刪除的操作。4. 實(shí)現(xiàn)管理成績(jī)界面與相應(yīng)功能?？刹樵兊綄W(xué)生并對(duì)其成績(jī)信息進(jìn)行編輯。5. 實(shí)現(xiàn)管理教師界面與相應(yīng)功能?？蓪?duì)教師信息進(jìn)行添加、查詢、修改和刪除的操作。6. 實(shí)現(xiàn)修改密碼界面與相應(yīng)功能。7. 實(shí)現(xiàn)用戶權(quán)限功能。管理員

3、權(quán)限為最高，可操作本系統(tǒng)所有功能。學(xué)生可查看、修改自己的信息，查看自己的成績(jī)，但不得添加、查詢、刪除他人信息與成績(jī)。教師可查看、修改自己的信息，查詢、編輯學(xué)生的成績(jī)信息，但不得添加、修改、刪除學(xué)生信息，不得添加、查詢、修改、刪除其他教師信息。8. 實(shí)現(xiàn)退出賬號(hào)、關(guān)閉系統(tǒng)、關(guān)于作者、版本信息、意見(jiàn)反饋和顯示當(dāng)前用戶信息功能。b. 設(shè)計(jì)思路1. 利用WindowBuilder插件可視化編寫GUI界面。2. 利用MySql數(shù)據(jù)庫(kù)保存學(xué)生、教師和管理員的信息，并用navicat管理數(shù)據(jù)庫(kù)。使用MVC框架，有以下幾個(gè)包：model包（模型）、view包（視圖）、images包（圖像）、util包（自己定

4、義的工具）、dao包（面向?qū)ο蟮臄?shù)據(jù)庫(kù)接口）。3. 對(duì)于用戶身份，將使用枚舉類實(shí)現(xiàn)，通過(guò)傳遞身份類型對(duì)象和用戶賬號(hào)對(duì)象實(shí)現(xiàn)各自功能操作。4. 信息管理界面的信息將以表格形式直觀體現(xiàn)，通過(guò)連接數(shù)據(jù)庫(kù)完成信息的添加、查詢、修改和刪除等功能。5. 根據(jù)不同的用戶身份選擇性的隱藏部分菜單、按鈕，實(shí)現(xiàn)用戶權(quán)限功能。6. 詳細(xì)列表：學(xué)生管理系統(tǒng)序號(hào)包名類名實(shí)例變量實(shí)例變量類型方法名方法的行為備注1modelAdminidprivate StringsetId建立序號(hào)getId獲得序號(hào)nameprivate StringsetName建立用戶名getName獲得用戶名ageprivate IntsetAge

5、建立年齡getAge獲得年齡passwordprivate StringsetPassword建立密碼getPassword獲得密碼Teacheridprivate StringsetId建立教工號(hào)getId獲得教工號(hào)nameprivate StringsetName建立用戶名getName獲得用戶名passwordprivate StringsetPassword建立密碼getPassword獲得密碼sexprivate StringsetSex建立性別getSex獲得性別ageprivate StringsetAge建立年齡getAge獲得年齡Studentidprivate String

6、setId建立學(xué)號(hào)getId獲得學(xué)號(hào)nameprivate StringsetName建立用戶名getName獲得用戶名passwordprivate StringsetPassword建立密碼getPassword獲得密碼sexprivate StringsetSex建立性別getSex獲得性別majorprivate StringsetMajor建立專業(yè)getMajor獲得專業(yè)courseNameprivate StringsetCourseName建立課程名getCourseName獲得課程名creditprivate StringsetCredit建立學(xué)分getCredit獲得學(xué)分ma

7、rkprivate intsetMark建立分?jǐn)?shù)getMark獲得分?jǐn)?shù)Identitynameprivate StringsetName建立名稱此類為枚舉類getName獲得名稱indexprivate intsetIndex建立索引getIndex獲得索引2viewLoginFramecontentPaneprivate JPanelloginAction點(diǎn)擊登錄按鈕所產(chǎn)生行為實(shí)現(xiàn)登陸功能idTextFieldprivate JTextFieldpasswordFieldprivate JPasswordFieldresetValue清空已經(jīng)輸入的內(nèi)容identityComboBoxpriv

8、ate JComboBoxMainFramecontentPaneprivate JPaneleditPassword打開修改密碼界面實(shí)現(xiàn)主界面各功能currentUser當(dāng)前用戶標(biāo)簽,顯示當(dāng)前用戶信息desktopPaneprivate JDesktopPaneidentityComboBoxpublic static IdentitymanageGrade顯示管理成績(jī)界面manageStudent打開管理學(xué)生界面userObjectpublic static ObjectmanageTeacher打開管理教師界面feedback用戶反饋gradeMenuprivate JMenuversi

9、onInformation版本信息shutdownSystem關(guān)閉系統(tǒng)teacherMenuprivate JMenuexitAccount用于系統(tǒng)設(shè)置中退出賬號(hào)studentMenuprivate JMenuaboutAuthor點(diǎn)擊關(guān)于作者后的彈窗userLabelprivate JLabelsetAuthority用戶權(quán)限ManageStudentFrameidTextFieldprivate JTextFieldinquireStudent查詢學(xué)生信息實(shí)現(xiàn)管理學(xué)生界面各功能nameTextFieldprivate JTextFieldAddStudent添加學(xué)生majorTextFie

10、ldprivate JTextFieldsetTable顯示列表內(nèi)容studentTableprivate JTabledeleteStudent刪除學(xué)生信息passwordFieldprivate JPasswordFieldselectTableRow鼠標(biāo)點(diǎn)擊得到信息maleRadioButtonprivate JRadioButtoneditStudent修改學(xué)生信息femaleRadioButtonprivate JRadioButtonsexButtonGroupprivate ButtonGroupsetAuthority用戶權(quán)限addButtonprivate JButtonin

11、quireButtonprivate JButtondeleteButtonprivate JButtonManageGradeFrameidTextFieldprivate JTextFieldselectTableRow鼠標(biāo)點(diǎn)擊得到信息實(shí)現(xiàn)管理成績(jī)界面各功能courseNameTextFieldprivate JTextFieldeditGrade保存學(xué)生成績(jī)creditTextFieldprivate JTextFieldinquireGrade查詢markTextFieldprivate JTextFieldsetTable顯示列表內(nèi)容gradeTableprivate JTableM

12、anageTeacherFrameidTextFieldprivate JTextFielddeleteTeacher刪除教師信息實(shí)現(xiàn)管理教師界面各功能nameTextFieldprivate JTextFieldselectTableRow鼠標(biāo)點(diǎn)擊得到信息ageTextFieldprivate JTextFieldpasswordFieldprivate JPasswordFieldeditTeacher修改教師信息teacherTableprivate JTableinquireTeacher查詢教師信息maleRadioButtonprivate JRadioButtonaddTeach

13、er添加教師femaleRadioButtonprivate JRadioButtonsexButtonGroupprivate ButtonGroupsetTable顯示列表內(nèi)容addButtonprivate JButtonsetAuthority用戶權(quán)限inquireButtonprivate JButtondeleteButtonprivate JButtonEditPasswordFrameoldPasswordFieldprivate JPasswordFieldconfirmPassword確認(rèn)修改密碼實(shí)現(xiàn)修改密碼界面各功能newPasswordFieldprivate JPas

14、swordFieldclearText清空文本框信息confirmPasswordFieldprivate JPasswordField3utilStringUtilisEmpty判斷字符串等是否為空DatabaseUtilgetCon獲取數(shù)據(jù)庫(kù)連接此工具用于連接數(shù)據(jù)庫(kù)closeCon關(guān)閉數(shù)據(jù)庫(kù)連接4daoBaseDaoBaseDao創(chuàng)建對(duì)數(shù)據(jù)庫(kù)連接對(duì)象父類AdminDaoadminLogin用于管理員登錄均為BaseDao子類editPassword修改密碼TeacherDaoteacherLogin用于教師登錄addTeacher添加教師getTeacherList顯示所有信息或查詢的信息

15、updateTeacher修改deleteTeacher刪除editPassword修改密碼StudentDaostudentLogin用于學(xué)生登錄addStudent添加學(xué)生getStudentList顯示所有信息或查詢的信息updateStudent學(xué)生信息修改updateGrade學(xué)生成績(jī)修改deleteStudent刪除editPassword修改密碼5images此包內(nèi)為本系統(tǒng)所用圖標(biāo)的圖像3、 實(shí)驗(yàn)程序/Admin.javapackage model;public class Admin private String id;/賬號(hào) private String name;/姓名 p

16、rivate int age;/年齡 private String password;/密碼public String getId() return id;public void setId(String id) this.id = id;public String getName() return name;public void setName(String name) = name;public int getAge() return age;public void setAge(int age) this.age = age;public String getPas

17、sword() return password;public void setPassword(String password) this.password = password;/Teacher.javapackage model;public class Teacher private String id;/賬號(hào) private String name;/姓名 private String password;/密碼 private String sex;/性別 private String age;/年齡public String getId() return id;public void

18、 setId(String id) this.id = id;public String getName() return name;public void setName(String name) = name;public String getPassword() return password;public void setPassword(String password) this.password = password;public String getSex() return sex;public void setSex(String sex) this.sex

19、 = sex;public String getAge() return age;public void setAge(String age) this.age = age;/Student.javapackage model;public class Student private String id;/學(xué)號(hào) private String name;/姓名 private String password;/密碼 private String sex;/性別 private String major;/專業(yè) private String courseName;/課程名稱 private Str

20、ing credit;/學(xué)分 private String mark;/分?jǐn)?shù)public String getId() return id;public void setId(String id) this.id = id;public String getName() return name;public void setName(String name) = name;public String getPassword() return password;public void setPassword(String password) this.password = p

21、assword;public String getSex() return sex;public void setSex(String sex) this.sex = sex;public String getMajor() return major;public void setMajor(String major) this.major = major;public String getCourseName() return courseName;public void setCourseName(String courseName) this.courseName = courseNam

22、e;public String getCredit() return credit;public void setCredit(String credit) this.credit = credit;public String getMark() return mark;public void setMark(String mark) this.mark = mark;/Identity.javapackage model;public enum Identity /身份 DEFAULT("-請(qǐng)選擇-",0),STUDENT("學(xué)生",1),TEACHE

23、R("教師",2),ADMIN("管理員",3);private String name;private int index;private Identity(String name,int index) = name;this.index = index;public String getName() return name;public void setName(String name) = name;public int getIndex() return index;public void setIndex

24、(int index) this.index = index;/DatabaseUtil.javapackage util;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DatabaseUtil /數(shù)據(jù)庫(kù)連接工具private String datebaseAddress="jdbc:mysql:/localhost:3306/database_student?useUnicode=true&characterEncoding

25、=utf8"/ 數(shù)據(jù)庫(kù)連接地址public Connection getCon() / 獲取數(shù)據(jù)庫(kù)連接try Class.forName("com.mysql.jdbc.Driver");/方法通過(guò)類的全稱來(lái)返回一個(gè)類/用靜態(tài)方法forName加載com.mysql.jdbc包中的Driver類建立橋接器 catch (ClassNotFoundException e) / TODO Auto-generated catch blocke.printStackTrace();/在命令行打印異常信息在程序中出錯(cuò)的位置及原因Connection con = null;

26、try con = DriverManager.getConnection(datebaseAddress, "root", "");/("數(shù)據(jù)庫(kù)連接地址","loginName","password") catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return con; /關(guān)閉數(shù)據(jù)庫(kù)連接public void closeCon(Connection con)throws Exceptio

27、nif(con!=null)con.close();/關(guān)閉數(shù)據(jù)庫(kù)public static void main(String args) DatabaseUtil datebaseUtil=new DatabaseUtil();try datebaseUtil.getCon();System.out.println("數(shù)據(jù)庫(kù)連接成功！"); catch (Exception e) / TODO Auto-generated catch blocke.printStackTrace();System.out.println("數(shù)據(jù)庫(kù)連接失敗！");/Str

28、ingUtil.javapackage util;public class StringUtil public static Boolean isEmpty(String string) /此方法用來(lái)判斷字符串是否為空 if(string = null|"".equals(string) return true; else return false; /BaseDao.javapackage dao;import java.sql.Connection;import java.sql.SQLException;import util.DatabaseUtil;public

29、class BaseDao /面向?qū)ο蟮臄?shù)據(jù)庫(kù)接口 public Connection con = new DatabaseUtil().getCon();/此項(xiàng)目與數(shù)據(jù)庫(kù)的連接使用此對(duì)象 public void closeDao() /此方法用來(lái)關(guān)閉數(shù)據(jù)庫(kù) try con.close(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace(); /AdminDao.javapackage dao;import java.sql.PreparedStatement;import java.sql.

30、ResultSet;import java.sql.SQLException;import model.Admin;public class AdminDao extends BaseDao /用于管理員登錄 public Admin adminLogin(Admin admin) Admin adm = null; String sql = "select * from admin where id=? and password=?"/數(shù)據(jù)庫(kù)查詢語(yǔ)句 try PreparedStatement prst = con.prepareStatement(sql);prst.s

31、etString(1,admin.getId();/對(duì)第一個(gè)參數(shù)?設(shè)置值idprst.setString(2, admin.getPassword();/對(duì)第二個(gè)參數(shù)?設(shè)置值passwordResultSet rs = prst.executeQuery();/內(nèi)存的結(jié)果集對(duì)象if(rs.next() /移到下一行數(shù)據(jù)獲取數(shù)據(jù)adm = new Admin();adm.setId(rs.getString("id");/獲得字段值adm.setName(rs.getString("name");/獲得字段值adm.setAge(rs.getInt(&qu

32、ot;age");/獲得字段值adm.setPassword(rs.getString("password");/獲得字段值 catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace(); return adm; public String editPassword(Admin admin,String newPassword)/修改密碼String sql = "select * from admin where id=? and password=?"

33、/數(shù)據(jù)庫(kù)查詢語(yǔ)句String id = null;try PreparedStatement preparedStatement = con.prepareStatement(sql);/向數(shù)據(jù)庫(kù)發(fā)送數(shù)據(jù)庫(kù)語(yǔ)句preparedStatement.setString(1, admin.getId();/將值傳給第一個(gè)?preparedStatement.setString(2, admin.getPassword();ResultSet rs = preparedStatement.executeQuery();/內(nèi)存的結(jié)果集對(duì)象if(!rs.next()/移到下一行數(shù)據(jù)獲取數(shù)據(jù)，并判斷是否有此

34、數(shù)據(jù)String returnString = "舊密碼錯(cuò)誤！"/返回舊密碼錯(cuò)誤return returnString;id = rs.getString("id");/如果舊密碼正確則將賬號(hào)賦值給id catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();String returnString = null;String sqlString = "update admin set password = ? where id = ?"/數(shù)

35、據(jù)庫(kù)更新語(yǔ)句try PreparedStatement preparedStatement = con.prepareStatement(sqlString);/向數(shù)據(jù)庫(kù)發(fā)送數(shù)據(jù)庫(kù)語(yǔ)句preparedStatement.setString(1, newPassword);/將值傳給第一個(gè)?preparedStatement.setString(2, id);if(preparedStatement.executeUpdate() > 0)/判斷是否修改成功returnString = "密碼修改成功！"else returnString = "密碼修改失敗！

36、" catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return returnString;/TeacherDao.javapackage dao;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import model.Admin;import model

37、.Teacher;import util.StringUtil;public class TeacherDao extends BaseDao public Teacher teacherLogin(Teacher teacher) /用于教師登錄 Teacher tea = null; String sql = "select * from teacher where id=? and password=?"/數(shù)據(jù)庫(kù)查詢語(yǔ)句 try PreparedStatement prst = con.prepareStatement(sql);prst.setString(1,te

38、acher.getId();/對(duì)第一個(gè)參數(shù)?設(shè)置值idprst.setString(2, teacher.getPassword();/對(duì)第二個(gè)參數(shù)?設(shè)置值passwordResultSet rs = prst.executeQuery();/內(nèi)存的結(jié)果集對(duì)象if(rs.next() /移到下一行數(shù)據(jù)獲取數(shù)據(jù)tea = new Teacher();tea.setId(rs.getString("id");/獲得字段值tea.setName(rs.getString("name");/獲得字段值tea.setPassword(rs.getString(&q

39、uot;password");/獲得字段值tea.setSex(rs.getString("sex");tea.setAge(rs.getString("age");/獲得字段值 catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace(); return tea; public boolean addTeacher(Teacher teacher) /添加教師 String sql = "insert into teacher values(?

40、,?,?,?,?)"/數(shù)據(jù)庫(kù)插入語(yǔ)句 PreparedStatement preparedStatement;try preparedStatement = con.prepareStatement(sql);/向數(shù)據(jù)庫(kù)發(fā)送語(yǔ)句preparedStatement.setString(1, teacher.getId();/將值傳給第一個(gè)?preparedStatement.setString(2, teacher.getName();preparedStatement.setString(3, teacher.getPassword();preparedStatement.setSt

41、ring(4, teacher.getSex();preparedStatement.setString(5, teacher.getAge();if(preparedStatement.executeUpdate()>0) return true; catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace(); return false; public List<Teacher> getTeacherList(Teacher teacher)/顯示所有信息與只顯示查詢的信息List&l

42、t;Teacher> list = new ArrayList<Teacher>();/List接口,有序String sql = "select * from teacher"if(!StringUtil.isEmpty(teacher.getId()/用于查詢文本框sql += " where id like '%"+teacher.getId()+"%' "/模糊查詢語(yǔ)句try PreparedStatement preparedStatement = con.prepareStatement(

43、sql);/向數(shù)據(jù)庫(kù)發(fā)送語(yǔ)句ResultSet rs = preparedStatement.executeQuery();/內(nèi)存的結(jié)果集對(duì)象while(rs.next()/移到下一行數(shù)據(jù)獲取數(shù)據(jù)Teacher teac = new Teacher();teac.setId(rs.getString("id");/獲得字段值teac.setName(rs.getString("name");/獲得字段值teac.setPassword(rs.getString("password");/獲得字段值teac.setSex(rs.getS

44、tring("sex");/獲得字段值teac.setAge(rs.getString("age");/獲得字段值list.add(teac); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return list; public boolean updateTeacher(Teacher teacher)/修改String sql = "update teacher set name=?, password=?, sex=?, age=?

45、 where id=?"/數(shù)據(jù)庫(kù)更新語(yǔ)句try PreparedStatement preparedStatement = con.prepareStatement(sql);/向數(shù)據(jù)庫(kù)發(fā)送語(yǔ)句preparedStatement.setString(1, teacher.getName();/將值傳給第一個(gè)?preparedStatement.setString(2, teacher.getPassword();preparedStatement.setString(3, teacher.getSex();preparedStatement.setString(4, teacher.

46、getAge();preparedStatement.setString(5, teacher.getId();if(preparedStatement.executeUpdate() > 0)return true; catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return false; public boolean deleteTeacher(String id)/刪除String sql = "delete from teacher where id=?"

47、/數(shù)據(jù)庫(kù)刪除語(yǔ)句try PreparedStatement preparedStatement = con.prepareStatement(sql);/向數(shù)據(jù)庫(kù)發(fā)送語(yǔ)句preparedStatement.setString(1, id);/將值傳給第一個(gè)?if(preparedStatement.executeUpdate() > 0)return true; catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();return false; public String editPasswo

48、rd(Teacher teacher,String newPassword)/修改密碼String sql = "select * from teacher where id=? and password=?"/數(shù)據(jù)庫(kù)查詢語(yǔ)句String id = null;try PreparedStatement preparedStatement = con.prepareStatement(sql);/向數(shù)據(jù)庫(kù)發(fā)送數(shù)據(jù)庫(kù)語(yǔ)句preparedStatement.setString(1, teacher.getId();/將值傳給第一個(gè)?preparedStatement.setStr

49、ing(2, teacher.getPassword();ResultSet rs = preparedStatement.executeQuery();/內(nèi)存的結(jié)果集對(duì)象if(!rs.next()/移到下一行數(shù)據(jù)獲取數(shù)據(jù)，并判斷是否有此數(shù)據(jù)String returnString = "舊密碼錯(cuò)誤！"/返回舊密碼錯(cuò)誤return returnString;id = rs.getString("id");/如果舊密碼正確則將賬號(hào)賦值給id catch (SQLException e) / TODO Auto-generated catch blocke.p

50、rintStackTrace();String returnString = null;String sqlString = "update teacher set password = ? where id = ?"/數(shù)據(jù)庫(kù)更新語(yǔ)句try PreparedStatement preparedStatement = con.prepareStatement(sqlString);/向數(shù)據(jù)庫(kù)發(fā)送數(shù)據(jù)庫(kù)語(yǔ)句preparedStatement.setString(1, newPassword);/將值傳給第一個(gè)?preparedStatement.setString(2, id)

51、;if(preparedStatement.executeUpdate() > 0)/判斷是否修改成功returnString = "密碼修改成功！"else returnString = "密碼修改失??！" catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();/把sql語(yǔ)句傳給數(shù)據(jù)庫(kù)操作對(duì)象return returnString;/StudentDao.javapackage dao;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import model.Admin;import model.Student;import model.Teacher;import util.StringUtil;public class StudentDao extends BaseDao public Student studentLogin(Student student ) /用于學(xué)生登