Cdel.java

来源：互联网发布：js获取屏幕宽度编辑：程序博客网时间：2024/04/29 01:33

import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.net.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;
class Cdel extends Frame implements ActionListener
{
    MenuBar menubar;
Panel p1,p2,p3;
Label L,L1;
TextField text1;
Button b1,b2;
Cdel(String s,int a,int b)
{
  super(s);
  setSize(a,b);
  setResizable(false); //ﾊｹﾗ鋗ｯｴｰｿﾚｱ莎ﾉｻﾒﾉｫ
  p1=new Panel();
  p2=new Panel();
  p3=new Panel();
  setLayout(new BorderLayout());
  L=new Label("ﾉｾｳｿﾎｳﾌ");
  L1=new Label("ﾇ・菠・ﾎｳﾌｺﾅ:");
  text1=new TextField(10);
  b1=new Button("ﾉｾｳ");
  b2=new Button("ﾈ｡ﾏ・);
  setMenuBar(menubar);
  setBackground(Color.white);
  setVisible(true);
        p1.add(L);p2.add(L1);p2.add(text1);
        p3.add(b1);p3.add(b2);
        add(p1,"North");
        add(p2,"Center");
        add(p3,"South");
        b1.addActionListener(this);
        b2.addActionListener(this);
        addWindowListener(new WindowAdapter()
        {
        public void windowClosing(WindowEvent e)
        {
          setVisible(false);
          /*System.exit(0);*///ﾊｹﾋﾐｵﾄｴｰｿﾚｹﾘｱﾕ
        }
        });
}
public void actionPerformed(ActionEvent e)
{

     if(e.getSource()==b1)
   {
   Connection con=null;
   Statement st=null;
   String sql="";
   String sq="";
   String num=text1.getText();
   sq="select Cnum from Cinf where Cnum='"+num+"';";
   sql="DELETE FROM Cinf WHERE Cnum='"+num+"';";
   if((num==null)||(num.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);
   st.close();
   con.close();
   {JOptionPane.showMessageDialog(null,"ﾉｾｳｳﾉｹｦ!");}
     }
     else
     {JOptionPane.showMessageDialog(null,"ﾊ菠・ﾎｳﾌｺﾅﾓﾐﾎ・");}
  }
  catch(Exception e4){
   {JOptionPane.showMessageDialog(null,"ﾉｾｳﾊｧｰﾜ!");}
  }
  }
   }
   else if(e.getSource()==b2)
{
setVisible(false);
         pack();
}
}
}