p3.add(b3);   
    add(p1,"North");   
    add(p2,"Center");   
    add(p3,"South");   
    setSize(300,250);   
    setBackground(Color.cyan);   
  }   
  public void actionPerformed(ActionEvent e){   
    if(e.getSource()==b1){   
        try{   
            String num,name,sex,subject,grade,born;   
            con=DriverManager.getConnection("jdbc:odbc:data","","");   
            ResultSet rs=sql.executeQuery("SELECT * FROM jesse ");   
            while(rs.next()){   
                num=rs.getString("學(xué)號");   
                name=rs.getString("姓名");   
                sex=rs.getString("性別");   
                subject=rs.getString("專業(yè)");   
                grade=rs.getString("年級");   
                born=rs.getString("出生");   
                if(num.equals(t1.getText().trim())){   
                    t2.setText(name);   
                    t3.setText(sex);   
                    t4.setText(subject);   
                    t5.setText(grade);   
                    t6.setText(born);   
                    break;   
                }   
            }   
            con.close();   
         }   
         catch(SQLException ee){}   
    }   
    if(e.getSource()==b2){   
        try{update();}   
        catch(SQLException ee){}   
    }   
    if(e.getSource()==b3){   
        t2.setText(" ");   
        t3.setText(" ");   
        t4.setText(" ");   
        t5.setText(" ");   
        t6.setText(" ");   
    }   
  }   
  public void update() throws SQLException{   
    String s1="'"+t1.getText().trim()+"'";   
    String s2="'"+t2.getText().trim()+"'";   
    String s3="'"+t3.getText().trim()+"'";   
    String s4="'"+t4.getText().trim()+"'";   
    String s5="'"+t5.getText().trim()+"'";   
    String s6="'"+t6.getText().trim()+"'";   
    String temp="UPDATE jesse SET 姓名 ="+s2+", 性別="+s3+", 專業(yè)="+s4+", 年級="+s5+", 出生="+s6+" WHERE 學(xué)號="+s1;   
    con=DriverManager.getConnection("jdbc:odbc:data","","");   
    sql.executeQuery(temp);   
    con.close();   
  }   
}   
class Delete extends Panel implements ActionListener{   
  Connection con;   
  Statement sql;   
  TextField t1,t2,t3,t4,t5,t6;   
  Button b;   
  Box baseBox,bv1,bv2;   
  Delete(){   
    try{   
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");   
        }   
    catch(ClassNotFoundException e){}   
    try{   
        con=DriverManager.getConnection("jdbc:odbc:data","","");   
        sql=con.createStatement();   
    }   
    catch(SQLException ee){}   
    setLayout(new BorderLayout());   
    b=new Button("刪除");   
    b.setBackground(Color.cyan);   
    b.addActionListener(this);   
    t1=new TextField(8);   
    t1.addActionListener(this);   
    t2=new TextField(16);   
    t3=new TextField(16);   
    t4=new TextField(16);   
    t5=new TextField(16);   
    t6=new TextField(16);   
    t2.setEditable(false);   
    t3.setEditable(false);   
    t4.setEditable(false);   
    t5.setEditable(false);   
    t6.setEditable(false);   
    Panel p1=new Panel(),p2=new Panel();   
    p1.add(new Label("輸入要?jiǎng)h除的學(xué)號"));   
    p1.add(t1);   
    p1.add(b);   
    bv1=Box.createVerticalBox();   
    bv1.add(new Label("姓名"));   
    bv1.add(Box.createVerticalStrut(8));   
    bv1.add(new Label("性別"));   
    bv1.add(Box.createVerticalStrut(8));   
    bv1.add(new Label("專業(yè)"));   
    bv1.add(Box.createVerticalStrut(8));   
    bv1.add(new Label("年級"));   
    bv1.add(Box.createVerticalStrut(8));   
    bv1.add(new Label("出生"));   
    bv1.add(Box.createVerticalStrut(8));   
    bv2=Box.createVerticalBox();   
    bv2.add(t2);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(t3);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(t4);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(t5);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(t6);   
    bv2.add(Box.createVerticalStrut(8));   
    baseBox=Box.createHorizontalBox();   
    baseBox.add(bv1);   
    baseBox.add(Box.createHorizontalStrut(10));   
    baseBox.add(bv2);   
    p2.add(baseBox);   
    add(p1,"North");   
    add(p2,"Center");   
    setSize(300,250);   
    setBackground(Color.green);   
  }   
  public void actionPerformed(ActionEvent e){   
    if(e.getSource()==t1){   
        try{delete();}   
        catch(SQLException ee){}   
    }   
    else if(e.getSource()==b){   
        int n=JOptionPane.showConfirmDialog(this,"確定要?jiǎng)h除該學(xué)號及全部信息嗎?","確定",JOptionPane.YES_NO_OPTION);   
        if(n==JOptionPane.YES_OPTION){   
            try{   
                String s1="'"+t1.getText().trim()+"'";   
                String temp="DELETE FROM jesse WHERE 學(xué)號="+s1;   
                con=DriverManager.getConnection("jdbc:odbc:data","","");   
                sql.executeUpdate(temp);   
                con.close();   
               }   
            catch(SQLException ee){}   
        }   
        else if(n==JOptionPane.NO_OPTION){}   
    }   
  }   
  public void delete() throws SQLException{   
    String num,name,sex,subject,grade,born;   
    con=DriverManager.getConnection("jdbc:odbc:data","","");   
    ResultSet rs=sql.executeQuery("SELECT * FROM jesse ");   
    while(rs.next()){   
        num=rs.getString("學(xué)號");   
        name=rs.getString("姓名");   
        sex=rs.getString("性別");   
        subject=rs.getString("專業(yè)");   
        grade=rs.getString("年級");   
        born=rs.getString("出生");   
        if(num.equals(t1.getText().trim())){   
            t2.setText(name);   
            t3.setText(sex);   
            t4.setText(subject);   
            t5.setText(grade);   
            t6.setText(born);   
            break;   
        }   
    }   
    con.close();   
  }    
}   
public class tyj extends Frame implements ActionListener{   
  MenuBar bar=null;   
  Menu menu1,menu2,menu3,menu4,menu5;   
  MenuItem item1,item2,item3,item4,item5;   
  Add zengjia;   
  Query chaxun;   
  Update gengxin;   
  Delete shanchu;   
  tyj(){   
    super("歡迎進(jìn)入學(xué)生信息管理系統(tǒng)");   
    zengjia=new Add();   
    chaxun=new Query();   
    gengxin=new Update();   
    shanchu=new Delete();   
    bar=new MenuBar();   
    menu1=new Menu("信息錄入");   
    menu2=new Menu("信息查詢");   
    menu3=new Menu("信息更新");   
    menu4=new Menu("信息刪除");   
    menu5=new Menu("退出系統(tǒng)");   
    item1=new MenuItem("錄入");   
    item2=new MenuItem("查詢");   
    item3=new MenuItem("更新");   
    item4=new MenuItem("刪除");   
    item5=new MenuItem("退出");   
    menu1.add(item1);   
    menu2.add(item2);   
    menu3.add(item3);   
    menu4.add(item4);   
    menu5.add(item5);   
    bar.add(menu1);   
    bar.add(menu2);   
    bar.add(menu3);   
    bar.add(menu4);   
    bar.add(menu5);   
    setMenuBar(bar);   
    item1.addActionListener(this);   
    item2.addActionListener(this);   
    item3.addActionListener(this);   
    item4.addActionListener(this);   
    item5.addActionListener(this);   
    Label label=new Label("歡迎進(jìn)入學(xué)生信息管理系統(tǒng)",Label.CENTER);   
    String s=" ";   
    Font f=new Font(s,Font.BOLD,22);   
    label.setFont(f);   
    label.setBackground(Color.GREEN);   
    label.setForeground(Color.BLUE);   
    add(label,"Center");   
    setVisible(true);   
    setSize(320,300);   
  }   
  public void actionPerformed(ActionEvent e){   
    if(e.getSource()==item1){   
        removeAll();   
        add(zengjia,"Center");   
        validate();   
    }   
   if(e.getSource()==item2){   
        removeAll();   
        add(chaxun,"Center");   
        validate();   
    }   
   if(e.getSource()==item3){   
        removeAll();   
        add(gengxin,"Center");   
        validate();   
    }   
   if(e.getSource()==item4){   
        removeAll();   
        add(shanchu,"Center");   
        validate();   
    }   
    if(e.getSource()==item5){   
        removeAll();   
        setBackground(Color.GREEN);   
        Label label=new Label("歡迎進(jìn)入學(xué)生信息管理系統(tǒng)",Label.CENTER);   
        String s=" ";   
        Font f=new Font(s,Font.BOLD,22);   
        label.setFont(f);   
        label.setForeground(Color.BLUE);   
        add(label,"Center");   
        validate();   
    }   
  }   
  public static void main(String[] args)   
  {   
    tyj jesse=new tyj();   
    jesse.setVisible(true);   
    jesse.addWindowListener(new WindowAdapter(){   
        public void windowClosing(WindowEvent e){   
            System.exit(0);   
        }   
    });   
  }   
}