class InfoInput extends Frame implements ActionListener{
 public void actionPerformed(ActionEvent e) {
  Button btn = (Button)e.getSource();
  if(btn == insert){
   String idD = id.getText();
   String nameD = name.getText();
   String sql="insert into mytest values(";
   sql=sql+idD+",'"+nameD+"')";
////////////////////////////////////////////////////////
   String driver="oracle.jdbc.driver.OracleDriver";
   String url="jdbc:oracle:thin:@127.0.0.1:1521:xe";
   Connection con=null; Statement stmt=null;
   try{
    Class.forName(driver);
    System.out.println("?? ??");
    con = DriverManager.getConnection(url,"hr","hr");
    stmt = con.createStatement();
    System.out.println("DB?? ??!!!");
    stmt.executeUpdate(sql);
   }catch(Exception ee){
    ee.printStackTrace();
    System.out.println("DB?? ??!");
   }finally{
    try{stmt.close(); con.close();}catch(Exception ee){}
   }
////////////////////////////////////////////////////////
  }else if(btn==delete){
   String idD = id.getText();
   String nameD = name.getText();
   String sql="delete mytest where id=";
   sql=sql+idD+" and name= '"+nameD+"'";
////////////////////////////////////////////////////////
   String driver="oracle.jdbc.driver.OracleDriver";
   String url="jdbc:oracle:thin:@127.0.0.1:1521:xe";
   Connection con=null; Statement stmt=null;
   try{
    Class.forName(driver);
    System.out.println("?? ??");
    con = DriverManager.getConnection(url,"hr","hr");
    stmt = con.createStatement();
    System.out.println("DB?? ??!!!");
    stmt.executeUpdate(sql);
   }catch(Exception ee){
    ee.printStackTrace();
    System.out.println("DB?? ??!");
   }finally{
    try{stmt.close(); con.close();}catch(Exception ee){}
   }
////////////////////////////////////////////////////////
  }else if(btn==update){
   String idD = id.getText();
   String nameD = name.getText();
   String sql="update mytest set name=";
   sql=sql+"'"+nameD+"' where id="+idD;
////////////////////////////////////////////////////////
   String driver="oracle.jdbc.driver.OracleDriver";
   String url="jdbc:oracle:thin:@127.0.0.1:1521:xe";
   Connection con=null; Statement stmt=null;
   try{
    Class.forName(driver);
    System.out.println("?? ??");
    con = DriverManager.getConnection(url,"hr","hr");
    stmt = con.createStatement();
    System.out.println("DB?? ??!!!");
    stmt.executeUpdate(sql);
   }catch(Exception ee){
    ee.printStackTrace();
    System.out.println("DB?? ??!");
   }finally{
    try{stmt.close(); con.close();}catch(Exception ee){}
   }
////////////////////////////////////////////////////////
  }else if(btn==select){
   String idD = id.getText();
   String nameD = name.getText();
   String sql="select * from mytest where id=";
   sql=sql+idD+" and name='"+nameD+"'";
////////////////////////////////////////////////////////
   String driver="oracle.jdbc.driver.OracleDriver";
   String url="jdbc:oracle:thin:@127.0.0.1:1521:xe";
   Connection con=null; Statement stmt=null;
   try{
    Class.forName(driver);
    System.out.println("?? ??");
    con = DriverManager.getConnection(url,"hr","hr");
    stmt = con.createStatement();
    System.out.println("DB?? ??!!!");
    ResultSet rs = stmt.executeQuery(sql);
    while(rs.next()){
     int myId = rs.getInt("ID");
     String myName = rs.getString("NAME");
     id.setText(""+myId);
     name.setText(myName);
    }
   }catch(Exception ee){
    ee.printStackTrace();
    System.out.println("DB?? ??!");
   }finally{
    try{stmt.close(); con.close();}catch(Exception ee){}
   }
////////////////////////////////////////////////////////
  }else if(btn==cancel){
   id.setText(" "); name.setText(" ");
  }
 }
 Button insert,delete,update,select,cancel;
 TextField id, name;
 InfoInput(String str){
  super(str); setLayout(new BorderLayout());
  Label info1 = new Label("??? ?????");
  id = new TextField(20);
  Label info2 = new Label("??? ?????");
  name = new TextField(20);
  Panel p1 = new Panel(); p1.add(info1);p1.add(id);
  p1.add(info2); p1.add(name);
  insert = new Button(" ? ? ");insert.addActionListener(this);
  delete=new Button(" ? ? ");delete.addActionListener(this);
  update=new Button(" ? ? ");update.addActionListener(this);
  select=new Button(" ? ? ");select.addActionListener(this);
  cancel=new Button(" ? ? ");cancel.addActionListener(this);
  Panel p2 = new Panel();
  p2.add(insert);p2.add(delete);p2.add(update);
  p2.add(select); p2.add(cancel);
  add("Center",p1); add("South",p2);
  setSize(300,300); setVisible(true);
 }
}
public class DBTest {
 public static void main(String[] args) {
  new InfoInput("????");
 }
}