java學(xué)生成績管理系統(tǒng)代碼

1、java 學(xué)生成績管理系統(tǒng)代碼import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.*;import java.awt.*;import java.awt.event.*; import java.awt.event.*;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.table.JTableHead

2、er; import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;import javax.swing.*;import java.awt.*;import java.aw

3、t.event.*;import java.sql.*;import javax.swing.table.DefaultTableModel; importjavax.swing.table.JTableHeader; import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;class AddForm extends JFrame implements ActionListenerJLabel labName=new JLabel( 學(xué)號 :);JLabel labDate=new JLa

4、bel( 出生日期 :);JLabel labScore=new JLabel( 成績 :);JTextField txtName=new JTextField(20);JTextField txtDate=new JTextField(18);JTextField txtScore=new JTextField(20);JButton btnOk=new JButton( 確定 );JButton btnClear=new JButton( 清空 );JPanel pan=new JPanel();JPanel pan1=new JPanel();JPanel pan2=new JPanel

5、();JPanel pan3=new JPanel();JPanel pan4=new JPanel();Connection cnn;Statement stm;ResultSet rs;AddForm()super( 添加數(shù)據(jù) );setSize(400,300);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactory.createEtchedBorder();pan1.add(labName);pan1.add(txtName);pan2.add(labDate);pan2.add(txt

6、Date);pan3.add(labScore);pan3.add(txtScore);pan4.add(btnOk);pan4.add(btnClear);pan.setLayout(new GridLayout(3,1);pan.add(pan1);pan.add(pan2);pan.add(pan3);getContentPane().add(pan,Center);getContentPane().add(pan4,South);btnOk.addActionListener(this);btnClear.addActionListener(this);setVisible(true)

7、;txtName.requestFocus();public void actionPerformed(ActionEvent ae)if(ae.getSource()=btnClear)txtName.setText();txtDate.setText();txtScore.setText();txtName.requestFocus();else if(ae.getSource()=btnOk)String strName=txtName.getText();String strDate=txtDate.getText();String strScore=txtScore.getText(

8、);if(strName.equals()JOptionPane.showMessageDialog(this,學(xué)號不能為空,警告,JOptionPane.ERROR_MESSAGE);else if(strDate.equals()JOptionPane.showMessageDialog(this, 警告,JOptionPane.ERROR_MESSAGE);else if(strScore.equals()JOptionPane.showMessageDialog(this,成績不能為空,警告,JOptionPane.ERROR_MESSAGE);elsetry Class.forNam

9、e(sun.jdbc.odbc.JdbcOdbcDriver); catch (ClassNotFoundException ex) ex.printStackTrace();try cnn=DriverManager.getConnection(Jdbc:Odbc:MyDB);stm=cnn.createStatement(); catch (SQLException ex) ex.printStackTrace();tryrs = stm.executeQuery(select * from 成績表 where 學(xué)號 = +strName + );if (rs.next() JOption

10、Pane.showMessageDialog(this,對不起，該成績信息已存在”)； else / 否則插入記錄/System.out.println(insert into成績表values(+strName+,#+strDate+#,+strScore+);stm.executeUpdate(insert into 成績表values(+strName+,+strDate+,+strScore+);JOptionPane.showMessageDialog(null,”記錄已經(jīng)成功添加);/ 斷開連接stm.close();cnn.close(); catch (SQLException

11、 ex) System.out.println(SQLException: + ex.getMessage();public static void main(String args) new AddForm();class BrowseForm extends JFrame String str= 學(xué)號 , 出生日期 , 成績 ;Object data;JTable table;JTableHeader head;JScrollPane jsp;Connection conn;Statement stmt;ResultSet rs;BrowseForm()super( 瀏覽數(shù)據(jù) );setS

12、ize(400,300);int i=0,j=0;int row;tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);conn=DriverManager.getConnection(jdbc:odbc:MyDB,);stmt=conn.createStatement();rs=stmt.executeQuery(select COUNT(*) as a from 成績表 );rs.next();row=rs.getInt(a);rs.close();data=new Objectrow3;rs=stmt.executeQuery(select * f

13、rom 成績表 );while(rs.next()dataij+=rs.getString( 學(xué)號 );dataij+=rs.getDate( 出生日期 );dataij=new Integer(rs.getInt(成績 );i+;j=0;table=new JTable(data,str);head=table.getTableHeader();jsp=new JScrollPane(table);getContentPane().add(head,North);getContentPane().add(jsp,Center);rs.close();stmt.close();conn.clo

14、se();catch(Exception e) e.printStackTrace();setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); setVisible(true);public static void main(String args) new BrowseForm();class DeleteForm extends JFrame implements ActionListener JLabel labName=new JLabel( 學(xué)號 :);JLabel labDate=new JLabel( 出生日期 :);JLabel l

15、abScore=new JLabel( 成績 :);JTextField txtName=new JTextField(20);JTextField txtDate=new JTextField(18);JTextField txtScore=new JTextField(20);JButton btnDel=new JButton( 刪除 );JButton btnCancel=new JButton( 取消 );JButton btnQuery=new JButton( 查詢 );JPanel pan=new JPanel();JPanel pan1=new JPanel();JPanel

16、 pan2=new JPanel();JPanel pan3=new JPanel();JPanel pan4=new JPanel();Connection cnn;Statement stm;ResultSet rs;DeleteForm()super( 刪除數(shù)據(jù) );setSize(400,300);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactory.createEtchedBorder();pan1.add(labName);pan1.add(txtName);pan2.add(la

17、bDate);pan2.add(txtDate);pan3.add(labScore);pan3.add(txtScore);pan4.add(btnQuery);pan4.add(btnDel);pan4.add(btnCancel);pan.setLayout(new GridLayout(3,1);pan.add(pan1);pan.add(pan2);pan.add(pan3);getContentPane().add(pan,Center);getContentPane().add(pan4,South);btnQuery.addActionListener(this);btnDel

18、.addActionListener(this);btnCancel.addActionListener(this);btnDel.setEnabled(false);txtDate.setEditable(false);txtScore.setEditable(false);setVisible(true);txtName.requestFocus();public void actionPerformed(ActionEvent ae)/* if(ae.getSource()=btnCancel)try if(stm!=null)stm.close();if(cnn!=null)cnn.c

19、lose(); catch (SQLException ex) ex.printStackTrace();this.dispose(); else if(ae.getSource()=btnQuery)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);cnn=DriverManager.getConnection(jdbc:odbc:MyDB,);stm=cnn.createStatement();rs=stm.executeQuery(select * from 成績表 where 學(xué)號=+txtName.getText()+);if(rs.nex

20、t()txtName.setText(rs.getString( 學(xué)號 );txtDate.setText(rs.getDate( 出生日期 ).toString();txtScore.setText(new Integer(rs.getInt( 成績 ).toString();btnDel.setEnabled(true);elseJOptionPane.showMessageDialog(this,不存在該記錄)；btnDel.setEnabled(false);txtName.setText();txtScore.setText();txtDate.setText();catch(Exc

21、eption e)e.printStackTrace();else if(ae.getSource()=btnDel)try if(JOptionPane.YES_OPTION=JOptionPane.showConfirmDialog(this, 確定要刪除該記錄, 信息 ,JOptionPane.YES_NO_OPTION)stm.executeUpdate(delete from 成績表 where 學(xué)號=+txtName.getText()+);btnDel.setEnabled(false);txtName.setText();txtScore.setText();txtDate.s

22、etText();catch (SQLException ex) ex.printStackTrace();*/public static void main(String args) new DeleteForm();class LoginForm extends JFrame implements ActionListenerJLabel labName=new JLabel( 姓名 );JLabel labPwd=new JLabel( 密碼 );JTextField txtName=new JTextField(20);JPasswordField txtPwd=new JPasswo

23、rdField(20);JButton btnOk=new JButton( 確定 );JButton btnCancel=new JButton( 取消 );JPanel pan=new JPanel();JPanel pan1=new JPanel();JPanel pan2=new JPanel();JPanel pan3=new JPanel();JPanel pan4=new JPanel();Connection cnn;Statement stm;ResultSet rs;LoginForm()super( 用戶登錄 );setSize(300,200);setDefaultCl

24、oseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactory.createTitledBorder( 登錄 );pan.setLayout(new GridLayout(2,1);pan1.add(labName);pan1.add(txtName);pan2.add(labPwd);pan2.add(txtPwd);pan.add(pan1);pan.add(pan2);pan3.add(btnOk);pan3.add(btnCancel);pan4.add(pan);getContentPane().add(pan4,C

25、enter);getContentPane().add(pan3,South);txtName.addActionListener(this);txtPwd.addActionListener(this);btnOk.addActionListener(this);btnCancel.addActionListener(this);setVisible(true);try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch (ClassNotFoundException ex) ex.printStackTrace();try cnn=Driv

26、erManager.getConnection(Jdbc:Odbc:MyDB);stm=cnn.createStatement(); catch (SQLException ex) ex.printStackTrace();txtName.requestFocus();public void actionPerformed(ActionEvent ae)if(ae.getSource()=txtName)txtPwd.requestFocus();else if(ae.getSource()=txtPwd)btnOk.requestFocus();else if(ae.getSource()=

27、btnCancel)txtName.setText();txtPwd.setText();txtName.requestFocus();else if(ae.getSource()=btnOk)String str=select * from 用戶表 where 用戶名=+txtName.getText()+and 密碼 =+new String(txtPwd.getPassword()+; try rs=stm.executeQuery(str); catch (SQLException ex) ex.printStackTrace();try if(rs.next()JOptionPane

28、.showMessageDialog(this, 驗證通過 !, 信息,JOptionPane.INFORMATION_MESSAGE);rs.close();stm.close();cnn.close();new MainForm().setVisible(true);this.dispose();elseJOptionPane.showMessageDialog(this, 用戶名或密碼不正確!, 信息,JOptionPane.INFORMATION_MESSAGE); catch (SQLException ex) ex.printStackTrace();public static v

29、oid main(String args) new LoginForm();class ModifyForm extends JFrame implements ActionListenerJLabel labName=new JLabel( 學(xué)號 :);JLabel labDate=new JLabel( 出生日期 :);JLabel labScore=new JLabel( 成績 :);JTextField txtName=new JTextField(20);JTextField txtDate=new JTextField(18);JTextField txtScore=new JTe

30、xtField(20);JButton btnModify=new JButton(修改 );JButton btnCancel=new JButton(取消 );JButton btnQuery=new JButton( 查詢 );JPanel pan=new JPanel();JPanel pan1=new JPanel();JPanel pan2=new JPanel();JPanel pan3=new JPanel();JPanel pan4=new JPanel();Connection cnn;Statement stm;ResultSet rs;ModifyForm()super

31、( 修改數(shù)據(jù) );setSize(400,300);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);pan.setBorder(BorderFactory.createEtchedBorder();pan1.add(labName);pan1.add(txtName);pan2.add(labDate);pan2.add(txtDate);pan3.add(labScore);pan3.add(txtScore);pan4.add(btnQuery);pan4.add(btnModify);pan4.add(btnCancel);pan.se

32、tLayout(new GridLayout(3,1);pan.add(pan1);pan.add(pan2);pan.add(pan3);getContentPane().add(pan,Center);getContentPane().add(pan4,South);btnQuery.addActionListener(this);btnModify.addActionListener(this);btnCancel.addActionListener(this);btnModify.setEnabled(false);txtDate.setEditable(false);txtScore

33、.setEditable(false);setVisible(true);txtName.requestFocus();public void actionPerformed(ActionEvent ae)if(ae.getSource()=btnCancel)try if(stm!=null)stm.close();if(cnn!=null)cnn.close(); catch (SQLException ex) ex.printStackTrace();this.dispose(); else if(ae.getSource()=btnQuery)tryClass.forName(sun.

34、jdbc.odbc.JdbcOdbcDriver);cnn=DriverManager.getConnection(jdbc:odbc:MyDB,);stm=cnn.createStatement();rs=stm.executeQuery(select * from 成績表 where 學(xué)號=+txtName.getText()+);if(rs.next()txtName.setText(rs.getString( 學(xué)號 );txtScore.setText(new Integer(rs.getInt( 成績 ).toString();txtDate.setText(rs.getDate(

35、出生日期 ).toString();btnModify.setEnabled(true);txtDate.setEditable(true);txtScore.setEditable(true);elseJOptionPane.showMessageDialog(this,不存在該記錄)；btnModify.setEnabled(false);txtName.setText();txtScore.setText();txtDate.setText();txtDate.setEditable(false);txtScore.setEditable(false);catch(Exception e

36、)e.printStackTrace();else if(ae.getSource()=btnModify)trySystem.out.println(Update 成績表 set 出生日期=#+txtDate.getText()+#, 成績 =+txtScore.getText()+ where 學(xué)號=+txtName.getText()+);stm.executeUpdate(Update 成績表 set 出生日期=#+txtDate.getText()+#, 成績 =+txtScore.getText()+ where 學(xué)號=+txtName.getText()+);JOptionPan

37、e.showMessageDialog(this,”記錄修改完畢”)；btnModify.setEnabled(false);txtName.setText();txtScore.setText();txtDate.setText();txtDate.setEditable(false);txtScore.setEditable(false);stm.close();cnn.close();catch(Exception e)e.printStackTrace();public static void main(String args) new ModifyForm();class Numbe

38、rQueryForm extends JFrame implements ActionListenerJLabel labName=new JLabel( 學(xué)號 :);JLabel labDate=new JLabel( 出生日期 :);JLabel labScore=new JLabel( 成績 :);JTextField txtName=new JTextField(20);JTextField txtDate=new JTextField(18);JTextField txtScore=new JTextField(20);JButton btnCancel=new JButton( 取

39、消 );JButton btnQuery=new JButton( 查詢 );JPanel pan=new JPanel();JPanel pan1=new JPanel();JPanel pan2=new JPanel();JPanel pan3=new JPanel();JPanel pan4=new JPanel();Connection cnn;Statement stm;ResultSet rs;NumberQueryForm()super( 按學(xué)號查詢 );setSize(400,300);setDefaultCloseOperation(JFrame.DISPOSE_ON_CLO

40、SE);pan.setBorder(BorderFactory.createEtchedBorder();pan1.add(labName);pan1.add(txtName);pan2.add(labDate);pan2.add(txtDate);pan3.add(labScore);pan3.add(txtScore);pan4.add(btnQuery);pan4.add(btnCancel);pan.setLayout(new GridLayout(3,1);pan.add(pan1);pan.add(pan2);pan.add(pan3);getContentPane().add(p

41、an,Center);getContentPane().add(pan4,South);btnQuery.addActionListener(this);btnCancel.addActionListener(this);txtDate.setEditable(false);txtScore.setEditable(false);setVisible(true);txtName.requestFocus();public void actionPerformed(ActionEvent ae)if(ae.getSource()=btnCancel)try if(stm!=null)stm.cl

42、ose();if(cnn!=null)cnn.close(); catch (SQLException ex) ex.printStackTrace();this.dispose(); else if(ae.getSource()=btnQuery)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);cnn=DriverManager.getConnection(jdbc:odbc:MyDB,);stm=cnn.createStatement();rs=stm.executeQuery(select * from 成績表 where 學(xué)號=+txtNa

43、me.getText()+);if(rs.next()txtName.setText(rs.getString( 學(xué)號 );txtScore.setText(new Integer(rs.getInt( 成績 ).toString();txtDate.setText(rs.getDate( 出生日期 ).toString();elseJOptionPane.showMessageDialog(this,不存在該記錄)；txtName.setText();txtScore.setText();txtDate.setText();txtName.requestFocus();catch(Excep

44、tion e)e.printStackTrace();public static void main(String args) new NumberQueryForm();class ScoreQueryForm extends JFrame implements ActionListenerJLabel labScore=new JLabel( 請輸入成績 :);JTextField txtScore=new JTextField(10);JButton btnQuery=new JButton( 查詢 );JPanel pan1=new JPanel();JPanel pan2=new J

45、Panel();String str= 學(xué)號 , 出生日期 , 成績 ;Object data=new Object103;JTable table=new JTable(data,str);JTableHeader head=table.getTableHeader();JScrollPane jsp=new JScrollPane(table);Connection conn;Statement stmt;ResultSet rs;ScoreQueryForm()super( 按成績查詢 );setSize(400,300);pan1.add(labScore);pan1.add(txtS

46、core);pan1.add(btnQuery);getContentPane().add(pan1,North);table=new JTable(data,str);pan2.setLayout(new BorderLayout();head=table.getTableHeader();jsp=new JScrollPane(table);pan2.add(head,North);pan2.add(jsp,Center);getContentPane().add(pan2,Center);btnQuery.addActionListener(this);setDefaultCloseOp

47、eration(JFrame.DISPOSE_ON_CLOSE);setVisible(true);public void actionPerformed(ActionEvent ae)if(ae.getSource()=btnQuery)int i,j,row;tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);conn=DriverManager.getConnection(jdbc:odbc:MyDB,);stmt=conn.createStatement();成績表 wherers=stmt.executeQuery(select COUNT(

48、*) as rowcount from成績 =+txtScore.getText();rs.next();row=rs.getInt(rowcount);rs.close();data=new Objectrow3;rs=stmt.executeQuery(select * from 成績表 where 成績=+txtScore.getText();i=0;j=0;while(rs.next()dataij+=rs.getString( 學(xué)號 );dataij+=rs.getDate( 出生日期 );dataij=new Integer(rs.getInt(成績 );i+;j=0;pan2.r

49、emoveAll();getContentPane().remove(pan2);table=new JTable(data,str);pan2.setLayout(new BorderLayout();head=table.getTableHeader();jsp=new JScrollPane(table);pan2.add(head,North);pan2.add(jsp,Center);getContentPane().add(pan2,Center);this.validate();rs.close();stmt.close();conn.close();catch(Exceptio

50、n e)e.printStackTrace();public static void main(String args) new ScoreQueryForm();class MyPanel extends JPanelImage img=Toolkit.getDefaultToolkit().getImage(c:/a.jpg);public void paint(Graphics g)g.drawImage(img,0,0,this);class MainForm extends JFrame implements ActionListener JMenu mSystem=new JMenu(系統(tǒng)) JMenuItem mExit=new JMenuItem(