department_c.java

很好的Java绘图程序源代码

package project;


import javax.swing.JPanel;
import javax.swing.JList;
import java.awt.Rectangle;
import javax.swing.JScrollPane;
import java.awt.Dimension;
import javax.swing.*;
import java.awt.*;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JCheckBox;
import javax.swing.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.sql.*;
import java.util.ArrayList;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Department_C extends JPanel implements All_view{
    public Department_C(JFrame mainFrame) {
        this.mainFrame = mainFrame;
        try {
            jbInit();
            setList();
            setPanelPosOnDesktop(this.mainFrame);
        } catch (Exception exception) {
            exception.printStackTrace();
        }

    }

    private void jbInit() throws Exception {
        this.setBackground(SystemColor.control);
        this.setSize(new Dimension(800, 600));
        this.setLocation(200, 200);
        this.setLayout(null);

        departaddLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        departaddLabel.setText("添加部门名");
        departaddLabel.setBounds(new Rectangle(216, 82, 74, 24));
        departaddTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        departaddTextField.setText("");
        departaddTextField.setBounds(new Rectangle(320, 82, 131, 24));
        profeaddCheckBox.setBackground(SystemColor.control);
        profeaddCheckBox.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        profeaddCheckBox.setText("添加相关职位");
        profeaddCheckBox.setBounds(new Rectangle(216, 131, 152, 27));
        profeaddCheckBox.addChangeListener(new
                Department_C_profeaddCheckBox_changeAdapter(this));
        profeaddCheckBox.addMouseListener(new
                                          Department_C_profeaddCheckBox_mouseAdapter(this));
        professaddPanel.setBackground(SystemColor.control);
        professaddPanel.setBorder(titledBorder1);
        professaddPanel.setBounds(new Rectangle(217, 186, 516, 328));
        professaddPanel.setLayout(null);
        havedProfessLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        havedProfessLabel.setText("已有的职位名称");
        havedProfessLabel.setBounds(new Rectangle(15, 17, 116, 32));
        professhavedScrollPane.setBounds(new Rectangle(44, 52, 115, 150));
        newprefessLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        newprefessLabel1.setText("新添职位名1");
        newprefessLabel1.setBounds(new Rectangle(210, 70, 84, 29));
        newprofessLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        newprofessLabel2.setText("新添职位名2");
        newprofessLabel2.setBounds(new Rectangle(209, 119, 84, 29));
        newprofessLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        newprofessLabel3.setText("新添职位名3");
        newprofessLabel3.setBounds(new Rectangle(208, 167, 84, 29));
        nProfessTextField1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        nProfessTextField1.setText("");
        nProfessTextField1.setBounds(new Rectangle(314, 70, 122, 29));
        nProfessTextField2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        nProfessTextField2.setText("");
        nProfessTextField2.setBounds(new Rectangle(314, 119, 122, 29));
        nProfessTextField3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        nProfessTextField3.setText("");
        nProfessTextField3.setBounds(new Rectangle(314, 167, 122, 29));
        subButton.setBounds(new Rectangle(49, 276, 99, 31));
        subButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        subButton.setText("提交");
        subButton.addActionListener(new Department_C_subButton_actionAdapter(this));
        resetButton.setBounds(new Rectangle(191, 276, 99, 31));
        resetButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        resetButton.setText("重置");
        resetButton.addActionListener(new
                                      Department_C_resetButton_actionAdapter(this));
        clnButton.setBounds(new Rectangle(342, 276, 99, 31));
        clnButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        clnButton.setText("取消");
        clnButton.addActionListener(new Department_C_clnButton_actionAdapter(this));
        departScrollPane.setBounds(new Rectangle(40, 82, 150, 430));
        departList.setBackground(SystemColor.control);
        departList.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        profesdhavedList.setBackground(SystemColor.control);
        profesdhavedList.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        titleLabel.setFont(new java.awt.Font("Dialog", Font.BOLD, 40));
        titleLabel.setForeground(Color.blue);
        titleLabel.setText("部门新增");
        titleLabel.setBounds(new Rectangle(327, 17, 174, 51));
        this.add(professaddPanel);
        professaddPanel.add(havedProfessLabel);
        professaddPanel.add(professhavedScrollPane);
        professaddPanel.add(resetButton);
        professaddPanel.add(clnButton);
        professaddPanel.add(newprefessLabel1);
        professaddPanel.add(newprofessLabel2);
        professaddPanel.add(newprofessLabel3);
        professaddPanel.add(nProfessTextField3);
        professaddPanel.add(nProfessTextField2);
        professaddPanel.add(nProfessTextField1);
        professaddPanel.add(subButton);
        professhavedScrollPane.getViewport().add(profesdhavedList);
        this.add(departScrollPane);
        this.add(departaddLabel);
        this.add(departaddTextField);
        this.add(profeaddCheckBox);
        this.add(titleLabel);
        departScrollPane.getViewport().add(departList);
        //设置模块不被启用
        this.closeCom();
    }

    JLabel departaddLabel = new JLabel();
    JTextField departaddTextField = new JTextField();
    JCheckBox profeaddCheckBox = new JCheckBox();
    JPanel professaddPanel = new JPanel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JLabel havedProfessLabel = new JLabel();
    JScrollPane professhavedScrollPane = new JScrollPane();
    JList profesdhavedList = new JList();
    JLabel newprefessLabel1 = new JLabel();
    JLabel newprofessLabel2 = new JLabel();
    JLabel newprofessLabel3 = new JLabel();
    JTextField nProfessTextField1 = new JTextField();
    JTextField nProfessTextField2 = new JTextField();
    JTextField nProfessTextField3 = new JTextField();
    JButton subButton = new JButton();
    JButton resetButton = new JButton();
    JButton clnButton = new JButton();
    JFrame mainFrame = null;
    ResultSet deprs = null;
    ArrayList deplist = null;
    ResultSet prors = null;
    ArrayList prolist = null;
    DataBase db = new DataBase();
    JScrollPane departScrollPane = new JScrollPane();
    JList departList = new JList();
    String selDep = "select * from depart_table";
    String selPro = "select * from position_table";
    JLabel titleLabel = new JLabel();

    public void resetButton_actionPerformed(ActionEvent e) {
        cleanall();
        this.profeaddCheckBox.setSelected(false);
    }

    public void profeaddCheckBox_mouseClicked(MouseEvent e) {
        prolist = new ArrayList();
        if (profeaddCheckBox.isSelected()) {

            //查询出部门Id为-1的职称
            String sql2 = this.selPro + " where depart_id like '-1'";
            //保存结果集
            prors = db.executeQuery(sql2);
            try {
                while (prors.next()) {
                    prolist.add(prors.getString(2));
                }
           } catch (SQLException ex){
                ex.printStackTrace();
            }
            //将信加入到JList中
           this.profesdhavedList.setListData(prolist.toArray());

            //组件启用
            this.openCom();
        } else {
            //组件不启用
            this.closeCom();
        }
    }

    public void subButton_actionPerformed(ActionEvent e) {
        //3个新增职位名
        String proname1 = this.nProfessTextField1.getText();
        String proname2 = this.nProfessTextField2.getText();
        String proname3 = this.nProfessTextField3.getText();
        int num = 0;
        //新增部门名
        String departName = this.departaddTextField.getText();

        //判断新部门输入是否与数据库中信息重复
        for (int i = 0; i < deplist.size(); i++) {
            if (departName.equals(deplist.get(i).toString())) {
                num = -1;
                break;
            } else {
                num = 0;
            }
        }
        //判断输入的3个职位名称是否重复
        if (num == 0) {
            if (!proname1.equals("") && proname1.equals(proname2)) {
                num = -2;
            } else if (!proname2.equals("") && proname2.equals(proname3)) {
                num = -2;
            } else if (!proname3.equals("") && proname1.equals(proname3)) {
                num = -2;
            } else {
                num = 0;
            }
            //判断是否与数据库中的信息重复
            if (num == 0) {
                for (int j = 0; j < this.prolist.size(); j++) {
                    String str = this.prolist.get(j).toString();
                    if (proname1.equals(str)) {
                        num = -2;
                        break;
                    } else if (proname2.equals(str)) {
                        num = -2;
                        break;
                    } else if (proname3.equals(str)) {
                        num = -2;
                        break;
                    } else {
                        num = 0;
                    }
                }
                //当所有信息都不重复时,开始添加信息
                if (num == 0) {
                    int Dep_id = 0;

                    //建立DB对象，创建SQL语句（增加部门）
                    DataBase db = new DataBase();
                    String departAddSql = "insert into depart_table values('" +
                                          departName +
                                          "')";
                    num = db.executeUpdate(departAddSql);
                    ResultSet rs = null;
                    String sql = this.selDep + " where depart_name like '" +
                                 departName +
                                 "'";
                    rs = db.executeQuery(sql);
                    try {
                        while (rs.next()) {
                            Dep_id = rs.getInt(1);
                        }
                    } catch (SQLException ex) {
                        ex.printStackTrace();
                    }