dd.java

小程序 自己写的 请多多指教 希望高手不吝赐教

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
class dd extends Frame implements ActionListener,ItemListener
{ private  condb conx=null;
  private ResultSet rs=null;
  private String sql=null;
  private Label num=new Label("调度编号");
  private Label jb=new Label("调度方式");
  private Label fj=new Label("调度数量");
  private Label in=new Label("客户地址");
  private Label lb=new Label("调度编号列表");
  private TextField numtx=new TextField();
  private TextField jbtx=new TextField();
  private TextField fjtx=new TextField();
  private TextField intx=new TextField();
  private Choice numcho=new Choice();
  private Button add=new Button("增加");
  private Button del=new Button("删除");
  private Button mod=new Button("修改");
  private Button exit=new Button("退出");
  public dd()
  {  setTitle("调度信息管理");
     setSize(400,300);
     setBackground(Color.LIGHT_GRAY);
     this.setLocationRelativeTo(this.getParent());
     this.setResizable(false);
     setLayout(null);
     num.setBounds(80,50,50,20);
     jb.setBounds(80,80,50,20);
     fj.setBounds(80,110,50,20);
     in.setBounds(80,140,50,20);
     lb.setBounds(80,170,50,20);
     numtx.setBounds(160,50,100,20);
     jbtx.setBounds(160,80,100,20);
     fjtx.setBounds(160,110,100,20);
     intx.setBounds(160,140,100,20);
     numcho.setBounds(160,170,100,20);
     add.setBounds(60,220,50,20);
     del.setBounds(140,220,50,20);
     mod.setBounds(220,220,50,20);
     exit.setBounds(300,220,50,20);
     add(add);
     add(del);
     add(mod);
     add(exit);
     add(num);
     add(jb);
     add(fj);
     add(in);
     add(lb);
     add(numtx);
     add(jbtx);
     add(fjtx);
     add(intx);
     add(numcho);
  
     add.addActionListener(this);
     del.addActionListener(this);
     mod.addActionListener(this);
     exit.addActionListener(this);
     numcho.addItemListener(this);
     initnumcho();
     setVisible(true);  
     addWindowListener(new WindowAdapter()
                      { public void windowClosing(WindowEvent e)
                         {dispose();}
                       }
                      );  
    }
   
  public void itemStateChanged(ItemEvent i)
  {  numtx.setText(numcho.getSelectedItem());
  }
 
public void initnumcho()
  { conx=new condb();
    sql="select * from 库存管理 ";
    numcho.removeAll();
    try {  rs=conx.getrs(conx.con,sql);
          while(rs.next())
            {numcho.add(rs.getString("商品代码"));}
           conx.dbclose(conx.con,rs);
           conx=null;
           rs=null;
          }
    catch(Exception eo){}
  }
  
 public void actionPerformed(ActionEvent e)
  { conx=new condb();
  if(e.getActionCommand().equals("退出"))
       this.dispose();
       
    if(e.getActionCommand().equals("增加"))
      {   
         sql="select * from 调度管理 where 调度编号='"+numtx.getText()+"'";
       try{ rs=conx.getrs(conx.con,sql);
           if(rs.next())
             { JOptionPane jop=new JOptionPane();
               jop.showConfirmDialog(null,"该职工已经存在!","警告!",-1);
               conx.dbclose(conx.con,rs);
               conx=null;
               rs=null;
             }
        else  {  
                 sql="insert into 调度管理(调度编号,调度方式,调度数量,客户地址)"+
                      "values('"+numtx.getText().trim()+"',"+
                      jbtx.getText()+","+fjtx.getText()+",'"+intx.getText()+"')";
                 
                 try {  System.out.println(sql);
                      conx.moddb(conx.con,sql);
                      conx.dbclose(conx.con,null);
                    }
                 catch(Exception ue){System.out.println(""+ue);}
                 numtx.setText("");
                 jbtx.setText("");
                 fjtx.setText("");
                 conx=null;
                  rs=null;
               }
       
         } catch(SQLException et){System.out.println(""+et);}
         
      }
         
      
    if(e.getActionCommand().equals("修改"))
      { 
        sql="update 调度管理 set 调度方式="+jbtx.getText()+",调度数量="+fjtx.getText()+",客户地址='"+intx.getText()+"' where 调度编号='"+numtx.getText()+"'";
        try{ System.out.println(sql);
              conx.moddb(conx.con,sql);
              conx.dbclose(conx.con,null);
            }
         catch(Exception er){System.out.println(""+er);}
         
         numtx.setText("");
                 jbtx.setText("");
                 fjtx.setText("");
       conx=null;
       }
    if(e.getActionCommand().equals("删除"))
     {
       sql="delete from 调度管理 where 调度编号='"+numtx.getText()+"'";
       try{ System.out.println(sql);
            conx.moddb(conx.con,sql);
            conx.dbclose(conx.con,null);
           }
        catch(Exception ee){System.out.println("调度管理表删除失败");}
        numtx.setText("");
                 jbtx.setText("");
                 fjtx.setText("");
        conx=null;
      }
  }


}