java食品公司管理系统.rar

package messagejpanel; import java.awt.Color; import java.awt.Font; import java.awt.Rectangle; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseEvent; import java.awt.event.MouseListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashSet; import java.util.Iterator; import java.util.Vector; import javax.swing.BorderFactory; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.ListSelectionModel; import javax.swing.table.DefaultTableCellRenderer; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; import javax.swing.table.TableColumnModel; import javax.swing.table.TableRowSorter; import jframe.Login; import jframe.Main; import company.Test; import company.Testmysql; public class Message_employee extends JPanel { /** * Create the panel. */ private JTextField modify_textField; private JTable table; String JDriver = "com.mysql.jdbc.Driver"; // MySQL提供的JDBC驱动，要保证它在CLASSPATH里可见 String conURL = "jdbc:mysql://localhost/"+Test.database; // 本地计算机上的MySQL数据库Company的URL DefaultTableModel tableModel; Vector<Vector<String>> tableValueV; Vector<String> columnNameV; private JTextField add_born; private JTextField add_addr; private JTextField add_name; private JTextField add_position; private JTextField add_sex; private JTextField add_tel; private JTextField add_time; private JTextField add_school; private JTextField modify_born; private JTextField modify_addr; private JTextField modify_name; private JTextField modify_position; private JTextField modify_sex; private JTextField modify_tel; private JTextField modify_time; private JTextField modify_school; private JTextField search_born; private JTextField search_addr; private JTextField search_name; private JTextField search_position; private JTextField search_sex; private JTextField search_tel; private JTextField search_time; private JTextField search_school; public Message_employee() { setBackground(Color.WHITE); setBounds(197, 0, 637, 570); setLayout(null); init(); } public void init(){ JPanel panel = new JPanel(); panel.setBackground(Color.WHITE); panel.setBounds(39, 372, 568, 188); add(panel); panel.setLayout(null); panel.setVisible(false); panel.setBorder (BorderFactory.createTitledBorder ("添加员工")); JPanel panel1= new JPanel(); panel1.setBounds(39, 372, 568, 188); add(panel1); panel1.setBackground(Color.WHITE); panel1.setLayout(null); panel1.setVisible(false); panel1.setBorder (BorderFactory.createTitledBorder ("修改员工")); JPanel panel2= new JPanel(); panel2.setBounds(39, 372, 568, 188); add(panel2); panel2.setBackground(Color.WHITE); panel2.setLayout(null); panel2.setVisible(false); panel2.setBorder (BorderFactory.createTitledBorder ("查询员工 ")); JLabel add_label = new JLabel("\u59D3\u540D\uFF1A"); add_label.setFont(new Font("宋体", Font.PLAIN, 15)); add_label.setBounds(19, 24, 71, 21); panel.add(add_label); add_name = new JTextField(); add_name.setBounds(100, 24, 93, 21); panel.add(add_name); add_name.setColumns(10); JLabel add_label_1 = new JLabel("\u5BB6\u5EAD\u4F4F\u5740\uFF1A"); add_label_1.setFont(new Font("宋体", Font.PLAIN, 15)); add_label_1.setBounds(203, 100, 82, 30); panel.add(add_label_1); add_addr = new JTextField(); add_addr.setBounds(282, 105, 262, 21); panel.add(add_addr); add_addr.setColumns(10); JLabel add_label_5 = new JLabel("\u51FA\u751F\u5E74\u6708\uFF1A"); add_label_5.setFont(new Font("宋体", Font.PLAIN, 15)); add_label_5.setBounds(19, 59, 82, 30); panel.add(add_label_5); add_born = new JTextField(); add_born.setBounds(100, 64, 93, 21); panel.add(add_born); add_born.setColumns(10); JLabel add_label_3 = new JLabel("\u804C\u4F4D\uFF1A"); add_label_3.setFont(new Font("宋体", Font.PLAIN, 15)); add_label_3.setBounds(211, 24, 54, 21); panel.add(add_label_3); add_position = new JTextField(); add_position.setBounds(261, 24, 122, 21); panel.add(add_position); add_position.setColumns(10); JLabel add_label_4 = new JLabel("\u6027\u522B\uFF1A"); add_label_4.setFont(new Font("宋体", Font.PLAIN, 15)); add_label_4.setBounds(400, 25, 54, 18); panel.add(add_label_4); add_sex = new JTextField(); add_sex.setBounds(451, 24, 93, 21); panel.add(add_sex); add_sex.setColumns(10); JLabel add_label_2 = new JLabel("\u8054\u7CFB\u65B9\u5F0F\uFF1A"); add_label_2.setFont(new Font("宋体", Font.PLAIN, 15)); add_label_2.setBounds(203, 63, 79, 23); panel.add(add_label_2); add_tel = new JTextField(); add_tel.setBounds(271, 64, 112, 21); panel.add(add_tel); add_tel.setColumns(10); JLabel add_lblNewLabel_4 = new JLabel("\u5B66\u5386\uFF1A"); add_lblNewLabel_4.setFont(new Font("宋体", Font.PLAIN, 15)); add_lblNewLabel_4.setBounds(400, 64, 54, 21); panel.add(add_lblNewLabel_4); add_school = new JTextField(); add_school.setBounds(451, 64, 93, 21); panel.add(add_school); add_school.setColumns(10); JLabel add_label_6 = new JLabel("\u5165\u804C\u65F6\u95F4\uFF1A"); add_label_6.setFont(new Font("宋体", Font.PLAIN, 15)); add_label_6.setBounds(19, 102, 82, 26); panel.add(add_label_6); add_time = new JTextField(); add_time.setBounds(100, 102, 93, 21); panel.add(add_time); add_time.setColumns(10); JLabel modify_label = new JLabel("\u59D3\u540D\uFF1A"); modify_label.setFont(new Font("宋体", Font.PLAIN, 15)); modify_label.setBounds(19, 24, 71, 21); panel1.add(modify_label); modify_name = new JTextField(); modify_name.setBounds(100, 24, 93, 21); panel1.add(modify_name); modify_name.setColumns(10); JLabel modify_label_1 = new JLabel("\u5BB6\u5EAD\u4F4F\u5740\uFF1A"); modify_label_1.setFont(new Font("宋体", Font.PLAIN, 15)); modify_label_1.setBounds(203, 100, 82, 30); panel1.add(modify_label_1); modify_addr = new JTextField(); modify_addr.setBounds(282, 105, 262, 21); panel1.add(modify_addr); modify_addr.setColumns(10); JLabel modify_label_5 = new JLabel("\u51FA\u751F\u5E74\u6708\uFF1A"); modify_label_5.setFont(new Font("宋体", Font.PLAIN, 15)); modify_label_5.setBounds(19, 59, 82, 30); panel1.add(modify_label_5); modify_born = new JTextField(); modify_born.setBounds(100, 64, 93, 21); panel1.add(modify_born); modify_born.setColumns(10); JLabel modify_label_3 = new JLabel("\u804C\u4F4D\uFF1A"); modify_label_3.setFont(new Font("宋体", Font.PLAIN, 15)); modify_label_3.setBounds(211, 24, 54, 21); panel1.add(modify_label_3); modify_position = new JTextField(); modify_position.setBounds(261, 24, 122, 21); panel1.add(modify_position); modify_position.setColumns(10); JLabel modify_label_4 = new JLabel("\u6027\u522B\uFF1A"); modify_label_4.setFont(new Font("宋体", Font.PLAIN, 15)); modify_label_4.setBounds(400, 25, 54, 18); panel1.add(modify_label_4); modify_sex = new JTextField(); modify_sex.setBounds(451, 24, 93, 21); panel1.add(modify_sex); modify_sex.setColumns(10); JLabel modify_label_2 = new JLabel("\u8054\u7CFB\u65B9\u5F0F\uFF1A"); modify_label_2.setFont(new Font("宋体", Font.PLAIN, 15)); modify_label_2.setBounds(203, 63, 79, 23); panel1.add(modify_label_2); modify_tel = new JTextField(); modify_tel.setBounds(271, 64, 112, 21); panel1.add(modify_tel); modify_tel.setColumns(10); JLabel modify_lblNewLabel_4 = new JLabel("\u5B66\u5386\uFF1A"); modify_lbl