學(xué)生管理系統(tǒng)實驗報告.doc

學(xué)生管理系統(tǒng)實驗報告實驗?zāi)康模簩W(xué)習(xí)學(xué)生管理系統(tǒng)java程序編程、編寫學(xué)生管理系統(tǒng)程序。一、 實驗環(huán)境：在軟件Eclipse運行環(huán)境下運行二、 實驗步驟：1. 在Eclipse環(huán)境中創(chuàng)建一個java工程，然后創(chuàng)建學(xué)生管理系統(tǒng)類，并在這類中編寫代碼。2. 調(diào)試代碼，并進行糾正。3. 檢驗試驗結(jié)果，查看是否符合要求。4. 得到結(jié)果。4、 實驗內(nèi)容代碼：import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.border.*; import javax.swing.JDialog; import javax.swing.JFrame; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Vector; import javax.swing.table.*; public class Xsglxt extends JFrame implements ActionListener JPanel mb1,mb2;JLabel bq1;JTextField wbk1;JButton an1,an2,an3,an4;JTable bg1;JScrollPane gd1;Xsxx xsxx2;public static void main(String args)Xsglxt xs=new Xsglxt(); public Xsglxt() mb1=new JPanel(); bq1=new JLabel(請輸入姓名); wbk1=new JTextField(10); an1=new JButton(查詢); an1.addActionListener(this); an1.setActionCommand(chaxun); mb1.add(bq1);mb1.add(wbk1);mb1.add(an1); mb2=new JPanel(); an2=new JButton(添加); an2.addActionListener(this); an2.setActionCommand(tianjia); an3=new JButton(修改); an3.addActionListener(this); an3.setActionCommand(xiugai); an4=new JButton(刪除); an4.addActionListener(this); an4.setActionCommand(shanchu); mb2.add(an2); mb2.add(an3); mb2.add(an4); xsxx2=new Xsxx(); bg1=new JTable(xsxx2); gd1=new JScrollPane(bg1); this.add(gd1); this.add(mb1,North); this.add(mb2,South); this.setTitle(學(xué)生管理系統(tǒng)); this.setSize(500,400); this.setLocation(201,181); this.setResizable(false); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setVisible(true); public void actionPerformed(ActionEvent e) if(e.getActionCommand().equals(chaxun) String xingming=this.wbk1.getText().trim(); String sql=select * from xuesheng where xingming=+xingming+; xsxx2=new Xsxx(sql); bg1.setModel(xsxx2); else if(e.getActionCommand().equals(tianjia) Tianjia tj=new Tianjia(this,添加學(xué)生信息,true); System.out.println(123456); xsxx2=new Xsxx(); bg1.setModel(xsxx2); else if(e.getActionCommand().equals(xiugai) int ii=this.bg1.getSelectedRow(); if(ii=-1) JOptionPane.showMessageDialog(this,請選中要刪除的行); return; new Xiugai(this,修改學(xué)生信息,true,xsxx2,ii); System.out.println(123456); xsxx2=new Xsxx(); bg1.setModel(xsxx2); else if(e.getActionCommand().equals(shanchu) int ii=this.bg1.getSelectedRow(); if(ii=-1) JOptionPane.showMessageDialog(this, 請選中要刪除的行); return; String st=(String)xsxx2.getValueAt(ii,0); PreparedStatement ps=null; Connection ct=null; ResultSet rs=null; Statement sn=null; try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); ct=DriverManager.getConnection(jdbc:odbc:sqlserver,sa,123456); /String xuehao=this.wbk1.getText().trim(); ps=ct.prepareStatement(delete from xuesheng where xuehao=?); ps.setString(1, st); ps.executeUpdate(); catch(Exception c2)e.paramString(); finally try if(rs!=null) rs.close(); if(ps!=null) ps.close(); if(ct!=null) ct.close(); catch(Exception e3) xsxx2=new Xsxx(); bg1.setModel(xsxx2); import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.border.*; import javax.swing.JDialog; import javax.swing.JFrame; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Vector; import javax.swing.table.*;public class Xiugai extends JDialog implements ActionListener JLabel bq1, bq2, bq3, bq4, bq5, bq6;JTextField wbk1, wbk2, wbk3, wbk4, wbk5, wbk6;JButton an1, an2;JPanel mb1, mb2, mb3, mb4;public Xiugai(Frame fck, String ckm, Boolean msck, Xsxx xsxx2, int hang) super(fck, ckm, msck);bq1 = new JLabel( 學(xué)號 );bq2 = new JLabel( 姓名 );bq3 = new JLabel( 性別 );bq4 = new JLabel( 年齡 );bq5 = new JLabel( 籍貫 );bq6 = new JLabel( 院系 );wbk1 = new JTextField(5);wbk1.setText(String) xsxx2.getValueAt(hang, 0);wbk1.setEditable(false);wbk2 = new JTextField(5);wbk2.setText(String) xsxx2.getValueAt(hang, 1);wbk3 = new JTextField(5);wbk3.setText(String) xsxx2.getValueAt(hang, 2);wbk4 = new JTextField(5);wbk4.setText(String) xsxx2.getValueAt(hang, 3);wbk5 = new JTextField(5);wbk5.setText(String) xsxx2.getValueAt(hang, 4);wbk6 = new JTextField(5);wbk6.setText(String) xsxx2.getValueAt(hang, 5);an1 = new JButton(修改);an1.addActionListener(this);an1.setActionCommand(tiangjia2);an2 = new JButton(取消);an2.addActionListener(this);an2.setActionCommand(quxiao);mb1 = new JPanel();mb2 = new JPanel();mb3 = new JPanel();mb4 = new JPanel();mb1.setLayout(new GridLayout(6, 1);mb2.setLayout(new GridLayout(6, 1);mb1.add(bq1);mb1.add(bq2);mb1.add(bq3);mb1.add(bq4);mb1.add(bq5);mb1.add(bq6);mb2.add(wbk1);mb2.add(wbk2);mb2.add(wbk3);mb2.add(wbk4);mb2.add(wbk5);mb2.add(wbk6);mb3.add(an1);mb3.add(an2);this.add(mb1, BorderLayout.WEST);this.add(mb2);this.add(mb3, BorderLayout.SOUTH);this.add(mb4, BorderLayout.EAST);this.setSize(370, 270);this.setLocation(401, 261);this.setResizable(false);/ this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);public void actionPerformed(ActionEvent e)if(e.getActionCommand().equals(tiangjia2)PreparedStatement ps=null;Connection ct=null;ResultSet rs=null;Statement sm=null;System.out.println(00000000000);try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);System.out.println(1111111111);ct=DriverManager.getConnection(jdbc:odbc:sqlserver,sa,123456);System.out.println(222222222222);String ss=(update xuesheng set xingming=?,xingbie=?,nianling=?,jiguan=?,yuanxi=? where xuehao=+wbk1.getText().trim()+);ps=ct.prepareStatement(ss);ps.setString(1, wbk2.getText();ps.setString(2, wbk3.getText();ps.setString(3, wbk4.getText();ps.setString(4, wbk5.getText();ps.setString(5, wbk6.getText();ps.executeUpdate();this.dispose(); catch (Exception e1) e1.printStackTrace();finallytryif(rs!=null)rs.close();if(ps!=null)ps.close();if(ct!=null)ct.close(); catch (Exception e3)else if(e.getActionCommand().equals(quxiao)this.dispose();import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.border.*; import javax.swing.JDialog; import javax.swing.JFrame; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Vector; import javax.swing.table.*;public class Xsxx extends AbstractTableModel Vector ziduan,jilu; PreparedStatement ps=null;Connection ct=null;ResultSet rs=null;public int getRowCount()return this.jilu.size();public int getColumnCount()return this.ziduan.size();public Object getValueAt(int hang,int lie)return (Vector) this.jilu.get(hang).get(lie);public Xsxx()this.sqlyj(select * from xuesheng);public Xsxx(String ss)this.sqlyj(ss);public String getColumnName(int e)return (String)this.ziduan.get(e);public void sqlyj(String sql)ziduan=new Vector();ziduan.add(學(xué)號);ziduan.add(姓名);ziduan.add(性別);ziduan.add(年齡);ziduan.add(籍貫);ziduan.add(所在院系);jilu=new Vector();tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);ct=DriverManager.getConnection(jdbc:odbc:sqlserver,sa,123456);ps=ct.prepareStatement(sql);rs=ps.executeQuery();while(rs.next()Vector hang=new Vector();hang.add(rs.getString(1);hang.add(rs.getString(2);hang.add(rs.getString(3);hang.add(rs.getString(4);hang.add(rs.getString(5);hang.add(rs.getString(6);jilu.add(hang);catch (Exception e)e.printStackTrace();finallytryif(rs!=null)rs.close();if(ps!=null)ps.close();if(ct!=null)ct.close(); catch (Exception e)import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.border.*; import javax.swing.JDialog; import javax.swing.JFrame; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.Vector; import javax.swing.table.*;public class Tianjia extends JDialog implements ActionListenerJLabel bq1,bq2,bq3,bq4,bq5,bq6;JTextField wbk1,wbk2,wbk3,wbk4,wbk5,wbk6;JButton an1,an2;JPanel mb1,mb2,mb3,mb4;public Tianjia(Frame fck,String ckm,Boolean msck)super(fck,ckm,msck);bq1=new JLabel( 學(xué)號 );bq2=new JLabel( 姓名 );bq3=new JLabel( 性別 );bq4=new JLabel( 年齡 );bq5=new JLabel( 籍貫 );bq6=new JLabel( 院系 );wbk1=new JTextField(5);wbk2=new JTextField(5);wbk3=new JTextField(5);wbk4=new JTextField(5);wbk5=new JTextField(5);wbk6=new JTextField(5);an1=new JButton(添加);an1.addActionListener(this);an1.setActionCommand(tiangjia2);an2=new JButton(取消);an2.addActionListener(this);an2.setActionCommand(quxiao);mb1=new JPanel();mb2=new JPanel();mb3=new JPanel();mb4=new JPanel();mb1.setLayout(new GridLayout(6,1);mb2.setLayout(new GridLayout(6,1);mb1.add(bq1); mb1.add(bq2); mb1.add(bq3);mb1.add(bq4); mb1.add(bq5); mb1.add(bq6);mb2.add(wbk1); mb2.add(wbk2); mb2.add(wbk3);mb2.add(wbk4); mb2.add(wbk5); mb2.add(wbk6);mb3.add(an1); mb3.add(an2);this.add(mb1,BorderLayout.WEST);this.add(mb2);this.add(mb3,Bo