还剩31页未读,继续阅读
本资源只提供10页预览,全部文档请下载后查看!喜欢就下载吧,查找使用更方便
文本内容:
设计数据库CREATEDATABASE学生成绩管理系统
(1)教师信息表创建createtable教师信息表教师IDvarchar8primarykey教师姓名varchar8notnullunique登录密码varchar8notnull
(2)学籍信息表创建createtable学籍信息表学号varchar15primarykey姓名varchar8notnull年龄varchar10出生日期varchar10性别varchar4班级varchar8notnull专业varchar5民族varchar10登录密码varchar6notnull
(3)成绩信息表创建createtable成绩信息表学号varchar15计算机网络varchar8计算机专业英语smallint计算机信息技术基础smallintJava程序设计smallint数据库应用实训教程smallint高等数学smallintXmlsmallint概要结构分析
1.登录界面和主界面importjavax.swing.*;importjavax.swing.table.DefaultTableModel;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;classmyConnection{ResultSetre;publicmyConnection{}publicResultSetgetResultStringsql{try{Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;Connectionconn=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;Statementstmt=conn.createStatementResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_UPDATABLE;ResultSetre=stmt.executeQuerysql;returnre;}catchExceptione{System.out.printlngetResult------+e.toString;returnnull;}}publicbooleanexecuteSqlStringsql{try{Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;Connectionconn=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;Statementstmt=conn.createStatement;stmt.executeUpdatesql;conn.commit;returntrue;}catchExceptione{System.out.printlnexecuteSql----+e.toString;returnfalse;}}}classstuMainFrameextendsJFrameimplementsActionListener{JMenuBarjmb=newJMenuBar;JMenuMessage=newJMenu信息;JMenuScore=newJMenu查询;JMenuItemItem1=newJMenuItem添加学生信息;JMenuItemmName=newJMenuItem学生成绩查询;JMenuItemmScore=newJMenuItem按成绩查询;JMenuItemmNam1=newJMenuItem查询学生信息;JLabellabel=newJLabel;publicstuMainFrame{ImageIconicon=newImageIconsrc/images/
1.jpg;label.setIconicon;label.setBounds00icon.getIconWidthicon.getIconHeight;addlabel;setSizelabel.getWidthlabel.getHeight;this.setJMenuBarjmb;jmb.addMessage;jmb.addScore;Message.addItem1;Score.addmNam1;Score.addmName;Score.addmScore;Item
1.addActionListenerthis;mName.addActionListenerthis;mScore.addActionListenerthis;mNam
1.addActionListenerthis;}publicvoidactionPerformedActionEvente{ife.getSource==Item1{newaddForm.setVisibletrue;}elseife.getSource==mName{dispose;newScore
1.setVisibletrue;}elseife.getSource==mScore{newscoreQueryForm.setVisibletrue;}elseife.getSource==mNam1{dispose;newSerch
1.setVisibletrue;}}}classmainFrameextendsJFrameimplementsActionListener{JLabellabel=newJLabel;JMenuBarmBar=newJMenuBar;JPanelp=newJPanel;privateJMenumSystemmOperatemQuerymHelpmyMenuUser;privateJMenuItemmFilemNewmOpenmExitmAddmDelmModifymNamemiShowmScoremAboutmiUsermAddSc;publicmainFrame{this.setJMenuBarmBar;ImageIconicon=newImageIconsrc/images/
1.jpg;label.setIconicon;label.setBounds00icon.getIconWidthicon.getIconHeight;addlabel;setSizelabel.getWidthlabel.getHeight;myMenuUser=newJMenu用户;miUser=newJMenuItem编辑用户;myMenuUser.addmiUser;mSystem=newJMenu系统;mOperate=newJMenu数据操作;mQuery=newJMenu查询;mHelp=newJMenu帮助;mBar.addmSystem;mBar.addmOperate;mBar.addmQuery;mBar.addmHelp;mBar.addmyMenuUser;mFile=newJMenuItem文件;mNew=newJMenuItem新建;mOpen=newJMenuItem打开;mExit=newJMenuItem退出;mSystem.addmFile;mSystem.addmNew;mSystem.addmOpen;mSystem.addSeparator;mSystem.addmExit;mAdd=newJMenuItem添加基本信息;mAddSc=newJMenuItem添加成绩信息;mDel=newJMenuItem删除;mModify=newJMenuItem修改;mOperate.addmAdd;mOperate.addmAddSc;mOperate.addmDel;mOperate.addmModify;mName=newJMenuItem查询学生信息;mScore=newJMenuItem查询学生成绩;miShow=newJMenuItem全部显示;mQuery.addmName;mQuery.addmScore;mQuery.addSeparator;mQuery.addmiShow;mAbout=newJMenuItem软件信息;mHelp.addmAbout;mExit.addActionListenerthis;mAdd.addActionListenerthis;mDel.addActionListenerthis;mModify.addActionListenerthis;mName.addActionListenerthis;mScore.addActionListenerthis;mAbout.addActionListenerthis;miShow.addActionListenerthis;miUser.addActionListenerthis;mAddSc.addActionListenerthis;}publicvoidactionPerformedActionEvente{ife.getSource==mExit{dispose;newCJ.setVisibletrue;}elseife.getSource==mAbout{JOptionPane.showMessageDialogthis学生成绩管理系统\n\n电信学院\n\n2012年3月软件信息JOptionPane.INFORMATION_MESSAGE;}elseife.getSource==mAdd{dispose;newaddForm.setVisibletrue;}elseife.getSource==mAddSc{dispose;newaddScore.setVisibletrue;}elseife.getSource==mDel{dispose;newdeleteForm.setVisibletrue;}elseife.getSource==mName{dispose;newSerch.setVisibletrue;}elseife.getSource==mScore{dispose;newScore.setVisibletrue;}elseife.getSource==mModify{newmodifyForm.setVisibletrue;}elseife.getSource==miUser{newuserFrame.setVisibletrue;}elseife.getSource==miShow{newfreshTable.setVisibletrue;}}}classCJextendsJFrameimplementsActionListener{JLabelt1=newJLabelID号:;JLabelt3=newJLabel密码:;JLabellabel=newJLabel;publicStringzh=null;JTextFieldt2=newJTextFieldnull15;JTextFieldt4=newJPasswordFieldnull15;JRadioButtonb=newJRadioButton教师;JRadioButtonb1=newJRadioButton学生;JButtonjB1=newJButton登录;JButtonjB2=newJButton取消;publicCJ{super学生生成绩管理系统;setLayoutnull;jB
1.setBounds1101706020;jB
1.setBackgroundColor.red;addjB1;jB
2.setBounds2101706020;jB
2.setBackgroundColor.red;addjB2;t
1.setBounds90508035;addt1;t
2.setBounds1205015035;addt2;t
3.setBounds901008035;addt3;t
4.setBounds12010015035;addt4;b.setBounds200207030;b
1.setBounds120207030;ButtonGroupbg=newButtonGroup;b.setSelectedfalse;b
1.setSelectedtrue;b
1.setSelectedfalse;addb;bg.addb;addb1;bg.addb1;b.setContentAreaFilledfalse;b
1.setContentAreaFilledfalse;ImageIconicon=newImageIconsrc/images/a.jpg;label.setIconicon;label.setBounds00icon.getIconWidthicon.getIconHeight;addlabel;setSizelabel.getWidthlabel.getHeight;setResizablefalse;setVisibletrue;setLocation300300;setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;jB
1.addActionListenerthis;jB
2.addActionListenerthis;}publicvoidactionPerformedActionEvente{ife.getSource==jB2{System.exit0;}elseife.getSource==jB1{Stringusernamepassword;username=t
2.getText;password=t
4.getText;ifb.isSelected{ifusername.toString.equals{JOptionPane.showMessageDialognull请输入用户名温馨提示JOptionPane.INFORMATION_MESSAGE;}elseifpassword.toString.equals{JOptionPane.showMessageDialognull请输入密码温馨提示JOptionPane.INFORMATION_MESSAGE;}else{myConnectionconn=newmyConnection;ResultSetrs;Stringsql=select*from教师信息表where教师ID=+username.toString+and登录密码=+password.toString+;try{rs=conn.getResultsql;rs.last;ifrs.getRow==1{setVisiblefalse;rs.beforeFirst;whilers.next{this.dispose;sql=select*from学籍信息表;mainFramemf=newmainFrame;mf.setLayoutnull;mf.setVisibletrue;mf.setLocation300300;mf.setResizablefalse;mf.setTitle学生成绩管理系统教师登录界面;mf.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;mf.addWindowListenernewWindowAdapter{publicvoidwindowClosingWindowEvente{System.exit0;}};JOptionPane.showMessageDialognullrs.getString教师姓名+老师!您好!欢迎登录学生成绩管理系统!;}}else{JOptionPane.showMessageDialognull用户名或密码错误登录失败JOptionPane.INFORMATION_MESSAGE;}}catchExceptioner{System.out.printlner.toString;}}}ifb
1.isSelected{ifusername.toString.equals{JOptionPane.showMessageDialognull请输入用户名温馨提示JOptionPane.INFORMATION_MESSAGE;}elseifpassword.toString.equals{JOptionPane.showMessageDialognull请输入密码温馨提示JOptionPane.INFORMATION_MESSAGE;}else{myConnectionconn=newmyConnection;ResultSetrs;Stringsql=select*from学籍信息表where学号=+t
2.getText.toString+and登录密码=+t
4.getText.toString+;try{rs=conn.getResultsql;rs.last;ifrs.getRow==1{setVisiblefalse;rs.beforeFirst;whilers.next{this.dispose;sql=select*from学籍信息表;stuMainFramesmf=newstuMainFrame;smf.setSize500400;smf.setVisibletrue;smf.setResizablefalse;smf.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;smf.addWindowListenernewWindowAdapter{publicvoidwindowClosingWindowEvente{System.exit0;}};JOptionPane.showMessageDialognullrs.getString学生姓名+同学!您好!欢迎登录学生成绩管理系统!;}}else{JOptionPane.showMessageDialognull用户名或密码错误登录失败JOptionPane.INFORMATION_MESSAGE;}}catchExceptioner{System.out.printlner.toString;}}}}}publicstaticvoidmainString[]args{try{UIManager.setLookAndFeelUIManager.getSystemLookAndFeelClassName;}catchExceptione{}CJframe=newCJ;newmainFrame;stuMainFramestu=newstuMainFrame;}}
2.添加学生基本信息importjavax.swing.*;importjavax.swing.table.DefaultTableModel;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassaddFormextendsJFrameimplementsActionListener{JLabellabel1=newJLabel添加基本信息JLabel.CENTER;JLabellabxuehao=newJLabel学号JLabel.CENTER;JLabellabyear=newJLabel年龄JLabel.CENTER;JLabellabName=newJLabel姓名JLabel.CENTER;JLabellabDate=newJLabel出生日期JLabel.CENTER;JLabellabclass=newJLabel班级JLabel.CENTER;JLabellabzy=newJLabel专业JLabel.CENTER;JLabellabmz=newJLabel民族JLabel.CENTER;JLabellabsex=newJLabel性别JLabel.CENTER;JTextFieldtxtName=newJTextField20;JTextFieldtxtDate=newJTextField18;JTextFieldtxtXueHao=newJTextField20;JTextFieldtxtYear=newJTextField20;JTextFieldtxtClass=newJTextField20;JTextFieldtxtZY=newJTextField20;JTextFieldtxtMZ=newJTextField20;ButtonGroupbgp=newButtonGroup;JRadioButtonman=newJRadioButton男;JRadioButtonwomen=newJRadioButton女;JButtonbtnAdd=newJButton添加;JButtonbtnCancel=newJButton返回;JButtonbtnReset=newJButton重置;JPaneljpl=newJPanel;//创建面板对象Connectioncon;Statementsql;ResultSetrs;addForm{super添加学生信息;this.setResizablefalse;this.setSize550450;this.setVisibletrue;this.setLocation300300;this.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;this.addjpl;jpl.setLayoutnull;btnAdd.addActionListenerthis;btnReset.addActionListenerthis;btnCancel.addActionListenerthis;jpl.setBackgroundColor.cyan;man.setBackgroundColor.cyan;women.setBackgroundColor.cyan;label
1.setBounds1002030020;jpl.addlabel1;labxuehao.setBounds100507020;jpl.addlabxuehao;txtXueHao.setBounds1905014020;jpl.addtxtXueHao;labName.setBounds100907020;jpl.addlabName;txtName.setBounds1909014020;jpl.addtxtName;labsex.setBounds1101306020;jpl.addlabsex;man.setBounds1901306020;women.setBounds2701306020;jpl.addman;jpl.addwomen;bgp.addman;bgp.addwomen;labyear.setBounds1001807020;jpl.addlabyear;txtYear.setBounds19018014020;jpl.addtxtYear;labDate.setBounds1002107020;jpl.addlabDate;txtDate.setBounds19021014020;jpl.addtxtDate;labmz.setBounds1002407020;jpl.addlabmz;txtMZ.setBounds19024014020;jpl.addtxtMZ;labclass.setBounds1002707020;jpl.addlabclass;txtClass.setBounds19027014020;jpl.addtxtClass;labzy.setBounds1003007020;jpl.addlabzy;txtZY.setBounds19030014020;jpl.addtxtZY;btnReset.setBounds803509020;btnAdd.setBounds2003509020;btnCancel.setBounds3203509020;jpl.addbtnReset;jpl.addbtnAdd;jpl.addbtnCancel;}publicvoidactionPerformedActionEvente{ife.getSource==btnCancel{dispose;newmainFrame.setVisibletrue;}ife.getSource==btnAdd{iftxtXueHao.getText.toString.equals{JOptionPane.showMessageDialognull请输入学号温馨提示JOptionPane.INFORMATION_MESSAGE;}elseiftxtName.getText.toString.equals{JOptionPane.showMessageDialognull请输入姓名温馨提示JOptionPane.INFORMATION_MESSAGE;}elseiftxtYear.getText.toString.equals{JOptionPane.showMessageDialognull请输入年龄温馨提示JOptionPane.INFORMATION_MESSAGE;}elseiftxtDate.getText.toString.equals{JOptionPane.showMessageDialognull出生日期温馨提示JOptionPane.INFORMATION_MESSAGE;}elseiftxtZY.getText.toString.equals{JOptionPane.showMessageDialognull请输入专业温馨提示JOptionPane.INFORMATION_MESSAGE;}elseiftxtMZ.getText.toString.equals{JOptionPane.showMessageDialognull请输入民族温馨提示JOptionPane.INFORMATION_MESSAGE;}elseiftxtClass.getText.toString.equals{JOptionPane.showMessageDialognull请输入班级温馨提示JOptionPane.INFORMATION_MESSAGE;}else{Stringsex;ifman.isSelected{sex=男;}else{sex=女;}try{Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;}catchClassNotFoundExceptionce{JOptionPane.showMessageDialognullce.getMessage;}try{Connectioncon=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;Statementstmt=con.createStatement;inta=stmt.executeUpdateinsertinto学籍信息表学号登录密码姓名年龄出生日期性别班级专业民族values+txtXueHao.getText++00000++txtName.getText++txtYear.getText++txtDate.getText++sex++txtClass.getText++txtZY.getText++txtMZ.getText+;ifa==1{JOptionPane.showMessageDialognull已成功添加温馨提示JOptionPane.INFORMATION_MESSAGE;}else{JOptionPane.showMessageDialognull添加失败温馨提示JOptionPane.INFORMATION_MESSAGE;}stmt.close;}catchSQLExceptionse{JOptionPane.showMessageDialognullse.getMessage;}}}else{txtClass.setText;txtZY.setText;txtMZ.setText;txtName.setText;txtDate.setText;txtXueHao.setText;txtYear.setText;txtXueHao.requestFocus;}}publicstaticvoidmainString[]args{addFormamg=newaddForm;}}
3.添加学生成绩importjava.awt.*;importjavax.swing.*;importjava.awt.event.*;importjava.sql.*;publicclassaddScoreextendsJFrameimplementsActionListener{staticaddScoress;JLabel[]label={newJLabel学号newJLabel计算机网络newJLabelLinux操作系统newJLabel计算机专业英语newJLabel计算机信息技术基础newJLabelJava程序设计newJLabel数据库应用实训教程newJLabel高等数学newJLabelXML};JTextField[]txt={newJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextField};JButtonadd=newJButton添加;JButtonreset=newJButton重置;JButtonCancel=newJButton返回;JPaneljpl=newJPanel;JLabeltitle=newJLabel添加学生成绩JLabel.CENTER;Fontf=newFont黑体Font.BOLD16;ints=100;publicaddScore{super添加学生信息;this.setResizablefalse;this.setSize500600;this.setDefaultCloseOperationEXIT_ON_CLOSE;this.setVisibletrue;this.addjpl;Cancel.addActionListenerthis;add.addActionListenerthis;reset.addActionListenerthis;jpl.setLayoutnull;title.setBounds1504020020;title.setFontf;title.setForegroundColor.red;jpl.setBackgroundColor.LIGHT_GRAY;jpl.addtitle;forinti=0;ilabel.length;i++{label[i].setBounds100s14020;jpl.addlabel[i];txt[i].setBounds260s14020;jpl.addtxt[i];s=s+40;}add.setBounds100s8020;reset.setBounds200s8020;Cancel.setBounds300s8020;jpl.addadd;jpl.addreset;jpl.addCancel;}publicvoidactionPerformedActionEvente{ife.getSource==Cancel{dispose;newmainFrame.setVisibletrue;}elseife.getSource==add{try{Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;}catchClassNotFoundExceptionce{JOptionPane.showMessageDialogssce.getMessage;}try{Connectioncon=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;Statementstmt=con.createStatement;inta=stmt.executeUpdateinsertinto成绩信息表学号计算机网络Linux操作系统计算机专业英语计算机信息技术基础Java程序设计数据库应用实训教程高等数学Xmlvalues+txt
[0].getText++txt
[1].getText++txt
[2].getText++txt
[3].getText++txt
[4].getText++txt
[5].getText++txt
[6].getText++txt
[7].getText++txt
[8].getText+;ifa==1{JOptionPane.showMessageDialogss添加成功;}else{JOptionPane.showMessageDialogss添加失败;}}catchSQLExceptionse{JOptionPane.showMessageDialogssse.getMessage;}}else{forinti=0;itxt.length;i++{txt[i].setText;txt
[0].requestFocus;}}}publicstaticvoidmainString[]args{addScoreas=newaddScore;}}
4.修改学生信息importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassmodifyFormextendsJFrameimplementsActionListener{JPaneljpl=newJPanel;JLabelSCH=newJLabel修改学生信息JLabel.CENTER;Fontf=newFont楷体Font.BOLD+Font.ITALIC30;JLabellabel1=newJLabel请输入学号JLabel.CENTER;JButtonbtnQuery=newJButton查询;JLabellabel2=newJLabel姓名JLabel.CENTER;JLabellabyear=newJLabel年龄JLabel.CENTER;JLabellabDate=newJLabel出生日期JLabel.CENTER;JLabellabel5=newJLabel性别JLabel.CENTER;JLabellabel3=newJLabel班级JLabel.CENTER;JLabellabel4=newJLabel专业JLabel.CENTER;JLabellabmz=newJLabel民族JLabel.CENTER;ButtonGroupbgp=newButtonGroup;JRadioButtonman=newJRadioButton男;JRadioButtonwomen=newJRadioButton女;JTextFieldtyear=newJTextField;JTextFieldtDate=newJTextField;JTextFieldtmz=newJTextField;JTextFieldnum=newJTextField;JTextFieldnam=newJTextField;JTextFieldclas=newJTextField;JTextFieldscl=newJTextField;JButtonbtnModify=newJButton修改;JButtonbtnCancel=newJButton取消;Connectioncon;Statementsql;ResultSetrs;intre;publicmodifyForm{this.setSize560460;this.setVisibletrue;this.setResizablefalse;SCH.setForegroundColor.red;this.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;this.addjpl;jpl.setBackgroundColor.cyan;man.setBackgroundColor.cyan;women.setBackgroundColor.cyan;jpl.setLayoutnull;btnQuery.addActionListenerthis;btnModify.addActionListenerthis;btnCancel.addActionListenerthis;SCH.setBounds1002030020;jpl.addSCH;label
1.setBounds1006010020;jpl.addlabel1;num.setBounds2206014020;jpl.addnum;btnQuery.setBounds1201009020;btnModify.setBounds2301009020;btnCancel.setBounds3401009020;jpl.addbtnQuery;jpl.addbtnModify;jpl.addbtnCancel;label
2.setBounds1001507020;jpl.addlabel2;nam.setBounds19015014020;jpl.addnam;labyear.setBounds1001807020;jpl.addlabyear;tyear.setBounds19018014020;jpl.addtyear;labDate.setBounds1002107020;jpl.addlabDate;tDate.setBounds19021014020;jpl.addtDate;label
5.setBounds1002507020;jpl.addlabel5;man.setBounds2052506020;women.setBounds2852506020;bgp.addman;bgp.addwomen;jpl.addman;jpl.addwomen;label
3.setBounds1002907020;jpl.addlabel3;clas.setBounds19029014020;jpl.addclas;label
4.setBounds1003207020;jpl.addlabel4;scl.setBounds19032014020;jpl.addscl;labmz.setBounds1003507020;jpl.addlabmz;tmz.setBounds19035014020;jpl.addtmz;}publicvoidactionPerformedActionEventae{ifae.getSource==btnCancel{dispose;newmainFrame.setVisibletrue;}elseifae.getSource==btnQuery{try{Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;}catchClassNotFoundExceptione{}try{con=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;sql=con.createStatement;rs=sql.executeQueryselect*from学籍信息表where学号=+num.getText+;ifrs.next{num.setTextrs.getString学号;nam.setTextrs.getString姓名;tyear.setTextrs.getString年龄.toString;tDate.setTextrs.getString出生日期;ifrs.getString性别.equals男{man.setSelectedtrue;}else{women.setSelectedtrue;}clas.setTextrs.getString班级;scl.setTextrs.getString专业;tmz.setTextrs.getString民族;btnModify.setEnabledtrue;nam.setEditabletrue;tyear.setEditabletrue;tDate.setEditabletrue;clas.setEditabletrue;scl.setEditabletrue;tmz.setEditabletrue;}else{JOptionPane.showMessageDialognull不存在该记录!温馨提示JOptionPane.INFORMATION_MESSAGE;btnModify.setEnabledfalse;tyear.setText;tDate.setText;tmz.setText;num.setText;nam.setText;clas.setText;scl.setText;num.requestFocus;nam.setEditablefalse;tyear.setEditablefalse;tDate.setEditablefalse;clas.setEditablefalse;scl.setEditablefalse;tmz.setEditablefalse;}}catchSQLExceptione{}}elseifae.getSource==btnModify{try{con=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;sql=con.createStatement;re=sql.executeUpdateUpdate学籍信息表set姓名=+nam.getText+年龄=+tyear.getText+出生日期=+tDate.getText+班级=+clas.getText+专业=+scl.getText+民族=+tmz.getText+where学号=+num.getText+;ifre==1{JOptionPane.showMessageDialognull记录修改完毕!温馨提示JOptionPane.INFORMATION_MESSAGE;}else{JOptionPane.showMessageDialognull记录修改失败!温馨提示JOptionPane.INFORMATION_MESSAGE;}sql.close;}catchSQLExceptionse{JOptionPane.showMessageDialognullse.getMessage;}}else{btnModify.setEnabledfalse;tyear.setText;tDate.setText;tmz.setText;num.setText;nam.setText;clas.setText;scl.setText;num.requestFocus;nam.setEditablefalse;tyear.setEditablefalse;tDate.setEditablefalse;clas.setEditablefalse;scl.setEditablefalse;tmz.setEditablefalse;}}publicstaticvoidmainString[]args{newmodifyForm;}}5.删除学生信息importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassdeleteFormextendsJFrameimplementsActionListener{JPaneljpl=newJPanel;JLabelSCH=newJLabel删除学生信息JLabel.CENTER;Fontf=newFont楷体Font.BOLD+Font.ITALIC30;JLabellabel1=newJLabel请输入学号JLabel.CENTER;JButtonbtnQuery=newJButton查询;JLabellabel2=newJLabel姓名JLabel.CENTER;JLabellabyear=newJLabel年龄JLabel.CENTER;JLabellabDate=newJLabel出生日期JLabel.CENTER;JLabellabel5=newJLabel性别JLabel.CENTER;JLabellabel3=newJLabel班级JLabel.CENTER;JLabellabel4=newJLabel专业JLabel.CENTER;JLabellabmz=newJLabel民族JLabel.CENTER;ButtonGroupbgp=newButtonGroup;JRadioButtonman=newJRadioButton男;JRadioButtonwomen=newJRadioButton女;JTextFieldtyear=newJTextField;JTextFieldtDate=newJTextField;JTextFieldtmz=newJTextField;JTextFieldnum=newJTextField;JTextFieldnam=newJTextField;JTextFieldclas=newJTextField;JTextFieldscl=newJTextField;JButtonbtnDelete=newJButton删除;JButtonbtnCancel=newJButton取消;Connectioncon;Statementsql;ResultSetrs;intre;deleteForm{this.setSize560460;this.setVisibletrue;this.setResizablefalse;SCH.setForegroundColor.red;this.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;this.addjpl;jpl.setBackgroundColor.cyan;man.setBackgroundColor.cyan;women.setBackgroundColor.cyan;jpl.setLayoutnull;btnQuery.addActionListenerthis;btnDelete.addActionListenerthis;btnCancel.addActionListenerthis;SCH.setBounds1002030020;jpl.addSCH;label
1.setBounds1006010020;jpl.addlabel1;num.setBounds2206014020;jpl.addnum;btnQuery.setBounds1201009020;btnDelete.setBounds2301009020;btnCancel.setBounds3401009020;jpl.addbtnQuery;jpl.addbtnDelete;jpl.addbtnCancel;label
2.setBounds1001507020;jpl.addlabel2;nam.setBounds19015014020;jpl.addnam;labyear.setBounds1001807020;jpl.addlabyear;tyear.setBounds19018014020;jpl.addtyear;labDate.setBounds1002107020;jpl.addlabDate;tDate.setBounds19021014020;jpl.addtDate;label
5.setBounds1002507020;jpl.addlabel5;man.setBounds2052506020;women.setBounds2852506020;bgp.addman;bgp.addwomen;jpl.addman;jpl.addwomen;label
3.setBounds1002907020;jpl.addlabel3;clas.setBounds19029014020;jpl.addclas;label
4.setBounds1003207020;jpl.addlabel4;scl.setBounds19032014020;jpl.addscl;labmz.setBounds1003507020;jpl.addlabmz;tmz.setBounds19035014020;jpl.addtmz;btnDelete.setEnabledfalse;//取消删除按钮的功能nam.setEditablefalse;tyear.setEditablefalse;tDate.setEditablefalse;clas.setEditablefalse;scl.setEditablefalse;tmz.setEditablefalse;setVisibletrue;num.requestFocus;}publicvoidactionPerformedActionEventae{ifae.getSource==btnCancel{dispose;newmainFrame.setVisibletrue;}elseifae.getSource==btnQuery{try{Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;}catchClassNotFoundExceptione{}try{con=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;sql=con.createStatement;rs=sql.executeQueryselect*from学籍信息表where学号=+num.getText+;ifrs.next{num.setTextrs.getString学号;nam.setTextrs.getString姓名;tyear.setTextrs.getString年龄.toString;tDate.setTextrs.getString出生日期;ifrs.getString性别.equals男{man.setSelectedtrue;}else{women.setSelectedtrue;}clas.setTextrs.getString班级;scl.setTextrs.getString专业;tmz.setTextrs.getString民族;btnDelete.setEnabledtrue;nam.setEditabletrue;tyear.setEditabletrue;tDate.setEditabletrue;clas.setEditabletrue;scl.setEditabletrue;tmz.setEditabletrue;}else{JOptionPane.showMessageDialognull不存在该记录!温馨提示JOptionPane.INFORMATION_MESSAGE;btnDelete.setEnabledfalse;tyear.setText;tDate.setText;tmz.setText;num.setText;nam.setText;clas.setText;scl.setText;num.requestFocus;nam.setEditablefalse;tyear.setEditablefalse;tDate.setEditablefalse;clas.setEditablefalse;scl.setEditablefalse;tmz.setEditablefalse;}}catchSQLExceptione{}}elseifae.getSource==btnDelete//实现删除功能{try{con=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;sql=con.createStatement;re=sql.executeUpdateDELETEFROM学籍信息表where学号=+num.getText+;ifre==1{JOptionPane.showMessageDialognull记录删除完毕!温馨提示JOptionPane.INFORMATION_MESSAGE;}else{JOptionPane.showMessageDialognull记录删除失败!温馨提示JOptionPane.INFORMATION_MESSAGE;}sql.close;}catchSQLExceptionse{JOptionPane.showMessageDialognullse.getMessage;}}else{btnDelete.setEnabledfalse;tyear.setText;tDate.setText;tmz.setText;num.setText;nam.setText;clas.setText;scl.setText;num.requestFocus;nam.setEditablefalse;tyear.setEditablefalse;tDate.setEditablefalse;clas.setEditablefalse;scl.setEditablefalse;tmz.setEditablefalse;}}publicstaticvoidmainString[]args{newdeleteForm;}}
6.学生信息查询与成绩查询importjava.awt.*;importjavax.swing.*;importjava.awt.event.*;importjava.awt.font.*;importjava.sql.*;publicclassScoreextendsJFrameimplementsActionListener{staticScores;JLabeltitle=newJLabel查询成绩JLabel.CENTER;Fontf=newFont楷体Font.BOLD+Font.ITALIC16;JPaneljpl=newJPanel;JLabellabel1=newJLabel请输入学号JLabel.CENTER;JTextFieldnum=newJTextField;JButtonserch=newJButton查询成绩;JButtonreset=newJButton重置;JLabellabel2=newJLabel计算机网络JLabel.LEFT;JLabellabel3=newJLabelLinux操作系统JLabel.LEFT;JLabellabel4=newJLabel计算机专业英语JLabel.LEFT;JLabellabel5=newJLabel计算机信息技术基础JLabel.LEFT;JLabellabel6=newJLabelJava程序设计JLabel.LEFT;JLabellabel7=newJLabel数据库JLabel.LEFT;JLabellabel8=newJLabel高等数学JLabel.LEFT;JLabellabel9=newJLabelXML JLabel.LEFT;JButtonCancel=newJButton返回;JTextField[]txt={newJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextFieldnewJTextField};staticintp=140;publicScore{super查询分数;this.setResizablefalse;this.setSize500550;this.setVisibletrue;title.setForegroundColor.red;jpl.setBackgroundColor.LIGHT_GRAY;this.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;title.setFontf;this.addjpl;jpl.setLayoutnull;title.setBounds1002030020;jpl.addtitle;label
1.setBounds100609020;jpl.addlabel1;num.setBounds2106014020;jpl.addnum;serch.setBounds1001009020;reset.setBounds2001009020;Cancel.setBounds3001009020;jpl.addserch;jpl.addreset;jpl.addCancel;serch.addActionListenerthis;reset.addActionListenerthis;Cancel.addActionListenerthis;label
2.setBounds10014014020;label
3.setBounds10018014020;label
4.setBounds10022014020;label
5.setBounds10026014020;label
6.setBounds10030014020;label
7.setBounds10034014020;label
8.setBounds10038014020;label
9.setBounds10042014020;jpl.addlabel2;jpl.addlabel3;jpl.addlabel4;jpl.addlabel5;jpl.addlabel6;jpl.addlabel7;jpl.addlabel8;jpl.addlabel9;forinti=0;itxt.length;i++{txt[i].setBounds260p14020;jpl.addtxt[i];p=p+40;}}publicvoidactionPerformedActionEvente{ife.getSource==Cancel{dispose;newmainFrame.setVisibletrue;}ife.getSource==serch{Stringid=num.getText;try{Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;}catchClassNotFoundExceptionce{JOptionPane.showMessageDialogsce.getMessage;}try{Connectioncon=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;Statementstmt=con.createStatement;ResultSetrs=stmt.executeQueryselect*from成绩信息表where学号=+id+;whilers.next{forinti=0;itxt.length;i++{txt[i].setTextrs.getStringi+2;}}}catchSQLExceptionse{JOptionPane.showMessageDialogsse.getMessage;}}else{forinti=0;itxt.length;i++{txt[i].setText;}num.setText;}}publicstaticvoidmainString[]args{Scores=newScore;}}importjava.awt.*;importjavax.swing.*;importjava.awt.event.*;importjava.sql.*;publicclassSerchextendsJFrameimplementsActionListener{staticSerchs;JPaneljpl=newJPanel;JLabelSCH=newJLabel查询学生信息JLabel.CENTER;JLabellabel1=newJLabel请输入学号JLabel.CENTER;JButtonserch=newJButton查询;JLabellabel2=newJLabel姓名JLabel.CENTER;JLabellabyear=newJLabel年龄JLabel.CENTER;JLabellabDate=newJLabel出生日期JLabel.CENTER;JLabellabel5=newJLabel性别JLabel.CENTER;JLabellabel3=newJLabel班级JLabel.CENTER;JLabellabel4=newJLabel专业JLabel.CENTER;JLabellabmz=newJLabel民族JLabel.CENTER;ButtonGroupbgp=newButtonGroup;JRadioButtonman=newJRadioButton男;JRadioButtonwomen=newJRadioButton女;JTextFieldtyear=newJTextField;JTextFieldtDate=newJTextField;JTextFieldtmz=newJTextField;JTextFieldnum=newJTextField;JTextFieldnam=newJTextField;JTextFieldclas=newJTextField;JTextFieldscl=newJTextField;JButtonreset=newJButton重置;JButtoncaln=newJButton取消;publicSerch{this.setSize560460;this.setVisibletrue;this.setResizablefalse;this.setDefaultCloseOperationJFrame.EXIT_ON_CLOSE;this.addjpl;jpl.setBackgroundColor.cyan;man.setBackgroundColor.cyan;women.setBackgroundColor.cyan;jpl.setLayoutnull;serch.addActionListenerthis;reset.addActionListenerthis;caln.addActionListenerthis;SCH.setBounds1002030020;jpl.addSCH;label
1.setBounds1006010020;jpl.addlabel1;num.setBounds2206014020;jpl.addnum;serch.setBounds1201009020;reset.setBounds2301009020;caln.setBounds3401009020;jpl.addserch;jpl.addreset;jpl.addcaln;label
2.setBounds1001507020;jpl.addlabel2;nam.setBounds19015014020;jpl.addnam;labyear.setBounds1001807020;jpl.addlabyear;tyear.setBounds19018014020;jpl.addtyear;labDate.setBounds1002107020;jpl.addlabDate;tDate.setBounds19021014020;jpl.addtDate;label
5.setBounds1002507020;jpl.addlabel5;man.setBounds2052506020;women.setBounds2852506020;bgp.addman;bgp.addwomen;jpl.addman;jpl.addwomen;label
3.setBounds1002907020;jpl.addlabel3;clas.setBounds19029014020;jpl.addclas;label
4.setBounds1003207020;jpl.addlabel4;scl.setBounds19032014020;jpl.addscl;labmz.setBounds1003507020;jpl.addlabmz;tmz.setBounds19035014020;jpl.addtmz;}publicvoidactionPerformedActionEvente{ife.getSource==caln{dispose;newmainFrame.setVisibletrue;}elseife.getSource==serch{try{Class.forNamesun.jdbc.odbc.JdbcOdbcDriver;}catchClassNotFoundExceptionse{}try{Connectioncon=DriverManager.getConnectionjdbc:odbc:学生成绩管理系统ww123;Statementstmt=con.createStatement;ResultSetrs=stmt.executeQueryselect*from学籍信息表where学号=+num.getText+;ifrs.next{num.setTextrs.getString学号;nam.setTextrs.getString姓名;tyear.setTextrs.getString年龄.toString;tDate.setTextrs.getString出生日期;ifrs.getString性别.equals男{man.setSelectedtrue;}else{women.setSelectedtrue;}clas.setTextrs.getString班级;scl.setTextrs.getString专业;tmz.setTextrs.getString民族;}else{JOptionPane.showMessageDialognull不存在该记录!温馨提示JOptionPane.INFORMATION_MESSAGE;tyear.setText;tDate.setText;tmz.setText;num.setText;nam.setText;clas.setText;scl.setText;num.requestFocus;}}catchSQLExceptionse{}}}publicstaticvoidmainString[]args{Serchsch=newSerch;}}添加学生信息查看学生成绩查看学生信息查看学生成绩查看学生信息删除学生信息修改学生信息添加学生成绩添加学生信息学生登录教师登录学生成绩管理系统登录界面。