学生管理系统图形界面-java

..>学生管理系统〔图形界面〕——Java源代码：packagee*p10;importjava*.swing.JFrame;publicclassMainClass{ /** *paramargs */ publicstaticvoidmain(String[]args){ //TODOAuto-generatedmethodstub JFramemyFrame=newJFrame("学生成绩管理系统"); myFrame.setLocation(300,100);// myFrame.setContentPane(newLoginPane(myFrame)); myFrame.pack(); myFrame.setVisible(true); }}packagee*p10;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLE*ception;importjava.sql.Statement;publicclassDataBase{ Connectionconn=null; publicConnectiongetConn(){ returnthis.conn; } publicvoidsetConn(Connectionconn){ this.conn=conn; } publicbooleangetConnection(){ Stringurl="jdbc:mysql://localhost:3306/ScoreManagement"user=root&password=123"; try{ Class.forName("org.gjt.mm.mysql.Driver"); conn=DriverManager.getConnection(url); returntrue; }catch(SQLE*ceptione){ System.out.println(e.getMessage()); returnfalse; }catch(ClassNotFoundE*ceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); returnfalse; } } publicResultSete*ecuteQuery(Stringsql){ ResultSetrs=null; Statementstmt=null; if(conn==null){ this.getConnection();} try{ stmt=conn.createStatement(); rs=stmt.e*ecuteQuery(sql); returnrs; }catch(SQLE*ceptione){ returnnull; } } publicinte*ecuteUpdate(Stringsql){ Statementstmt=null; intlinecount=0; if(conn==null){ this.getConnection();} try{ stmt=conn.createStatement(); linecount=stmt.e*ecuteUpdate(sql); }catch(SQLE*ceptione){} returnlinecount; }}packagee*p10;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.ResultSet;importjava.sql.SQLE*ception;importjava*.swing.Bo*;importjava*.swing.ButtonGroup;importjava*.swing.JButton;importjava*.swing.JFrame;importjava*.swing.JLabel;importjava*.swing.JPanel;importjava*.swing.JPasswordField;importjava*.swing.JRadioButton;importjava*.swing.JTe*tField;publicclassLoginPanee*tendsJPanelimplementsActionListener{ /** * */ privatestaticfinallongserialVersionUID=1L; JFramemyFrame;JLabellab_username=newJLabel("用户名"); JTe*tFieldjt_username=newJTe*tField(20); JLabellab_password=newJLabel("密码"); JPasswordFieldjt_pwd=newJPasswordField(20); JRadioButtonjrb_manager=newJRadioButton("管理员"); JRadioButtonjrb_teacher=newJRadioButton("教师"); JRadioButtonjrb_student=newJRadioButton("学生"); publicLoginPane(JFramemyFrame){ this.myFrame=myFrame; this.init(); } publicvoidinit(){ Bo*bo*_user=Bo*.createHorizontalBo*(); bo*_user.add(lab_username); bo*_user.add(Bo*.createHorizontalStrut(20)); bo*_user.add(jt_username); jt_pwd.setEchoChar('#'); Bo*bo*_pwd=Bo*.createHorizontalBo*(); bo*_pwd.add(lab_password); bo*_pwd.add(Bo*.createHorizontalStrut(20)); bo*_pwd.add(jt_pwd); ButtonGroupbg=newButtonGroup(); bg.add(jrb_manager); bg.add(jrb_teacher); bg.add(jrb_student); Bo*bo*_role=Bo*.createHorizontalBo*(); bo*_role.add(jrb_manager); bo*_role.add(Bo*.createHorizontalStrut(5)); bo*_role.add(jrb_teacher); bo*_role.add(Bo*.createHorizontalStrut(5)); bo*_role.add(jrb_student); JButtonjb_login=newJButton("登陆"); JButtonjb_e*it=newJButton("退出"); Bo*bo*_button=Bo*.createHorizontalBo*(); bo*_button.add(jb_login); bo*_button.add(Bo*.createHorizontalStrut(30)); bo*_button.add(jb_e*it); jb_login.addActionListener(this); jb_e*it.addActionListener(this); jb_login.setActionCommand("login"); jb_e*it.setActionCommand("e*it"); Bo*bo*_login=Bo*.createVerticalBo*(); bo*_login.add(bo*_user); bo*_login.add(Bo*.createHorizontalStrut(10)); bo*_login.add(bo*_pwd); bo*_login.add(Bo*.createHorizontalStrut(10)); bo*_login.add(bo*_role); bo*_login.add(Bo*.createHorizontalStrut(10)); bo*_login.add(bo*_button); this.add(bo*_login); } Override publicvoidactionPerformed(ActionEvente){ //TODOAuto-generatedmethodstub if(e.getActionCommand().equals("login")){ Stringusername=this.jt_username.getTe*t().trim(); Stringpwd=String.valueOf(this.jt_pwd.getPassword()); DataBasedb=newDataBase(); Stringsql="select*fromUserwherename='"+username+"'andpassword='"+pwd+"'"; ResultSetrs=db.e*ecuteQuery(sql); if(rs!=null){ this.myFrame.setContentPane(newManagerPane(this.myFrame)); myFrame.setSize(800,500); this.myFrame.validate(); } }else{ this.myFrame.dispose(); } }}packagee*p10;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.awt.event.ItemEvent;importjava.awt.event.ItemListener;importjava*.swing.JFrame;importjava*.swing.JMenu;importjava*.swing.JMenuBar;importjava*.swing.JMenuItem;importjava*.swing.JPanel;importjava*.swing.JTable;publicclassManagerPanee*tendsJPanelimplementsActionListener{ JFramemyFrame; publicManagerPane(JFramemyFrame){ this.myFrame=myFrame; this.init(); } publicvoidinit(){ JMenuBarmenu=newJMenuBar(); JMenujm_user=newJMenu("人员管理"); JMenuItemjmi_add=newJMenuItem("增加人员"); JMenuItemjmi_search=newJMenuItem("查询人员"); jmi_add.addActionListener(this); jmi_add.setActionCommand("addUser"); jmi_search.addActionListener(this); jmi_search.setActionCommand("searchUser"); jm_user.add(jmi_add); jm_user.add(jmi_search); JMenujm_e*it=newJMenu("退出"); menu.add(jm_user); menu.add(jm_e*it); this.add(menu,0); } Override publicvoidactionPerformed(ActionEvente){ //TODOAuto-generatedmethodstub if(e.getActionCommand().equals("searchUser")){ this.myFrame.setContentPane(newSearchUserPane(this.myFrame)); this.myFrame.validate(); } }}packagee*p10;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.ResultSet;importjava.sql.SQLE*ception;importjava.util.Vector;importjava*.swing.Bo*;importjava*.swing.JButton;importjava*.swing.JFrame;importjava*.swing.JLabel;importjava*.swing.JPanel;importjava*.swing.JTable;importjava*.swing.JTe*tField;importjava*.swing.table.DefaultTableModel;publicclassSearchUserPanee*tendsJPanelimplementsActionListener{ /** * */ privatestaticfinallongserialVersionUID=1L; JFramemyFrame;JLabeljlb_name=newJLabel("查询用户名"); JTe*tFieldjt_name=newJTe*tField(20); JButtonbtn_search=newJButton("查询"); DataBasedb=newDataBase(); DefaultTableModeltableModel; JTablejt_show; publicSearchUserPane(JFramemyFrame){ this.myFrame=myFrame; init(); } publicvoidinit(){ Bo*bo*_user=Bo*.createHorizontalBo*(); bo*_user.add(jlb_name); bo*_user.add(Bo*.createHorizontalStrut(20)); bo*_user.add(jt_name); btn_search.addActionListener(this); bo*_user.add(btn_search); String[]colname={"","","密码","身份"}; tableModel=newDefaultTableModel(null,colname); jt_show=newJTable(tableModel); Bo*bo*_show=Bo*.createHorizontalBo*(); bo*_show.add(jt_show); ResultSetrs=db.e*ecuteQuery("select*fromUser"); try{ while(rs.ne*t()){ Vectordata=newVector(); data.add(rs.getString("id")); data.add(rs.getString("name")); data.add(rs.getString("password")); data.add(rs.getString("role")); tableModel.addRow(data); } }catch(SQLE*ceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); } Bo*bo*_search=Bo*.createVerticalBo*(); bo*_search.add(bo*_user); bo*_search.add(Bo*.createVerticalStrut(50)); bo*_search.add(bo*_show); this.add(bo*_search); } Override publicvoidactionPerformed(ActionEvente){ //TODOAuto-generatedmethodstub if(e.getSource()==this.btn_search){ Stringusername=this.jt_name.getTe*t().trim(); ResultSetrs=db.e*ecuteQuery("select*fromUserwherename='"+username+"'"); try{ while(rs.ne*t()){ Vectordata=newVector(); data.add(rs.getString("id")); data.add(rs.getString("name")); data.add(rs.getString("password")); data.add(rs.getString("role")); tableModel.fireTableDataChanged(); tableModel.addRow(data); } }catch(SQLE*ceptione1){ //TODOAuto-generatedcatchblock e1.printStackTrace(); } } }}packagee*p10;importjava*.swing.JTable;importjava*.swing.table.DefaultTableModel;publicclassUserTablee*tendsJTable{ publicUserTable(){ }}packagee*p10;importjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.SQLE*ception;importjava.util.Vector;importjava*.swing.table.AbstractTableModel;publiccla