addcatepanel.java

固定资产管理

package stage_project;

import java.awt.*;

import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class AddCatePanel extends JPanel {
    public AddCatePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    ImageIcon img = new ImageIcon("xiubei.gif");
    JLabel lblBeijing = new JLabel(img);
    private void jbInit() throws Exception {
        this.setLayout(null);
        setSize(new Dimension(960, 600));
        jLabel1.setText("大类名称：");
        jLabel1.setBounds(new Rectangle(325, 260, 60, 35));
        jLabel2.setText("大类编号：");
        jLabel2.setBounds(new Rectangle(325, 200, 60, 35));
        jLabel3.setText("子类名称：");
        jLabel3.setBounds(new Rectangle(325, 380, 60, 35));
        jLabel4.setText("子类编号：");
        jLabel4.setBounds(new Rectangle(325, 320, 60, 35));
        txtMainCateId.setText("");
        txtMainCateId.setBounds(new Rectangle(421, 200, 180, 35));
        txtSortId.setText("");
        txtSortId.setBounds(new Rectangle(421, 320, 180, 35));
        txtMainCateName.setText("");
        txtMainCateName.setBounds(new Rectangle(421, 260, 180, 35));
        txtSortName.setText("");
        txtSortName.setBounds(new Rectangle(421, 380, 180, 35));
        btnAdd.setBounds(new Rectangle(259, 456, 70, 25));
        btnAdd.setText("增  加");
        btnAdd.addActionListener(new AddCatePanel_btnAdd_actionAdapter(this));
        btnMod.setBounds(new Rectangle(375, 456, 70, 25));
        btnMod.setText("修  改");
        btnMod.addActionListener(new AddCatePanel_btnMod_actionAdapter(this));
        btnDel.setBounds(new Rectangle(494, 456, 70, 25));
        btnDel.setText("删  除");
        btnDel.addActionListener(new AddCatePanel_btnDel_actionAdapter(this));
        btnSel.setBounds(new Rectangle(610, 456, 70, 25));
        btnSel.setText("查  询");
        btnSel.addActionListener(new AddCatePanel_btnSel_actionAdapter(this));
        lbiTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbiTime.setHorizontalAlignment(SwingConstants.CENTER);
        lbiTime.setText("");
        lbiTime.setBounds(new Rectangle(757, 45, 162, 50));
//        lblName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
//        lblName.setBounds(new Rectangle(659, 68, 119, 54));
        lblBeijing.setIcon(img);
        lblBeijing.setBounds(new Rectangle( 0, 0, 960, 600));
        this.add(txtSortName);
        this.add(jLabel1);
        this.add(jLabel4);
        this.add(jLabel3);
        this.add(lbiTime);
        this.add(lblName);
        this.add(txtMainCateId);
        this.add(jLabel2);
        this.add(txtMainCateName);
        this.add(txtSortId);
        this.add(btnAdd);
        this.add(btnSel);
        this.add(btnDel);
        this.add(btnMod);
        this.add(lblBeijing);
        TimeClass tc = new TimeClass();
        lbiTime.setText(tc.getTime());
        //管理员名字
        DebarkationDialog dd = new DebarkationDialog();
        lblName.setText(dd.name);

    }
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField txtMainCateId = new JTextField();
    JTextField txtSortId = new JTextField();
    JTextField txtMainCateName = new JTextField();
    JTextField txtSortName = new JTextField();
    JButton btnAdd = new JButton();
    JButton btnMod = new JButton();
    JButton btnDel = new JButton();
    JButton btnSel = new JButton();

    DBAccess db = new DBAccess();
    JLabel lbiTime = new JLabel();
    JLabel lblName = new JLabel();
    //增加类别

    public void btnAdd_actionPerformed(ActionEvent e) {
        String maincateid = txtMainCateId.getText();
        String maincatename = txtMainCateName.getText();
        String sortid = txtSortId.getText();
        String sortname = txtSortName.getText();
        //验证主类编号必须为数字
        for (int i = 0; i < maincateid.length(); i++) {
            char mci = maincateid.charAt(i);
            if (!Character.isDigit(mci)) {
                JOptionPane.showMessageDialog(this, "主类编号必须为数字");
                return;
            }
        }
        //验证主类编号不能为空
        if (maincateid.equals("")) {
            JOptionPane.showMessageDialog(this, "主类编号不能为空");
            return;
        }
        //验证子类编号必须为数字
        for (int i = 0; i < sortid.length(); i++) {
            char si = sortid.charAt(i);
            if (!Character.isDigit(si)) {
                JOptionPane.showMessageDialog(this, "子类编号必须为数字");
                return;
            }
        }
        //验证子类编号不能为空
        if (sortid.equals("")) {
            JOptionPane.showMessageDialog(this, "子类编号不能为空");
            return;
        }

        //向数据库添加
        int num = -1;

        String sql =
                "insert into category (cateid,catename,subcateid,subcatename) values ('" +
                maincateid + "','" + maincatename + "','" +
                sortid + "','" + sortname + "')";
        num = db.doUpdate(sql);
        if (num == 1) {
            JOptionPane.showMessageDialog(this, "添加成功！！");
        } else {
            JOptionPane.showMessageDialog(this, "添加失败！！");
        }
    }

    //查询事件 得到要修改和删除的 主类和子类
    public void btnSel_actionPerformed(ActionEvent e) {
        String maincateid = txtMainCateId.getText();
        String sortid = txtSortId.getText();

        //验证主类编号必须为数字
        for (int i = 0; i < maincateid.length(); i++) {
            char mci = maincateid.charAt(i);
            if (!Character.isDigit(mci)) {
                JOptionPane.showMessageDialog(this, "主类编号必须为数字");
                return;
            }
        }
        //验证主类编号不能为空
        if (maincateid.equals("")) {
            JOptionPane.showMessageDialog(this, "主类编号不能为空");
            return;
        }
        //验证子类编号必须为数字
        for (int i = 0; i < sortid.length(); i++) {
            char si = sortid.charAt(i);
            if (!Character.isDigit(si)) {
                JOptionPane.showMessageDialog(this, "子类编号必须为数字");
                return;
            }
        }
        //验证子类编号不能为空
        if (sortid.equals("")) {
            JOptionPane.showMessageDialog(this, "子类编号不能为空");
            return;
        }
        //显示查询的信息
        String sql =
                "select * from category where cateid = '" + maincateid +
                "' and subcateid  = '" + sortid + "'";
     ArrayList arr = db.chaxun(sql, 4);

        if (arr.size() < 1) {
            JOptionPane.showMessageDialog(this, "未找到，请确认输入是否正确！");
            return;
        } else {
            txtMainCateName.setText(arr.get(1).toString());
            txtSortName.setText(arr.get(3).toString());

        }

    }

    //修改事件 修改子类和主类的名称
    public void btnMod_actionPerformed(ActionEvent e) {
        String maincateid = txtMainCateId.getText();
        String maincatename = txtMainCateName.getText();
        String sortid = txtSortId.getText();
        String sortname = txtSortName.getText();
        //验证主类编号必须为数字
        for (int i = 0; i < maincateid.length(); i++) {
            char mci = maincateid.charAt(i);
            if (!Character.isDigit(mci)) {
                JOptionPane.showMessageDialog(this, "主类编号必须为数字");
                return;
            }
        }
        //验证主类编号不能为空
        if (maincateid.equals("")) {
            JOptionPane.showMessageDialog(this, "主类编号不能为空");
            return;
        }
        //验证子类编号必须为数字
        for (int i = 0; i < sortid.length(); i++) {
            char si = sortid.charAt(i);
            if (!Character.isDigit(si)) {
                JOptionPane.showMessageDialog(this, "子类编号必须为数字");
                return;
            }
        }
        //验证子类编号不能为空
        if (sortid.equals("")) {
            JOptionPane.showMessageDialog(this, "子类编号不能为空");
            return;
        }
        String sql = "update category set catename = '" + maincatename +
                     "',subcatename='" + sortname + "' where cateid = '" +
                     maincateid +
                     "' and subcateid  = '" + sortid + "' ";
        System.out.println(sql);
        int num = -1;
        num = db.doUpdate(sql);
        if (num == 1) {
            JOptionPane.showMessageDialog(this, "修改成功！！");
        } else {
            JOptionPane.showMessageDialog(this, "修改失败！！");
        }
    }
    //删除事件 在表中删除子类和主类的名称
    public void btnDel_actionPerformed(ActionEvent e) {
        String maincateid = txtMainCateId.getText();
        String sortid = txtSortId.getText();
        //验证主类编号必须为数字
        for (int i = 0; i < maincateid.length(); i++) {
            char mci = maincateid.charAt(i);
            if (!Character.isDigit(mci)) {
                JOptionPane.showMessageDialog(this, "主类编号必须为数字");
                return;
            }
        }
        //验证主类编号不能为空
        if (maincateid.equals("")) {
            JOptionPane.showMessageDialog(this, "主类编号不能为空");
            return;
        }
        //验证子类编号必须为数字
        for (int i = 0; i < sortid.length(); i++) {
            char si = sortid.charAt(i);
            if (!Character.isDigit(si)) {
                JOptionPane.showMessageDialog(this, "子类编号必须为数字");
                return;
            }
        }
        //验证子类编号不能为空
        if (sortid.equals("")) {
            JOptionPane.showMessageDialog(this, "子类编号不能为空");
            return;
        }

        String sql = "delete from category  where cateid = '" +
                     maincateid +
                     "' and subcateid  = '" + sortid + "' ";
        int num = -1;
        num = db.doUpdate(sql);
        if (num == 1) {
            JOptionPane.showMessageDialog(this, "删除成功！！");
        } else {
            JOptionPane.showMessageDialog(this, "删除失败！！");
        }

    }
}


class AddCatePanel_btnDel_actionAdapter implements ActionListener {
    private AddCatePanel adaptee;
    AddCatePanel_btnDel_actionAdapter(AddCatePanel adaptee) {
        this.adaptee = adaptee;
    }

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


class AddCatePanel_btnMod_actionAdapter implements ActionListener {
    private AddCatePanel adaptee;
    AddCatePanel_btnMod_actionAdapter(AddCatePanel adaptee) {
        this.adaptee = adaptee;
    }

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


class AddCatePanel_btnSel_actionAdapter implements ActionListener {
    private AddCatePanel adaptee;
    AddCatePanel_btnSel_actionAdapter(AddCatePanel adaptee) {
        this.adaptee = adaptee;
    }

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


class AddCatePanel_btnAdd_actionAdapter implements ActionListener {
    private AddCatePanel adaptee;
    AddCatePanel_btnAdd_actionAdapter(AddCatePanel adaptee) {
        this.adaptee = adaptee;
    }

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