productupdate.java~10~

若已安装Jbuilder X

package Manager;

import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class productUpdate extends JFrame {
  ResultSet rs;    //定义结果集
  private DBManager db =new DBManager();

  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel4 = new JLabel();
  JTextField jTextFielddanwei = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField jTextFieldperson = new JTextField();
  JLabel jLabel6 = new JLabel();
  JTextField jTextFieldname = new JTextField();
  JTextField jTextFieldcomment = new JTextField();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JTextField jTextFieldprice = new JTextField();
  JButton jButtonExit = new JButton();
  JTextField jTextFielddep = new JTextField();
  JButton jButtonClear = new JButton();
  JButton jButtonOk = new JButton();
  JLabel jLabel5 = new JLabel();
  JButton jButtonDeside = new JButton();
  JLabel jLabel7 = new JLabel();
  JButton jButtonDelete = new JButton();

  public productUpdate() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  public static void main(String[] args) {
    productUpdate productUpdate = new productUpdate();
  }
  private void jbInit() throws Exception {
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel5.setText("单价");
    jButtonOk.setFont(new java.awt.Font("Dialog", 0, 16));
      jButtonOk.setText("更新");
    jButtonOk.addMouseListener(new productUpdate_jButtonOk_mouseAdapter(this));
      jButtonClear.setText("清空");
    jButtonClear.addMouseListener(new productUpdate_jButtonClear_mouseAdapter(this));
    jButtonClear.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFielddep.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFielddep.setText("");
    jButtonExit.setFont(new java.awt.Font("Dialog", 0, 16));
     jButtonExit.setText("取消");
    jButtonExit.addMouseListener(new productUpdate_jButtonExit_mouseAdapter(this));
    jTextFieldprice.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldprice.setText("");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("所属部门");
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("名称");
    jTextFieldcomment.setText("");
    jTextFieldcomment.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldname.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldname.setText("");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel6.setText("描述");
    jTextFieldperson.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldperson.setText("");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("负责人");
    jTextFielddanwei.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFielddanwei.setText("");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel4.setText("单位");
    this.getContentPane().setLayout(xYLayout1);
     jButtonDeside.setText("确定");
    jButtonDeside.addMouseListener(new productUpdate_jButtonDeside_mouseAdapter(this));
     jButtonDeside.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel7.setText("填入产品名称点击确定将调出此产品相关信息：");
    xYLayout1.setWidth(546);
    xYLayout1.setHeight(402);
    jButtonDelete.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonDelete.setText("删除");
    jButtonDelete.addMouseListener(new productUpdate_jButtonDelete_mouseAdapter(this));
    this.setTitle("更新产品信息");
    this.getContentPane().add(jTextFieldname, new XYConstraints(309, 41, 111, 28));
    this.getContentPane().add(jLabel4, new XYConstraints(155, 173, 105, 34));
    this.getContentPane().add(jTextFielddanwei, new XYConstraints(310, 171, 111, 27));
    this.getContentPane().add(jLabel2, new XYConstraints(155, 86, 80, 34));
    this.getContentPane().add(jTextFieldperson, new XYConstraints(308, 85, 111, 26));
    this.getContentPane().add(jLabel6, new XYConstraints(152, 260, 105, 34));
    this.getContentPane().add(jTextFieldcomment, new XYConstraints(311, 256, 111, 28));
    this.getContentPane().add(jLabel1, new XYConstraints(158, 42, 99, 34));
    this.getContentPane().add(jLabel3, new XYConstraints(154, 127, 110, 36));
    this.getContentPane().add(jTextFieldprice, new XYConstraints(310, 214, 111, 28));
    this.getContentPane().add(jTextFielddep, new XYConstraints(310, 127, 111, 27));
    this.getContentPane().add(jLabel5, new XYConstraints(153, 215, 105, 34));
    this.getContentPane().add(jLabel7, new XYConstraints(11, 7, 359, 29));
    this.getContentPane().add(jButtonDeside, new XYConstraints(153, 326, 91, 31));
    this.getContentPane().add(jButtonOk, new XYConstraints(244, 326, 91, 31));
    this.getContentPane().add(jButtonDelete,  new XYConstraints(336, 326, 90, 31));
    this.getContentPane().add(jButtonClear, new XYConstraints(58, 325, 95, 31));
    this.getContentPane().add(jButtonExit, new XYConstraints(429, 327, 94, 30));
  }
//退出次窗体
  void jButtonExit_mouseClicked(MouseEvent e) {
              this.dispose();
  }
//清空文本框
  void jButtonClear_mouseClicked(MouseEvent e) {
          jTextFieldname.setText("");
          jTextFieldperson.setText("");
          jTextFielddep.setText("");
          jTextFielddanwei.setText("");
          jTextFieldprice.setText("");
          jTextFieldcomment.setText("");

  }

  void jButtonOk_mouseClicked(MouseEvent e) {
      //定义字符串对象,代表sql语句
      String strSQL ;
      //生成sql语句
      strSQL="update productinfo set principal='"+jTextFieldperson.getText().trim()  +"',";
      strSQL=  strSQL+" department='"+jTextFielddep.getText().trim()  +"',";
      strSQL=  strSQL+" danwei='"+jTextFielddanwei.getText().trim()  +"',";
      strSQL=  strSQL+" danjia='"+jTextFieldprice.getText().trim()  +"',";
      strSQL=  strSQL+" comment='"+jTextFieldcomment.getText().trim()  +"'";
      strSQL=  strSQL+"where name='"+jTextFieldname.getText().trim() +"' " ;
      //由DBManager对象执行过程，若成功返回成功信息，若失败返回失败提示
      if(db.executeSql(strSQL))
                      {JOptionPane.showMessageDialog(null,"成功更新！"); }
           else
                      { JOptionPane.showMessageDialog(null," 更新失败，请重新操作！");      }

  }

//调出产品相关信息
  void jButtonDeside_mouseClicked(MouseEvent e) {
      //定义字符串对象,代表sql语句
    String strSQL ;
    //生成sql语句
      strSQL="select * from productinfo where name='"+jTextFieldname.getText().trim() +"' " ;
    //由DBManager对象执行过程，若成功返回成功信息，若失败返回失败提示
      rs=db.getResult(strSQL) ;
    //判断结果集是否为空
             boolean  isexist=false;
                try {
                         isexist = rs.first();
                       }
                catch (SQLException ex1) {
                       }
   //若为空，则说明产品不存在，弹出警告信息
    if(!isexist)
        {JOptionPane.showMessageDialog(null,"此产品不存在！");
                 }
   //若不为空，则说明产品存在
    else
      {
       try {
         //将数据集中的数据显示在对应文本框中
         rs.first();
         jTextFieldperson.setText(rs.getString("principal") );
         jTextFielddep.setText(rs.getString("department"));
         jTextFielddanwei.setText(rs.getString("danwei"));
         jTextFieldprice.setText(rs.getString("danjia"));
         jTextFieldcomment.setText(rs.getString("comment"));
       }
       catch (SQLException ex) {
       }
      }
  }

  //删除此信息
  void jButtonDelete_mouseClicked(MouseEvent e) {
       //定义字符串对象,代表sql语句
      String strSQL ;
       //生成sql语句
      strSQL="delete from productinfo where name='"+jTextFieldname.getText().trim() +"' " ;
       //由DBManager对象执行过程，若成功返回成功信息，若失败返回失败提示
      if(db.executeSql(strSQL))
                      {JOptionPane.showMessageDialog(null,"成功删除！"); }
      else
                      { JOptionPane.showMessageDialog(null," 删除失败，请重新操作！");      }




  }
}

class productUpdate_jButtonExit_mouseAdapter extends java.awt.event.MouseAdapter {
  productUpdate adaptee;

  productUpdate_jButtonExit_mouseAdapter(productUpdate adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonExit_mouseClicked(e);
  }
}

class productUpdate_jButtonClear_mouseAdapter extends java.awt.event.MouseAdapter {
  productUpdate adaptee;

  productUpdate_jButtonClear_mouseAdapter(productUpdate adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonClear_mouseClicked(e);
  }
}

class productUpdate_jButtonOk_mouseAdapter extends java.awt.event.MouseAdapter {
  productUpdate adaptee;

  productUpdate_jButtonOk_mouseAdapter(productUpdate adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonOk_mouseClicked(e);
  }
}

class productUpdate_jButtonDeside_mouseAdapter extends java.awt.event.MouseAdapter {
  productUpdate adaptee;

  productUpdate_jButtonDeside_mouseAdapter(productUpdate adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonDeside_mouseClicked(e);
  }
}

class productUpdate_jButtonDelete_mouseAdapter extends java.awt.event.MouseAdapter {
  productUpdate adaptee;

  productUpdate_jButtonDelete_mouseAdapter(productUpdate adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonDelete_mouseClicked(e);
  }
}