zcadd.java~20~

代码是自己我的代码不是网上down的。是自己写的。里面有很多值得学习的知识点。还有一些javabean组件。不算自己写的JAR文件

package zcgl;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import javax.swing.BorderFactory;
import java.awt.Rectangle;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ZcAdd extends JFrame {
    Connection con = null;
    ResultSet rs = null;
    Statement smt = null;

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField txtZcId = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField txtZcName = new JTextField();
    JLabel jLabel3 = new JLabel();
    JComboBox cmbDlId = new JComboBox();
    JLabel jLabel4 = new JLabel();
    JComboBox cmbZlId = new JComboBox();
    JLabel jLabel5 = new JLabel();
    JTextField txtStyle = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField txtPrice = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField txtGrDate = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField txtStatus = new JTextField();
    JLabel jLabel9 = new JLabel();
    JTextField txtGrR = new JTextField();
    JLabel jLabel10 = new JLabel();
    JTextField txtContext = new JTextField();
    JButton btnAdd = new JButton();
    JButton btnEdit = new JButton();
    JButton btnDel = new JButton();
    JButton jButton1 = new JButton();
    public ZcAdd() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(10, 10, 377, 204));
        jPanel1.setLayout(null);
        jLabel2.setText("资产名称");
        jLabel2.setBounds(new Rectangle(203, 18, 52, 15));
        txtZcName.setBounds(new Rectangle(260, 14, 97, 21));
        jLabel3.setText("大类编号");
        jLabel3.setBounds(new Rectangle(15, 56, 50, 15));
        cmbDlId.setSelectedItem(null);
        cmbDlId.setBounds(new Rectangle(72, 54, 89, 23));
        jLabel4.setText("子类编号");
        jLabel4.setBounds(new Rectangle(202, 57, 50, 15));
        cmbZlId.setBounds(new Rectangle(261, 52, 96, 23));
        jLabel5.setText("样   式");
        jLabel5.setBounds(new Rectangle(16, 94, 52, 15));
        txtStyle.setBounds(new Rectangle(72, 93, 90, 21));
        jLabel6.setText("价   格");
        jLabel6.setBounds(new Rectangle(205, 94, 42, 15));
        txtPrice.setBounds(new Rectangle(261, 91, 95, 21));
        jLabel7.setText("购入日期");
        jLabel7.setBounds(new Rectangle(14, 128, 50, 15));
        txtGrDate.setBounds(new Rectangle(72, 126, 89, 21));
        jLabel8.setText("状   态");
        jLabel8.setBounds(new Rectangle(206, 127, 42, 15));
        txtStatus.setBounds(new Rectangle(261, 125, 95, 21));
        jLabel9.setText("购 入 人");
        jLabel9.setBounds(new Rectangle(15, 166, 49, 15));
        txtGrR.setBounds(new Rectangle(70, 164, 90, 21));
        jLabel10.setText("备   注");
        jLabel10.setBounds(new Rectangle(207, 167, 48, 15));
        txtContext.setBounds(new Rectangle(261, 164, 95, 21));
        btnAdd.setBounds(new Rectangle(24, 240, 83, 25));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new ZcAdd_btnAdd_actionAdapter(this));
        btnEdit.setBounds(new Rectangle(114, 239, 83, 25));
        btnEdit.setText("修改");
        btnDel.setBounds(new Rectangle(204, 240, 83, 25));
        btnDel.setText("删除");
        btnDel.addActionListener(new ZcAdd_btnDel_actionAdapter(this));
        jButton1.setBounds(new Rectangle(294, 241, 83, 25));
        jButton1.setText("查询");
        jButton1.addActionListener(new ZcAdd_jButton1_actionAdapter(this));
        this.getContentPane().add(jPanel1, null);
        txtZcId.setBounds(new Rectangle(71, 16, 90, 21));
        jPanel1.add(jLabel1);
        jPanel1.add(txtZcId);
        jPanel1.add(jLabel2);
        jPanel1.add(txtZcName);
        jPanel1.add(jLabel3);
        jPanel1.add(cmbDlId);
        jPanel1.add(jLabel4);
        jPanel1.add(cmbZlId);
        jPanel1.add(jLabel5);
        jPanel1.add(txtStyle);
        jPanel1.add(jLabel6);
        jPanel1.add(txtPrice);
        jPanel1.add(jLabel7);
        jPanel1.add(txtGrDate);
        jPanel1.add(jLabel8);
        jPanel1.add(txtStatus);
        jPanel1.add(jLabel9);
        jPanel1.add(txtGrR);
        jPanel1.add(jLabel10);
        jPanel1.add(txtContext);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(btnAdd);
        this.getContentPane().add(btnEdit);
        this.getContentPane().add(btnDel);
        jLabel1.setText("资产编号");
        jLabel1.setBounds(new Rectangle(13, 19, 64, 15));
        con = new DBConn().getConnection();
        smt = con.createStatement();
        rs = smt.executeQuery("select cateid,subcateid from CATEGORY");
        while (rs.next()) {
            cmbDlId.addItem(rs.getInt(1));
            cmbZlId.addItem(rs.getInt(2));
        }
    }

    public void btnAdd_actionPerformed(ActionEvent e) {

        ZcBean bean = new ZcBean();
        bean.setZcId(Integer.parseInt(txtZcId.getText()));
        bean.setZcName(txtZcName.getText());
        bean.setZcDlId(Integer.parseInt(cmbDlId.getSelectedItem().toString()));
        bean.setZcZlId(Integer.parseInt(cmbZlId.getSelectedItem().toString()));
        bean.setZcStyle(txtStyle.getText());
        bean.setZcPrice(Float.parseFloat(txtPrice.getText()));
        bean.setZcGrDate(txtGrDate.getText());
        bean.setZcStatus(txtStatus.getText());
        bean.setZcGrR(txtGrR.getText());
        bean.setZcContext(txtContext.getText());
        if (bean.insert()) {
            JOptionPane.showMessageDialog(this, "插入成功！");
        } else {
            JOptionPane.showMessageDialog(this, "插入失败！");
        }

    }

    public void btnDel_actionPerformed(ActionEvent e) {

    }

    public void jButton1_actionPerformed(ActionEvent e) throws SQLException
             {
        ResultSet rs=null;
        if(txtZcId.getText().trim().equals(""))
        {
             JOptionPane.showMessageDialog(this, "资产编号不能为空！");
        }
        try
        {
          rs= new DBConn().execute("select * from ASSET where assetid="+txtZcId.getText());
        }
        catch(Exception ex1)
        {

        }
        if(rs.next()){

            txtZcId.setText(String.valueOf(rs.getInt("assetid")));
            txtZcName.setText(rs.getString("asset_name").trim());

            cmbDlId.setSelectedItem(String.valueOf(rs.getInt("cateid")));
            cmbZlId.setSelectedItem(String.valueOf(rs.getInt("subcateid")));

            txtStyle.setText(rs.getString("model").trim());
            txtPrice.setText(String.valueOf(rs.getFloat("price")));

            txtGrDate.setText(rs.getDate("purchase_date").toString());
            txtStatus.setText(rs.getString("status"));
            txtGrR.setText(rs.getString("useby").trim());
            txtContext.setText(rs.getString("remarks").trim());
        }

    }
}


    class ZcAdd_btnAdd_actionAdapter implements ActionListener {
        private ZcAdd adaptee;
        ZcAdd_btnAdd_actionAdapter(ZcAdd adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnAdd_actionPerformed(e);
        }
    }



class ZcAdd_jButton1_actionAdapter implements ActionListener {
    private ZcAdd adaptee;
    ZcAdd_jButton1_actionAdapter(ZcAdd adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        try {
         adaptee.jButton1_actionPerformed(e);
     } catch (SQLException ex) {
     }

    }
}


class ZcAdd_btnDel_actionAdapter implements ActionListener {
    private ZcAdd adaptee;
    ZcAdd_btnDel_actionAdapter(ZcAdd adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnDel_actionPerformed(e);
    }
}