Cedi.java

 import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.net.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
class Cedi extends Frame implements ActionListener
{  
    MenuBar menubar;
 Panel p1,p2,p3;
 Label l,l1,l2,l3,l4;
 TextField text,text1,text2,text3,text4;
 Button b3,b1,b2;
 Cedi(String s,int a,int b)
 {
  super(s);
  setSize(a,b);
  setResizable(false); //ﾊｹﾗ鋗ｯｴｰｿﾚｱ莎ﾉｻﾒﾉｫ
  p1=new Panel();
  p2=new Panel();
  p3=new Panel();
  setLayout(new GridLayout(1,3));//1ﾐﾐ3ﾁﾐ
  l=new Label("ﾇ・菠・ﾎｳﾌｺﾅ");
  l1=new Label("ｿﾎｳﾌｱ犲ﾅ:");
  l2=new Label("ｿﾎｳﾌﾃ﨤ﾆ:");
  l3=new Label("ﾊﾚｿﾎｵﾘｵ・");
  l4=new Label("ｿﾎｳﾌﾀ牾・");
  text=new TextField(10);
  text1=new TextField(10);
  text2=new TextField(10);
  text3=new TextField(10);
  text4=new TextField(10);
  b3=new Button("ﾈｷｶｨ");
  b1=new Button("ﾐﾞｸﾄ");
  b2=new Button("ﾈ｡ﾏ・);
  setMenuBar(menubar);
  setBackground(Color.white);
  setVisible(true);
        p1.setLayout(new GridLayout(7,2));
        p1.add(new Label());p1.add(new Label());p1.add(new Label());p1.add(l);p1.add(new Label());p1.add(text);
        p1.add(new Label());p1.add(b3);p1.add(new Label());p1.add(b1);p1.add(new Label());p1.add(b2);p1.add(new Label());
        p2.setLayout(new GridLayout(7,1));
        p2.add(new Label());p2.add(new Label());p2.add(l1);p2.add(l2);p2.add(l3);p2.add(l4);
        p3.setLayout(new GridLayout(7,1));
        p3.add(new Label());p3.add(new Label());p3.add(text1);p3.add(text2);p3.add(text3);p3.add(text4);
        add(p1);
        add(p2);
        add(p3);
        b1.addActionListener(this);
        b2.addActionListener(this);
        b3.addActionListener(this);
        //ﾊｹｴｰｿﾚｿﾉﾒﾔｹﾘｱﾕ
        addWindowListener(new WindowAdapter()
        {
         public void windowClosing(WindowEvent e)
         {
          setVisible(false);
          /*System.exit(0);*///ﾊｹﾋﾐｵﾄｴｰｿﾚｹﾘｱﾕ
         }
        });
 }//ﾏﾔﾊｾﾐﾅﾏ｢ﾓ・・
 public void actionPerformed(ActionEvent e)
 {
  if(e.getSource()==b3) //b3ﾎｪﾊ菠・ｧｺﾅﾈｷｶｨｰｴﾅ･,ｻ｡ﾐﾅﾏ｢
   { 
      String sqlcmd="";
      String number=text.getText();
      sqlcmd="SELECT * FROM Cinf WHERE Cnum='"+number+"';";
      if ((number==null)||(number.length()==0))
   JOptionPane.showMessageDialog(null,"ﾊﾗﾏﾈﾇ・菠・耡ｪﾐﾞｸﾄﾐﾅﾏ｢ｵﾄｿﾎｳﾌｵﾄｿﾎｳﾌｺﾅ!");
   else{
    try{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     //ﾁｬｽﾓﾊｾﾝｿ・
     Connection con=DriverManager.getConnection("jdbc:odbc:Stu");
     Statement sql=con.createStatement();
         ResultSet rs=sql.executeQuery(sqlcmd);//
     if (rs.next())
     {
      String num=rs.getString("Cnum");
      String name=rs.getString("Cname");
      String place=rs.getString("Cplace");
      String type=rs.getString("Ctype");
      //ﾏﾔﾊｾｱ櫢ﾐﾋﾐﾐﾅﾏ｢
      text1.setText(num);
      text2.setText(name);
      text3.setText(place);
      text4.setText(type);
            }
            else
             JOptionPane.showMessageDialog(null,"ﾊｾﾝｿ籔ﾐﾎﾞｴﾋｼﾇﾂｼ");
    }
    catch(Exception e3)
    {
     System.out.println("error1");
    }
   }
   }
   //ﾐﾞｸﾄﾐﾅﾏ｢ﾓ・・
   else if(e.getSource()==b1)// b1ﾎｪﾐﾞｸﾄﾐﾅﾏ｢ｰｴﾅ･,ﾐﾞｸﾄﾐﾅﾏ｢;
  { Connection con=null;
    Statement st=null;
    String sql="";
    String sq="";
    String se="";
    String t1,t2,t3,t4,t;
    String number=text.getText();
         t1=text1.getText();
   t2=text2.getText();
   t3=text3.getText();
   t4=text4.getText();
          t=text.getText();
         sq="SELECT Cnum FROM Cinf WHERE Cnum='"+number+"';";
         sql="update Cinf set Cnum='"+t1+"',Cname='"+t2+"',Cplace='"+t3+"',Ctype='"+t4+"' where Cnum='"+t+"';";
           if((t1==null)||(t1.length()==0))
   JOptionPane.showMessageDialog(null,"ｿﾎｳﾌｺﾅｲｻﾄﾜﾎｪｿﾕ!");
  else if((t2==null)||(t2.length()==0))
  JOptionPane.showMessageDialog(null,"ｿﾎｳﾌﾃ軏ｻﾄﾜﾎｪｿﾕ!");
   else if((t3==null)||(t3.length()==0))
  JOptionPane.showMessageDialog(null,"ﾊﾚｿﾎｵﾘｵ羇ｻﾄﾜﾎｪｿﾕ!");
   else if((t4==null)||(t4.length()==0))
  JOptionPane.showMessageDialog(null,"ｿﾎｳﾌﾀ牾ｻﾄﾜﾎｪｿﾕ!");
        else{
     try{
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   //ﾁｬｽﾓﾊｾﾝｿ・
      con=DriverManager.getConnection("jdbc:odbc:Stu");
   st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
      ResultSet.CONCUR_READ_ONLY);
      ResultSet rs=st.executeQuery(sq);//
     if (rs.next())
     {
   st.executeUpdate(sql);
   {JOptionPane.showMessageDialog(null,"ﾐﾞｸﾄｳﾉｹｦ!");}
   st.close();
   con.close();
   }
   else
    {JOptionPane.showMessageDialog(null,"ﾄ耒ｴﾊ菠・ﾈｷｵﾄｿﾎｳﾌｺﾅ!");}
     }
  catch(Exception e4){
  {JOptionPane.showMessageDialog(null,"ﾐﾞｸﾄﾊｧｰﾜ!!");}
  }
        }
  } //___________________ｽﾓﾉﾏ

  else if(e.getSource()==b2)
  {
   setVisible(false);
         pack();
  }
 }
}