java项目(学生成绩管理系统)

1、Java程序设计实训学生成绩管理系统设计数据库：CREATE DATABAS 学生成绩管理系统(1)教师信息表创建：create table教师信息表(教师 ID varchar(8) primary key ,教师姓名 varchar(8) not null unique,登录密码 varchar(8) not null,)(2 )学籍信息表创建：create table学籍信息表(学号 varchar(15) primary key,姓名 varchar(8) not null ,年龄 varchar(10),岀生日期 varchar(10),性别 varchar(4),班级 varcha

2、r(8) not null ,专业 varchar(5),民族 varchar(10),登录密码 varchar(6) not null)(3 )成绩信息表创建：create table成绩信息表(学号 varchar(15),计算机网络 varchar(8),计算机专业英语 smalli nt,计算机信息技术基础 smalli nt,Java 程序设计 smallint ,数据库应用实训教程 smalli nt ,高等数学 smallint ,Xml smalli nt ,)概要结构分析：import java.sql.*;classmyConnectionResultSetre ;publ

3、icmyConn ecti on()public ResultSet getResult(Stri ng sql)try Class. forName ();Connection conn=DriverManager.getConnection( jdbc:odbc:成绩管理系统”，ww , 123);Stateme ntstmt=co nn .createStateme nt(ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.ONCUR_UPDATABLE);ResultSet re=stmt.executeQuery(sql);return re;cat

4、ch (Excepti on e)return n ull ;boolea n executeSql(Stri ng sql)try Class. forName ();Connection conn=DriverManager.getConnection( jdbc:odbc:成绩管理系统,ww , 123);Stateme nt stmt=c onn. createStateme nt();stmt.executeUpdate(sql);conn .commit();return true ;catch (Excepti on e)System. out .println(executeS

5、ql-+e.toString();return false ;class stuMainF rame exte nds JFrame impleme ntsActi on Liste nerJMe nuBar jmb = new JMe nuBar();Message = new JMenu(信息)；JMe nuScore= new JMenu(查询:);JMe nultemItem1 = new JMe nultem(添加学生信息JMe nultemmName =new JMe nultem(学生成绩查询“）；JMe nultemmScore =new JMe nultem(按成绩查询“）；

6、JMe nultemmNam1=new JMe nultem(查询学生信息“）;JLabellabel=new JLabel();publicstuMai nF rame()ImageIc on icon =newImageIc on(src/images/1.jpg);label.setIc on (ic on);label .setBounds(0, 0, icon.getIconWidth(),icon .getIc onH eight();add( label );setSize( label .getWidth(), this .setJMenuBar( jmb );jmb .add

7、( Message ); jmb .add( Score );Message .add( Iteml );Score .add( mNaml);Score .add( mName);Score .add( mScore );Iteml .addActi on Liste ner(this );mName.addActio nListe ner(this );学生System. out .println(getResult+e.toString();public学生label .getHeight();mScore .addActionListener(this );mNam1.addActi

8、on Liste ner(this ); public void acti on Performed(Acti on Eve nt e)if (e.getSource()=Item1 ) new addForm().setVisible(true );else if (e.getSource()= mName) dispose();new Score1().setVisible(true );elseif (e.getSource()=mScore ) new scoreQueryForm().setVisible(true );elseif (e.getSource()=mNam1)disp

9、ose。；new Serch1().setVisible(true );class mainFrameexte ndsJFrameimpleme ntsActio nListe nerJ Label label = new JLabel();JMe nuBar mBar = new JMe nuBar();J Panelp = new JPanel();private JMenu mSystem , mOperate , mQuery , mHelp , myMenuUser ;private JMe nultemmFile , mNew, mOpen, mExit , mAdd, mDel

10、, mModify , mName, miShow , mScore , mAbout , m iUser ,mAddSc ;publicmainF rame() this .setJMenuBar(mBar);I mageIcon icon =new ImageIcon(src/images/1.jpg);label.setIc on (ic on);label.setBounds(0, 0, icon.getIconWidth(),icon. getIc onH eight();add( label );setSize( label .getWidth(), label .getHeigh

11、t();myMenuUser =new JMenu(用户)；miUser =new JMenultem( 编辑用户”)；myMenuUser .add( miUser );mSystem =new JMenu(系统”);mOperate =new JMenu(数据操作)；mQuery =new JMenu(查询);mHelp =new JMenu(帮助)；mBar .add( mSystem );mBar .add( mOperate );mBar .add( mQuery );mBar .add( mHelp );mBar .add( myMenuUser );mFile =new JMen

12、uItem( 文件 ); mNew=new JMenuItem( 新建 );mOpen = new JMenuItem( 打开 ); mExit =new JMenuItem( 退出 ); mSystem .add( mFile );mSystem .add( mNew);mSystem .add( mOpen );mSystem .addSeparator();mSystem .add( mExit );mAdd =new JMenuItem( 添加基本信息 ); mAddSc =new JMenuItem( 添加成绩信息 );mDel =new JMenuItem( 删除 );mModif

13、y =new JMenuItem( 修改 );mOperate .add( mAdd);mOperate .add( mAddSc );mOperate .add( mDel );mOperate .add( mModify);mName= new JMenuItem( 查询学生信息 )mScore =new JMenuItem( 查询学生成绩 miShow =new JMenuItem( 全部显示 );mQuery .add( mName);mQuery .add( mScore );mQuery .addSeparator();mQuery .add( miShow );mAbout =n

14、ew JMenuItem( 软件信息 );mHelp .add( mAbout );mExit .addActionListener(this );mAdd .addActionListener(this );mDel .addActionListener(this );mModify .addActionListener(this );mName.addActionListener(this );mScore .addActionListener(this );mAbout .addActionListener(this );miShow .addActionListener(this );

15、miUser .addActionListener(this );mAddSc .addActionListener(this );public void actionPerformed(ActionEvent e)if (e.getSource()= mExit ) dispose();new CJ().setVisible( true );JRadioButtonb1 =new JRadioButton(学生);JButton jB1 =new JButton(登录);JButton jB2 =new JButton( 取消);public CJ () super (学生生成绩管理系统);

16、setLayout( n ull );jB1 .setBou nds(110,170,60,20);jB1 .setBackground(Color.red );add( jB1 );jB2 .setBounds(210,170,60,20);else if (e.getSource()= mAbout )JOptionPane.showMessageDialog (this ,学生成绩管理系统信学院 nn2012 年 3 月，“软件信息，JOptionPane. INFORMATION_MESSAGE );nn 电else if (e.getSource()=dispose();newadd

17、Form().setVisible( else if(e.getSource()= dispose();new addScore().setVisible(else if (e.getSource()=mAdd)true );mAddSc)true );mDel )dispose();new deleteForm().setVisible(true );else if (e.getSource()=dispose();newSerch().setVisible( else if(e.getSource()= dispose();newScore().setVisible( else ifmNa

18、me)true );mScore )true );mModify )new modifyForm().setVisible(true );else if (e.getSource()=new userFrame().setVisible(else if (e.getSource()=newfreshTamiUser )true );miShow )true ); class CJ exte nds JFrameimpleme ntsJLabelt1 =new JLabel(ID 号:);JLabelt3 =new JLabel(密码：)；JLabel label = new JLabel();

19、public String zh = null ;Actio nListenerJTextFieldt2 =new JTextField( null ,15);JTextFieldt4 =new JPasswordField(null ,15);JRadioButtonb = new JRadioButt on(教师“);jB2 .setBackground(Color.red );add( jB2 );t1 .setBou nds(90,50,80,35);add( t1 );t2 .setBounds(120,50,150,35);add( t2 );t3 .setBounds(90,10

20、0,80,35);add( t3 );t4 .setBounds(120,100,150,35);add( t4 );b.setBounds(200,20,70,30);public voidactionPerformed(ActionEvent e) if(e.getSource()= jB2 ) System. exit (0);else if (e.getSource()= jB1 ) Stringusername , password; username =t2 .getText();password = t4 .getText();if ( b .isSelected() if (u

21、sername.toString().equals(elseb1 .setBounds(120,20,70,30);ButtonGroup bg=b.setSelected(b1 .setSelected(b1 .setSelected(new ButtonGroup();false );true );false);b);add(add( b );bg.add( b.setContentAreaFilled( b1 .setContentAreaFilled(ImageIcon icon =label .setIcon(icon);b1 ); bg.add( b1 );false );newf

22、alse );ImageIcon( src/images/a.jpg);label .setBounds(0, 0, icon.getIconWidth(), icon.getIconHeight();add( label setSize( setResizable( setVisible();label .getWidth(),false ); true );label .getHeight();setLocation(300,300);setDefaultCloseOperation(JFrame.jB1 .addActionListener(jB2 .addActionListener(

23、EXIT_ON_CLOSE );thisthis););III!) 温馨提示 , JOptionPane.elseJOptionPane. showMessageDialogINFORMATION_MESSAGE );if (password.toString().equals( null )请输入用户名温馨提示 , JOptionPane.JOptionPane. showMessageDialogINFORMATION_MESSAGE );( null ,请输入密码myConnection conn=ResultSet rs;new myConnection();rs=conn.getRe

24、sult(sql); rs.last();if (rs.getRow()=1) setVisible( falsers.beforeFirst();while(rs.next() this .dispose(); sql= select *from mainFrame mf=mf.setLayout( mf.setVisible(mf.setLocation(300,300); mf.setResizable( false );mf.setTitle（ 学生成绩管理系统：教师登录界面 ）;mf.setDefaultCloseOperation(JFrame. EXIT_ON_CLOSE );m

25、f.addWindowListener( new WindowAdapter()public void windowClosing(WindowEvent e) System. exit (0););JOptionPane. showMessageDialog ( null ,rs.getString( 教师姓名 )+ 老师！ 您好！ 欢迎登录学生成绩管理系统！ ) ; else JOptionPane. showMessageDialog ( null , 用户名或密码错误 , 登录失败 , JOptionPane. INFORMATION_MESSAGE );catch (Exceptio

26、n er)System. out .println(er.toString();if ( b1 .isSelected() if (username.toString().equals( )JOptionPane. showMessageDialog ( null , 请输入用户名 , 温馨提示 , JOptionPane. INFORMATION_MESSAGE );ID=+username.toString()+try String sql= select * from and登录密码 = 教师信息表 where+password.toString()+教师I!);学籍信息表 new ma

27、inFrame()null );true ); setVisible( false );rs.beforeFirst(); while(rs.next() this .dispose(); sql=select * from stuMainFrame smf= s mf.setSize(500,400);smf.setVisible( smf.setResizable(smf.setDefaultCloseOperation(JFrame. EXIT_ON_CLOSE );s mf.addWindowListener( new WindowAdapter() public voidwindow

28、Closing(WindowEvent e) System. exit (0););JOptionPane. showMessageDialog ( null ,rs.getString( 学生姓名 )+ 同学！ 您好！欢迎登录学生成绩管理系统！ ) ; else JOptionPane. showMessageDialog ( null , 用户名或密码错 误 , 登录失败 , JOptionPane. INFORMATION_MESSAGE ); catch (Exception er)System. out .println(er.toString(); public static vo

29、id main(String args) try UIManager. setLookAndFeel (UIManager. getSystemLookAndFeelClassNameelseif (password.toString().equals(温馨提示 , JOptionPane.elsJOptionPane. showMessageDialogINFORMATION_MESSAGE ); )( null , 请输入密码 , IllmyConnection conn=ResultSet rs;new myConnection();String+t2 .getText().toStri

30、ng()+t4 .getText().toString()+try rs=conn.getResult(sql);rs.last();if (rs.getRow()=1)sql= select * from and 登录密码学籍信息表 where 学号I!学籍信息表 ; newstuMainFrame();true );false );();catch (Excepti on e) CJ frame= new CJ();new mai nF rame();stuMai nF rame stu = _2.添加学生基本信息importjavax.sw in g.*;import ;import j

31、ava.awt.*;importimport java.sql.*;txtYear =new JTextField(20); txtClass =newJTextField(20);public JLabelJLabelJLabelJLabelJLabelJLabelclass addFormexte ndsJFrameimpleme ntsActi on Liste ner添加基本信息,JLabel. CENTER); 学号：,JLabel. CENTER);年龄：,JLabel. CENTER);姓名：,JLabel. CENTER); 岀生日期：,JLabel. CENTER);班级：,

32、JLabel. CENTER);Iabel1new JLabel(labxuehao =new JLabel(= new JLabel(labyearlabNamelabDatelabclass= new JLabel(=new JLabel(= new JLabel(JLabelJLabelJLabellabzy =new JLabel(专业：，JLabel.CENTER);labmz =new JLabel(民族：,JLabel.CENTER);new JLabel( 性别：,JLabel. CENTER);labsexJTextFieldJTextFieldJTextFieldtxtNa

33、me =n ew JTextField(20);txtDate =n ew JTextField(18); txtXueHao =new JTextField(20);JTextFieldJTextFieldButt onGrouptxtZY =new JTextField(20);txtMZ =n ew JTextField(20);bgp = new Butt on Group();JRadioButtonman = new JRadioButt on(男);女);JButt onbtnAdd =new JButton(添加)；JButt onbtnCancel=new JButton(返

34、回);JButt onbtnReset = new JButton(重置JPaneljpl =new JPanel();/创建面板对象Conn ecti oncon ;Stateme ntsql ;ResultSetrs ;addForm()JRadioButtonwome n = new JRadioButt on(（添加学生信息“）;superthis.setResizable( false );this.setSize(550,450);this.setVisible( true);this.setLocati on (300,300);this.setDefaultCloseOpera

35、tion( JFrame.EXIT_ON_CLOSE );new stuMa inF rame();JTextFieldJTextFieldthis .add( jpl );jpl .setLayout( null );btnAdd .addActionListener( this ); btnReset .addActionListener( this );btnCancel .addActionListener( this ); jpl .setBackground(Color.cyan );man .setBackground(Color.cyan );women .setBackgro

36、und(Color.cyan );label1 .setBounds(100,20,300,20);jpl .add( label1 );labxuehao .setBounds(100,50,70,20);jpl .add( labxuehao ); txtXueHao .setBounds(190,50,140,20);jpl .add( txtXueHao ); labName .setBounds(100,90,70,20);jpl .add( labName );txtName .setBounds(190,90,140,20);jpl .add( txtName ); labsex

37、 .setBounds(110,130,60,20);jpl .add( labsex ); man .setBounds(190,130,60,20);women .setBounds(270,130,60,20);jpl .add( man);jpl .add( women ); bgp .add( man); bgp .add( women );labyear .setBounds(100,180,70,20);jpl .add( labyear );txtYear .setBounds(190,180,140,20);jpl .add( txtYear );labDate .setBo

38、unds(100,210,70,20);jpl .add( labDate );txtDate .setBounds(190,210,140,20);jpl .add( txtDate ); labmz .setBounds(100,240,70,20);jpl .add( labmz );txtMZ .setBounds(190,240,140,20);jpl .add( txtMZ );labclass .setBounds(100,270,70,20);jpl .add( labclass );txtClass .setBounds(190,270,140,20);jpl .add( t

39、xtClass ); labzy .setBounds(100,300,70,20);jpl .add( labzy );txtZY .setBounds(190,300,140,20); jpl .add( txtZY );btnReset .setBounds(80,350,90,20); btnAdd .setBounds(200,350,90,20);btnCancel.setBounds(320,350,90,20);jpl.add( btnReset );jpl.add( btnAdd );jpl.add( btnCancel );publicvoidactionPerformed

40、(ActionEvent e) if(e.getSource()= btnCancel )dispose();new mainFrame().setVisible( true ); if (e.getSource()= btnAdd )String sex;if ( man .isSelected() sex= 男 ; else sex= 女 ; tryClass. forName (); if ( txtXueHao .getText().toString().equals(JOptionPane. showMessageDialog ( null ,JOptionPane. INFORMA

41、TION_MESSAGE ); else if ( txtName .getText().toString().equals( ), 请输入学号III!I!) 温馨提示JOptionPane. showMessageDialog ( null ,JOptionPane. INFORMATION_MESSAGE ); else if ( txtYear .getText().toString().equals(, 请输入姓名III!I!) 温馨提示JOptionPane. showMessageDialog ( null ,JOptionPane. INFORMATION_MESSAGE );

42、else if ( txtDate .getText().toString().equals(, 请输入年龄I! 温馨提示JOptionPane. showMessageDialog ( null ,JOptionPane. INFORMATION_MESSAGE ); else if ( txtZY .getText().toString().equals(JOptionPane. showMessageDialog ( null ,JOptionPane. INFORMATION_MESSAGE ); else if ( txtMZ .getText().toString().equals

43、(), 出生日期 ,III!I!温馨提示 ), 请输入专业I! 温馨提示JOptionPane. showMessageDialog ( null ,JOptionPane. INFORMATION_MESSAGE ); else if ( txtClass .getText().toString().equals( ), 请输入民族I! 温馨提示JOptionPane. showMessageDialog ( null , JOptionPane. INFORMATION_MESSAGE );else ), 请输入班级 ,III! 温馨提示catch (ClassNotFoundExcept

44、ion ce)JOptionPane. showMessageDialog ( null ,ce.getMessage();txtZY .setText();txtMZ .setText();txtName.setText();txtDate.setText();txtXueHao .setText( ); txtYear.setText();txtXueHao .requestFocus();public static void main( Stri ng args)addForm amg = new addForm();3.添加学生成绩 import java.awt.*;importja

45、vax.swi ng.*;importimport java.sql.*;public class addScoreexte ndsJFrame impleme ntsActi on Liste nerstatic addScore ss ;JLabel label = new JLabel( 学号：), new JLabel( 计算机网络：), new JLabel( Linux 操作系统：),new JLabel(计算机专业英语：),new JLabel(计算机信息技术基础： ),new JLabel( Java 程序设计： ),new JLabel( 数据库应 用实训教程： ), new

46、 JLabel( 高等数学：), new JLabel( XML : );JTextFieldtxt = new JTextField() ,new JTextField() ,newtry Connection con = DriverManager.getConnection(jdbc:odbc:学生成绩管理系统“ ,ww , 123);Stateme nt stmt = con .createStateme nt();int a = stmt.executeUpdate(insert into登录密码，姓名，年龄，出生日期，性别，班级，专业，民学籍信息表(学号族)values(+ txt

47、XueHao .getText()+00000+ , +txtName .getText()+.getText()+ , +sex+ , +txtClass .getText()+,+txtZY.getText()+,+ txtMZ .getText()+);if (a=1)JOptio nPan e.showMessageDialog(null ,已成功添加,温馨提示,JOptionPane.INFORMATION.MESSAGE );else,JOptionPane.JOptionPane.showMessageDialog ( null ,添加失败,温馨提示INFORMATIOcatch

48、 (SQLExcepti on se)JOptio nPane.else txtClassshowMessageDialog.setText( );(null,se.getMessage();JTextField(),new JTextField(),new JTextField(),new JTextField(),new JTextField(),new JTextField(),new JTextField() ;JButtonadd = new JButt on(添加);+txtYear .getText()+ txtDateJButtonreset = new JButton(重置)

49、;else if (e.getSource()=add )JButton Cancel =new JButton( 返回 );JPanel jpl = new JPanel();JLabel title = new JLabel( 添加学生成绩 , JLabel. CENTER);Font f = new Font( 黑体 , Font. BOLD , 16 );int s =100;public addScore()super （ 添加学生信息 ）;this.setResizable( false )this.setSize(500,600);this.setDefaultCloseOper

50、ation(EXIT_ON_CLOSEthis.setVisible( true );this.add( jpl );Cancel .addActionListener(this);add .addActionListener( this );reset .addActionListener(this );jpl.setLayout( null );title.setBounds(150,40,200,20);title.setFont( f );title.setForeground(Color.red );jpl.setBackground(Color.LIGHT_ GRAY );jpl.

51、add( title );for( int i = 0 ; i label. length; i+)label i.setBounds(100, s ,140,20); jpl .add( label i);txt i.setBounds(260, s ,140,20);jpl .add( txt i);s=s+40;add .setBounds(100, s ,80,20);reset .setBounds(200, s ,80,20);Cancel .setBounds(300,s ,80,20);jpl.add( add );jpl .add(reset );jpl.add(Cancel

52、 );publicvoid actionPerformed(ActionEvent e)if (e.getSource()= Cancel ) dispose();new mainFrame().setVisible(true );Class. forName ();catch (ClassNotFou ndExcepti on ce)JOptionPane.showMessageDialog ( ss ,ce.getMessage();try Connectioncon = DriverManager.getConnection(jdbc:odbc:学生成绩管理系统“ ,ww , 123);

53、Stateme nt stmt = con .createStateme nt();static voidmain( Stri ng args)new addScore();4.修改学生信息: import javax.swi ng.*;import java.awt.*;importimport java.sql.*;public class modifyForm exte nds JFrameimpleme ntsActio nListe nerJPaneljpl =new JPa nel();JLabelSCH =new JLabel(修改学生信息,JLabel.CENTER);Font

54、 f=newFont(楷体,Font.BOLD+Font.ITALIC ,30);JLabellabel1=new JLabel(请输入学号：,JLabel.CENTER)JButt onbtnQuery= new JButton(查询)；JLabellabel2=new JLabel(姓名：，JLabelCENTER);JLabellabyear=new JLabel(年龄：,JLabel.CENTER);JLabellabDate=new JLabel(岀生日期：,JLabel.CENTER);JLabellabel5=new JLabel(性别：，JLabelCENTER);JLabel

55、label3=new JLabel(班级：,JLabelCENTER);JLabellabel4=new JLabel(专业：,JLabelCENTER);JLabellabmz := new JLabel(民族：,JLabel.CENTER);算机网络，Linux操作系统，计算机专业英语,计算机信息技术基础，Java程序设计数据库应用实训教程，高等数学，Xml)values(+ txt0.getText()+III III5+ txt 1.getText()+III+ txt 2.getText()+,+ txt3.getText()+III III5+ txt 4.getText()+II

56、I+ txt 5.getText()+,+ txt6.getText()+III III5+ txt 7.getText()+III+ txt 8.getText()+);if(a=1)JOptio nPan e.showMessageDialog( ss ,添加成功);elseJOptio nPan e.showMessageDialog( ss ,添加失败);成绩信息表(学号，计catch (SQLExcepti on se)int a = stmt.executeUpdate(in sertintotryelseJOptionPane.showMessagefor(int i = 0 ;

57、 itxt i.setText(txt 0.requestFocus();txt . length; i+);publicaddScore as =ButtonGroup bgp = new ButtonGroup();women = new JRadioButton( 女 );JTextFieldtyear= new JTextField();JTextFieldtDate= new JTextField();JTextFieldtmz =new JTextField();new JTextField();new JTextField();new JTextField();new JText

58、Field();= new JButton( 修改 );= new JButton( 取消 );int re ;public modifyForm() this .setSize(560,460); this .setVisible( true );this .setResizable( false );SCH.setForeground(Color. red );this .setDefaultCloseOperation(JFrame.this .add( jpl );jpl .setBackground(Color.cyan );man .setBackground(Color.cyan

59、 );women .setBackground(Color.cyan );jpl .setLayout( null ); btnQuery .addActionListener(this );btnModify .addActionListener(this );btnCancel .addActionListener(this );SCH.setBounds(100,20,300,20);jpl .add( SCH);label1 .setBounds(100,60,100,20);jpl .add( label1 ); num .setBounds(220,60,140,20);jpl .

60、add( num);btnQuery .setBounds(120,100,90,20);btnModify .setBounds(230,100,90,20);btnCancel .setBounds(340,100,90,20);jpl .add( btnQuery );jpl .add( btnModify ); jpl .add( btnCancel );label2 .setBounds(100,150,70,20);jpl .add( label2 );JRadioButtonman = new JRadioButton( 男 );JTextFieldnum =JTextField