delectdepartview.java

很好的Java绘图程序源代码

package project;

import java.awt.BorderLayout;

import javax.swing.JPanel;
import java.awt.Dimension;
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.sql.*;
import java.util.*;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
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 DelectDepartView extends JPanel implements All_view{
    BorderLayout borderLayout1 = new BorderLayout();
    JScrollPane departScrollPane = new JScrollPane();
    JList departList = new JList();
    JLabel departLabel = new JLabel();
    JTextField departTextField = new JTextField();
    JPanel addproPanel = new JPanel();
    JCheckBox delproCheckBox = new JCheckBox();
    JLabel proLabel = new JLabel();
    JScrollPane proScrollPane = new JScrollPane();
    JList proList = new JList();
    JButton subButton = new JButton();
    JButton resetButton = new JButton();
    JButton cancelButton = new JButton();
    JFrame mainFrame = new JFrame();
    ArrayList deplist = null;
    ResultSet deprs = null;
    ArrayList prolist = null;
    ResultSet prors = null;
    DataBase db = new DataBase();
    JCheckBox delAllCheckBox = new JCheckBox();
    JLabel tellULabel = new JLabel();
    JLabel titleLabel = new JLabel();
    int depart_id = 0;
    public DelectDepartView() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public DelectDepartView(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.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(312, 82, 156, 30));
        departTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        departTextField.setText("");
        departTextField.setBounds(new Rectangle(504, 82, 138, 30));
        addproPanel.setBackground(SystemColor.control);
        addproPanel.setBorder(BorderFactory.createEtchedBorder());
        addproPanel.setBounds(new Rectangle(225, 179, 545, 334));
        addproPanel.setLayout(null);
        delproCheckBox.setBackground(SystemColor.control);
        delproCheckBox.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        delproCheckBox.setText("察看将被注销的相关职位名称");
        delproCheckBox.setBounds(new Rectangle(226, 144, 351, 29));
        delproCheckBox.addChangeListener(new
                                         DelectDepartView_delproCheckBox_changeAdapter(this));
        delproCheckBox.addMouseListener(new
                                        DelectDepartView_delproCheckBox_mouseAdapter(this));
        proLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        proLabel.setText("将被注销部门所相关的职位名称");
        proLabel.setBounds(new Rectangle(18, 14, 184, 27));
        proScrollPane.setBounds(new Rectangle(18, 60, 161, 177));
        subButton.setBounds(new Rectangle(71, 278, 113, 31));
        subButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        subButton.setAction(null);
        subButton.setText("提交");
        subButton.addActionListener(new
                                    DelectDepartView_subButton_actionAdapter(this));
        resetButton.setBounds(new Rectangle(230, 278, 113, 31));
        resetButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        resetButton.setText("重置");
        resetButton.addActionListener(new
                                      DelectDepartView_resetButton_actionAdapter(this));
        cancelButton.setBounds(new Rectangle(389, 278, 113, 31));
        cancelButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        cancelButton.setText("取消");
        cancelButton.addActionListener(new
                                       DelectDepartView_cancelButton_actionAdapter(this));
        departList.setBackground(SystemColor.control);
        departList.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        departList.addMouseListener(new
                                    DelectDepartView_departList_mouseAdapter(this));
        proList.setBackground(SystemColor.control);
        proList.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        delAllCheckBox.setBackground(SystemColor.control);
        delAllCheckBox.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        delAllCheckBox.setSelected(true);
        delAllCheckBox.setText("删除所有与该部门相关的职位信息");
        delAllCheckBox.setBounds(new Rectangle(214, 130, 251, 34));
        tellULabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        tellULabel.setForeground(Color.red);
        tellULabel.setText("注:如果注销部门将连带注销部门所相关的职位信息!");
        tellULabel.setBounds(new Rectangle(312, 116, 320, 30));
        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(departScrollPane);
        this.add(addproPanel);
        addproPanel.add(proLabel);
        addproPanel.add(proScrollPane);
        addproPanel.add(delAllCheckBox);
        addproPanel.add(subButton);
        addproPanel.add(resetButton);
        addproPanel.add(cancelButton);
        proScrollPane.getViewport().add(proList);
        this.add(delproCheckBox);
        this.add(titleLabel);
        this.add(departLabel);
        this.add(tellULabel);
        this.add(departTextField);
        departScrollPane.getViewport().add(departList);
        this.closeCom();
    }
    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 cancelButton_actionPerformed(ActionEvent e) {
        closeCurrentPanel(this.mainFrame);
    }

    public void setList() {
        deplist = new ArrayList();
        String sql = "select * from depart_table";
        deprs = db.executeQuery(sql);
        try {
            while (deprs.next()) {
                deplist.add(deprs.getString(2));
            }

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

    }

    public void resetButton_actionPerformed(ActionEvent e) {
        this.departTextField.setText("");
        this.delproCheckBox.setSelected(false);
    }

    public void departList_mouseClicked(MouseEvent e) {
        String depart_name = this.departList.getSelectedValue().toString();
        this.departTextField.setText(depart_name);
        this.delproCheckBox.setSelected(false);
    }


    public void delproCheckBox_mouseClicked(MouseEvent e) {
        prolist = new ArrayList();
        if (this.delproCheckBox.isSelected()){
          String depart_name = this.departTextField.getText();
            int num = 0;
            depart_id = 0;
            if (depart_name.equals("")) {
                num = -1;
            } else {
                num = 0;
                String sql =
                        "select * from depart_table where depart_name like '" +