import java.sql.*;   
import java.awt.*;   
import javax.swing.*;   
import java.awt.event.*;   
import javax.swing.border.*;   
import javax.swing.JOptionPane;   
class Add extends Panel implements ActionListener{   
  Connection con;   
  Statement sql;   
  Button b1,b2;   
  TextField tf1,tf2,tf3,tf4,tf5,tf6;   
  Box baseBox,bv1,bv2;   
  Add(){   
    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());   
    Panel p1=new Panel();   
    Panel p2=new Panel();   
    tf1=new TextField(16);   
    tf2=new TextField(16);   
    tf3=new TextField(16);   
    tf4=new TextField(16);   
    tf5=new TextField(16);   
    tf6=new TextField(16);   
    b1=new Button("錄入");   
    b1.setBackground(Color.green);   
    b2=new Button("重置");   
    b2.setBackground(Color.green);   
    b1.addActionListener(this);   
    b2.addActionListener(this);   
    p1.add(b1);   
    p1.add(b2);   
    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("性別"));   
    bv1.add(Box.createVerticalStrut(8));   
    bv1.add(new Label("專業"));   
    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(tf1);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(tf2);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(tf3);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(tf4);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(tf5);   
    bv2.add(Box.createVerticalStrut(8));   
    bv2.add(tf6);   
    bv2.add(Box.createVerticalStrut(8));   
    baseBox=Box.createHorizontalBox();   
    baseBox.add(bv1);   
    baseBox.add(Box.createHorizontalStrut(10));   
    baseBox.add(bv2);   
    p2.add(baseBox);   
    add(p1,"South");   
    add(p2,"Center");   
    setSize(350,300);   
    setBackground(Color.pink);   
  }   
  public void actionPerformed(ActionEvent e){   
    if(e.getSource()==b1){   
        try{ insert();}   
        catch(SQLException ee){}   
        JOptionPane.showMessageDialog(this,"數據已入庫!","提示對話框",JOptionPane.INFORMATION_MESSAGE);   
    }   
    else if(e.getSource()==b2){   
        tf1.setText(" ");   
        tf2.setText(" ");   
        tf3.setText(" ");   
        tf4.setText(" ");   
        tf5.setText(" ");   
        tf6.setText(" ");   
    }   
  }   
  public void insert() throws SQLException{   
    String s1="'"+tf1.getText().trim()+"'";   
    String s2="'"+tf2.getText().trim()+"'";   
    String s3="'"+tf3.getText().trim()+"'";   
    String s4="'"+tf4.getText().trim()+"'";   
    String s5="'"+tf5.getText().trim()+"'";   
    String s6="'"+tf6.getText().trim()+"'";   
    String temp="INSERT INTO jesse VALUES ("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+")";   
    con=DriverManager.getConnection("jdbc:odbc:data","","");   
    sql.executeQuery(temp);   
    con.close();   
  }    
}   
class Query extends Panel implements ActionListener{   
  Connection con;   
  Statement sql;   
  TextField t1,t2,t3,t4,t5,t6;   
  Button b;   
  Box baseBox,bv1,bv2;   
  int flag=0;   
  Query(){   
    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.orange);   
    b.addActionListener(this);   
    t1=new TextField(8);   
    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("輸入要查詢的學號"));   
    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("專業"));   
    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.red);   
  }   
  public void actionPerformed(ActionEvent e){   
    flag=0;   
    try{query();}   
    catch(SQLException ee){}   
  }   
  public void query() 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("學號");   
        name=rs.getString("姓名");   
        sex=rs.getString("性別");   
        subject=rs.getString("專業");   
        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);   
            flag=1;   
            break;   
        }   
    }   
    con.close();   
    if(flag==0){t1.setText("沒有該學生");}   
  }   
}   
class Update extends Panel implements ActionListener{   
  Connection con;   
  Statement sql;   
  Button b1,b2,b3;   
  Box baseBox,bv1,bv2;   
  TextField t1,t2,t3,t4,t5,t6;   
  Update(){   
    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());   
    b1=new Button("開始修改");   
    b1.setBackground(Color.green);   
    b2=new Button("錄入修改");   
    b2.setBackground(Color.yellow);   
    b3=new Button("重置");   
    b3.setBackground(Color.yellow);   
    b1.addActionListener(this);   
    b2.addActionListener(this);   
    b3.addActionListener(this);   
    t1=new TextField(8);   
    t2=new TextField(16);   
    t3=new TextField(16);   
    t4=new TextField(16);   
    t5=new TextField(16);   
    t6=new TextField(16);   
    Panel p1=new Panel(),p2=new Panel(),p3=new Panel();   
    p1.add(new Label("輸入要修改信息的學號"));   
    p1.add(t1);   
    p1.add(b1);   
    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("(新)專業"));   
    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);   
    p3.add(b2);