employee_ui.java

桌面销售管理系统 JDBC的基本应用

import javax.swing.JPanel;
import java.awt.GridLayout;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.JButton;
import javax.swing.table.DefaultTableModel;
import javax.swing.BorderFactory;
import javax.swing.JRadioButton;
import javax.swing.ButtonGroup;
import java.util.HashMap;
import dal.Employee;
import dal.Department;
import javax.swing.JOptionPane;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
public class Employee_UI extends JPanel
{
	String id;
	HashMap hm=new HashMap();
	String[] columns={"员工编号","所属部门","姓名","性别","年龄","电话","住址"};
	DefaultTableModel model=new DefaultTableModel(columns,0);
	JTable table=new JTable(model);
	JLabel l1=new JLabel("员工所属部门:");
	JLabel l2=new JLabel("员工姓名:");
	JLabel l3=new JLabel("员工性别:");
	JLabel l4=new JLabel("员工年龄:");
	JLabel l5=new JLabel("员工电话:");
	JLabel l6=new JLabel("员工住址:");
	JLabel l7=new JLabel("你将要删除的员工:");
	JLabel l8=new JLabel("根据员工姓名查询:");
	JLabel l9=new JLabel("根据所属部门查询:");
	JComboBox cb1=new JComboBox();
	JComboBox cb2=new JComboBox();
	JTextField txt_name=new JTextField(12);
	JRadioButton r1=new JRadioButton("男");
	JRadioButton r2=new JRadioButton("女");
	JTextField txt_age=new JTextField(12);
	JTextField txt_tel=new JTextField(12);
	JTextField txt_address=new JTextField(12);
	
	JTextField txt_name1=new JTextField(12);//删除旁边的一个文本框
	JTextField txt_key=new JTextField(12);//输入要查训脑惫ば彰