java學生信息管理系統(tǒng)

1、1.登錄界面和主界面import javax.swing.*;import javax.swing.table.DefaultTableModel;import java.awt.*;import java.awt.event.*;import java.sql.*;class myConnectionResultSet re;public myConnection() class stuMainFrame extends JFrame implements ActionListenerJMenuBar jmb = new JMenuBar();JMenu Message = new JMen

2、u(信息);JMenu Score = new JMenu(查詢);JMenuItem Item1 = new JMenuItem(添加學生信息);JMenuItem mName=new JMenuItem(學生成績查詢);JMenuItem mScore=new JMenuItem(按成績查詢);JMenuItem mNam1=new JMenuItem(查詢學生信息);JLabel label = new JLabel();public stuMainFrame()ImageIcon icon = new ImageIcon(src/images/1.jpg); label.setIcon

3、(icon); label.setBounds(0, 0, icon.getIconWidth(), icon.getIconHeight(); add(label); setSize(label.getWidth(),label.getHeight();this.setJMenuBar(jmb);jmb.add(Message);jmb.add(Score);Message.add(Item1);Score.add(mNam1);Score.add(mName);Score.add(mScore);Item1.addActionListener(this);mName.addActionLi

4、stener(this);mScore.addActionListener(this);mNam1.addActionListener(this); public void actionPerformed(ActionEvent e)if(e.getSource()=Item1) new addForm().setVisible(true);else if(e.getSource()=mName) dispose();new Score1().setVisible(true);else if(e.getSource()=mScore)new scoreQueryForm().setVisibl

5、e(true);else if(e.getSource()=mNam1)dispose(); new Serch1().setVisible(true); class mainFrame extends JFrame implements ActionListener JLabel label = new JLabel(); JMenuBar mBar= new JMenuBar(); JPanel p=new JPanel(); private JMenu mSystem,mOperate,mQuery,mHelp,myMenuUser; private JMenuItem mFile,mN

6、ew,mOpen,mExit,mAdd,mDel,mModify,mName,miShow,mScore,mAbout,miUser,mAddSc; public mainFrame() this.setJMenuBar(mBar); ImageIcon icon = new ImageIcon(src/images/1.jpg); label.setIcon(icon); label.setBounds(0, 0, icon.getIconWidth(), icon.getIconHeight(); add(label); setSize(label.getWidth(),label.get

7、Height(); myMenuUser=new JMenu(用戶);miUser=new JMenuItem(編輯用戶);myMenuUser.add(miUser); mSystem=new JMenu(系統(tǒng)); mOperate=new JMenu(數(shù)據(jù)操作); mQuery=new JMenu(查詢); mHelp=new JMenu(幫助); mBar.add(mSystem); mBar.add(mOperate); mBar.add(mQuery); mBar.add(mHelp); mBar.add(myMenuUser); mFile=new JMenuItem(文件); m

8、New=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(添加成績信息); mName=new JMenuItem(查詢學生信息); mScore=new JMenuItem(查詢學生成績); miShow=

9、new JMenuItem(全部顯示); mQuery.add(mName); mQuery.add(mScore); mQuery.addSeparator(); mQuery.add(miShow); public void actionPerformed(ActionEvent e) if (e.getSource()=jB2)System.exit(0);else if (e.getSource()=jB1)String username , password;username = t2.getText(); password = t4.getText();if(b1.isSelect

10、ed() if (username.toString().equals()JOptionPane.showMessageDialog(null, 請輸入用戶名, 溫馨提示, JOptionPane.INFORMATION_MESSAGE); else if (password.toString().equals()JOptionPane.showMessageDialog(null, 請輸入密碼, 溫馨提示, JOptionPane.INFORMATION_MESSAGE);elsemyConnection conn=new myConnection();ResultSet rs;String

11、 sql=select * from 學生信息表 where 學號=+t2.getText().toString()+ and 登錄密碼 = +t4.getText().toString()+; try rs=conn.getResult(sql); rs.last(); if(rs.getRow()=1) setVisible(false); rs.beforeFirst(); while(rs.next() this.dispose(); sql=select * from 學籍信息表; stuMainFrame smf =new stuMainFrame(); smf.setSize(5

12、00,400); smf.setVisible(true); smf.setResizable(false); smf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); smf.addWindowListener(new WindowAdapter() public void windowClosing(WindowEvent e) System.exit(0); ); JOptionPane.showMessageDialog( null ,rs.getString(學生姓名)+同學！您好！歡迎登錄學生成績管理系統(tǒng)！ ) ; elseJOptio

13、nPane.showMessageDialog(null, 用戶名或密碼錯誤, 登錄失敗, JOptionPane.INFORMATION_MESSAGE); catch(Exception er)System.out.println(er.toString(); 2.添加學生基本信息import javax.swing.*;import javax.swing.table.DefaultTableModel;import java.awt.*;import java.awt.event.*;import java.sql.*;public class addForm extends JFra

14、me implements ActionListener JLabel label1 = new JLabel(添加基本信息,JLabel.CENTER);JLabel labxuehao=new JLabel(學號：,JLabel.CENTER);JLabel labName=new JLabel(姓名：,JLabel.CENTER); JLabel labclass=new JLabel(班級：,JLabel.CENTER);JLabel labzy=new JLabel(專業(yè)：,JLabel.CENTER);JLabel labsex = new JLabel(性別：,JLabel.CE

15、NTER); JLabel labsex = new JLabel(聯(lián)系方式：,JLabel.CENTER);JTextField txtName=new JTextField(20); JTextField txtXueHao=new JTextField(20); JTextField txtClass=new JTextField(20); JTextField txtZY=new JTextField(20); JTextField txtMZ=new JTextField(20); ButtonGroup bgp = new ButtonGroup();JRadioButton ma

16、n = new JRadioButton(男);JRadioButton women = new JRadioButton(女); JButton btnAdd=new JButton(添加); JButton btnCancel=new JButton(返回); JButton btnReset = new JButton(重置);JPanel jpl=new JPanel(); Connection con; Statement sql; ResultSet rs; addForm() super(添加學生信息);this.setResizable(false);this.setSize(

17、550,450);this.setVisible(true);this.setLocation(300,300);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);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(1

18、90,90,140,20);jpl.add(txtName);labsex.setBounds(110,130,60,20);jpl.add(labsex);man.setBounds(190,130,60,20);women.setBounds(270,130,60,20);jpl.add(labclass);txtClass.setBounds(190,270,140,20);jpl.add(txtClass);labzy.setBounds(100,300,70,20);jpl.add(btnReset);jpl.add(btnAdd);jpl.add(btnCancel); publi

19、c void actionPerformed(ActionEvent e) if(e.getSource()=btnCancel) dispose(); new mainFrame().setVisible(true);if(e.getSource()=btnAdd)if (txtXueHao.getText().toString().equals()JOptionPane.showMessageDialog(null, 請輸入學號);else if (txtName.getText().toString().equals()JOptionPane.showMessageDialog(null

20、, 請輸入姓名);else if (txtlxfs.getText().toString().equals()JOptionPane.showMessageDialog(null, 請輸入聯(lián)系方式);else if (txtClass.getText().toString().equals()JOptionPane.showMessageDialog(null, 請輸入班級);elseString sex;if(man.isSelected() sex=男;else sex=女; public static void main(String args)addForm amg = new add

21、Form();3.添加學生成績import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;public class addScore extends JFrame implements ActionListenerstatic addScore ss;JLabel label = new JLabel(學號：) , new JLabel(大學英語：) , new JLabel(計算機信息技術基礎：) , new JLabel(Java程序設計：) , new JLabel(高等數(shù)學：) ; J

22、TextField txt = new JTextField() , new JTextField() , new JTextField() , new JTextField() , new JTextField();JButton add = new JButton(添加);JButton reset = new JButton(重置);JButton Cancel=new JButton(返回);JPanel jpl = new JPanel();JLabel title = new JLabel(添加學生成績);public addScore()super(添加學生信息);this.se

23、tResizable(false);this.setSize(500,600);this.setDefaultCloseOperation(EXIT_ON_CLOSE);this.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(Co

24、lor.red);jpl.setBackground(Color.LIGHT_GRAY);jpl.add(title);for(int i = 0 ; i label.length ; i+)labeli.setBounds(100,s,140,20);jpl.add(labeli);txti.setBounds(260,s,140,20);jpl.add(txti);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(

25、reset);jpl.add(Cancel);public void actionPerformed(ActionEvent e)if(e.getSource()=Cancel) dispose(); new mainFrame().setVisible(true); else if(e.getSource()=add)tryConnection con = DriverManager.getConnection(jdbc:odbc:學生成績管理系統(tǒng),ww,123);Statement stmt = con.createStatement();int a = stmt.executeUpdat

26、e(insert into 成績信息表(學號 , 大學英語 , 計算機信息技術基礎 , Java程序設計 , 高等數(shù)學 , Xml)values(+txt0.getText()+,+txt1.getText()+,+txt2.getText()+,+txt3.getText()+,+txt4.getText()+);if(a=1)JOptionPane.showMessageDialog(ss,添加成功);elseJOptionPane.showMessageDialog(ss,添加失敗);catch (SQLException se)JOptionPane.showMessageDialog

27、(ss,se.getMessage();elsefor(int i = 0 ; itxt.length ; i+)txti.setText();txt0.requestFocus();public static void main(String args)addScore as = new addScore();4.學生信息查詢與成績查詢import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.awt.font.*;import java.sql.*;public class Score extends

28、 JFrame implements ActionListener static Score s;JLabel title = new JLabel(查詢成績);JPanel jpl = new JPanel();JLabel label1 = new JLabel(請輸入學號：);JTextField num = new JTextField();JButton serch = new JButton(查詢成績);JButton reset = new JButton(重置);JLabel label2 = new JLabel(計算機應用基礎：);JLabel label3 = new J

29、Label(大學英語：);JLabel label4 = new JLabel(Java程序設計：);JLabel label5 = new JLabel(高等數(shù)學：);JTextField txt = new JTextField() , new JTextField() , new JTextField() , new JTextField() ;static int p = 140;public Score() super(查詢分數(shù));this.setResizable(false);this.setSize(500,550);this.setVisible(true);this.add

30、(jpl);jpl.add(num);serch.setBounds(100,100,90,20);reset.setBounds(200,100,90,20);Cancel.setBounds(300,100,90,20);jpl.add(serch);jpl.add(reset);jpl.add(Cancel);serch.addActionListener(this);reset.addActionListener(this);Cancel.addActionListener(this);label2.setBounds(100,140,140,20);label3.setBounds(

31、100,180,140,20);label4.setBounds(100,220,140,20);label5.setBounds(100,260,140,20);jpl.add(label2);jpl.add(label3);jpl.add(label4);jpl.add(label5);for(int i = 0 ;itxt.length ; i+)txti.setBounds(260,p,140,20);jpl.add(txti);p=p+40;public void actionPerformed(ActionEvent e)if(e.getSource()=Cancel) dispo

32、se(); new mainFrame().setVisible(true); if(e.getSource()=serch)String id = num.getText();tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch (ClassNotFoundException ce) JOptionPane.showMessageDialog(s,ce.getMessage();tryConnection con = DriverManager.getConnection(jdbc:odbc:學生成績管理系統(tǒng),ww,123);Statem

33、ent stmt = con.createStatement();ResultSet rs = stmt.executeQuery(select * from 成績信息表 where 學號 = + id + );while(rs.next()for(int i = 0 ; itxt.length ; i+)txti.setText(rs.getString(i+2);catch (SQLException se)JOptionPane.showMessageDialog(s,se.getMessage();elsefor(int i = 0;itxt.length ; i+)txti.setT

34、ext();num.setText();public static void main(String args)Score s = new Score();import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;public class Serch extends JFrame implements ActionListenerstatic Serch s;JPanel jpl = new JPanel();JLabel SCH = new JLabel(查詢學生信息,JLabel.CEN

35、TER);JLabel label1 = new JLabel(請輸入學號：,JLabel.CENTER);JButton serch = new JButton(查詢);JLabel label2 = new JLabel(姓名：,JLabel.CENTER);JLabel labyear=new JLabel(年齡：,JLabel.CENTER);JLabel labDate=new JLabel(出生日期：,JLabel.CENTER);JLabel label5 = new JLabel(性別：,JLabel.CENTER);JLabel label3 = new JLabel(班級：

36、,JLabel.CENTER);JLabel label4 = new JLabel(專業(yè)：,JLabel.CENTER); JLabel labmz=new JLabel(民族：,JLabel.CENTER);ButtonGroup bgp = new ButtonGroup();JRadioButton man = new JRadioButton(男);JRadioButton women = new JRadioButton(女);JTextField tyear = new JTextField();JTextField tDate = new JTextField();JTextF

37、ield tmz = new JTextField();JTextField num = new JTextField();JTextField nam = new JTextField();JTextField clas = new JTextField();JTextField scl = new JTextField();JButton reset = new JButton(重置);JButton caln = new JButton(取消);public Serch() this.setSize(560,460);this.setVisible(true);this.setResiz

38、able(false);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.add(jpl);jpl.setBackground(Color.cyan);man.setBackground(Color.cyan);women.setBackground(Color.cyan);jpl.setLayout(null);serch.addActionListener(this);reset.addActionListener(this);caln.addActionListener(this);SCH.setBounds(100,20,

39、300,20);jpl.add(SCH);label1.setBounds(100,60,100,20);jpl.add(label1);num.setBounds(220,60,140,20);jpl.add(num);serch.setBounds(120,100,90,20);reset.setBounds(230,100,90,20);caln.setBounds(340,100,90,20);jpl.add(serch);jpl.add(reset);jpl.add(caln);label2.setBounds(100,150,70,20);jpl.add(label2);nam.s

40、etBounds(190,150,140,20);jpl.add(nam);labyear.setBounds(100,180,70,20);jpl.add(labyear);tyear.setBounds(190,180,140,20);jpl.add(tyear);labDate.setBounds(100,210,70,20);jpl.add(labDate);tDate.setBounds(190,210,140,20);jpl.add(tDate);label5.setBounds(100,250,70,20);jpl.add(label5);man.setBounds(205,250,60,20);women.setBounds(2