学生管理系统图形界面Java.docx
《学生管理系统图形界面Java.docx》由会员分享，可在线阅读，更多相关《学生管理系统图形界面Java.docx（15页珍藏版）》请在冰点文库上搜索。
学生管理系统图形界面Java
学生管理系统（图形界面）——Java
源代码：
packageexp10;
importjavax.swing.JFrame;
publicclassMainClass{
/**
*@paramargs
*/
publicstaticvoidmain（String[]args）{
//TODOAuto-generatedmethodstub
JFramemyFrame=newJFrame（"学生成绩管理系统"）;
myFrame.setLocation（300,100）;
//
myFrame.setContentPane（newLoginPane（myFrame））;
myFrame.pack（）;
myFrame.setVisible（true）;
}
}
packageexp10;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
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（SQLExceptione）{
System.out.println（e.getMessage（））;
returnfalse;
}catch（ClassNotFoundExceptione）{
//TODOAuto-generatedcatchblock
e.printStackTrace（）;
returnfalse;
}
}
publicResultSetexecuteQuery（Stringsql）{
ResultSetrs=null;
Statementstmt=null;
if（conn==null）{
this.getConnection（）;}
try{
stmt=conn.createStatement（）;
rs=stmt.executeQuery（sql）;
returnrs;
}catch（SQLExceptione）{
returnnull;
}
}
publicintexecuteUpdate（Stringsql）{
Statementstmt=null;
intlinecount=0;
if（conn==null）{
this.getConnection（）;}
try{
stmt=conn.createStatement（）;
linecount=stmt.executeUpdate（sql）;
}catch（SQLExceptione）{}
returnlinecount;
}
}
packageexp10;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjavax.swing.Box;
importjavax.swing.ButtonGroup;
importjavax.swing.JButton;
importjavax.swing.JFrame;
importjavax.swing.JLabel;
importjavax.swing.JPanel;
importjavax.swing.JPasswordField;
importjavax.swing.JRadioButton;
importjavax.swing.JTextField;
publicclassLoginPaneextendsJPanelimplementsActionListener{
/**
*
*/
privatestaticfinallongserialVersionUID=1L;
JFramemyFrame;
JLabellab_username=newJLabel（"用户名"）;
JTextFieldjt_username=newJTextField（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（）{
Boxbox_user=Box.createHorizontalBox（）;
box_user.add（lab_username）;
box_user.add（Box.createHorizontalStrut（20））;
box_user.add（jt_username）;
jt_pwd.setEchoChar（'#'）;
Boxbox_pwd=Box.createHorizontalBox（）;
box_pwd.add（lab_password）;
box_pwd.add（Box.createHorizontalStrut（20））;
box_pwd.add（jt_pwd）;
ButtonGroupbg=newButtonGroup（）;
bg.add（jrb_manager）;
bg.add（jrb_teacher）;
bg.add（jrb_student）;
Boxbox_role=Box.createHorizontalBox（）;
box_role.add（jrb_manager）;
box_role.add（Box.createHorizontalStrut（5））;
box_role.add（jrb_teacher）;
box_role.add（Box.createHorizontalStrut（5））;
box_role.add（jrb_student）;
JButtonjb_login=newJButton（"登陆"）;
JButtonjb_exit=newJButton（"退出"）;
Boxbox_button=Box.createHorizontalBox（）;
box_button.add（jb_login）;
box_button.add（Box.createHorizontalStrut（30））;
box_button.add（jb_exit）;
jb_login.addActionListener（this）;
jb_exit.addActionListener（this）;
jb_login.setActionCommand（"login"）;
jb_exit.setActionCommand（"exit"）;
Boxbox_login=Box.createVerticalBox（）;
box_login.add（box_user）;
box_login.add（Box.createHorizontalStrut（10））;
box_login.add（box_pwd）;
box_login.add（Box.createHorizontalStrut（10））;
box_login.add（box_role）;
box_login.add（Box.createHorizontalStrut（10））;
box_login.add（box_button）;
this.add（box_login）;
}
@Override
publicvoidactionPerformed（ActionEvente）{
//TODOAuto-generatedmethodstub
if（e.getActionCommand（）.equals（"login"））{
Stringusername=this.jt_username.getText（）.trim（）;
Stringpwd=String.valueOf（this.jt_pwd.getPassword（））;
DataBasedb=newDataBase（）;
Stringsql="select*fromUserwherename='"+username+"'andpassword='"+pwd+"'";
ResultSetrs=db.executeQuery（sql）;
if（rs!
=null）{
this.myFrame.setContentPane（newManagerPane（this.myFrame））;
myFrame.setSize（800,500）;
this.myFrame.validate（）;
}
}else{
this.myFrame.dispose（）;
}
}
}
packageexp10;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.awt.event.ItemEvent;
importjava.awt.event.ItemListener;
importjavax.swing.JFrame;
importjavax.swing.JMenu;
importjavax.swing.JMenuBar;
importjavax.swing.JMenuItem;
importjavax.swing.JPanel;
importjavax.swing.JTable;
publicclassManagerPaneextendsJPanelimplementsActionListener{
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_exit=newJMenu（"退出"）;
menu.add（jm_user）;
menu.add（jm_exit）;
this.add（menu,0）;
}
@Override
publicvoidactionPerformed（ActionEvente）{
//TODOAuto-generatedmethodstub
if（e.getActionCommand（）.equals（"searchUser"））{
this.myFrame.setContentPane（newSearchUserPane（this.myFrame））;
this.myFrame.validate（）;
}
}
}
packageexp10;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.util.Vector;
importjavax.swing.Box;
importjavax.swing.JButton;
importjavax.swing.JFrame;
importjavax.swing.JLabel;
importjavax.swing.JPanel;
importjavax.swing.JTable;
importjavax.swing.JTextField;
importjavax.swing.table.DefaultTableModel;
publicclassSearchUserPaneextendsJPanelimplementsActionListener{
/**
*
*/
privatestaticfinallongserialVersionUID=1L;
JFramemyFrame;
JLabeljlb_name=newJLabel（"查询用户名"）;
JTextFieldjt_name=newJTextField（20）;
JButtonbtn_search=newJButton（"查询"）;
DataBasedb=newDataBase（）;
DefaultTableModeltableModel;
JTablejt_show;
publicSearchUserPane（JFramemyFrame）{
this.myFrame=myFrame;
init（）;
}
publicvoidinit（）{
Boxbox_user=Box.createHorizontalBox（）;
box_user.add（jlb_name）;
box_user.add（Box.createHorizontalStrut（20））;
box_user.add（jt_name）;
btn_search.addActionListener（this）;
box_user.add（btn_search）;
String[]colname={"编号","姓名","密码","身份"};
tableModel=newDefaultTableModel（null,colname）;
jt_show=newJTable（tableModel）;
Boxbox_show=Box.createHorizontalBox（）;
box_show.add（jt_show）;
ResultSetrs=db.executeQuery（"select*fromUser"）;
try{
while（rs.next（））{
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（SQLExceptione）{
//TODOAuto-generatedcatchblock
e.printStackTrace（）;
}
Boxbox_search=Box.createVerticalBox（）;
box_search.add（box_user）;
box_search.add（Box.createVerticalStrut（50））;
box_search.add（box_show）;
this.add（box_search）;
}
@Override
publicvoidactionPerformed（ActionEvente）{
//TODOAuto-generatedmethodstub
if（e.getSource（）==this.btn_search）{
Stringusername=this.jt_name.getText（）.trim（）;
ResultSetrs=db.executeQuery（"select*fromUserwherename='"+username+"'"）;
try{
while（rs.next（））{
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（SQLExceptione1）{
//TODOAuto-generatedcatchblock
e1.printStackTrace（）;
}
}
}
}
packageexp10;
importjavax.swing.JTable;
importjavax.swing.table.DefaultTableModel;
publicclassUserTableextendsJTable{
publicUserTable（）{
}
}
packageexp10;
importjava.sql.ResultSet;
importjava.sql.ResultSetMetaData;
importjava.sql.SQLException;
importjava.util.Vector;
importjavax.swing.table.AbstractTableModel;
publicclassUserTableModelextendsAbstractTableModel{
ResultSetrs;
Vectortabledat;
publicUserTableModel（）{
DataBasedb=newDataBase（）;
rs=db.executeQuery（"select*fromUser"）;
tabledat=newVector（）;
}
@Override
publicintgetColumnCount（）{
//TODOAuto-generatedmethodstub
try{
ResultSetMetaDatametadata=rs.getMetaData（）;
returnmetadata.getColumnCount（）;
}catch（SQLExceptione）{
//TODOAuto-generatedcatchblock
return0;
}
}
@Override
publicintgetRowCount（）{
//TODOAuto-generatedmethodstub
intrownum=0;
try{
while（rs.next（））{
rownum++;
}
}catch（SQLExceptione）{
//TODOAuto-generatedcatchblock
e.printStackTrace（）;
}
returnrownum;
}
@Override
publicObjectgetValueAt（introw,intcol）{
//TODOAuto-generatedmethodstub
try{
if（rs.absolute（row））{
returnrs.getObject（col）;
}
}catch（SQLExceptione）{
//TODOAuto-generatedcatchblock
}
升级会员 