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

1、精選優(yōu)質(zhì)文檔-傾情為你奉上Java程序設(shè)計實訓(xùn)學(xué)生成績管理系統(tǒng)設(shè)計數(shù)據(jù)庫：CREATE DATABASE 學(xué)生成績管理系統(tǒng)（1）教師信息表創(chuàng)建：create table 教師信息表(教師ID varchar(8) primary key ,教師姓名 varchar(8) not null unique,登錄密碼 varchar(8) not null,)（2）學(xué)籍信息表創(chuàng)建：create table 學(xué)籍信息表(學(xué)號 varchar(15) primary key,姓名 varchar(8) not null ,年齡 varchar(10),出生日期 varchar(10),性別 varcha

2、r(4) ,班級 varchar(8) not null ,專業(yè) varchar(5) ,民族 varchar(10),登錄密碼 varchar(6) not null)（3）成績信息表創(chuàng)建：create table 成績信息表(學(xué)號 varchar(15),計算機(jī)網(wǎng)絡(luò) varchar(8),計算機(jī)專業(yè)英語 smallint,計算機(jī)信息技術(shù)基礎(chǔ) smallint,Java程序設(shè)計 smallint ,數(shù)據(jù)庫應(yīng)用實訓(xùn)教程 smallint ,高等數(shù)學(xué) smallint ,Xml smallint ,)概要結(jié)構(gòu)分析：學(xué)生成績管理系統(tǒng)登錄界面添加學(xué)生信息查看學(xué)生成績查看學(xué)生信息查看學(xué)生成績查看學(xué)生信

3、息刪除學(xué)生信息修改學(xué)生信息添加學(xué)生成績添加學(xué)生信息學(xué)生登錄教師登錄1.登錄界面和主界面import javax.swing.*;import javax.swing.table.DefaultTableModel;import java.awt.*; import java.awt.event.*;import java.sql.*;class myConnectionResultSet re;public myConnection()public ResultSet getResult(String sql)tryClass.forName("sun.jdbc.odbc.JdbcO

4、dbcDriver");Connection conn=DriverManager.getConnection("jdbc:odbc:學(xué)生成績管理系統(tǒng)","ww","123");Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);ResultSet re=stmt.executeQuery(sql);return re;catch(Exception e)System.out.print

5、ln("getResult-"+e.toString();return null;public boolean executeSql(String sql)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection conn=DriverManager.getConnection("jdbc:odbc:學(xué)生成績管理系統(tǒng)","ww","123");Statement stmt=conn.createStatement();stmt.exe

6、cuteUpdate(sql);mit();return true;catch(Exception e)System.out.println("executeSql-"+e.toString();return false; class stuMainFrame extends JFrame implements ActionListenerJMenuBar jmb = new JMenuBar(); Message = new JMenu("信息");JMenu Score = new JMenu("查詢");JMenuItem It

7、em1 = new JMenuItem("添加學(xué)生信息");JMenuItem mName=new JMenuItem("學(xué)生成績查詢");JMenuItem mScore=new JMenuItem("按成績查詢");JMenuItem mNam1=new JMenuItem("查詢學(xué)生信息");JLabel label = new JLabel();public stuMainFrame()ImageIcon icon = new ImageIcon("src/images/1.jpg");

8、 label.setIcon(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);mNa

9、me.addActionListener(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 scoreQueryFo

10、rm().setVisible(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 JMen

11、uItem mFile,mNew,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(

12、label.getWidth(),label.getHeight(); 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.

13、add(mOperate); mBar.add(mQuery); mBar.add(mHelp); mBar.add(myMenuUser); mFile=new JMenuItem("文件"); mNew=new JMenuItem("新建"); mOpen=new JMenuItem("打開"); mExit=new JMenuItem("退出"); mSystem.add(mFile); mSystem.add(mNew); mSystem.add(mOpen); mSystem.addSeparator()

14、; mSystem.add(mExit); mAdd=new JMenuItem("添加基本信息"); mAddSc=new JMenuItem("添加成績信息"); mDel=new JMenuItem("刪除"); mModify=new JMenuItem("修改"); mOperate.add(mAdd); mOperate.add(mAddSc); mOperate.add(mDel); mOperate.add(mModify); mName=new JMenuItem("查詢學(xué)生信息&quo

15、t;); mScore=new JMenuItem("查詢學(xué)生成績"); miShow=new JMenuItem("全部顯示"); mQuery.add(mName); mQuery.add(mScore); mQuery.addSeparator(); mQuery.add(miShow); mAbout=new JMenuItem("軟件信息"); mHelp.add(mAbout); mExit.addActionListener(this); mAdd.addActionListener(this); mDel.addAct

16、ionListener(this); mModify.addActionListener(this); mName.addActionListener(this); mScore.addActionListener(this); mAbout.addActionListener(this); miShow.addActionListener(this); miUser.addActionListener(this); mAddSc.addActionListener(this); public void actionPerformed(ActionEvent e) if(e.getSource

17、()=mExit) dispose(); new CJ().setVisible(true); else if(e.getSource()=mAbout) JOptionPane.showMessageDialog(this,"學(xué)生成績管理系統(tǒng)nn電信學(xué)院nn2012年3月","軟件信息",JOptionPane.INFORMATION_MESSAGE); else if(e.getSource()=mAdd) dispose(); new addForm().setVisible(true); else if(e.getSource()=mAddSc)

18、 dispose(); new addScore().setVisible(true); else if(e.getSource()=mDel) dispose(); new deleteForm().setVisible(true); else if(e.getSource()=mName) dispose(); new Serch().setVisible(true); else if(e.getSource()=mScore) dispose(); new Score().setVisible(true); else if(e.getSource()=mModify) new modif

19、yForm().setVisible(true); else if(e.getSource()=miUser) new userFrame().setVisible(true); else if(e.getSource()=miShow) new freshTable().setVisible(true); class CJ extends JFrame implements ActionListenerJLabel t1=new JLabel("ID號:"); JLabel t3=new JLabel("密碼:"); JLabel label = ne

20、w JLabel(); public String zh=null; JTextField t2=new JTextField(null,15);JTextField t4=new JPasswordField(null,15);JRadioButton b=new JRadioButton("教師");JRadioButton b1=new JRadioButton("學(xué)生");JButton jB1=new JButton("登錄");JButton jB2=new JButton("取消");public C

21、J ()super("學(xué)生生成績管理系統(tǒng)");setLayout(null);jB1.setBounds(110,170,60,20);jB1.setBackground(Color.red);add(jB1);jB2.setBounds(210,170,60,20);jB2.setBackground(Color.red);add(jB2);t1.setBounds(90,50,80,35);add(t1);t2.setBounds(120,50,150,35);add(t2);t3.setBounds(90,100,80,35);add(t3);t4.setBounds

22、(120,100,150,35);add(t4);b.setBounds(200,20,70,30);b1.setBounds(120,20,70,30);ButtonGroup bg=new ButtonGroup(); b.setSelected(false);b1.setSelected(true);b1.setSelected(false);add(b);bg.add(b);add(b1); bg.add(b1); b.setContentAreaFilled(false); b1.setContentAreaFilled(false); ImageIcon icon = new Im

23、ageIcon("src/images/a.jpg"); label.setIcon(icon); label.setBounds(0, 0, icon.getIconWidth(), icon.getIconHeight(); add(label); setSize(label.getWidth(),label.getHeight(); setResizable(false); setVisible(true); setLocation(300,300); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); jB1.addAct

24、ionListener(this); jB2.addActionListener(this);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(b.isSelected() if (username.toString().equals("")JOptionP

25、ane.showMessageDialog(null, "請輸入用戶名", "溫馨提示", JOptionPane.INFORMATION_MESSAGE); else if (password.toString().equals("")JOptionPane.showMessageDialog(null, "請輸入密碼", "溫馨提示", JOptionPane.INFORMATION_MESSAGE);elsemyConnection conn=new myConnection();Resu

26、ltSet rs;String sql="select * from 教師信息表 where 教師ID='"+username.toString()+"' and 登錄密碼 = '"+password.toString()+"'" try rs=conn.getResult(sql); rs.last(); if(rs.getRow()=1) setVisible(false); rs.beforeFirst(); while(rs.next() this.dispose(); sql="se

27、lect * from 學(xué)籍信息表" mainFrame mf=new mainFrame(); mf.setLayout(null); mf.setVisible(true); mf.setLocation(300,300); mf.setResizable(false); mf.setTitle("學(xué)生成績管理系統(tǒng)：教師登錄界面"); mf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); mf.addWindowListener(new WindowAdapter() public void windowClos

28、ing(WindowEvent e) System.exit(0); ); JOptionPane.showMessageDialog( null ,rs.getString("教師姓名")+"老師！您好！歡迎登錄學(xué)生成績管理系統(tǒng)！" ) ; elseJOptionPane.showMessageDialog(null, "用戶名或密碼錯誤", "登錄失敗", JOptionPane.INFORMATION_MESSAGE); catch(Exception er)System.out.println(er.toS

29、tring(); if(b1.isSelected() if (username.toString().equals("")JOptionPane.showMessageDialog(null, "請輸入用戶名", "溫馨提示", JOptionPane.INFORMATION_MESSAGE); else if (password.toString().equals("")JOptionPane.showMessageDialog(null, "請輸入密碼", "溫馨提示"

30、, JOptionPane.INFORMATION_MESSAGE);elsemyConnection conn=new myConnection();ResultSet rs;String sql="select * from 學(xué)籍信息表 where 學(xué)號='"+t2.getText().toString()+"' and 登錄密碼 = '"+t4.getText().toString()+"'" try rs=conn.getResult(sql); rs.last(); if(rs.getRow(

31、)=1) setVisible(false); rs.beforeFirst(); while(rs.next() this.dispose(); sql="select * from 學(xué)籍信息表" stuMainFrame smf =new stuMainFrame(); smf.setSize(500,400); smf.setVisible(true); smf.setResizable(false); smf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); smf.addWindowListener(new Windo

32、wAdapter() public void windowClosing(WindowEvent e) System.exit(0); ); JOptionPane.showMessageDialog( null ,rs.getString("學(xué)生姓名")+"同學(xué)！您好！歡迎登錄學(xué)生成績管理系統(tǒng)！" ) ; elseJOptionPane.showMessageDialog(null, "用戶名或密碼錯誤", "登錄失敗", JOptionPane.INFORMATION_MESSAGE); catch(Excep

33、tion er)System.out.println(er.toString(); public static void main(String args) try UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName(); catch(Exception e) CJ frame=new CJ(); new mainFrame(); stuMainFrame stu = new stuMainFrame();2.添加學(xué)生基本信息import javax.swing.*;import javax.swing.table.

34、DefaultTableModel;import java.awt.*;import java.awt.event.*;import java.sql.*;public class addForm extends JFrame implements ActionListener JLabel label1 = new JLabel("添加基本信息",JLabel.CENTER);JLabel labxuehao=new JLabel("學(xué)號：",JLabel.CENTER);JLabel labyear=new JLabel("年齡："

35、;,JLabel.CENTER);JLabel labName=new JLabel("姓名：",JLabel.CENTER); JLabel labDate=new JLabel("出生日期：",JLabel.CENTER); JLabel labclass=new JLabel("班級：",JLabel.CENTER); JLabel labzy=new JLabel("專業(yè)：",JLabel.CENTER); JLabel labmz=new JLabel("民族：",JLabel.CEN

36、TER); JLabel labsex = new JLabel("性別：",JLabel.CENTER); JTextField txtName=new JTextField(20); JTextField txtDate=new JTextField(18); JTextField txtXueHao=new JTextField(20); JTextField txtYear=new JTextField(20); JTextField txtClass=new JTextField(20); JTextField txtZY=new JTextField(20);

37、JTextField txtMZ=new JTextField(20); ButtonGroup bgp = new ButtonGroup();JRadioButton man = new JRadioButton("男");JRadioButton women = new JRadioButton("女"); JButton btnAdd=new JButton("添加"); JButton btnCancel=new JButton("返回"); JButton btnReset = new JButton(

38、"重置"); JPanel jpl=new JPanel(); /創(chuàng)建面板對象 Connection con; Statement sql; ResultSet rs; addForm() super("添加學(xué)生信息");this.setResizable(false);this.setSize(550,450);this.setVisible(true);this.setLocation(300,300);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.add(jpl);jpl.setL

39、ayout(null);btnAdd.addActionListener(this);btnReset.addActionListener(this);btnCancel.addActionListener(this);jpl.setBackground(Color.cyan);man.setBackground(Color.cyan);women.setBackground(Color.cyan);label1.setBounds(100,20,300,20);jpl.add(label1);labxuehao.setBounds(100,50,70,20);jpl.add(labxueha

40、o);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.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(

41、man);bgp.add(women);labyear.setBounds(100,180,70,20);jpl.add(labyear);txtYear.setBounds(190,180,140,20);jpl.add(txtYear);labDate.setBounds(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);

42、jpl.add(txtMZ);labclass.setBounds(100,270,70,20);jpl.add(labclass);txtClass.setBounds(190,270,140,20);jpl.add(txtClass);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(32

43、0,350,90,20);jpl.add(btnReset);jpl.add(btnAdd);jpl.add(btnCancel); public 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, &qu

44、ot;請輸入學(xué)號", "溫馨提示", JOptionPane.INFORMATION_MESSAGE);else if (txtName.getText().toString().equals("")JOptionPane.showMessageDialog(null, "請輸入姓名", "溫馨提示", JOptionPane.INFORMATION_MESSAGE);else if (txtYear.getText().toString().equals("")JOptionPane

45、.showMessageDialog(null, "請輸入年齡", "溫馨提示", JOptionPane.INFORMATION_MESSAGE);else if (txtDate.getText().toString().equals("")JOptionPane.showMessageDialog(null, "出生日期", "溫馨提示", JOptionPane.INFORMATION_MESSAGE);else if (txtZY.getText().toString().equals

46、("")JOptionPane.showMessageDialog(null, "請輸入專業(yè)", "溫馨提示", JOptionPane.INFORMATION_MESSAGE);else if (txtMZ.getText().toString().equals("")JOptionPane.showMessageDialog(null, "請輸入民族", "溫馨提示", JOptionPane.INFORMATION_MESSAGE);else if (txtClass.

47、getText().toString().equals("")JOptionPane.showMessageDialog(null, "請輸入班級", "溫馨提示", JOptionPane.INFORMATION_MESSAGE);elseString sex;if(man.isSelected() sex="男"else sex="女" tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");catch (ClassNotFoun

48、dException ce)JOptionPane.showMessageDialog(null,ce.getMessage();tryConnection con = DriverManager.getConnection("jdbc:odbc:學(xué)生成績管理系統(tǒng)","ww","123");Statement stmt = con.createStatement();int a = stmt.executeUpdate("insert into 學(xué)籍信息表(學(xué)號 ,登錄密碼,姓名,年齡 , 出生日期 , 性別 , 班級,專業(yè)

49、,民族)values('"+txtXueHao.getText()+"','"+00000+"','"+txtName.getText()+"','"+txtYear.getText()+"','"+txtDate.getText()+"','"+sex+"','"+txtClass.getText()+"','"+txtZY.

50、getText()+"','"+txtMZ.getText()+"')");if(a=1)JOptionPane.showMessageDialog(null,"已成功添加","溫馨提示",JOptionPane.INFORMATION_MESSAGE);elseJOptionPane.showMessageDialog(null,"添加失敗","溫馨提示",JOptionPane.INFORMATION_MESSAGE);stmt.close();c

51、atch (SQLException se)JOptionPane.showMessageDialog(null,se.getMessage();else txtClass.setText("");txtZY.setText("");txtMZ.setText("");txtName.setText("");txtDate.setText("");txtXueHao.setText("");txtYear.setText("");txtXueHao.req

52、uestFocus();public static void main(String args)addForm amg = new addForm();3.添加學(xué)生成績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("學(xué)號：") , new JLabe

53、l("計算機(jī)網(wǎng)絡(luò)：") , new JLabel("Linux操作系統(tǒng)：") , new JLabel("計算機(jī)專業(yè)英語：") , new JLabel("計算機(jī)信息技術(shù)基礎(chǔ)：") , new JLabel("Java程序設(shè)計：") , new JLabel("數(shù)據(jù)庫應(yīng)用實訓(xùn)教程：") , new JLabel("高等數(shù)學(xué)：") , new JLabel("XML："); JTextField txt = new JTextField(

54、) , new JTextField() , new JTextField() , new JTextField() , 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("添加學(xué)生成績" , JLabel.CENTER);Font f = new Font("黑體" , Font.BOLD , 16 ); int s=100;public addScore()super("添加學(xué)生信息");this.setResizable(false);this.setSize(500,600);th