updatadepartview.java

很好的Java绘图程序源代码

package project;

import java.awt.BorderLayout;

import javax.swing.JPanel;
import javax.swing.JScrollPane;
import java.awt.*;
import javax.swing.JList;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.sql.*;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;
import java.beans.PropertyChangeEvent;
import java.beans.PropertyChangeListener;
import java.beans.PropertyVetoException;
import java.beans.VetoableChangeListener;
import javax.swing.border.Border;
import javax.swing.border.TitledBorder;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c)  2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class UpdataDepartView extends JPanel implements All_view{
    public UpdataDepartView() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public UpdataDepartView(JFrame mainFrame) {
        this.mainFrame = mainFrame;
        try {
            jbInit();
            setList();
            setPanelPosOnDesktop(this.mainFrame);
        } catch (Exception exception) {
            exception.printStackTrace();
        }

    }

    private void jbInit() throws Exception {
        this.setLayout(null);
    this.setBackground(SystemColor.control);
    this.setToolTipText("");
        this.setSize(new Dimension(800, 600));
        departScrollPane.setBounds(new Rectangle(40, 82, 150, 430));
        departLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        departLabel.setText("原部门名");
        departLabel.setBounds(new Rectangle(298, 87, 80, 28));
        departTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        departTextField.setText("");
        departTextField.setBounds(new Rectangle(434, 85, 126, 28));
        newDepartLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        newDepartLabel.setText("新部门名");
        newDepartLabel.setBounds(new Rectangle(298, 131, 80, 28));
        nDepTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        nDepTextField.setText("");
        nDepTextField.setBounds(new Rectangle(434, 131, 126, 28));
        professPanel.setBackground(SystemColor.control);
        professPanel.setBorder(BorderFactory.createEtchedBorder());
        professPanel.setBounds(new Rectangle(223, 207, 523, 307));
        professPanel.setLayout(null);
        udproCheckBox.setBackground(SystemColor.control);
        udproCheckBox.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        udproCheckBox.setText("是否需要修改相关联的职位名称");
        udproCheckBox.setBounds(new Rectangle(225, 171, 248, 23));
        udproCheckBox.addChangeListener(new
                                        UpdataDepartView_addproCheckBox_changeAdapter(this));
        udproCheckBox.addMouseListener(new
                                       UpdataDepartView_addproCheckBox_mouseAdapter(this));
        proLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        proLabel.setText("与该部门相关的职位名称");
        proLabel.setBounds(new Rectangle(18, 13, 152, 24));
        proScrollPane.getViewport().setBackground(SystemColor.
                                                  inactiveCaptionText);
        proScrollPane.setBounds(new Rectangle(19, 49, 141, 153));
        proLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        proLabel1.setText("原职位名称");
        proLabel1.setBounds(new Rectangle(200, 97, 83, 22));
        nProLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        nProLabel.setText("新职位名称");
        nProLabel.setBounds(new Rectangle(200, 131, 83, 22));
        proTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        proTextField.setText("");
        proTextField.setBounds(new Rectangle(304, 97, 172, 22));
        nProTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        nProTextField.setText("");
        nProTextField.setBounds(new Rectangle(304, 131, 172, 22));
        resetButton.setBounds(new Rectangle(243, 239, 114, 32));
        resetButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        resetButton.setText("重置");
        resetButton.addActionListener(new
                                      UpdataDepartView_resetButton_actionAdapter(this));
        subButton.setBounds(new Rectangle(82, 239, 114, 32));
        subButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        subButton.setText("提交");
        subButton.addActionListener(new
                                    UpdataDepartView_subButton_actionAdapter(this));
        canButton.setBounds(new Rectangle(398, 239, 114, 32));
        canButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        canButton.setText("取消");
        canButton.addActionListener(new
                                    UpdataDepartView_canButton_actionAdapter(this));
        resetButton.addActionListener(new
                                      UpdataDepartView_resetButton_actionAdapter(this));
        departList.setBackground(SystemColor.control);
        departList.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        departList.addMouseListener(new
                                    UpdataDepartView_departList_mouseAdapter(this));
        proList.addMouseListener(new UpdataDepartView_proList_mouseAdapter(this));
        proList.setBackground(SystemColor.control);
        proList.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));
        onlyCheckBox.setBackground(SystemColor.control);
        onlyCheckBox.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        onlyCheckBox.setText("只修改该部门所相关的职位名称");
        onlyCheckBox.setBounds(new Rectangle(472, 171, 248, 23));
        onlyCheckBox.addMouseListener(new
                                      UpdataDepartView_onlyCheckBox_mouseAdapter(this));
        this.add(departScrollPane);
        professPanel.add(proLabel);
        professPanel.add(proScrollPane);
        professPanel.add(proLabel1);
        professPanel.add(nProLabel);
        professPanel.add(proTextField);
        professPanel.add(nProTextField);
        professPanel.add(subButton);
        professPanel.add(resetButton);
        professPanel.add(canButton);
        this.add(udproCheckBox);
        this.add(onlyCheckBox);
        this.add(titleLabel);
        this.add(newDepartLabel);
        this.add(departTextField);
        this.add(nDepTextField);
        this.add(departLabel);
        proScrollPane.getViewport().add(proList);

        this.add(professPanel);
        departScrollPane.getViewport().add(departList);
        this.closeCom();
    }

    JScrollPane departScrollPane = new JScrollPane();
    JList departList = new JList();
    JLabel departLabel = new JLabel();
    JTextField departTextField = new JTextField();
    JLabel newDepartLabel = new JLabel();
    JTextField nDepTextField = new JTextField();
    JPanel professPanel = new JPanel();
    JCheckBox udproCheckBox = new JCheckBox();
    JLabel proLabel = new JLabel();
    JScrollPane proScrollPane = new JScrollPane();
    JList proList = new JList();
    JLabel proLabel1 = new JLabel();
    JLabel nProLabel = new JLabel();
    JTextField proTextField = new JTextField();
    JTextField nProTextField = new JTextField();
    JButton resetButton = new JButton();
    JButton subButton = new JButton();
    JButton canButton = new JButton();
    JFrame mainFrame = new JFrame();
   ArrayList deplist = null;
    ResultSet deprs = null;
    ArrayList prolist = null;
    ResultSet prrs = null;
    DataBase db = new DataBase();
    String selDep = "select * from depart_table";
    String selPro = "select * from position_table";
    ResultSet rs = null;
    JLabel titleLabel = new JLabel();
    JCheckBox onlyCheckBox = new JCheckBox();
    int onlynum = 0;

    //取消键
    public void canButton_actionPerformed(ActionEvent e) {
        closeCurrentPanel(this.mainFrame);
    }

    //设置List内容
    public void setList() {
        deplist = new ArrayList();
        deprs = db.executeQuery(selDep);
        try {
            while (deprs.next()) {
                deplist.add(deprs.getString(2));
            }

            this.departList.setListData(deplist.toArray());
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        db.close();
    }

    public void setPanelPosOnDesktop(JFrame frame) {
      this.setLocation((((Frame1)frame).get_Container_width()- this.getSize().width) / 2,(((Frame1)frame).get_Container_height() - this.getSize().height) / 2);
    }

    public void closeCurrentPanel(JFrame frame) {

      ((Frame1)frame).remove_panel();

    }

    public void set_focus() {
      departList.updateUI();

    }

    public void requestFocus(){
      set_focus();
  }


    //重置键
    public void resetButton_actionPerformed(ActionEvent e) {
        this.cleanall();
        this.udproCheckBox.setSelected(false);
    }

    //选项栏点击事件
    public void addproCheckBox_mouseClicked(MouseEvent e) {
        prolist = new ArrayList();
        String depart_name = this.departTextField.getText();
        int depart_id = 0;

        if (this.udproCheckBox.isSelected()) {
            String sql = this.selDep + " where depart_Name like '" +
                         depart_name + "'";
            this.rs = db.executeQuery(sql);

            try {
                while (rs.next()) {
                    depart_id = rs.getInt(1);
                }
            } catch (SQLException ex) {
                ex.printStackTrace();
            }

            String sql2 = this.selPro + " where depart_id = " + depart_id;
            ResultSet rs = db.executeQuery(sql2);
            try {
                while (rs.next()) {
                    this.prolist.add(rs.getString(2));
                }
                this.proList.setListData(prolist.toArray());
            } catch (SQLException ex1) {
                ex1.printStackTrace();
            }
            //开启组件
            this.openCom();
        } else {
            //关闭组件
            this.closeCom();
        }
    }

    //departList点击事件
    public void departList_mouseClicked(MouseEvent e) {
        String old_name = String.valueOf(this.departList.getSelectedValue());
        this.departTextField.setText(old_name);
        this.udproCheckBox.setSelected(false);
    }

    //开启组件
    private void openCom() {
        this.proList.setEnabled(true);
        this.proTextField.setEditable(true);
        this.nProTextField.setEditable(true);
    }

    //关闭组件
    private void closeCom() {
        this.proList.setEnabled(false);
        this.proTextField.setEditable(false);
        this.nProTextField.setEditable(false);
    }

    //清屏
    private void cleanall() {
        this.nDepTextField.setText("");
        this.proTextField.setText("");
        this.nProTextField.setText("");
        this.departTextField.setText("");