尝试的第一个开发项目-小型公司工资管理

项目代码及其相关配置文件链接:https://pan.baidu.com/s/1smZS4OX 密码:c37f

一,功能

(1)用户登录注册

(2)人员基本信息的增删改查和统计部门人数以及总人数

(3)工资信息的增删改查和统计部门工资以及总工资

二,工具

(1)java编程:Eclipse Java EE IDE

(2)数据库:SQL Server2008 R2

(3)jdbc:sqljdbc4.jar

三,效果展示

(1)注册

(2)登录


(3)主界面


(4)查找


四,包结构


五,数据库设计

(1)表结构


(2)各表字段

1>BaseInfo_Table表


2>Password_Table表


3>Manager表


4>SalesManager表


5>Technician表


6>Salesperson表


六,系统UML图介绍

(1)用例图


(2)注册类图


(3)注册时序图


七,系统数据流程图


八,主要操作代码

package info;



import java.awt.BorderLayout;



public class Info2 extends JFrame {

	/**
	 * 
	 */
	private static final long serialVersionUID = -1207187762843890725L;
	private JMenuBar jBar;
	private JMenu jMenu1,jMenu2,jMenu3,jMenu4,jMenu5,jMenu_introduce;
	private JMenuItem jMenuItem1,jMenuItem2,jMenuItem3,jMenuItem4,jMenuItem6,jMenuItem7,jMenuItem8,jMenuItem9,jmenuItem_introduce;
	private JPanel contentPane;
	private JPanel panel_1,panel_1_0,panel_2,panel_2_0,panel_3,panel_4,panel_4_0,panel_5,panel_5_0,panel_6,panel_7;
	private CardLayout cardLayout,cLayout;
	private JButton btn_confirm,btn_cancel;
	private JLabel label_id,label_sex,label_name,label_birthday,label_phone;
	private JTextField textField_id,textField_name,textField_birthday,textField_phone;//输入文本框
	private JLabel label_id_hint,label_birthday_hint,label_sex_hint,label_name_hint;//提示信息标签
	private JLabel label_addBasePanel_hint,label_addSalaryPanel_hint;//面板区分信息标签
	private JComboBox<String> comboBox_admin,comboBox_2,comboBox_sex,comboBox_count,comboBox_id_Salary;
	private JLabel label_deleteBasePanel_hint;
	private JLabel label_15;
	private JLabel lblNewLabel_3;
	private JLabel label_16;
	private JLabel label_17;
	private JLabel lblNewLabel_4;
	private JTextField textField_8;
	private JButton btn_both,btn_strictfp,btn_clear;//全部查询,精确查询
	private JScrollPane scrollPane;
	private JTable select_table;
	private Object[][] empty= new Object[100][6],all_Data=new Object[100][6],sec_Data = new Object[100][6],delete_old_data=new Object[1][6];
	private Object[][] repairBase_old=new Object[1][6],select_salary_strictfp=new Object[100][7];
	private Object[][] repairSalary_old=new Object[1][7],selectSalary=new Object[100][7],selectEmpty=new Object[100][7];
	private Boolean bool=null;//性别的布尔值
	private JTextField textField_deleteBase;
	private JTable table_delete_repair;
	private JLabel label_repair;
	private JTextField textField_repairBase;
	private JTable table_repairBase_old;
	private JLabel label_5;
	private JTextField textField_select_identity;
	private JButton button_select_strictfp;
	private JButton button_select_both;
	private JScrollPane scrollPane_1,scrollPane_repairBase_old,scrollPane_repairSalary_old;
	private JTable table_select_Salary;
	private JButton button_wipe;
	private JTextField textField_addSalary;
	private JPanel panel_base;
	private JPanel panel_00,panel_01,panel_02,panel_03,panel_04;
	private JLabel label_1;
	private JTextField textField_Manager;
	private JLabel label_6;
	private JTextField textField_Technician_hourRate;
	private JLabel label_7;
	private JTextField textField_Technician_workHours;
	private JLabel label_8;
	private JTextField textField_SalesManager_BasePay;
	private JLabel label_9;
	private JTextField textField_SalesManager_pushMoney;
	private JLabel label_10;
	private JLabel label_11;
	private JTextField textField_SalesManager_sales;
	private JLabel label_12;
	private JTextField textField_Salesperson_sales;
	private JLabel label_13;
	private JTextField textField_Salesperson_pushMoney;
	private JLabel label_18;
	private JButton button_Manager_add;
	private JButton button_Technician_add;
	private JButton button_SalesManager_add;
	private JButton button_Salesperson_add;
	private JLabel label_19;
	private JButton button_addSalary_confirm;
	private JButton button_addSalary_canel;
	private JButton button_delete;
	private JButton button_delCanel;
	private JButton button_repairBase_confirm,button_repairBase_cancel;//修改基本信息的查找确认、查找取消、修改确认按钮
	private JButton button_repair_confirm,button_repair_canel;//修改工资信息的确认和取消按钮
	private JTextField textField_repairSalary;
	private JLabel lblNewLabel_1;
	private JTable table_repairSalary_old;
	private String number;
	private JLabel label_3;
	private JMenu jmenu6;
	private JMenuItem menuItem_countPeople;
	private JLabel label_20;
	private JLabel label_23;
	private JTextField textField_manager_countPeople;
	private JTextField textField_SalesManager_countPeople;
	private JTextField textField_Technician_countPeople;
	private JTextField textField_Salesperson_countPeople;
	private JLabel label_25;
	private JTextField textField_both_countPeople;
	private JLabel label_26;
	private JButton button_countSalary;
	private JLabel label_27;
	private JTextField textField_Manage_Salary;
	private JLabel label_28;
	private JTextField textField_SalesManager_Salary;
	private JLabel label_29;
	private JTextField textField_Technician_Salary;
	private JLabel label_30;
	private JTextField textField_Salesperson_Salary;
	private JLabel label_31;
	private JTextField textField_bothSalary;
	private JButton button_wipe_SalaryCount;
	/**
	 * Launch the application.
	 */
	/**
	 * Create the frame.
	 */
	public Info2() {
		setResizable(false);
		setTitle("操作窗口");
		jBar=new JMenuBar();
		jMenu1=new JMenu("基本数据维护");
		jMenu_introduce=new JMenu("系统介绍");
		jMenu_introduce.setIcon(new ImageIcon(Info2.class.getResource("/images/bookTypeManager.png")));
		jMenu1.setIcon(new ImageIcon(Info2.class.getResource("/images/base.png")));
		jMenuItem1=new JMenuItem("关于我们");
		jMenuItem1.setIcon(new ImageIcon(Info2.class.getResource("/images/about.png")));
		jMenu2=new JMenu("增加");
		jMenu2.setIcon(new ImageIcon(Info2.class.getResource("/images/add.png")));
		jMenu3=new JMenu("删除");
		jMenu3.setIcon(new ImageIcon(Info2.class.getResource("/images/delete.png")));
		jMenu4=new JMenu("修改");
		jMenu4.setIcon(new ImageIcon(Info2.class.getResource("/images/modify.png")));
		jMenu5=new JMenu("查找");
		jMenu5.setIcon(new ImageIcon(Info2.class.getResource("/images/search.png")));
		jMenuItem2=new JMenuItem("基本信息");
		jMenuItem3=new JMenuItem("工资信息");
		jMenuItem4=new JMenuItem("基本和工资信息");
		jMenuItem6=new JMenuItem("基本信息");
		jMenuItem7=new JMenuItem("工资信息");
		jMenuItem8=new JMenuItem("基本信息");
		jMenuItem9=new JMenuItem("工资信息");
		jBar.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenu1.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenuItem1.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenu2.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenu3.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenu4.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenu5.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenu_introduce.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenuItem2.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenuItem3.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenuItem4.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenuItem6.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenuItem7.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenuItem8.setFont(new Font("宋体", Font.PLAIN, 12));
		jMenuItem9.setFont(new Font("宋体", Font.PLAIN, 12));
		setJMenuBar(jBar);
		jBar.add(jMenu1);
		
		jmenuItem_introduce = new JMenuItem("\u7CFB\u7EDF\u7B80\u4ECB");
		jmenuItem_introduce.setIcon(new ImageIcon(Info2.class.getResource("/images/me.png")));
		jmenuItem_introduce.setFont(new Font("宋体", Font.PLAIN, 12));
		jBar.add(jMenu_introduce);
		jMenu_introduce.add(jmenuItem_introduce);
		jMenu_introduce.add(jMenuItem1);
		jMenu1.add(jMenu2);//增
		//jMenu1.addSeparator();//添加分割线
		jMenu1.add(jMenu3);//删
		jMenu1.add(jMenu4);//改
		jMenu1.add(jMenu5);//查
		jMenu2.add(jMenuItem2);//增加基本信息
		jMenu2.add(jMenuItem3);//增加工资信息
		jMenu3.add(jMenuItem4);//删除基本信息
		jMenu4.add(jMenuItem6);//修改基本信息
		jMenu4.add(jMenuItem7);//修改工资信息
		jMenu5.add(jMenuItem8);//查找基本信息
		jMenu5.add(jMenuItem9);//查找工资信息
		
		jmenu6 = new JMenu("\u7EDF\u8BA1");//统计
		jmenu6.setFont(new Font("宋体", Font.PLAIN, 12));
		jmenu6.setIcon(new ImageIcon(Info2.class.getResource("/images/bookManager.png")));
		jMenu1.add(jmenu6);
		
		menuItem_countPeople = new JMenuItem("\u7EDF\u8BA1\u90E8\u95E8\u4EBA\u6570");
		menuItem_countPeople.setFont(new Font("宋体", Font.PLAIN, 12));
		jmenu6.add(menuItem_countPeople);
		
		JMenuItem menuItem_countSalary = new JMenuItem("\u7EDF\u8BA1\u90E8\u95E8\u603B\u5DE5\u8D44");
		menuItem_countSalary.setFont(new Font("宋体", Font.PLAIN, 12));
		jmenu6.add(menuItem_countSalary);
		
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 635, 358);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(new BorderLayout(0, 0));//创建为水平间隙和垂直间隙都为0的边界式布局
		
		panel_1 = new JPanel();//卡片式布局的基层
		contentPane.add(panel_1, BorderLayout.CENTER);//中间容器为边界式布局
		cardLayout=new CardLayout(0, 0);//创建为水平间隙和垂直间隙都为0的卡片式布局
		panel_1.setLayout(cardLayout);//卡片式布局
		
		ImageIcon bg=new ImageIcon(Info2.class.getResource("/images/巧办网_商务合作banner背景模板PSD分层.png"));
		JLabel jLabel_bg=new JLabel(bg);
		jLabel_bg.setSize(bg.getIconWidth(),bg.getIconHeight());
		JPanel jPanel=new JPanel();
		jPanel=(JPanel)this.getContentPane();
		jPanel.setOpaque(false);
		getLayeredPane().add(jLabel_bg,new Integer(Integer.MIN_VALUE));
		panel_1_0=new JPanel();//主页面板
		panel_1_0.setLayout(null);
		panel_1_0.setOpaque(false);
		panel_1.add(panel_1_0);
		panel_1.setOpaque(false);
		
		label_3 = new JLabel("\u5C0F\u578B\u516C\u53F8\u5DE5\u8D44\u7BA1\u7406\u7CFB\u7EDF",JLabel.CENTER);
		label_3.setFont(new Font("宋体", Font.BOLD | Font.ITALIC, 30));
		label_3.setForeground(Color.GRAY);
		label_3.setBackground(Color.WHITE);
		label_3.setBounds(0, 0, 619, 47);
		panel_1_0.add(label_3);
		
		/*增加模块                                */		
		panel_2 = new JPanel();//增加基本信息面板
		panel_2_0=new JPanel();//增加工资信息面板
		panel_2.setLayout(null);
		panel_2_0.setLayout(null);
		panel_1.add(panel_2, "增加基本");
		panel_1.add(panel_2_0,"增加工资");
		
		label_id= new JLabel("职工编号");
		label_id.setBounds(83, 30, 60, 15);
		panel_2.add(label_id);
		
		label_name= new JLabel("\u59D3    \u540D");
		label_name.setBounds(83, 65, 60, 21);
		panel_2.add(label_name);
		
		label_sex=new JLabel("\u6027    \u522B");
		label_sex.setBounds(83, 100, 54, 15);
		panel_2.add(label_sex);
		
		label_birthday= new JLabel("出生日期");
		label_birthday.setBounds(83, 140, 54, 15);
		panel_2.add(label_birthday);
		
		label_phone = new JLabel("联系电话");
		label_phone.setBounds(83, 170, 54, 15);
		panel_2.add(label_phone);
		
		textField_id= new JTextField();//职工编号文本框
		textField_id.setBounds(166, 30, 196, 21);
		panel_2.add(textField_id);
		textField_id.setColumns(10);
		
		textField_name = new JTextField();//姓名信息输入文本框
		textField_name.setBounds(166, 65, 196, 21);
		panel_2.add(textField_name);
		textField_name.setColumns(10);
		
		comboBox_sex=new JComboBox<String>();//性别信息选择框
		comboBox_sex.setModel(new DefaultComboBoxModel<String>(new String[] {"请选择性别","男", "女"}));
		comboBox_sex.setBounds(166, 100, 196, 21);
		panel_2.add(comboBox_sex);
		
		textField_birthday= new JTextField();//出生日期输入文本框
		textField_birthday.setBounds(166, 137, 196, 21);
		panel_2.add(textField_birthday);
		textField_birthday.setColumns(10);
		
		textField_phone= new JTextField();//联系电话输入文本框
		textField_phone.setBounds(166, 170, 196, 21);
		panel_2.add(textField_phone);
		textField_phone.setColumns(10);
		
		label_id_hint= new JLabel("*必填*");//职工编号提示标签
		label_id_hint.setBounds(396, 30, 54, 15);
		label_id_hint.setForeground(Color.RED);
		label_id_hint.setFont(new Font("宋体",Font.PLAIN,14));
		panel_2.add(label_id_hint);
		
		label_name_hint= new JLabel("*必填*");//姓名信息提示标签
		label_name_hint.setBounds(396, 65, 54, 15);
		label_name_hint.setForeground(Color.RED);
		label_name_hint.setFont(new Font("宋体",Font.PLAIN,14));
		panel_2.add(label_name_hint);
		
		label_sex_hint=new JLabel("*必填*");//性别信息提示标签
		label_sex_hint.setBounds(396,100, 54, 15);
		label_sex_hint.setForeground(Color.RED);
		label_sex_hint.setFont(new Font("宋体",Font.PLAIN,14));
		panel_2.add(label_sex_hint);
		
		label_birthday_hint=new JLabel("*不为空且格式为(xxxx-xx-xx)*");//出生日期信息提示标签
		label_birthday_hint.setBounds(396,137, 200, 15);
		label_birthday_hint.setForeground(Color.RED);
		label_birthday_hint.setFont(new Font("宋体",Font.PLAIN,14));
		panel_2.add(label_birthday_hint);
		
		comboBox_admin= new JComboBox<String>();//增加基本信息的身份选择
		comboBox_admin.setModel(new DefaultComboBoxModel<String>(new String[] {"请选择身份···", "经理", "销售经理","技术人员","销售人员"}));
		comboBox_admin.setBounds(166, 210, 108, 21);
		panel_2.add(comboBox_admin);
		
		btn_confirm=new JButton("\u589E\u52A0");//确认添加基本信息
		btn_confirm.setIcon(new ImageIcon(Info2.class.getResource("/images/add.png")));
		btn_confirm.setBounds(166,245,95,25);
		panel_2.add(btn_confirm);
		
		btn_cancel=new JButton("取消");//清空文本输入框基本信息
		btn_cancel.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		btn_cancel.setBounds(270,245,95,25);
		panel_2.add(btn_cancel);
		
		label_addBasePanel_hint= new JLabel("增加基本信息");//面板区分提示信息
		label_addBasePanel_hint.setBounds(508, 0, 82, 15);
		panel_2.add(label_addBasePanel_hint);
		
		label_addSalaryPanel_hint= new JLabel("增加工资信息");//面板区分提示信息
		label_addSalaryPanel_hint.setBounds(508, 0, 82, 15);
		panel_2_0.add(label_addSalaryPanel_hint);
		
		JLabel label = new JLabel("\u8BF7\u8F93\u5165\u9700\u8981\u6DFB\u52A0\u5DE5\u8D44\u4FE1\u606F\u7684\u804C\u5DE5\u7F16\u53F7");
		label.setBounds(10, 25, 198, 21);
		panel_2_0.add(label);
		
		textField_addSalary = new JTextField();
		textField_addSalary.setBounds(218, 25, 170, 21);
		panel_2_0.add(textField_addSalary);
		textField_addSalary.setColumns(10);
		
		button_addSalary_confirm = new JButton("\u6DFB\u52A0");
		button_addSalary_confirm.setIcon(new ImageIcon(Info2.class.getResource("/images/add.png")));
		button_addSalary_confirm.setBounds(398, 24, 93, 23);
		panel_2_0.add(button_addSalary_confirm);
		
		panel_base = new JPanel();
		panel_base.setBounds(39, 77, 542, 187);
		panel_2_0.add(panel_base);
		cLayout=new CardLayout(0, 0);
		panel_base.setLayout(cLayout);
		
		panel_00 = new JPanel();
		panel_base.add(panel_00, "提示");
		panel_00.setLayout(null);
		
		label_19 = new JLabel("\u5DE5\u8D44\u4FE1\u606F\u8F93\u5165\u9762\u677F");
		label_19.setBounds(212, 78, 116, 15);
		panel_00.add(label_19);
		
		panel_01 = new JPanel();
		panel_base.add(panel_01, "经理");
		panel_01.setLayout(null);
		
		label_1 = new JLabel("\u5DE5\u8D44");
		label_1.setBounds(55, 30, 60, 21);
		panel_01.add(label_1);
		
		textField_Manager = new JTextField();
		textField_Manager.setBounds(125, 30, 133, 21);
		panel_01.add(textField_Manager);
		textField_Manager.setColumns(10);
		
		button_Manager_add = new JButton("\u6DFB\u52A0");
		button_Manager_add.setIcon(new ImageIcon(Info2.class.getResource("/images/add.png")));
		button_Manager_add.setBounds(55, 129, 93, 23);
		panel_01.add(button_Manager_add);
		
		panel_02 = new JPanel();
		panel_base.add(panel_02, "技术人员");
		panel_02.setLayout(null);
		
		label_6 = new JLabel("\u6BCF\u5C0F\u65F6\u916C\u91D1");
		label_6.setBounds(56, 31, 88, 15);
		panel_02.add(label_6);
		
		textField_Technician_hourRate = new JTextField();
		textField_Technician_hourRate.setBounds(181, 28, 155, 21);
		panel_02.add(textField_Technician_hourRate);
		textField_Technician_hourRate.setColumns(10);
		
		label_7 = new JLabel("\u5DE5\u4F5C\u65F6\u6570");
		label_7.setBounds(56, 76, 54, 15);
		panel_02.add(label_7);
		
		textField_Technician_workHours = new JTextField();
		textField_Technician_workHours.setBounds(181, 73, 155, 21);
		panel_02.add(textField_Technician_workHours);
		textField_Technician_workHours.setColumns(10);
		
		button_Technician_add = new JButton("\u6DFB\u52A0");
		button_Technician_add.setIcon(new ImageIcon(Info2.class.getResource("/images/add.png")));
		button_Technician_add.setBounds(56, 143, 93, 23);
		panel_02.add(button_Technician_add);
		
		panel_03 = new JPanel();
		panel_base.add(panel_03, "销售经理");
		panel_03.setLayout(null);
		
		panel_04 = new JPanel();
		panel_base.add(panel_04, "销售人员");
		panel_04.setLayout(null);
		
		label_12 = new JLabel("\u9500\u552E\u989D");
		label_12.setBounds(69, 39, 54, 15);
		panel_04.add(label_12);
		
		textField_Salesperson_sales = new JTextField();
		textField_Salesperson_sales.setBounds(146, 36, 170, 21);
		panel_04.add(textField_Salesperson_sales);
		textField_Salesperson_sales.setColumns(10);
		
		label_13 = new JLabel("\u63D0\u6210");
		label_13.setBounds(69, 88, 54, 15);
		panel_04.add(label_13);
		
		textField_Salesperson_pushMoney = new JTextField();
		textField_Salesperson_pushMoney.setBounds(146, 85, 170, 21);
		panel_04.add(textField_Salesperson_pushMoney);
		textField_Salesperson_pushMoney.setColumns(10);
		
		label_18 = new JLabel("0~1\u4E4B\u95F4");
		label_18.setForeground(Color.RED);
		label_18.setBounds(354, 85, 54, 21);
		panel_04.add(label_18);
		
		button_Salesperson_add = new JButton("\u6DFB\u52A0");
		button_Salesperson_add.setIcon(new ImageIcon(Info2.class.getResource("/images/add.png")));
		button_Salesperson_add.setBounds(69, 140, 93, 23);
		panel_04.add(button_Salesperson_add);
		
		label_8 = new JLabel("\u57FA\u672C\u5DE5\u8D44");
		label_8.setBounds(69, 35, 54, 18);
		panel_03.add(label_8);
		
		textField_SalesManager_BasePay = new JTextField();
		textField_SalesManager_BasePay.setBounds(153, 35, 161, 21);
		panel_03.add(textField_SalesManager_BasePay);
		textField_SalesManager_BasePay.setColumns(10);
		
		label_9 = new JLabel("\u63D0   \u6210");
		label_9.setBounds(69, 77, 54, 15);
		panel_03.add(label_9);
		
		textField_SalesManager_pushMoney = new JTextField();
		textField_SalesManager_pushMoney.setBounds(153, 74, 161, 21);
		panel_03.add(textField_SalesManager_pushMoney);
		textField_SalesManager_pushMoney.setColumns(10);
		
		label_10 = new JLabel("0~1\u4E4B\u95F4");
		label_10.setForeground(Color.RED);
		label_10.setBounds(356, 74, 54, 21);
		panel_03.add(label_10);
		
		label_11 = new JLabel("\u9500\u552E\u989D");
		label_11.setBounds(69, 118, 54, 15);
		panel_03.add(label_11);
		
		textField_SalesManager_sales = new JTextField();
		textField_SalesManager_sales.setBounds(153, 115, 161, 21);
		panel_03.add(textField_SalesManager_sales);
		textField_SalesManager_sales.setColumns(10);
		
		button_SalesManager_add = new JButton("\u6DFB\u52A0");
		button_SalesManager_add.setIcon(new ImageIcon(Info2.class.getResource("/images/add.png")));
		button_SalesManager_add.setBounds(69, 154, 93, 23);
		panel_03.add(button_SalesManager_add);
		
		button_addSalary_canel = new JButton("\u53D6\u6D88");
		button_addSalary_canel.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		button_addSalary_canel.setBounds(501, 24, 93, 23);
		panel_2_0.add(button_addSalary_canel);
		
		
		
		/*     删除模块        */
		panel_3=new JPanel();
		panel_3.setLayout(null);
		panel_1.add(panel_3,"删除基本");
		
		label_deleteBasePanel_hint = new JLabel("\u5220\u9664\u804C\u5DE5\u4FE1\u606F");
		label_deleteBasePanel_hint.setBounds(524, 0, 85, 15);
		panel_3.add(label_deleteBasePanel_hint);
		
		JLabel label_delete = new JLabel("\u8BF7\u8F93\u5165\u9700\u8981\u5220\u9664\u7684\u804C\u5DE5\u7F16\u53F7:");
		label_delete.setBounds(22, 38, 163, 21);
		panel_3.add(label_delete);
		
		textField_deleteBase =new JTextField();
		textField_deleteBase.setBounds(195, 38, 143, 21);
		panel_3.add(textField_deleteBase);
		textField_deleteBase.setColumns(10);
		
		final JScrollPane scrollPane_delete_old = new JScrollPane();
		scrollPane_delete_old.setBounds(22, 185, 440, 50);
		panel_3.add(scrollPane_delete_old);
		
		final String[] columnNames_delete = {"职工编号","姓名","性别","出生年月","联系电话","职位"}; //列名
		table_delete_repair = new JTable(delete_old_data,columnNames_delete);
		table_delete_repair.setEnabled(false);//禁止写入
		table_delete_repair.getTableHeader().setReorderingAllowed(false);
		table_delete_repair.setRowHeight(25);//以像素为单位的行高
		scrollPane_delete_old.setViewportView(table_delete_repair);
		
		JLabel lblOldData = new JLabel("Delete data");
		lblOldData.setFont(new Font("幼圆", Font.BOLD, 30));
		lblOldData.setBounds(151, 125, 187, 37);
		panel_3.add(lblOldData);
		
		button_delete = new JButton("\u5220\u9664");
		button_delete.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
			}
		});
		button_delete.setIcon(new ImageIcon(Info2.class.getResource("/images/delete.png")));
		button_delete.setBounds(348, 37, 84, 23);
		panel_3.add(button_delete);
		
		button_delCanel = new JButton("\u53D6\u6D88");
		button_delCanel.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		button_delCanel.setBounds(442, 37, 84, 23);
		panel_3.add(button_delCanel);
		
		/*           修改模块                         */
		panel_4=new JPanel();
		panel_4_0=new JPanel();
		panel_4.setLayout(null);
		panel_4_0.setLayout(null);
		panel_1.add(panel_4,"修改基本");
		
		label_15 = new JLabel("修改基本信息");
		label_15.setBounds(506, 0, 84, 15);
		panel_4.add(label_15);
		
		label_repair = new JLabel("\u8BF7\u8F93\u5165\u9700\u8981\u4FEE\u6539\u7684\u804C\u5DE5\u7F16\u53F7\uFF1A");
		label_repair.setFont(new Font("宋体", Font.ITALIC, 14));
		label_repair.setBounds(44, 25, 186, 21);
		panel_4.add(label_repair);
		
		textField_repairBase = new JTextField();
		textField_repairBase.setBounds(240, 25, 131, 21);
		panel_4.add(textField_repairBase);
		textField_repairBase.setColumns(10);
		
		button_repairBase_confirm = new JButton("\u4FEE\u6539");
		button_repairBase_confirm.setIcon(new ImageIcon(Info2.class.getResource("/images/modify.png")));
		button_repairBase_confirm.setBounds(381, 24, 93, 23);
		panel_4.add(button_repairBase_confirm);
		
		button_repairBase_cancel = new JButton("\u53D6\u6D88");
		button_repairBase_cancel.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		button_repairBase_cancel.setBounds(484, 25, 93, 23);
		panel_4.add(button_repairBase_cancel);
		
		JLabel lblNewLabel = new JLabel("old Data");
		lblNewLabel.setFont(new Font("幼圆", Font.BOLD, 22));
		lblNewLabel.setBounds(200, 125, 119, 21);
		panel_4.add(lblNewLabel);
		
		scrollPane_repairBase_old = new JScrollPane();
		scrollPane_repairBase_old.setBounds(44, 156, 430, 48);
		panel_4.add(scrollPane_repairBase_old);
		
		final String[] columnNames_repairBase_old= {"职工编号","姓名","性别","出生年月","联系电话","职位"}; //列名
		table_repairBase_old = new JTable(repairBase_old,columnNames_repairBase_old);
		table_repairBase_old.setEnabled(false);//禁止写入
		table_repairBase_old.getTableHeader().setReorderingAllowed(false);//禁止表头拖动
		table_repairBase_old.setRowHeight(25);//以像素为单位的行高
		scrollPane_repairBase_old.setViewportView(table_repairBase_old);
		panel_1.add(panel_4_0,"修改工资");
		
		lblNewLabel_3 = new JLabel("修改工资信息");
		lblNewLabel_3.setBounds(518, 0, 91, 15);
		panel_4_0.add(lblNewLabel_3);
		
		JLabel label_2 = new JLabel("\u8BF7\u8F93\u5165\u9700\u8981\u4FEE\u6539\u7684\u804C\u5DE5\u7F16\u53F7");
		label_2.setFont(new Font("宋体", Font.ITALIC, 14));
		label_2.setBounds(32, 25, 168, 23);
		panel_4_0.add(label_2);
		
		button_repair_confirm = new JButton("\u4FEE\u6539");
		button_repair_confirm.setIcon(new ImageIcon(Info2.class.getResource("/images/modify.png")));
		button_repair_confirm.setBounds(380, 25, 93, 23);
		panel_4_0.add(button_repair_confirm);
		
		button_repair_canel = new JButton("\u53D6\u6D88");
		button_repair_canel.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		button_repair_canel.setBounds(483, 25, 93, 23);
		panel_4_0.add(button_repair_canel);
		
		textField_repairSalary = new JTextField();
		textField_repairSalary.setBounds(210, 26, 160, 21);
		panel_4_0.add(textField_repairSalary);
		textField_repairSalary.setColumns(10);
		
		lblNewLabel_1 = new JLabel("old data");
		lblNewLabel_1.setFont(new Font("宋体", Font.BOLD, 30));
		lblNewLabel_1.setBounds(210, 125, 160, 29);
		panel_4_0.add(lblNewLabel_1);
		
		scrollPane_repairSalary_old = new JScrollPane();
		scrollPane_repairSalary_old.setBounds(44, 168, 464, 50);
		panel_4_0.add(scrollPane_repairSalary_old);
		
		final String[] columnNames_repair_Salary= {"职工编号","基本月薪","销售额","提成","每小时酬金","当月工作时数","总工资"}; //列名
		table_repairSalary_old =new JTable(repairSalary_old,columnNames_repair_Salary);
		table_repairSalary_old.setEnabled(false);
		table_repairSalary_old.getTableHeader().setReorderingAllowed(false);
		table_repairSalary_old.setRowHeight(25);//以像素为单位的行高
		scrollPane_repairSalary_old.setViewportView(table_repairSalary_old);
		
		/*           查找模块                         */
		panel_5=new JPanel();
		panel_5_0=new JPanel();
		panel_5_0.setLayout(null);
		panel_1.add(panel_5,"查找基本");
		panel_5.setLayout(null);
		
		label_16 = new JLabel("查找基本信息");
		label_16.setFont(new Font("宋体", Font.PLAIN, 12));
		label_16.setBounds(518, 0, 72, 15);
		panel_5.add(label_16);
		
		lblNewLabel_4 = new JLabel("查找方式");
		lblNewLabel_4.setFont(new Font("宋体", Font.PLAIN, 12));
		lblNewLabel_4.setBounds(10, 10, 54, 15);
		panel_5.add(lblNewLabel_4);
		
		comboBox_2 = new JComboBox<String>();
		comboBox_2.setModel(new DefaultComboBoxModel<String>(new String[] {"请选择查询方式···", "按编号查找", "按姓名查找"}));
		comboBox_2.setBounds(74, 7, 97, 21);
		panel_5.add(comboBox_2);
		
		textField_8 = new JTextField();
		textField_8.setBounds(189, 7, 90, 21);
		panel_5.add(textField_8);
		textField_8.setColumns(10);
		
		btn_strictfp = new JButton("精确查询");
		btn_strictfp.setIcon(new ImageIcon(Info2.class.getResource("/images/search.png")));
		btn_strictfp.setFont(new Font("宋体", Font.PLAIN, 12));
		btn_strictfp.setBounds(289, 6, 104, 23);
		//btn_strictfp.setEnabled(false);
		panel_5.add(btn_strictfp);
		
		btn_both = new JButton("全部查询");
		btn_both.setIcon(new ImageIcon(Info2.class.getResource("/images/search.png")));
		btn_both.setFont(new Font("宋体", Font.PLAIN, 12));
		btn_both.setBounds(403, 6, 105, 23);
		panel_5.add(btn_both);
		
		btn_clear=new JButton("\u6E05\u7A7A\u663E\u793A");
		btn_clear.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		btn_clear.setFont(new Font("宋体", Font.PLAIN, 12));
		btn_clear.setBounds(500,53,109, 23);
		panel_5.add(btn_clear);
		
		scrollPane = new JScrollPane();
		scrollPane.setBounds(10, 50, 480, 228);
		panel_5.add(scrollPane);
		
		final String[] columnNames = {"职工编号","姓名","性别","出生年月","联系电话","职位"}; //列名
		select_table = new JTable(empty,columnNames);
		select_table.setEnabled(false);//禁止写入
		select_table.getTableHeader().setReorderingAllowed(false);
		select_table.setRowHeight(25);//以像素为单位的行高
		scrollPane.setViewportView(select_table);
		panel_1.add(panel_5_0,"查找工资");
		
		label_17 = new JLabel("查找工资信息");
		label_17.setFont(new Font("宋体", Font.PLAIN, 12));
		label_17.setBounds(498, 0, 92, 15);
		panel_5_0.add(label_17);
		
		label_5 = new JLabel("\u8F93\u5165\u804C\u5DE5\u7F16\u53F7");
		label_5.setBounds(10, 43, 92, 15);
		panel_5_0.add(label_5);
		
		textField_select_identity = new JTextField();
		textField_select_identity.setBounds(112, 40, 153, 21);
		panel_5_0.add(textField_select_identity);
		textField_select_identity.setColumns(10);
		
		button_select_strictfp = new JButton("\u7CBE\u786E\u67E5\u8BE2");
		button_select_strictfp.setFont(new Font("宋体", Font.PLAIN, 12));
		button_select_strictfp.setIcon(new ImageIcon(Info2.class.getResource("/images/search.png")));
		button_select_strictfp.setBounds(275, 39, 113, 23);
		panel_5_0.add(button_select_strictfp);
		
		button_select_both = new JButton("\u5168\u90E8\u67E5\u8BE2");
		button_select_both.setFont(new Font("宋体", Font.PLAIN, 12));
		button_select_both.setIcon(new ImageIcon(Info2.class.getResource("/images/search.png")));
		button_select_both.setBounds(398, 39, 109, 23);
		panel_5_0.add(button_select_both);
		
		scrollPane_1 = new JScrollPane();
		scrollPane_1.setBounds(10, 87, 486, 185);
		panel_5_0.add(scrollPane_1);
		
		final String[] columnNames_select_Salary= {"职工编号","基本月薪","销售额","提成","每小时酬金","当月工作时数","总工资"}; //列名
		table_select_Salary = new JTable(selectEmpty,columnNames_select_Salary);
		table_select_Salary.setEnabled(false);//禁止写入
		table_select_Salary.getTableHeader().setReorderingAllowed(false);
		table_select_Salary.setRowHeight(25);//以像素为单位的行高
		scrollPane_1.setViewportView(table_select_Salary);
		
		button_wipe = new JButton("\u6E05\u7A7A\u663E\u793A");
		button_wipe.setFont(new Font("宋体", Font.PLAIN, 12));
		button_wipe.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		button_wipe.setBounds(500, 90, 109, 23);
		panel_5_0.add(button_wipe);
		
		/* 统计模块*/
		panel_6=new JPanel();//统计人数面板
		panel_6.setLayout(null);
		panel_1.add(panel_6,"统计人数");
		
		JLabel label_4 = new JLabel("\u7EDF\u8BA1\u4EBA\u6570");//统计人数标签标识
		label_4.setBounds(555, 10, 54, 15);
		panel_6.add(label_4);
		
		label_20 = new JLabel("\u7EDF\u8BA1\u90E8\u95E8\u4EBA\u6570");
		label_20.setBounds(105, 23, 80, 21);
		panel_6.add(label_20);
		
		comboBox_count = new JComboBox<String>();
		comboBox_count.setModel(new DefaultComboBoxModel<String>(new String[] {"\u8BF7\u9009\u62E9\u804C\u4F4D", "\u7ECF\u7406", "\u9500\u552E\u7ECF\u7406", "\u6280\u672F\u4EBA\u5458", "\u9500\u552E\u4EBA\u5458", "\u5168\u90E8"}));
		comboBox_count.setBounds(215, 23, 96, 21);
		panel_6.add(comboBox_count);
		
		JButton button_count = new JButton("\u786E\u8BA4");
		button_count.setIcon(new ImageIcon(Info2.class.getResource("/images/ok.png")));
		button_count.setBounds(343, 22, 93, 23);
		panel_6.add(button_count);
		
		JLabel label_21 = new JLabel("\u7ECF   \u7406");
		label_21.setBounds(131, 68, 54, 21);
		panel_6.add(label_21);
		
		JLabel label_22 = new JLabel("\u9500\u552E\u7ECF\u7406");
		label_22.setBounds(131, 118, 54, 21);
		panel_6.add(label_22);
		
		label_23 = new JLabel("\u6280\u672F\u4EBA\u5458");
		label_23.setBounds(131, 165, 54, 21);
		panel_6.add(label_23);
		
		textField_manager_countPeople = new JTextField();
		textField_manager_countPeople.setEditable(false);
		textField_manager_countPeople.setBounds(215, 68, 122, 21);
		panel_6.add(textField_manager_countPeople);
		textField_manager_countPeople.setColumns(10);
		
		textField_SalesManager_countPeople = new JTextField();
		textField_SalesManager_countPeople.setEditable(false);
		textField_SalesManager_countPeople.setBounds(215, 118, 122, 21);
		panel_6.add(textField_SalesManager_countPeople);
		textField_SalesManager_countPeople.setColumns(10);
		
		textField_Technician_countPeople = new JTextField();
		textField_Technician_countPeople.setEditable(false);
		textField_Technician_countPeople.setBounds(215, 165, 122, 21);
		panel_6.add(textField_Technician_countPeople);
		textField_Technician_countPeople.setColumns(10);
		
		JLabel label_24 = new JLabel("\u9500\u552E\u4EBA\u5458");
		label_24.setBounds(131, 212, 54, 15);
		panel_6.add(label_24);
		
		textField_Salesperson_countPeople = new JTextField();
		textField_Salesperson_countPeople.setEditable(false);
		textField_Salesperson_countPeople.setBounds(215, 209, 122, 21);
		panel_6.add(textField_Salesperson_countPeople);
		textField_Salesperson_countPeople.setColumns(10);
		
		label_25 = new JLabel("\u5168    \u90E8");
		label_25.setBounds(131, 256, 54, 15);
		panel_6.add(label_25);
		
		textField_both_countPeople = new JTextField();
		textField_both_countPeople.setEditable(false);
		textField_both_countPeople.setBounds(215, 253, 122, 21);
		panel_6.add(textField_both_countPeople);
		textField_both_countPeople.setColumns(10);
		
		JButton button_wipe_count = new JButton("\u6E05\u7A7A");
		button_wipe_count.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		button_wipe_count.setBounds(382, 252, 93, 23);
		panel_6.add(button_wipe_count);
		panel_7=new JPanel();
		panel_7.setLayout(null);
		panel_1.add(panel_7,"统计工资");
		
		JLabel label_14 = new JLabel("\u7EDF\u8BA1\u5DE5\u8D44");//统计工资标签标识
		label_14.setBounds(555, 10, 54, 15);
		panel_7.add(label_14);
		
		label_26 = new JLabel("\u7EDF\u8BA1\u5DE5\u8D44");
		label_26.setBounds(93, 20, 54, 21);
		panel_7.add(label_26);
		
		comboBox_id_Salary = new JComboBox<String>();
		comboBox_id_Salary.setModel(new DefaultComboBoxModel<String>(new String[] {"\u8BF7\u9009\u62E9\u804C\u4F4D", "\u7ECF\u7406", "\u9500\u552E\u7ECF\u7406", "\u6280\u672F\u4EBA\u5458", "\u9500\u552E\u4EBA\u5458", "\u5168\u90E8"}));
		comboBox_id_Salary.setBounds(192, 20, 87, 21);
		panel_7.add(comboBox_id_Salary);
		
		button_countSalary = new JButton("\u786E\u8BA4");
		button_countSalary.setIcon(new ImageIcon(Info2.class.getResource("/images/ok.png")));
		button_countSalary.setBounds(320, 19, 93, 23);
		panel_7.add(button_countSalary);
		
		label_27 = new JLabel("\u7ECF    \u7406");
		label_27.setBounds(93, 67, 54, 15);
		panel_7.add(label_27);
		
		textField_Manage_Salary = new JTextField();
		textField_Manage_Salary.setEditable(false);
		textField_Manage_Salary.setBounds(192, 64, 105, 21);
		panel_7.add(textField_Manage_Salary);
		textField_Manage_Salary.setColumns(10);
		
		label_28 = new JLabel("\u9500\u552E\u7ECF\u7406");
		label_28.setBounds(93, 114, 54, 15);
		panel_7.add(label_28);
		
		textField_SalesManager_Salary = new JTextField();
		textField_SalesManager_Salary.setEditable(false);
		textField_SalesManager_Salary.setBounds(192, 111, 105, 21);
		panel_7.add(textField_SalesManager_Salary);
		textField_SalesManager_Salary.setColumns(10);
		
		label_29 = new JLabel("\u6280\u672F\u4EBA\u5458");
		label_29.setBounds(93, 159, 54, 15);
		panel_7.add(label_29);
		
		textField_Technician_Salary = new JTextField();
		textField_Technician_Salary.setEditable(false);
		textField_Technician_Salary.setBounds(192, 156, 105, 21);
		panel_7.add(textField_Technician_Salary);
		textField_Technician_Salary.setColumns(10);
		
		label_30 = new JLabel("\u9500\u552E\u4EBA\u5458");
		label_30.setBounds(93, 199, 54, 15);
		panel_7.add(label_30);
		
		textField_Salesperson_Salary = new JTextField();
		textField_Salesperson_Salary.setEditable(false);
		textField_Salesperson_Salary.setBounds(192, 196, 105, 21);
		panel_7.add(textField_Salesperson_Salary);
		textField_Salesperson_Salary.setColumns(10);
		
		label_31 = new JLabel("\u5168    \u90E8");
		label_31.setBounds(93, 250, 54, 15);
		panel_7.add(label_31);
		
		textField_bothSalary = new JTextField();
		textField_bothSalary.setEditable(false);
		textField_bothSalary.setBounds(192, 247, 105, 21);
		panel_7.add(textField_bothSalary);
		textField_bothSalary.setColumns(10);
		
		button_wipe_SalaryCount = new JButton("\u6E05\u7A7A");
		button_wipe_SalaryCount.setIcon(new ImageIcon(Info2.class.getResource("/images/reset.png")));
		button_wipe_SalaryCount.setBounds(330, 246, 93, 23);
		panel_7.add(button_wipe_SalaryCount);
		
		menuItem_countPeople.addActionListener(new ActionListener() {//统计人数
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				cardLayout.show(panel_1,"统计人数");
			}
		});
		/*统计人数面板中的动作内容*/
		button_count.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String choose_id=(String)comboBox_count.getSelectedItem();
				if(choose_id.equals("请选择职位")){
					JOptionPane.showMessageDialog(null,"请选择职位!","提示信息",JOptionPane.WARNING_MESSAGE);
				}
				else{
					if(choose_id.equals("经理")){
						String count_Manager="select count(number) from BaseInfo_Table where id='经理'";
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_Manager);
							if(resultSet.next()){
								textField_manager_countPeople.setText(String.valueOf(resultSet.getInt(1))+"人");
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
					if (choose_id.equals("销售经理")) {
						String count_SalesManager="select count(number) from BaseInfo_Table where id='销售经理'";
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_SalesManager);
							if(resultSet.next()){
								textField_SalesManager_countPeople.setText(String.valueOf(resultSet.getInt(1))+"人");
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
					if(choose_id.equals("技术人员")){
						String count_Technician="select count(number) from BaseInfo_Table where id='技术人员'";
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_Technician);
							if(resultSet.next()){
								textField_Technician_countPeople.setText(String.valueOf(resultSet.getInt(1))+"人");
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
					if(choose_id.equals("销售人员")){
						String count_Salesperson="select count(number) from BaseInfo_Table where id='销售人员'";
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_Salesperson);
							if(resultSet.next()){
								textField_Salesperson_countPeople.setText(String.valueOf(resultSet.getInt(1))+"人");
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
					if(choose_id.equals("全部")){
						String count_both="select count(number) from BaseInfo_Table";
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_both);
							if(resultSet.next()){
								textField_both_countPeople.setText(String.valueOf(resultSet.getInt(1))+"人");
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
				}	
			}
		});
		button_wipe_count.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				textField_manager_countPeople.setText("");
				textField_SalesManager_countPeople.setText("");
				textField_Technician_countPeople.setText("");
				textField_Salesperson_countPeople.setText("");
				textField_both_countPeople.setText("");
			}
		});
		/*
		 * 
		 * 
		 * 
		 * 
		 * */
		menuItem_countSalary.addActionListener(new ActionListener() {//统计工资
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				cardLayout.show(panel_1,"统计工资");
			}
		});
		/*统计工资面板中的动作内容*/
		button_countSalary.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String choose_id=(String)comboBox_id_Salary.getSelectedItem();
				if(choose_id.equals("请选择职位")){
					JOptionPane.showMessageDialog(null,"请选择职位!","提示信息",JOptionPane.WARNING_MESSAGE);
				}
				else{
					if(choose_id.equals("经理")){
						String count_ManagerSalary="select monthPay from Manager";
						float ManagerSalary_sum=0;
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_ManagerSalary);
							while(resultSet.next()){
								ManagerSalary_sum+=resultSet.getFloat(1);	
							}
							textField_Manage_Salary.setText(String.valueOf(ManagerSalary_sum)+"元");
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
					if(choose_id.equals("销售经理")){
						String count_SalesManagerSalary="select monthPay from SalesManager";
						float SalesManagerSalary_sum=0;
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_SalesManagerSalary);
							while(resultSet.next()){
								SalesManagerSalary_sum+=resultSet.getFloat(1);	
							}
							textField_SalesManager_Salary.setText(String.valueOf(SalesManagerSalary_sum)+"元");
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
					if(choose_id.equals("技术人员")){
						String count_TechnicianSalary="select monthPay from Technician";
						float TechnicianSalary_sum=0;
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_TechnicianSalary);
							while(resultSet.next()){
								TechnicianSalary_sum+=resultSet.getFloat(1);	
							}
							textField_Technician_Salary.setText(String.valueOf(TechnicianSalary_sum)+"元");
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
					if(choose_id.equals("销售人员")){
						String count_SalespersonSalary="select monthPay from Salesperson";
						float SalespersonSalary_sum=0;
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_SalespersonSalary);
							while(resultSet.next()){
								SalespersonSalary_sum+=resultSet.getFloat(1);	
							}
							textField_Salesperson_Salary.setText(String.valueOf(SalespersonSalary_sum)+"元");
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
					}
					if(choose_id.equals("全部")){
						float monthPay=0;
						String count_ManagerSalary="select monthPay from Manager";
						String count_SalesManagerSalary="select monthPay from SalesManager";
						String count_TechnicianSalary="select monthPay from Technician";
						String count_SalespersonSalary="select monthPay from Salesperson";
						Connection connection=null;
						Statement statement=null;
						ResultSet resultSet=null;
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_ManagerSalary);
							while(resultSet.next()){
								monthPay+=resultSet.getFloat(1);
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_SalesManagerSalary);
							while(resultSet.next()){
								monthPay+=resultSet.getFloat(1);
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_TechnicianSalary);
							while(resultSet.next()){
								monthPay+=resultSet.getFloat(1);
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
						try {
							connection=JDBCUtil.getConnection();
							statement=connection.createStatement();
							resultSet=statement.executeQuery(count_SalespersonSalary);
							while(resultSet.next()){
								monthPay+=resultSet.getFloat(1);
							}
						} catch (SQLException e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally {
							JDBCUtil.release(resultSet, statement, connection);
						}
						textField_bothSalary.setText(String.valueOf(monthPay)+"元");
					}
				}
			}
		});
		button_wipe_SalaryCount.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				textField_Manage_Salary.setText("");
				textField_SalesManager_Salary.setText("");
				textField_Technician_Salary.setText("");
				textField_Salesperson_Salary.setText("");
				textField_bothSalary.setText("");
			}
		});
		/*
		 * 
		 * 
		 * 
		 * 
		 * */
		jMenuItem1.addActionListener(new ActionListener() {//关于我们
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				new About_me().setVisible(true);
			}
		});
		jmenuItem_introduce.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				new Introduce().setVisible(true);
			}
		});
		jMenuItem2.addActionListener(new ActionListener() {//添加基本信息
			
			@Override
			public void actionPerformed(ActionEvent e){
				// TODO Auto-generated method stub
				cardLayout.show(panel_1,"增加基本");
			}
		});
		/*添加基本信息面板中的动作内容*/
		btn_confirm.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e){
				// TODO Auto-generated method stub
				String choose_sex=(String)comboBox_sex.getSelectedItem();
				String choose_id=(String)comboBox_admin.getSelectedItem();
				if(textField_id.getText().isEmpty()||textField_name.getText().isEmpty()||textField_birthday.getText().isEmpty()||choose_sex.isEmpty()||choose_sex.equals("请选择性别")||choose_id.isEmpty()||choose_id.equals("请选择身份···")){
					JOptionPane.showMessageDialog(null,"添加失败,前四项字段不为空,身份必须选择!","提示信息",JOptionPane.ERROR_MESSAGE);
				}
				else if(textField_birthday.getText().length()!=10||!Check_Date.check_date(textField_birthday.getText())){//日期不符合逻辑
					JOptionPane.showMessageDialog(null,"添加失败,日期不符合逻辑(1.当月没有这个日期2.当年没有这个月3.未按格式输入)!","提示信息",JOptionPane.ERROR_MESSAGE);
				}
				else {
					if(choose_sex.equals("请选择性别")){
					}
					if(choose_sex.equals("男")){
						bool=new Boolean(true);
					}
					if(choose_sex.equals("女")){
						bool=new Boolean(false);
					}
					Date date=null;
					try{
						SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
						date=sdf.parse(textField_birthday.getText());
					}catch(ParseException e4){
						JOptionPane.showMessageDialog(null,"添加失败,日期格式错误(未添加-)!","提示信息",JOptionPane.ERROR_MESSAGE);
					}
					Connection connection=null;
					ResultSet reSet=null;
					PreparedStatement pStatement = null;
					try {
						connection=JDBCUtil.getConnection();
						String insertValue="insert into BaseInfo_Table(number,name,sex,birthday,phone,id)Values(?,?,?,?,?,?)";//插入数据的动态设置的SQL语句
						pStatement=connection.prepareStatement(insertValue);
						pStatement.setString(1,textField_id.getText());
						pStatement.setString(2,textField_name.getText());
						pStatement.setBoolean(3,bool);
						pStatement.setDate(4,new java.sql.Date(date.getTime()));
						pStatement.setString(5,textField_phone.getText());
						pStatement.setString(6,choose_id);
						pStatement.addBatch();
						pStatement.executeUpdate();
						JOptionPane.showMessageDialog(null,"添加成功!","提示信息",JOptionPane.INFORMATION_MESSAGE);
					} catch (SQLException e3) {
						JOptionPane.showMessageDialog(null,"添加失败,该编号已存在!","提示信息",JOptionPane.ERROR_MESSAGE);//主键重复抛出异常
					}finally{
						JDBCUtil.release(reSet,pStatement, connection);
					}
				}
			}
		});
		btn_cancel.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				textField_id.setText("");
				textField_name.setText("");
				textField_birthday.setText("");
				textField_phone.setText("");
			}
		});
		/*
		 * 
		 * 
		 * 
		 * 
		 * */
		jMenuItem3.addActionListener(new ActionListener() {//增加工资信息
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				cardLayout.show(panel_1,"增加工资");
			}
		});
		/*增加工资信息面板中的动作内容*/
		button_addSalary_confirm.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String select="select * from BaseInfo_Table where number='"+textField_addSalary.getText()+"'";
				Connection connection=null;
				Statement statement=null;
				ResultSet rSet=null;
				try {
					connection=JDBCUtil.getConnection();
					statement=connection.createStatement();
					rSet=statement.executeQuery(select);
					if(rSet.next()){
						number=rSet.getString("number");//从基本信息表中获取职工编号然后写入工资信息表中
						if(rSet.getString("id").equals("经理")){
							cLayout.show(panel_base,"经理");
						}
						if(rSet.getString("id").equals("技术人员")){
							cLayout.show(panel_base,"技术人员");
						}
						if(rSet.getString("id").equals("销售经理")){
							cLayout.show(panel_base,"销售经理");
						}
						if(rSet.getString("id").equals("销售人员")){
							cLayout.show(panel_base,"销售人员");
						}
					}
					else{
						JOptionPane.showMessageDialog(null,"未找到该编号人员信息!","提示信息",JOptionPane.WARNING_MESSAGE);
					}
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally {
					JDBCUtil.release(rSet, statement, connection);
				}
			}
		});
		button_addSalary_canel.addMouseListener(new MouseAdapter() {

			@Override
			public void mouseClicked(MouseEvent e) {
				// TODO 自动生成的方法存根
				textField_addSalary.setText("");
			}
		});
		/*获取的编号是经理职位(进行增加工资信息时)*/
		button_Manager_add.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String addManager="insert into Manager(number,monthPay)values(?,?)";
				Connection connection=null;
				PreparedStatement pStatement=null;
				ResultSet rSet=null;
				try {
					connection=JDBCUtil.getConnection();
					pStatement=connection.prepareStatement(addManager);
					pStatement.setString(1,number);
					pStatement.setFloat(2,Float.parseFloat(textField_Manager.getText()));
					pStatement.executeUpdate();
					JOptionPane.showMessageDialog(null,"添加成功!","提示信息",JOptionPane.INFORMATION_MESSAGE);
				} catch (SQLException e2) {
					// TODO: handle exception
					JOptionPane.showMessageDialog(null,"添加失败,该编号已存在!","提示信息",JOptionPane.ERROR_MESSAGE);
					
				}catch (NumberFormatException e2) {
					// TODO: handle exception
					JOptionPane.showMessageDialog(null,"添加失败,输入格式错误!","提示信息",JOptionPane.ERROR_MESSAGE);
				}finally {
					JDBCUtil.release(rSet, pStatement, connection);
				}
			}
		});
		/*获取的编号是技术人员职位(进行增加工资信息时)*/
		button_Technician_add.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				Connection connection=null;
				PreparedStatement pStatement=null;
				ResultSet rSet=null;
				String addTechnician="insert into Technician(number,hourRate,workHours,monthPay)values(?,?,?,?)";
				float monthPay=Float.parseFloat(textField_Technician_hourRate.getText())*Float.parseFloat(textField_Technician_workHours.getText());
				try {
					connection=JDBCUtil.getConnection();
					pStatement=connection.prepareStatement(addTechnician);
					pStatement.setString(1,number);
					pStatement.setFloat(2,Float.parseFloat(textField_Technician_hourRate.getText()));
					pStatement.setFloat(3,Float.parseFloat(textField_Technician_workHours.getText()));
					pStatement.setFloat(4,monthPay);
					pStatement.executeUpdate();
					JOptionPane.showMessageDialog(null,"添加成功!","提示信息",JOptionPane.INFORMATION_MESSAGE);
				} catch (SQLException e2) {
					// TODO: handle exception
					JOptionPane.showMessageDialog(null,"添加失败,该编号已存在!","提示信息",JOptionPane.ERROR_MESSAGE);
				}catch (NumberFormatException e2) {
					// TODO: handle exception
					JOptionPane.showMessageDialog(null,"添加失败,输入格式错误!","提示信息",JOptionPane.ERROR_MESSAGE);
				}finally {
					JDBCUtil.release(rSet, pStatement, connection);
				}
			}
		});
		/*获取的编号是销售经理(进行增加工资信息时)*/
		button_SalesManager_add.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				Connection connection=null;
				PreparedStatement pStatement=null;
				ResultSet rSet=null;
				String addSalesManager="insert into SalesManager(number,basePay,pushMoney,sales,monthPay)values(?,?,?,?,?)";
				float monthPay=Float.parseFloat(textField_SalesManager_BasePay.getText())+Float.parseFloat(textField_SalesManager_pushMoney.getText())*Float.parseFloat(textField_SalesManager_sales.getText());
				try {
					connection=JDBCUtil.getConnection();
					pStatement=connection.prepareStatement(addSalesManager);
					pStatement.setString(1,number);
					pStatement.setFloat(2,Float.parseFloat(textField_SalesManager_BasePay.getText()));
					pStatement.setFloat(3,Float.parseFloat(textField_SalesManager_pushMoney.getText()));
					pStatement.setFloat(4,Float.parseFloat(textField_SalesManager_sales.getText()));
					pStatement.setFloat(5, monthPay);
					pStatement.executeUpdate();
					JOptionPane.showMessageDialog(null,"添加成功!","提示信息",JOptionPane.INFORMATION_MESSAGE);
				} catch (SQLException e2) {
					// TODO: handle exception
					//e2.printStackTrace();
					JOptionPane.showMessageDialog(null,"添加失败,该编号已存在或提成不在0~1之间!","提示信息",JOptionPane.ERROR_MESSAGE);
				}catch (NumberFormatException e2) {
					// TODO: handle exception
					JOptionPane.showMessageDialog(null,"添加失败,输入格式错误!","提示信息",JOptionPane.ERROR_MESSAGE);
				}finally {
					JDBCUtil.release(rSet, pStatement, connection);
				}	
			}
		});
		/*获取的职工编号是销售人员(进行增加工资信息时)*/
		button_Salesperson_add.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				Connection connection=null;
				PreparedStatement pStatement=null;
				ResultSet rSet=null;
				String addSalesperson="insert into Salesperson(number,pushMoney,sales,monthPay)values(?,?,?,?)";
				float monthPay=Float.parseFloat(textField_Salesperson_pushMoney.getText())*Float.parseFloat(textField_Salesperson_sales.getText());
				try {
					connection=JDBCUtil.getConnection();
					pStatement=connection.prepareStatement(addSalesperson);
					pStatement.setString(1,number);
					pStatement.setFloat(2, Float.parseFloat(textField_Salesperson_pushMoney.getText()));
					pStatement.setFloat(3,Float.parseFloat(textField_Salesperson_sales.getText()));
					pStatement.setFloat(4,monthPay);
					pStatement.executeUpdate();
					JOptionPane.showMessageDialog(null,"添加成功!","提示信息",JOptionPane.INFORMATION_MESSAGE);
				} catch (SQLException e2) {
					// TODO: handle exception
					JOptionPane.showMessageDialog(null,"添加失败,该编号已存在或提成不在0~1之间!","提示信息",JOptionPane.ERROR_MESSAGE);
				}catch (NumberFormatException e2) {
					// TODO: handle exception
					JOptionPane.showMessageDialog(null,"添加失败,输入格式错误!","提示信息",JOptionPane.ERROR_MESSAGE);
				}finally {
					JDBCUtil.release(rSet, pStatement, connection);
				}	
			}
		});
		/*
		 * 
		 * 
		 * 
		 * 
		 * 
		 * 
		 * */
		jMenuItem4.addActionListener(new ActionListener() {//删除基本和工资信息
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				cardLayout.show(panel_1, "删除基本");
			}
		});
		/*删除基本信息和工资信息面板中的动作内容*/
		button_delete.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String sql="select * from BaseInfo_Table where number='"+textField_deleteBase.getText()+"'";
				String deleteBase="delete from BaseInfo_Table where number='"+textField_deleteBase.getText()+"'";
				Connection connection=null;
				Statement statement=null;
				ResultSet rSet=null;
				try {
					connection=JDBCUtil.getConnection();
					statement=connection.createStatement();
					rSet=statement.executeQuery(sql);
					if(rSet.next()){
						delete_old_data[0][0]=rSet.getString(1);
						delete_old_data[0][1]=rSet.getString(2);
						if(rSet.getBoolean(3)){
							delete_old_data[0][2]="男";
						}
						else{
							delete_old_data[0][2]="女";
						}
						delete_old_data[0][3]=rSet.getDate(4);
						delete_old_data[0][4]=rSet.getString(5);
						delete_old_data[0][5]=rSet.getString(6);
						table_delete_repair = new JTable(delete_old_data,columnNames_delete);
						DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
						renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
						table_delete_repair.setDefaultRenderer(Object.class, renderer);//表中数据居中
						table_delete_repair.setEnabled(false);//禁止写入
						table_delete_repair.getTableHeader().setReorderingAllowed(false);
						table_delete_repair.setRowHeight(25);//以像素为单位的行高
						scrollPane_delete_old.setViewportView(table_delete_repair);
						if (rSet.getString("id").equals("经理")) {	
							String deleteManager="delete from Manager where number='"+textField_deleteBase.getText()+"'";
							Connection connection1=null;
							Statement statement1=null;
							ResultSet rSet1=null;
							try {
								connection1=JDBCUtil.getConnection();
								statement1=connection1.createStatement();
								statement1.executeUpdate(deleteManager);
							} catch (Exception e2) {
								// TODO: handle exception
								e2.printStackTrace();
							}finally {
								JDBCUtil.release(rSet1, statement1, connection1);
							}
						}
						if(rSet.getString("id").equals("技术人员")){
							String deleteTechnician="delete from Technician where number='"+textField_deleteBase.getText()+"'";
							Connection connection2=null;
							Statement statement2=null;
							ResultSet rSet2=null;
							try {
								connection2=JDBCUtil.getConnection();
								statement2=connection2.createStatement();
								statement2.executeUpdate(deleteTechnician);
							} catch (Exception e2) {
								// TODO: handle exception
								e2.printStackTrace();
							}finally {
								JDBCUtil.release(rSet2, statement2, connection2);
							}
						}
						if(rSet.getString("id").equals("销售经理")){
							String deleteSalesManager="delete from SalesManager where number='"+textField_deleteBase.getText()+"'";
							Connection connection3=null;
							Statement statement3=null;
							ResultSet rSet3=null;
							try {
								connection3=JDBCUtil.getConnection();
								statement3=connection3.createStatement();
								statement3.executeUpdate(deleteSalesManager);
							} catch (Exception e2) {
								// TODO: handle exception
								e2.printStackTrace();
							}finally {
								JDBCUtil.release(rSet3, statement3, connection3);
							}
							
						}
						if(rSet.getString("id").equals("销售人员")){
							String deleteSalesperson="delete from Salesperson where number='"+textField_deleteBase.getText()+"'";
							statement.executeUpdate(deleteSalesperson);
						}
						JOptionPane.showMessageDialog(null,"删除成功!","提示信息",JOptionPane.INFORMATION_MESSAGE);
					}
					else{
						JOptionPane.showMessageDialog(null,"未找到该编号人员信息!","提示信息",JOptionPane.WARNING_MESSAGE);
					}
					statement.executeUpdate(deleteBase);
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally {
					JDBCUtil.release(rSet, statement, connection);
				}
			}
		});
		button_delCanel.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				textField_deleteBase.setText("");
			}
		});
		/*
		 * 
		 * 
		 * 
		 * 
		 * 
		 * 
		 * */
		jMenuItem6.addActionListener(new ActionListener() {//修改基本信息
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				cardLayout.show(panel_1, "修改基本");
			}
		});
		/*修改基本信息面板中的动作内容*/
		button_repairBase_confirm.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String sql="select * from BaseInfo_Table where number='"+textField_repairBase.getText()+"'";
				Connection connection=null;
				Statement statement=null;
				ResultSet resultSet=null;
				try {
					connection=JDBCUtil.getConnection();
					statement=connection.createStatement();
					resultSet=statement.executeQuery(sql);
					if(resultSet.next()){
						repairBase_old[0][0]=resultSet.getString(1);
						repairBase_old[0][1]=resultSet.getString(2);
						if(resultSet.getBoolean(3)){
							repairBase_old[0][2]="男";
						}	
						else {
							repairBase_old[0][2]="女";
						}
						repairBase_old[0][3]=resultSet.getDate(4);
						repairBase_old[0][4]=resultSet.getString(5);
						repairBase_old[0][5]=resultSet.getString(6);
						table_repairBase_old = new JTable(repairBase_old,columnNames_delete);
						DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
						renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
						table_repairBase_old.setDefaultRenderer(Object.class, renderer);//表中数据居中
						table_repairBase_old.setEnabled(false);//禁止写入
						table_repairBase_old.getTableHeader().setReorderingAllowed(false);//禁止表头拖动
						table_repairBase_old.setRowHeight(25);//以像素为单位的行高
						scrollPane_repairBase_old.setViewportView(table_repairBase_old);
						/*修改基本信息窗体*/
						RepairBaseInfo repairBaseInfo=new RepairBaseInfo(textField_repairBase.getText());
						repairBaseInfo.setResizable(false);//窗体尺寸固定
						repairBaseInfo.setVisible(true);
					}
					else {
						JOptionPane.showMessageDialog(null,"未找到该编号人员信息!","提示信息",JOptionPane.WARNING_MESSAGE);
					}
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally {
					JDBCUtil.release(resultSet, statement, connection);
				}
			}
		});
		
		button_repairBase_cancel.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				textField_repairBase.setText("");
			}
		});
		/*
		 * 
		 * 
		 * 
		 * 
		 * 
		 * */
		jMenuItem7.addActionListener(new ActionListener() {//修改工资信息
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				cardLayout.show(panel_1, "修改工资");
			}
		});
		/*修改工资信息面板的动作内容*/
		button_repair_confirm.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String sql="select * from BaseInfo_Table where number='"+textField_repairSalary.getText()+"'";
				Connection connection=null;
				Statement statement=null;
				ResultSet resultSet=null;
				try {
					connection=JDBCUtil.getConnection();
					statement=connection.createStatement();
					resultSet=statement.executeQuery(sql);
					if(resultSet.next()){
						if(resultSet.getString("id").equals("经理")){
							String selectManager="select * from Manager where number='"+textField_repairSalary.getText()+"'";
							Connection connection1=null;
							Statement statement1=null;
							ResultSet resultSet1=null;
							try {
								connection1=JDBCUtil.getConnection();
								statement1=connection1.createStatement();
								resultSet1=statement1.executeQuery(selectManager);
								if(resultSet1.next()){
									repairSalary_old[0][0]=resultSet1.getString("number");
									repairSalary_old[0][1]=null;
									repairSalary_old[0][2]=null;
									repairSalary_old[0][3]=null;
									repairSalary_old[0][4]=null;
									repairSalary_old[0][5]=null;
									repairSalary_old[0][6]=resultSet1.getFloat("monthPay");
									table_repairSalary_old =new JTable(repairSalary_old,columnNames_repair_Salary);
									DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
									renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
									table_repairSalary_old.setDefaultRenderer(Object.class, renderer);//表中数据居中
									table_repairSalary_old.setEnabled(false);
									table_repairSalary_old.getTableHeader().setReorderingAllowed(false);
									table_repairSalary_old.setRowHeight(25);//以像素为单位的行高
									scrollPane_repairSalary_old.setViewportView(table_repairSalary_old);
									/*修改经理工资信息的窗体*/
									RepairSalary_Manager repairSalary_Manager=new RepairSalary_Manager(textField_repairSalary.getText());
									repairSalary_Manager.setResizable(false);//窗体尺寸固定
									repairSalary_Manager.setVisible(true);
								}
								else{
									JOptionPane.showMessageDialog(null,"工资信息表中未找到该编号人员信息!","提示信息",JOptionPane.WARNING_MESSAGE);
								}
							} catch (Exception e2) {
								// TODO: handle exception
							}finally {
								JDBCUtil.release(resultSet1, statement1, connection1);
							}
						}
						if(resultSet.getString("id").equals("技术人员")){
							String selectTechnician="select * from Technician where number='"+textField_repairSalary.getText()+"'";
							Connection connection1=null;
							Statement statement1=null;
							ResultSet resultSet1=null;
							try {
								connection1=JDBCUtil.getConnection();
								statement1=connection1.createStatement();
								resultSet1=statement1.executeQuery(selectTechnician);
								if(resultSet1.next()){
									repairSalary_old[0][0]=resultSet1.getString("number");
									repairSalary_old[0][1]=null;
									repairSalary_old[0][2]=null;
									repairSalary_old[0][3]=null;
									repairSalary_old[0][4]=resultSet1.getFloat("hourRate");
									repairSalary_old[0][5]=resultSet1.getFloat("workHours");
									repairSalary_old[0][6]=resultSet1.getFloat("monthPay");
									table_repairSalary_old =new JTable(repairSalary_old,columnNames_repair_Salary);
									DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
									renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
									table_repairSalary_old.setDefaultRenderer(Object.class, renderer);//表中数据居中
									table_repairSalary_old.setEnabled(false);
									table_repairSalary_old.getTableHeader().setReorderingAllowed(false);
									table_repairSalary_old.setRowHeight(25);//以像素为单位的行高
									scrollPane_repairSalary_old.setViewportView(table_repairSalary_old);
									/*修改技术人员工资信息的窗体*/
									RepairSalary_Technician repairSalary_Technician=new RepairSalary_Technician(textField_repairSalary.getText());
									repairSalary_Technician.setResizable(false);//窗体尺寸固定
									repairSalary_Technician.setVisible(true);
								}
								else{
									JOptionPane.showMessageDialog(null,"工资信息表中未找到该编号人员信息!","提示信息",JOptionPane.WARNING_MESSAGE);
								}
							} catch (Exception e2) {
								// TODO: handle exception
							}finally {
								JDBCUtil.release(resultSet1, statement1, connection1);
							}
						}
						if(resultSet.getString("id").equals("销售人员")){
							String selectSalesperson="select * from Salesperson where number='"+textField_repairSalary.getText()+"'";
							Connection connection1=null;
							Statement statement1=null;
							ResultSet resultSet1=null;
							try {
								connection1=JDBCUtil.getConnection();
								statement1=connection1.createStatement();
								resultSet1=statement1.executeQuery(selectSalesperson);
								if(resultSet1.next()){
									repairSalary_old[0][0]=resultSet1.getString("number");
									repairSalary_old[0][1]=null;
									repairSalary_old[0][2]=resultSet1.getFloat("sales");
									repairSalary_old[0][3]=resultSet1.getFloat("pushMoney");
									repairSalary_old[0][4]=null;
									repairSalary_old[0][5]=null;
									repairSalary_old[0][6]=resultSet1.getFloat("monthPay");
									table_repairSalary_old =new JTable(repairSalary_old,columnNames_repair_Salary);
									DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
									renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
									table_repairSalary_old.setDefaultRenderer(Object.class, renderer);//表中数据居中
									table_repairSalary_old.setEnabled(false);
									table_repairSalary_old.getTableHeader().setReorderingAllowed(false);
									table_repairSalary_old.setRowHeight(25);//以像素为单位的行高
									scrollPane_repairSalary_old.setViewportView(table_repairSalary_old);
									/*修改销售人员工资信息的窗体*/
									RepairSalary_Salesperson repairSalary_Salesperson=new RepairSalary_Salesperson(textField_repairSalary.getText());
									repairSalary_Salesperson.setResizable(false);//窗体尺寸固定
									repairSalary_Salesperson.setVisible(true);
								}
								else{
									JOptionPane.showMessageDialog(null,"工资信息表中未找到该编号人员信息!","提示信息",JOptionPane.WARNING_MESSAGE);
								}
							} catch (Exception e2) {
								// TODO: handle exception
							}finally {
								JDBCUtil.release(resultSet1, statement1, connection1);
							}
						}
						if(resultSet.getString("id").equals("销售经理")){
							String selectManager="select * from SalesManager where number='"+textField_repairSalary.getText()+"'";
							Connection connection2=null;
							Statement statement2=null;
							ResultSet resultSet2=null;
							try {
								connection2=JDBCUtil.getConnection();
								statement2=connection2.createStatement();
								resultSet2=statement2.executeQuery(selectManager);
								if(resultSet2.next()){
									repairSalary_old[0][0]=resultSet2.getString("number");
									repairSalary_old[0][1]=resultSet2.getFloat("basePay");
									repairSalary_old[0][2]=resultSet2.getFloat("sales");
									repairSalary_old[0][3]=resultSet2.getFloat("pushMoney");
									repairSalary_old[0][4]=null;
									repairSalary_old[0][5]=null;
									repairSalary_old[0][6]=resultSet2.getFloat("monthPay");
									table_repairSalary_old =new JTable(repairSalary_old,columnNames_repair_Salary);
									DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
									renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
									table_repairSalary_old.setDefaultRenderer(Object.class, renderer);//表中数据居中
									table_repairSalary_old.setEnabled(false);
									table_repairSalary_old.getTableHeader().setReorderingAllowed(false);
									table_repairSalary_old.setRowHeight(25);//以像素为单位的行高
									scrollPane_repairSalary_old.setViewportView(table_repairSalary_old);
									/*修改销售经理工资信息的窗体*/
									ReapirSalary_SalesManager repairSalary_SalesManager=new ReapirSalary_SalesManager(textField_repairSalary.getText());
									repairSalary_SalesManager.setResizable(false);//窗体尺寸固定
									repairSalary_SalesManager.setVisible(true);
								}
								else{
									JOptionPane.showMessageDialog(null,"工资信息表中未找到该编号人员信息!","提示信息",JOptionPane.WARNING_MESSAGE);
								}
							} catch (SQLException e2) {
								// TODO: handle exception
								e2.printStackTrace();
							}finally {
								JDBCUtil.release(resultSet2, statement2, connection2);
							}
						}
					}
					else{
						JOptionPane.showMessageDialog(null,"基本信息表中未找到该编号人员信息!","提示信息",JOptionPane.WARNING_MESSAGE);
					}
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally {
					JDBCUtil.release(resultSet, statement, connection);
				}
				
			}
		});
		button_repair_canel.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				textField_repairSalary.setText("");
			}
		});
		/*
		 * 
		 * 
		 * 
		 * 
		 * 
		 * 
		 * */
		jMenuItem8.addActionListener(new ActionListener() {//查找基本信息
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				cardLayout.show(panel_1,"查找基本");
			}
		});
		/*查找基本信息面板中的动作内容*/
		btn_both.addActionListener(new ActionListener() {
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				String query="select * from BaseInfo_Table";
				Connection connection=null;
				Statement statement=null;
				ResultSet rSet=null;
				int count=0,i=0;//控制以一行一行的读入表,i为表是否为空的标志位
				try {
					connection=JDBCUtil.getConnection();
					connection.setAutoCommit(true);
					statement=connection.createStatement();
					rSet=statement.executeQuery(query);
					while(rSet.next()){
						all_Data[count][0]=rSet.getString(1);
						all_Data[count][1]=rSet.getString(2);
						if (rSet.getBoolean(3)){
							all_Data[count][2]="男";
							i++;
						}
						else{
							all_Data[count][2]="女";
							i++;
						}
						all_Data[count][3]=rSet.getDate(4);
						all_Data[count][4]=rSet.getString(5);
						all_Data[count][5]=rSet.getString(6);
						count++;
					}
					if(i==0)
						JOptionPane.showMessageDialog(null,"表为空","提示信息",JOptionPane.WARNING_MESSAGE);
				} catch (Exception e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally{
					JDBCUtil.release(rSet, statement, connection);
				}
				select_table=new JTable(all_Data,columnNames);
				DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
				renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
				select_table.setDefaultRenderer(Object.class, renderer);//表中数据居中
				select_table.setEnabled(false);//禁止写入
				select_table.getTableHeader().setReorderingAllowed(false);//禁止表头拖动
				select_table.setRowHeight(25);//以像素为单位的行高
				select_table.setFont(new Font("宋体", Font.PLAIN, 12));
				scrollPane.setViewportView(select_table);
			}
		});	
		btn_strictfp.addActionListener(new ActionListener() {
		
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				Connection connection=null;
				Statement statement=null;
				ResultSet rSet=null;
				String select=(String)comboBox_2.getSelectedItem();//当前所选项目
				if(select.equals("请选择身份···")||select.isEmpty()){
				}
				else{
					if(select.equals("按编号查找")){
						String query="select * from BaseInfo_Table where number='"+textField_8.getText()+"'";
						int count=0,i=0;
						try {
							connection=JDBCUtil.getConnection();
							connection.setAutoCommit(true);
							statement=connection.createStatement();
							rSet=statement.executeQuery(query);
							while(rSet.next()){
								sec_Data[count][0]=rSet.getString(1);
								sec_Data[count][1]=rSet.getString(2);
								if (rSet.getBoolean(3)){
									sec_Data[count][2]="男";
									i++;
								}
								else{ 
									sec_Data[count][2]="女";
									i++;
								}
								sec_Data[count][3]=rSet.getDate(4);
								sec_Data[count][4]=rSet.getString(5);
								sec_Data[count][5]=rSet.getString(6);
								count++;
							}
							if(i==0)
								JOptionPane.showMessageDialog(null,"编号不存在,请重新输入","提示信息",JOptionPane.WARNING_MESSAGE);
						} catch (Exception e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally{
							JDBCUtil.release(rSet, statement, connection);
						}
						select_table=new JTable(sec_Data,columnNames);
						DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
						renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
						select_table.setDefaultRenderer(Object.class, renderer);//表中数据居中
						select_table.setEnabled(false);//禁止写入
						select_table.getTableHeader().setReorderingAllowed(false);//禁止表头拖动
						select_table.setRowHeight(25);//以像素为单位的行高
						select_table.setFont(new Font("宋体", Font.PLAIN, 12));
						scrollPane.setViewportView(select_table);
					}
					if(select.equals("按姓名查找")){
						String query="select * from BaseInfo_Table where name='"+textField_8.getText()+"'";
						int count=0,i=0;
						try {
							connection=JDBCUtil.getConnection();
							connection.setAutoCommit(true);
							statement=connection.createStatement();
							rSet=statement.executeQuery(query);
							while(rSet.next()){
								sec_Data[count][0]=rSet.getString(1);
								sec_Data[count][1]=rSet.getString(2);
								if (rSet.getBoolean(3)){
									sec_Data[count][2]="男";
									i++;
								}
								else{
									sec_Data[count][2]="女";
									i++;
								}
								sec_Data[count][3]=rSet.getDate(4);
								sec_Data[count][4]=rSet.getString(5);
								sec_Data[count][5]=rSet.getString(6);
								count++;
							}
							if(i==0||textField_8.getText().equals(""))
								JOptionPane.showMessageDialog(null,"姓名不存在,请重新输入","提示信息",JOptionPane.WARNING_MESSAGE);
						} catch (Exception e2) {
							// TODO: handle exception
							e2.printStackTrace();
						}finally{
							JDBCUtil.release(rSet, statement, connection);
						}
						select_table=new JTable(sec_Data,columnNames);
						DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
						renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
						select_table.setDefaultRenderer(Object.class, renderer);//表中数据居中
						select_table.setEnabled(false);//禁止写入
						select_table.getTableHeader().setReorderingAllowed(false);//禁止表头拖动
						select_table.setRowHeight(25);//以像素为单位的行高
						select_table.setFont(new Font("宋体", Font.PLAIN, 12));
						scrollPane.setViewportView(select_table);
					}
				}
			}
		});
		btn_clear.addActionListener(new ActionListener() {
		
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				select_table=new JTable(empty,columnNames);
				select_table.setEnabled(false);//禁止写入
				select_table.getTableHeader().setReorderingAllowed(false);//禁止表头拖动
				select_table.setRowHeight(25);//以像素为单位的行高
				select_table.setFont(new Font("宋体", Font.PLAIN, 12));
				scrollPane.setViewportView(select_table);
			}
		});
		/*
		 * 
		 * 
		 * 
		 * 
		 * 
		 * 
		 * 
		 * */
		jMenuItem9.addActionListener(new ActionListener() {//查找工资信息
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO Auto-generated method stub
				cardLayout.show(panel_1, "查找工资");
			}
		});
		/*查找工资信息面板内的动作内容*/
		button_select_both.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String queryManager="select * from Manager";
				String queryTechnician="select * from Technician";
				String querySalesManager="select * from SalesManager";
				String querySalesperson="select * from Salesperson";
				Connection connection=null;
				Statement statement=null;
				ResultSet resultSet=null;
				int count=0;
				try {//经理
					connection=JDBCUtil.getConnection();
					//connection.setAutoCommit(true);
					statement=connection.createStatement();
					resultSet=statement.executeQuery(queryManager);
					while(resultSet.next()){
						selectSalary[count][0]=resultSet.getString(1);
						selectSalary[count][1]=null;
						selectSalary[count][2]=null;
						selectSalary[count][3]=null;
						selectSalary[count][4]=null;
						selectSalary[count][5]=null;
						selectSalary[count][6]=resultSet.getFloat(2);
						count++;
					}
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally {
					JDBCUtil.release(resultSet, statement, connection);
				}
				try {//技术人员
					connection=JDBCUtil.getConnection();
					//connection.setAutoCommit(true);
					statement=connection.createStatement();
					resultSet=statement.executeQuery(queryTechnician);
					while(resultSet.next()){
						selectSalary[count][0]=resultSet.getString(1);
						selectSalary[count][1]=null;
						selectSalary[count][2]=null;
						selectSalary[count][3]=null;
						selectSalary[count][4]=resultSet.getFloat(2);
						selectSalary[count][5]=resultSet.getFloat(3);
						selectSalary[count][6]=resultSet.getFloat(4);
						count++;
					}
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally{
					JDBCUtil.release(resultSet, statement, connection);
				}
				try {//销售经理
					connection=JDBCUtil.getConnection();
					//connection.setAutoCommit(true);
					statement=connection.createStatement();
					resultSet=statement.executeQuery(querySalesManager);
					while(resultSet.next()){
						selectSalary[count][0]=resultSet.getString(1);
						selectSalary[count][1]=resultSet.getFloat(2);
						selectSalary[count][2]=resultSet.getFloat(4);
						selectSalary[count][3]=resultSet.getFloat(3);
						selectSalary[count][4]=null;
						selectSalary[count][5]=null;
						selectSalary[count][6]=resultSet.getFloat(5);
						count++;
					}
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally{
					JDBCUtil.release(resultSet, statement, connection);
				}
				try {//销售人员
					connection=JDBCUtil.getConnection();
					//connection.setAutoCommit(true);
					statement=connection.createStatement();
					resultSet=statement.executeQuery(querySalesperson);
					while(resultSet.next()){
						selectSalary[count][0]=resultSet.getString(1);
						selectSalary[count][1]=null;
						selectSalary[count][2]=resultSet.getFloat(3);
						selectSalary[count][3]=resultSet.getFloat(2);
						selectSalary[count][4]=null;
						selectSalary[count][5]=null;
						selectSalary[count][6]=resultSet.getFloat(4);
						count++;
					}
					if(count==0){
						JOptionPane.showMessageDialog(null,"工资表为空","提示信息",JOptionPane.WARNING_MESSAGE);
					}
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally{
					JDBCUtil.release(resultSet, statement, connection);
				}
				table_select_Salary = new JTable(selectSalary,columnNames_select_Salary);
				table_select_Salary.setEnabled(false);//禁止写入
				DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
				renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
				table_select_Salary.setDefaultRenderer(Object.class, renderer);//表中数据居中
				table_select_Salary.getTableHeader().setReorderingAllowed(false);
				table_select_Salary.setRowHeight(25);//以像素为单位的行高
				table_select_Salary.setFont(new Font("宋体", Font.PLAIN, 12));
				scrollPane_1.setViewportView(table_select_Salary);
			}
		});
		button_select_strictfp.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				String select_strictfp="select number,id from BaseInfo_Table where number='"+textField_select_identity.getText()+"'";
				Connection connection=null;
				Statement statement=null;
				ResultSet resultSet=null;
				try {
					connection=JDBCUtil.getConnection();
					statement=connection.createStatement();
					resultSet=statement.executeQuery(select_strictfp);
					if(resultSet.next()){
						if (resultSet.getString("id").equals("经理")) {
							String select_Manager="select * from Manager where number='"+textField_select_identity.getText()+"'";
							Connection connection1=null;
							Statement statement1=null;
							ResultSet resultSet1=null;
							try {
								connection1=JDBCUtil.getConnection();
								statement1=connection1.createStatement();
								resultSet1=statement1.executeQuery(select_Manager);
								if(resultSet1.next()){
									select_salary_strictfp[0][0]=resultSet1.getString(1);
									select_salary_strictfp[0][1]=null;
									select_salary_strictfp[0][2]=null;
									select_salary_strictfp[0][3]=null;
									select_salary_strictfp[0][4]=null;
									select_salary_strictfp[0][5]=null;
									select_salary_strictfp[0][6]=resultSet1.getFloat(2);
								}
							} catch (SQLException e2) {
								// TODO: handle exception
								e2.printStackTrace();
							}finally {
								JDBCUtil.release(resultSet1, statement1, connection1);
							}
							table_select_Salary = new JTable(select_salary_strictfp,columnNames_select_Salary);
							table_select_Salary.setEnabled(false);//禁止写入
							DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
							renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
							table_select_Salary.setDefaultRenderer(Object.class, renderer);//表中数据居中
							table_select_Salary.getTableHeader().setReorderingAllowed(false);
							table_select_Salary.setRowHeight(25);//以像素为单位的行高
							table_select_Salary.setFont(new Font("宋体", Font.PLAIN, 12));
							scrollPane_1.setViewportView(table_select_Salary);
						}
						if (resultSet.getString("id").equals("技术人员")) {
							String select_Manager="select * from Technician where number='"+textField_select_identity.getText()+"'";
							Connection connection2=null;
							Statement statement2=null;
							ResultSet resultSet2=null;
							try {
								connection2=JDBCUtil.getConnection();
								statement2=connection2.createStatement();
								resultSet2=statement2.executeQuery(select_Manager);
								if(resultSet2.next()){
									select_salary_strictfp[0][0]=resultSet2.getString(1);
									select_salary_strictfp[0][1]=null;
									select_salary_strictfp[0][2]=null;
									select_salary_strictfp[0][3]=null;
									select_salary_strictfp[0][4]=resultSet2.getFloat(2);
									select_salary_strictfp[0][5]=resultSet2.getFloat(3);
									select_salary_strictfp[0][6]=resultSet2.getFloat(4);
								}
							} catch (SQLException e2) {
								// TODO: handle exception
								e2.printStackTrace();
							}finally {
								JDBCUtil.release(resultSet2, statement2, connection2);
							}
							table_select_Salary = new JTable(select_salary_strictfp,columnNames_select_Salary);
							table_select_Salary.setEnabled(false);//禁止写入
							DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
							renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
							table_select_Salary.setDefaultRenderer(Object.class, renderer);//表中数据居中
							table_select_Salary.getTableHeader().setReorderingAllowed(false);
							table_select_Salary.setRowHeight(25);//以像素为单位的行高
							table_select_Salary.setFont(new Font("宋体", Font.PLAIN, 12));
							scrollPane_1.setViewportView(table_select_Salary);
						}
						if (resultSet.getString("id").equals("销售经理")) {
							String select_Manager="select * from SalesManager where number='"+textField_select_identity.getText()+"'";
							Connection connection3=null;
							Statement statement3=null;
							ResultSet resultSet3=null;
							try {
								connection3=JDBCUtil.getConnection();
								statement3=connection3.createStatement();
								resultSet3=statement3.executeQuery(select_Manager);
								if(resultSet3.next()){
									select_salary_strictfp[0][0]=resultSet3.getString(1);
									select_salary_strictfp[0][1]=resultSet3.getFloat(2);
									select_salary_strictfp[0][2]=resultSet3.getFloat(4);
									select_salary_strictfp[0][3]=resultSet3.getFloat(3);
									select_salary_strictfp[0][4]=null;
									select_salary_strictfp[0][5]=null;
									select_salary_strictfp[0][6]=resultSet3.getFloat(5);
								}
							} catch (SQLException e2) {
								// TODO: handle exception
								e2.printStackTrace();
							}finally {
								JDBCUtil.release(resultSet3, statement3, connection3);
							}
							table_select_Salary = new JTable(select_salary_strictfp,columnNames_select_Salary);
							table_select_Salary.setEnabled(false);//禁止写入
							DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
							renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
							table_select_Salary.setDefaultRenderer(Object.class, renderer);//表中数据居中
							table_select_Salary.getTableHeader().setReorderingAllowed(false);
							table_select_Salary.setRowHeight(25);//以像素为单位的行高
							table_select_Salary.setFont(new Font("宋体", Font.PLAIN, 12));
							scrollPane_1.setViewportView(table_select_Salary);
						}
						if (resultSet.getString("id").equals("销售人员")) {
							String select_Manager="select * from Salesperson where number='"+textField_select_identity.getText()+"'";
							Connection connection4=null;
							Statement statement4=null;
							ResultSet resultSet4=null;
							try {
								connection4=JDBCUtil.getConnection();
								statement4=connection4.createStatement();
								resultSet4=statement4.executeQuery(select_Manager);
								if(resultSet4.next()){
									select_salary_strictfp[0][0]=resultSet4.getString(1);
									select_salary_strictfp[0][1]=null;
									select_salary_strictfp[0][2]=resultSet4.getFloat(3);
									select_salary_strictfp[0][3]=resultSet4.getFloat(2);
									select_salary_strictfp[0][4]=null;
									select_salary_strictfp[0][5]=null;
									select_salary_strictfp[0][6]=resultSet4.getFloat(4);
								}
							} catch (SQLException e2) {
								// TODO: handle exception
								e2.printStackTrace();
							}finally {
								JDBCUtil.release(resultSet4, statement4, connection4);
							}
							table_select_Salary = new JTable(select_salary_strictfp,columnNames_select_Salary);
							table_select_Salary.setEnabled(false);//禁止写入
							DefaultTableCellHeaderRenderer renderer=new DefaultTableCellHeaderRenderer();//表中数据居中
							renderer.setHorizontalAlignment((int) JTable.CENTER_ALIGNMENT);//表中数据居中
							table_select_Salary.setDefaultRenderer(Object.class, renderer);//表中数据居中
							table_select_Salary.getTableHeader().setReorderingAllowed(false);
							table_select_Salary.setRowHeight(25);//以像素为单位的行高
							table_select_Salary.setFont(new Font("宋体", Font.PLAIN, 12));
							scrollPane_1.setViewportView(table_select_Salary);
						}
					}
					else{
						JOptionPane.showMessageDialog(null,"未找到该职工工资信息","提示信息",JOptionPane.WARNING_MESSAGE);
					}
				} catch (SQLException e2) {
					// TODO: handle exception
					e2.printStackTrace();
				}finally{
					JDBCUtil.release(resultSet, statement, connection);
				}
			}
		});
		button_wipe.addActionListener(new ActionListener() {
			
			@Override
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成的方法存根
				table_select_Salary = new JTable(selectEmpty,columnNames_select_Salary);
				table_select_Salary.setEnabled(false);//禁止写入
				table_select_Salary.getTableHeader().setReorderingAllowed(false);
				table_select_Salary.setRowHeight(25);//以像素为单位的行高
				scrollPane_1.setViewportView(table_select_Salary);
			}
		});
	}
}

九,系统概要

该项目将为公司提供一个平台,该软件将辅助公司对员工基本信息和工资信息的增加、删除、修改、查询,同时还可以对该公司员工数进行统计和对月公司总支出进行统计。该系统包括:登录注册模块、基本数据维护模块、系统介绍模块。


阅读更多
想对作者说点什么? 我来说一句

员工工资管理系统(java+sql)

2015年06月15日 15KB 下载

SpringMVC实战-雇员薪资管理系统

2016年02月29日 14.04MB 下载

10个JAVA项目实例

2010年01月29日 2.75MB 下载

JAVA小项目设计实例

2009年02月16日 10.02MB 下载

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭