学生管理系统实验报告

1、学生管理系统实验报告实验目的：学习学生管理系统java程序编程、编写学生管理系统程序。一、 实验环境：在软件Eclipse运行环境下运行二、 实验步骤：1. 在Eclipse环境中创建一个java工程，然后创建学生管理系统类，并在这类中编写代码。2. 调试代码，并进行纠正。3. 检验试验结果，查看是否符合要求。4. 得到结果。4、 实验内容代码：import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.bo

2、rder.*; 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 JP

3、anel 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.se

4、tActionCommand(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.se

5、tActionCommand(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(学生管理系统); this.setSize(500,400); this.setLocation(201,181); this.setResizable(false); this.setDe

6、faultCloseOperation(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

7、if(e.getActionCommand().equals(tianjia) Tianjia tj=new Tianjia(this,添加学生信息,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 Xiuga

8、i(this,修改学生信息,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

9、 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,

10、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 jav

11、ax.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 JDi

12、alog 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( 学号 );bq2 = new JLabel( 姓名 );bq3

13、 = 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(Strin

14、g) 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.s

15、etActionCommand(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(b

16、q4);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, 2

17、61);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)

18、;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.

19、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

20、.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;

21、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

22、;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 getColumnNam

23、e(int e)return (String)this.ziduan.get(e);public void sqlyj(String sql)ziduan=new Vector();ziduan.add(学号);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,s

24、a,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

25、();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 ja

26、va.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;JB

27、utton an1,an2;JPanel mb1,mb2,mb3,mb4;public Tianjia(Frame fck,String ckm,Boolean msck)super(fck,ckm,msck);bq1=new JLabel( 学号 );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)

28、;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.s

29、etLayout(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