productadd.java

软件工程课程设计

package Manager;

import javax.swing.*;

import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.sql.ResultSet;
import java.sql.SQLException;

public class productAdd extends JFrame {
	/**
	 * <p>Title:添加入库产品信息 </p>
	 * <p>Description: </p>
	 * <p>Copyright: Copyright (c) 2008</p>
	 * <p>Company:南华大学计算机系 </p>
	 * @author 王云飞
	 * @version 1.0
	 */
	private static final long serialVersionUID = 1L;

private DBManager db =new DBManager();//定义数据库操作对象
   ResultSet rs;    //定义结果集
  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JButton jButtonExit = new JButton();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JTextField jTextFieldname = new JTextField();
  JButton jButtonAdd = new JButton();
  JTextField jTextFieldperson = new JTextField();
  JTextField jTextFielddep = new JTextField();
  JTextField jTextFielddanwei = new JTextField();
  JTextField jTextFieldprice = new JTextField();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JTextField jTextFieldcomment = new JTextField();
  JButton jButtonClear = new JButton();

  public productAdd() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  public static void main(String[] args) {
    new productAdd();
  }

  private void jbInit() throws Exception {
    jButtonAdd.addMouseListener(new userAdd_jButtonAdd_mouseAdapter(this));
    jButtonAdd.setText("添加");
    jButtonAdd.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldname.setText("");
    jTextFieldname.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("所属部门");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("名称");
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonExit.addMouseListener(new userAdd_jButtonExit_mouseAdapter(this));
    jButtonExit.setText("退出");
    jButtonExit.addMouseListener(new userAdd_jButtonExit_mouseAdapter(this));
    jButtonExit.addMouseListener(new userAdd_jButtonExit_mouseAdapter(this));
    jButtonExit.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("负责人");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel4.setText("单位");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
    this.getContentPane().setLayout(xYLayout1);
    jTextFieldperson.setText("");
    jTextFieldperson.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFielddep.setText("");
    jTextFielddep.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFielddanwei.setText("");
    jTextFielddanwei.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldprice.setText("");
    jTextFieldprice.setFont(new java.awt.Font("Dialog", 0, 16));
    xYLayout1.setWidth(444);
    xYLayout1.setHeight(398);
    jLabel5.setText("单价");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel6.setText("描述");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldcomment.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldcomment.setText("");
    jButtonClear.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonClear.setText("清空");
    jButtonClear.addMouseListener(new productAdd_jButtonClear_mouseAdapter(this));
    this.setTitle("添加产品信息");
    this.getContentPane().add(jTextFieldname,  new XYConstraints(239, 25, 111, 28));
    this.getContentPane().add(jLabel1, new XYConstraints(88, 26, 99, 34));
    this.getContentPane().add(jTextFieldperson,  new XYConstraints(238, 69, 111, 26));
    this.getContentPane().add(jTextFielddep,    new XYConstraints(240, 111, 111, 27));
    this.getContentPane().add(jTextFielddanwei,   new XYConstraints(240, 155, 111, 27));
    this.getContentPane().add(jTextFieldprice,  new XYConstraints(240, 198, 111, 28));
    this.getContentPane().add(jLabel2, new XYConstraints(85, 70, 80, 34));
    this.getContentPane().add(jLabel3, new XYConstraints(84, 111, 110, 36));
    this.getContentPane().add(jLabel4, new XYConstraints(85, 157, 105, 34));
    this.getContentPane().add(jLabel5, new XYConstraints(83, 199, 105, 34));
    this.getContentPane().add(jLabel6, new XYConstraints(82, 244, 105, 34));
    this.getContentPane().add(jButtonClear,    new XYConstraints(61, 325, 95, 31));
    this.getContentPane().add(jButtonExit, new XYConstraints(286, 327, 94, 30));
    this.getContentPane().add(jButtonAdd, new XYConstraints(175, 326, 91, 31));
    this.getContentPane().add(jTextFieldcomment, new XYConstraints(241, 240, 111, 28));
  }

  void jTextFielddep_actionPerformed(ActionEvent e) {

  }
//退出此窗口
  void jButtonExit_mouseClicked(MouseEvent e) {
         this.dispose();
  }
//添加产品信息
  void jButtonAdd_mouseClicked(MouseEvent e) {
    String strSQL ;
       //判断是否产品名称为空
      if(jTextFieldname.getText().trim().equals(""))
           {JOptionPane.showMessageDialog(null,"产品名称不可为空 ，请确认！");
           return;
           }
      //判断是否负责人为空
       if(jTextFieldperson.getText().trim().equals(""))
                     {JOptionPane.showMessageDialog(null,"负责人不可为空 ，请确认！");
                     return;
                     }
      //判断是否产品所属部门为空
       if(jTextFielddep.getText().trim().equals(""))
                               {JOptionPane.showMessageDialog(null,"产品所属部门不可为空 ，请确认！");
                               return;
                               }
      
       //生成sql语句，产品名和负责人从相应文本框取得
        strSQL="select * from productinfo where Name='"+jTextFieldname.getText().toString().trim() +"' and Principal='"+jTextFieldperson.getText().trim()+"'";
          //由DBManager对象执行查询过程
          rs=db.getResult(strSQL) ;
         //判断结果集是否为空
                    boolean  isexist=false;
                   try {
                     isexist = rs.first();
                   }
                   catch (SQLException ex) {
                   }
           //若已存在，则说明该系列产品已在仓库中存在，弹出警告信息
            if(isexist)
               {JOptionPane.showMessageDialog(null,"该产品名称和其相应的负责人已存在！");
               jTextFieldname.setText("");
               jTextFieldperson.setText("");
               jTextFielddep.setText("");
               jTextFielddanwei.setText("");
               jTextFieldprice.setText("");
               jTextFieldcomment.setText("");
               }
            else
            {
     //生成sql语句
        strSQL="insert into  productinfo(Name,Principal,Department,Units,Unitprice,Comment) values('";
        strSQL= strSQL+jTextFieldname.getText().trim() +"','";
        strSQL= strSQL+jTextFieldperson.getText().trim() +"','";
        strSQL= strSQL+jTextFielddep.getText().trim() +"','";
        strSQL= strSQL+jTextFielddanwei.getText().trim() +"','";
        strSQL= strSQL+jTextFieldprice.getText().trim() +"','";
          strSQL= strSQL+jTextFieldcomment.getText().trim() +"'";
        strSQL= strSQL+ ")";
      //由DBManager对象执行过程，若成功返回成功信息，若失败返回失败提示
       if(db.executeSql(strSQL))
                        {JOptionPane.showMessageDialog(null,"成功添加！"); }
       else
                        { JOptionPane.showMessageDialog(null," 添加失败，请重新操作！");}
            }

  }
//清空文本框
  void jButtonClear_mouseClicked(MouseEvent e) {
       jTextFieldname.setText("");
       jTextFieldperson.setText("");
       jTextFielddep.setText("");
       jTextFielddanwei.setText("");
       jTextFieldprice.setText("");
       jTextFieldcomment.setText("");
  }
}

class userAdd_jButtonExit_mouseAdapter extends java.awt.event.MouseAdapter {
  productAdd adaptee;

  userAdd_jButtonExit_mouseAdapter(productAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonExit_mouseClicked(e);
  }
}

class userAdd_jButtonAdd_mouseAdapter extends java.awt.event.MouseAdapter {
  productAdd adaptee;

  userAdd_jButtonAdd_mouseAdapter(productAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonAdd_mouseClicked(e);
  }
}

class productAdd_jButtonClear_mouseAdapter extends java.awt.event.MouseAdapter {
  productAdd adaptee;

  productAdd_jButtonClear_mouseAdapter(productAdd adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonClear_mouseClicked(e);
  }
}