企业信息管理系统.zip
资源内容介绍
企业信息管理系统.zip package com.ynou.view;import java.awt.EventQueue;import javax.swing.JFrame;import javax.swing.JPanel;import javax.swing.border.EmptyBorder;import javax.swing.JLabel;import javax.swing.JOptionPane;import java.awt.Font;import javax.swing.JTextField;import javax.swing.JButton;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.table.DefaultTableModel;import com.ynou.bean.Employee;import com.ynou.dao.EmployeeDao;import java.awt.event.ActionListener;import java.util.ArrayList;import java.awt.event.ActionEvent;import java.awt.Color;public class MainFrame extends JFrame {private JPanel contentPane;private JTextField textField;private JTable table;/** * Launch the application. */public static void main(String[] args) {EventQueue.invokeLater(new Runnable() {public void run() {try {MainFrame frame = new MainFrame();frame.setVisible(true);} catch (Exception e) {e.printStackTrace();}}});}/** * Create the frame. */public MainFrame() {setFont(new Font("华文行楷", Font.BOLD, 12));setTitle("\u4EBA\u4E8B\u4FE1\u606F\u7BA1\u7406");setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);setBounds(100, 100, 1021, 689);contentPane = new JPanel();contentPane.setForeground(new Color(193, 173, 245));contentPane.setBackground(new Color(235, 243, 175));contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));setContentPane(contentPane);contentPane.setLayout(null);JLabel lblNewLabel = new JLabel("\u5458\u5DE5\u4FE1\u606F\u7BA1\u7406");lblNewLabel.setForeground(new Color(175, 167, 252));lblNewLabel.setFont(new Font("华文楷体", Font.BOLD, 52));lblNewLabel.setBounds(311, 58, 402, 74);contentPane.add(lblNewLabel);JLabel lblNewLabel_1 = new JLabel("\u8BF7\u8F93\u5165\u5458\u5DE5\u59D3\u540D\u5173\u952E\u5B57\uFF1A");lblNewLabel_1.setForeground(new Color(251, 185, 168));lblNewLabel_1.setFont(new Font("华文楷体", Font.PLAIN, 36));lblNewLabel_1.setBounds(10, 181, 420, 64);contentPane.add(lblNewLabel_1);textField = new JTextField();textField.setBackground(new Color(193, 224, 186));textField.setBounds(402, 189, 311, 45);contentPane.add(textField);textField.setColumns(10);JScrollPane scrollPane = new JScrollPane();scrollPane.setBounds(31, 255, 816, 190);contentPane.add(scrollPane);JButton btnNewButton = new JButton("\u67E5\u8BE2");btnNewButton.setForeground(new Color(255, 164, 166));btnNewButton.setBackground(new Color(206, 222, 236));btnNewButton.setFont(new Font("华文行楷", Font.PLAIN, 28));btnNewButton.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {//查询按钮点击事件//1.获取输入框中得姓名关键字String key=textField.getText();//2.调用EmployeeDao里面得根据姓名关键字查EmployeeDao dao=new EmployeeDao();ArrayList<Employee> list=dao.selectByKey(key);//3.把list数据转二维数组然后放表格(复制下面全查得)//2.把list转成二维数据Object[][] datas=new Object[list.size()][5];//3.把list数据传给datasfor(int i=0;i<=list.size()-1;i++) {datas[i][0]=list.get(i).getEmpId();datas[i][1]=list.get(i).getEmpName();datas[i][2]=list.get(i).getEmpSex();datas[i][3]=list.get(i).getEmpPhone();datas[i][4]=list.get(i).getEmpAddress();}table = new JTable();table.setForeground(new Color(0, 0, 0));table.setBackground(new Color(241, 238, 205));table.setFont(new Font("华文楷体", Font.PLAIN, 20));table.setModel(new DefaultTableModel(datas,new String[] {"\u5458\u5DE5\u5E8F\u53F7", "\u5458\u5DE5\u59D3\u540D", "\u5458\u5DE5\u6027\u522B", "\u5458\u5DE5\u624B\u673A", "\u5458\u5DE5\u5730\u5740"}));scrollPane.setViewportView(table);}});btnNewButton.setBounds(750, 191, 97, 35);contentPane.add(btnNewButton);//准备表格里得数据//1.调用EmployeeDao里面得全查EmployeeDao dao=new EmployeeDao();ArrayList<Employee> list=dao.selectAll();//2.把list转成二维数据Object[][] datas=new Object[list.size()][5];//3.把list数据传给datasfor(int i=0;i<=list.size()-1;i++) {datas[i][0]=list.get(i).getEmpId();datas[i][1]=list.get(i).getEmpName();datas[i][2]=list.get(i).getEmpSex();datas[i][3]=list.get(i).getEmpPhone();datas[i][4]=list.get(i).getEmpAddress();}table = new JTable();table.setForeground(new Color(0, 0, 0));table.setBackground(new Color(241, 238, 205));table.setFont(new Font("华文楷体", Font.PLAIN, 20));table.setModel(new DefaultTableModel(datas,new String[] {"\u5458\u5DE5\u5E8F\u53F7", "\u5458\u5DE5\u59D3\u540D", "\u5458\u5DE5\u6027\u522B", "\u5458\u5DE5\u624B\u673A", "\u5458\u5DE5\u5730\u5740"}));scrollPane.setViewportView(table);JButton btnNewButton_1 = new JButton("\u5220\u9664\u5458\u5DE5");btnNewButton_1.setForeground(new Color(255, 164, 166));btnNewButton_1.setBackground(new Color(196, 208, 215));btnNewButton_1.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {//删除按钮得点击事件 int row=table.getSelectedRow();//获取选中得行号if(row==-1) {JOptionPane.showMessageDialog(null, "请至少选择一个员工进行删除!");}else {//获取这一行得员工的编号int empId=(int) table.getValueAt(row, 0);EmployeeDao dao1=new EmployeeDao();int jg=dao1.deleteById(empId);if(jg>=1) {JOptionPane.showMessageDialog(null, "删除成功");dispose();//关闭当前页面new MainFrame().setVisible(true);//打开页面}else {JOptionPane.showMessageDialog(null, "删除失败");}}}});btnNewButton_1.setFont(new Font("华文行楷", Font.PLAIN, 26));btnNewButton_1.setBounds(672, 582, 186, 47);contentPane.add(btnNewButton_1);JButton btnNewButton_2 = new JButton("\u65B0\u589E");btnNewButton_2.setBackground(new Color(243, 184, 194));btnNewButton_2.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {dispose();new AddFrame().setVisible(true);}});btnNewButton_2.setForeground(new Color(95, 87, 236));btnNewButton_2.setFont(new Font("华文行楷", Font.BOLD, 24));btnNewButton_2.setBounds(447, 582, 172, 43);contentPane.add(btnNewButton_2);}}