學(xué)生管理系統(tǒng)java實(shí)現(xiàn)

1、 學(xué)生管理系統(tǒng)java實(shí)現(xiàn) 準(zhǔn)備的軟件，我用是eclipse.exe，MySql，還有mysql jdbc 5.0 數(shù)據(jù)庫。網(wǎng)上很容易找到華軍上就有的。 第一步，安裝eclipse.exe，MySql。MySql的密碼請?jiān)O(shè)置為123，因?yàn)槲业某绦蛏系拿艽a就是123。以后你看懂了可以修改的！ 把下載的mysql jdbc 5.0 數(shù)據(jù)庫.zip通常是個壓縮包解壓到一個地方。然后運(yùn)行eclipse.exe。 建立個項(xiàng)目，名字自己隨便叫即可。然后在菜單欄上Project就是Run旁邊的那個菜單，按下左鍵選擇Properties就是最下面的一項(xiàng)。選擇Java Build Path。在對話框的右面出現(xiàn)個

2、小窗體，選Libraries。選擇Add External JARs.。選擇你mysql jdbc 5.0 數(shù)據(jù)庫，解壓出來的mysql-connector-java-5.0.0-beta-bin.jar 也許名字有出入。 如下面的圖 添加完成后就是這個樣子了 第二步 安裝Mysql數(shù)據(jù)庫 請把密碼設(shè)置為123 就是帶password的地方。我的程序上密碼設(shè)置就是123為了運(yùn)行方便。 執(zhí)行下面四個步驟Mysql然后運(yùn)行 。 四部的命令分別是 1。create database scxdb; 2。use scxdb; 3。create table student( number int, nam

3、e char(8), language int, math int, english int, birthday date); 4。insert into student values(1717,曹操,80,90,20,1985-01-01); 下面是程序清單！ /= 第一部分 package DBTest; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JFrame; import javax.swing.JMenu; import javax.swing

4、.JMenuBar; import javax.swing.JMenuItem; import javax.swing.JScrollPane; import javax.swing.JTable; public class DBFrame /* * param args */ public static void main(String args) / TODO Auto-generated method stub String sql = select * from student; / sql=insert into student values / (1717,張?jiān)骑L(fēng),56,80,65

5、,1979-02-16); DBFrameWindow db = new DBFrameWindow(sql); db.setDefaultCloseOperation(db.EXIT_ON_CLOSE); db.setVisible(true); db.setResizable(false); class DBFrameWindow extends JFrame public DBFrameWindow(String sql) super.setTitle(DBFrameWindow); this.sql=sql; this.setSize(500, 380); JTable table =

6、 DBHander.getTable(this.sql); scroolPane = new JScrollPane(table); this.add(scroolPane); / = JMenu runMenu = new JMenu(Run); JMenuBar mb = new JMenuBar(); mb.add(runMenu); this.setJMenuBar(mb); /=Append=Append= JMenuItem appendItem = new JMenuItem(Append); appendItem.addActionListener(new ActionList

7、ener() Override public void actionPerformed(ActionEvent e) / TODO Auto-generated method stub appendFrame af = new appendFrame(); af.setDefaultCloseOperation(af.EXIT_ON_CLOSE); af.setVisible(true); af.setResizable(false); DBHander.getUpdataTest(); ); /=Append=Append= /=Remove=Remove= JMenuItem remove

8、Item = new JMenuItem(Remove); removeItem.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent arg0) / TODO Auto-generated method stub removeFrame rf=new removeFrame(); rf.setDefaultCloseOperation(rf.EXIT_ON_CLOSE); rf.setResizable(false); rf.setVisible(true); ); /=

9、Remove=Remove= /=Update=Update= JMenuItem updateItem = new JMenuItem(Update); updateItem.addActionListener(new ActionListener() public void actionPerformed(ActionEvent e) / TODO Auto-generated method stub updateFrame uf = new updateFrame(); uf.setDefaultCloseOperation(uf.EXIT_ON_CLOSE); uf.setResiza

10、ble(false); uf.setVisible(true); ); /=Update=Update= /=Find=Find= JMenuItem findItem = new JMenuItem(Find); findItem.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent arg0) / TODO Auto-generated method stub selectFrame sf = new selectFrame(); sf.setDefaultCloseO

11、peration(sf.EXIT_ON_CLOSE); sf.setResizable(false); sf.setVisible(true); ); /=Find=Find= JMenuItem refreshItem = new JMenuItem(Refresh); refreshItem.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent arg0) / TODO Auto-generated method stub JTable ta=DBHander.getT

12、able(select * from student;); JScrollPane scroolPane_1=new JScrollPane(ta); add(scroolPane_1); System.out.println(efreshItem); ); runMenu.add(appendItem); runMenu.add(removeItem); runMenu.add(updateItem); runMenu.add(findItem); runMenu.add(refreshItem); / = private JScrollPane scroolPane = null; pri

13、vate String sql=; /= /= 第二部分 package DBTest; import java.io.UnsupportedEncodingException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import javax.swing.JTable; i

14、mport com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource; public class DBHander /* * param args */ public static void main(String args) / TODO Auto-generated method stub String sql = insert into student values (1717,張?jiān)骑L(fēng),56,80,65,1979-02-16); Connection conn = getConnection(); if (conn = nul

15、l) System.out.println(conn=null); else System.out.println(conn!=null); Statement stat = getStatement(); if (stat = null) System.out.println(stat=null); else System.out.println(stat!=null); ResultSet rs = getResult(select * from student;); if (rs = null) System.out.println(s=null); else System.out.pr

16、intln(s!=null); JTable table = getTable(select * from student;); if (rs = null) System.out.println(able=null); else System.out.println(able!=null); private static String select=null; / = Connection = public static Connection getConnection() MysqlConnectionPoolDataSource ds = new MysqlConnectionPoolD

17、ataSource(); ds.setUrl(jdbc:MySQL:/localhost/scxdb); ds.setUser(oot); ds.setPassword(S); try return ds.getConnection(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); System.out.println(conn=null); return null; / = Connection = / = Statement = public static Statement g

18、etStatement() Connection conn = DBHander.getConnection(); try return conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); System.out.println(stat=null); return null; / = Statement = / = Resu

19、ltSet = public static ResultSet getResult(String sql) try return getStatement().executeQuery(sql); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); System.out.println(able=null); return null; / = ResultSet = / = getTable = public static JTable getTable(String sql) Result

20、Set rs = null; String str = null; int cols = 0; try rs = getResult(sql); ResultSetMetaData md = rs.getMetaData(); cols = md.getColumnCount(); int n = 0; while (rs.next() n = n + 1; str = new Stringncols; catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); rs = getResult(sql

21、); int n = 0; try while (rs.next() for (int i = 0; i cols; i+) / strni=rs.getString(i+1); strni = new String(rs.getString(i + 1).getBytes( iso-8859-1), GBK); n = n + 1; catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); catch (UnsupportedEncodingException e) / TODO Auto-ge

22、nerated catch block e.printStackTrace(); String s = new String Number, Name, Language, Math, English, Birthday ; JTable table = new JTable(str, s); for (int i = 0; i str.length; i+) for (int j = 0; j stri.length; j+) System.out.print(strij + ); System.out.println(); select=str; return table; / = get

23、Table = public static void getUpdataTest(String sql) try Connection conn=getConnection(); if(conn=null) System.out.println(ull); PreparedStatement ps=conn.prepareStatement(UPDATE student SET number = ? WHERE number=?;); ps.setString(1,_x0010_88); ps.setString(2,y7); System.out.println(#); catch (SQL

24、Exception e) / TODO Auto-generated catch block e.printStackTrace(); / = getUpdata = public static void getUpdate(String sql) Statement stat; try stat = getConnection().createStatement(); int n = stat.executeUpdate(sql); System.out.println(* + n + *); catch (SQLException e) / TODO Auto-generated catc

25、h block e.printStackTrace(); / = getUpdata = / = getSelect = public static String getSelect(String sql) getTable(sql); if(select=null) System.out.println(select=null); return select; / = getSelect = /= /= 第3部分 package DBTest; import java.awt.BorderLayout; import java.awt.GridLayout; import java.awt.

26、event.ActionEvent; import java.awt.event.ActionListener; import java.io.UnsupportedEncodingException; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JPanel; import javax.swing.JTextField; public class appendFrame extends JFrame /* * param args */

27、 public static void main(String args) / TODO Auto-generated method stub appendFrame af = new appendFrame(); af.setDefaultCloseOperation(af.EXIT_ON_CLOSE); af.setVisible(true); public appendFrame() super.setTitle(AppendFrame); this.setSize(150, 220); JPanel panel = new JPanel(); panel.setLayout(new G

28、ridLayout(6, 2); panel.add(new JLabel( 學(xué)號), tf_num); panel.add(tf_num); ), tf_name); 姓名 panel.add(new JLabel( panel.add(tf_name); panel.add(new JLabel( 語文), tf_c); panel.add(tf_c); panel.add(new JLabel( 數(shù)學(xué)), tf_m); panel.add(tf_m); panel.add(new JLabel( 外語), tf_e); panel.add(tf_e); panel.add(new JLa

29、bel( 生日), tf_b); panel.add(tf_b); tf_c.setText( tf_m.setText( tf_e.setText( this.add(panel, BorderLayout.CENTER); JPanel p = new JPanel(); p.setLayout(new GridLayout(1, 2); p.add(smitButton); / = returnButton = returnButton.addActionListener(new ActionListener() Override public void actionPerformed(

30、ActionEvent arg0) / TODO Auto-generated method stub appendFrame.this.setVisible(false); appendFrame.this.setEnabled(false); ); p.add(returnButton); / = returnButton = / = smitButton / = smitButton.addActionListener(new ActionListener() Override / 本應(yīng)該在此處添加判斷是否為空紀(jì)錄的，然后有對話框彈出但是，沒有想到好的省事的方法，不過是可以實(shí)現(xiàn)的！ pu

31、blic void actionPerformed(ActionEvent e) / TODO Auto-generated method stub String t1 = + tf_num.getText() + ,; String t2 = + tf_name.getText() + ,; String t3 = + tf_c.getText() + ,; String t4 = + tf_m.getText() + ,; String t5 = + tf_e.getText() + ,; String t6 = + tf_b.getText() + ; sql = insert into

32、 student values( + t1 + t2 + t3 + t4 + t5 + t6 + ); try sql = new String(sql.getBytes(GBK), iso8859-1); catch (UnsupportedEncodingException e1) / TODO Auto-generated catch block e1.printStackTrace(); System.out.println( + sql); DBHander.getUpdate(sql); appendFrame.this.setVisible(false); appendFrame

33、.this.setEnabled(false); ); / = smitButton / = this.add(p, BorderLayout.SOUTH); public String getSql() return sql; private JTextField tf_num = new JTextField(10); private JTextField tf_name = new JTextField(10); private JTextField tf_c = new JTextField(10); private JTextField tf_m = new JTextField(1

34、0); private JTextField tf_e = new JTextField(10); private JTextField tf_b = new JTextField(16); 瀠楲慶整?畂瑴湯猠業(yè)?瑵潴?敮?瑵潴?確認(rèn)); 瀠楲慶整?畂瑴湯爠瑥牽?瑵潴?敮?瑵潴?返回); private String sql = null; /= /= 第4部分 package DBTest; import java.awt.BorderLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener

35、; import java.io.UnsupportedEncodingException; import javax.swing.JButton; import javax.swing.JCheckBox; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JTextField; public class removeFrame extends JFrame /* * par

36、am args */ public static void main(String args) / TODO Auto-generated method stub removeFrame rf = new removeFrame(); rf.setDefaultCloseOperation(rf.EXIT_ON_CLOSE); rf.setVisible(true); private JComboBox comboBox_condition = null; private JComboBox comboBox_field = null; private JTextField text_str

37、= new JTextField(10); 瀠楲慶整?畂瑴湯猠業(yè)?瑵潴?敮?瑵潴?確定); 瀠楲慶整?畂瑴湯爠瑥牽?瑵潴?敮?瑵潴?返回); private JCheckBox cBox = new JCheckBox(ALL); private String sql = ; public removeFrame() super.setTitle(RemoveFrame); this.setSize(410, 160); setResizable(false); String strCondition = new String , =, ; String strField = new Stri

38、ng Number, Name, Language, Math, English, Birthday; comboBox_condition = new JComboBox(strCondition); comboBox_field = new JComboBox(strField); JPanel panel = new JPanel(); / panel.setLayout(new GridLayout(2,3); panel.add(comboBox_field); panel.add(comboBox_condition); panel.add(text_str); panel.add

39、(cBox); / =cBox= cBox.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent arg0) / TODO Auto-generated method stub if (cBox.isSelected() comboBox_field.setEnabled(false); comboBox_condition.setEnabled(false); text_str.setEditable(false); / sql=delete from student;

40、else comboBox_field.setEnabled(true); comboBox_condition.setEnabled(true); text_str.setEditable(true); ); / =cBox= / =smitButton= smitButton.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent arg0) if (text_str.getText().equals() ?灝楴湯慐敮獻(xiàn)潨?獥慳敧楄污杯渨汵?尠條件不能為空); else

41、String t1 = (String) comboBox_field.getSelectedItem(); String t2 = (String) comboBox_condition.getSelectedItem(); String t3 = +text_str.getText()+; sql = delete from student where + t1 + t2 + t3; try sql=new String(sql.getBytes(GBK),iso8859-1); catch (UnsupportedEncodingException e) / TODO Auto-gene

42、rated catch block e.printStackTrace(); if (cBox.isSelected() sql = delete from student; System.out.println(sql); DBHander.getUpdate(sql); /else ); / =smitButton= /=returnButton= returnButton.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent arg0) / TODO Auto-gen

43、erated method stub removeFrame.this.setVisible(false); removeFrame.this.setEnabled(false); ); /=returnButton= JPanel p = new JPanel(); p.add(smitButton); p.add(returnButton); this.add(panel, BorderLayout.NORTH); this.add(p, BorderLayout.SOUTH); /= /= 第5部分 package DBTest; import java.awt.BorderLayout; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.UnsupportedEncodingException; import javax.swing.JButton; import javax.swing.JCheckBox; import javax.swing.JComboBox; im