student.java

学生信息管理

      package zhuang;
      import javax.swing.*;
      import java.awt.event.*;
      import java.awt.*;
      import java.io.*;
      import java.sql.*;
      import zhuang.query;
      public class Student extends JFrame implements ActionListener 
      { private JButton show;
		private  JButton insert;
	    private JButton delete;
	    private JButton edit;
		private JButton exit;
	    private	JButton query;
		JTable table;
		Object data[][]=new Object[30][9];
		String title[]={"编号","学号","姓名","性别","出生年月","院系名称","英语","数学","JAVA"};
	    Connection conn;
        Statement stat;
        ResultSet rs;
	    public Student()throws Exception
	    {  super("学生信息管理系统");
      	   JPanel p=new JPanel();
      	   JLabel label=new JLabel("学生信息");
           show = new JButton("显示全部");
		   insert = new JButton("插入");
		   delete = new JButton("删除");
	       edit = new JButton("修改");
	       query=new JButton("查询");
	       exit=new JButton("退出");
           this.setSize(750,600); 
          p.add(show);p.add(insert);p.add(edit);
          p.add(query);p.add(delete);p.add(exit);
		  show.addActionListener(this);
		  insert.addActionListener(this);
		  query.addActionListener(this);
		  edit.addActionListener(this);
		  delete.addActionListener(this);
		  exit.addActionListener(this);
		  table=new JTable(data,title);
		  //table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
          JScrollPane pane=new JScrollPane(table);
          this.add("Center",pane);
          this.add(label,"North");
          this.add(p,"South");       
		  this.setVisible(true);    
	      this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); 
	      this.connection();
	      this.pack();
	    }
	  public void connection()
      {
       try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             String url="jdbc:odbc:students";
             conn=DriverManager.getConnection(url);
              stat = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
           } catch (Exception ex){ }
      } 	   
   	 public void actionPerformed(ActionEvent e) 
     { if(e.getSource()==show)  Showall(); 
       if (e.getSource()==insert)   Insert();  
       if (e.getSource()==query) Query1(); 
	   if (e.getSource()==delete) Delete();
	   if (e.getSource()==edit) Update();
	   if(e.getSource()==exit)  System.exit(0);
	 }
	 public void Showall() 
	 { try{ for(int x=0;x<data.length;x++){
            data[x][0]=null;
            data[x][1]=null;
            data[x][2]=null;
            data[x][3]=null;
            data[x][4]=null;
            data[x][5]=null;
            data[x][6]=null;
            data[x][7]=null;
            data[x][8]=null;
             
           }
           int i=0;
            rs=stat.executeQuery("select * from students");
            while(rs.next()){
            data[i][0]=rs.getString(1);
            data[i][1]=rs.getString(2);
            data[i][2]=rs.getString(3);
            data[i][3]=rs.getString(4);
            data[i][4]=rs.getString(5);
            data[i][5]=rs.getString(6);
            data[i][6]=rs.getInt(7);
            data[i][7]=rs.getInt(8);
            data[i][8]=rs.getInt(9);
             i=i+1;
            }
            this.repaint();
        } catch (SQLException ex) {  }
    }
    private void Insert() 
    { try{ JTextField t[]=new JTextField[16];
               t[0]=new JTextField("输入学号:");
               t[0].setEditable(false);
               t[1]=new JTextField();
               t[2]=new JTextField("输入姓名:");
               t[2].setEditable(false);
               t[3]=new JTextField();
               t[4]=new JTextField("输入性别:");
               t[4].setEditable(false);
               t[5]=new JTextField();
               t[6]=new JTextField("出生年月:");
               t[6].setEditable(false);
               t[7]=new JTextField();
               t[8]=new JTextField("院系名称:");
               t[8].setEditable(false);
               t[9]=new JTextField();
               t[10]=new JTextField("英语成绩 :");
               t[10].setEditable(false);
               t[11]=new JTextField();
               t[12]=new JTextField(" 数学成绩:");
               t[12].setEditable(false);
               t[13]=new JTextField();
               t[14]=new JTextField("JAVA成绩:");
               t[14].setEditable(false);
               t[15]=new JTextField();
               String but[]={"确定","取消"};
         int go=JOptionPane.showOptionDialog(null,t,"插入信息",
JOptionPane.YES_OPTION,JOptionPane.INFORMATION_MESSAGE,null,but,but[0]);
     if(go==0){
      try{
       String sno=new String(t[1].getText());
       String name=new String(t[3].getText());
       String sex=new String(t[5].getText());
        String birthday=new String(t[7].getText());
       String department=new String(t[9].getText());
       int english=Integer.parseInt(t[11].getText());
       int manth=Integer.parseInt(t[13].getText());
       int java=Integer.parseInt(t[15].getText());
       connection();
       stat.executeUpdate("insert into students (sno,name,sex,birthday,department,english,manth,java) values ('"+sno+"','"+name+"','"+sex+"','"+birthday+"','"+department+"','"+english+"','"+manth+"','"+java+"')");
       JOptionPane.showMessageDialog(null,"数据插入成功！");
        this.Showall();
      }catch(Exception ee){   }
     }
     } catch (Exception ex) {   }
    }
    public void Query1()
    { try{query q=new query();}catch (Exception ex) { }
    }
	public void Delete() 
    {try {
        int row=table.getSelectedRow();
       stat.executeUpdate("delete from students where sno='"+data[row][1]+"'");
       JOptionPane.showMessageDialog(null,"数据删除成功");
       this.Showall();
      }catch (SQLException ex) {  }
    }
    public void Update() {
    try {   int row=table.getSelectedRow();
            JTextField t[]=new JTextField[16];
               t[0]=new JTextField("输入学号:");
               t[0].setEditable(false);
               t[1]=new JTextField();
               t[2]=new JTextField("输入姓名:");
               t[2].setEditable(false);
               t[3]=new JTextField();
               t[4]=new JTextField("输入性别:");
               t[4].setEditable(false);
               t[5]=new JTextField();
               t[6]=new JTextField("出生年月:");
               t[6].setEditable(false);
               t[7]=new JTextField();
               t[8]=new JTextField("院系名称:");
               t[8].setEditable(false);
               t[9]=new JTextField();
               t[10]=new JTextField("英语成绩 :");
               t[10].setEditable(false);
               t[11]=new JTextField();
               t[12]=new JTextField("数学成绩 :");
               t[12].setEditable(false);
               t[13]=new JTextField();
               t[14]=new JTextField("JAVA成绩:");
               t[14].setEditable(false);
               t[15]=new JTextField();
               String but[]={"确定","取消"};
          int go=JOptionPane.showOptionDialog(null,t,"请输入该生的新信息：",
          JOptionPane.YES_OPTION,JOptionPane.INFORMATION_MESSAGE,null,but,but[0]);
     if(go==0){
      try{
       String sno=new String(t[1].getText());
       String name=new String(t[3].getText());
       String sex=new String(t[5].getText());
       String birthday=new String(t[7].getText());
       String department=new String(t[9].getText());
       int english=Integer.parseInt(t[11].getText());
       int manth=Integer.parseInt(t[13].getText());
       int java=Integer.parseInt(t[15].getText());
       connection();
       stat.executeUpdate("update students "+"set sno='"+sno+"',"+"name='"+name+"',"+"sex='"+sex+"',"+"birthday='"+birthday+"',"+"department='"+department+"',"+"english='"+english+"',"+"manth='"+manth+"',"+"java='"+java+"'"+"where sno='"+data[row][1]+"'");
	   JOptionPane.showMessageDialog(null,"数据修改成功！");
	   this.Showall();
        }catch(Exception ee){  }
      }
     } catch (Exception ex) {   }
    }
	public static void main(String args[]) throws Exception
	{  Student x1=new Student();}
}