10d9b2c12bab001d19d3cf3b8b331509

超好用的企业员工信息管理系统

package frame;

import com.DAO;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import java.sql.*;
import java.util.*;
public class EmployeeManager extends JFrame {
	//主窗体
	JFrame mainFrame = new JFrame("员工管理系统");
	JPanel p = new JPanel();
	JTable table = new JTable();
	JLabel label = new JLabel();
	//将JTable放入JScrollPane中
	JScrollPane scroll = new JScrollPane(table);
	JButton btnQuery = new JButton("查询");
	/**
	 * @param args
	 */
	public void init(){
		//向Frame中添加panel
		mainFrame.add(p, BorderLayout.CENTER);
		mainFrame.pack();
		//设置默认的关闭方式
		mainFrame.setDefaultCloseOperation(EXIT_ON_CLOSE);
		mainFrame.setSize(new Dimension(500,400));
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
		Dimension frameSize = mainFrame.getSize();
		if(frameSize.height > screenSize.height){
			frameSize.height = screenSize.height;
		}
		if(frameSize.width > screenSize.width){
			frameSize.width = screenSize.width;
		}
		mainFrame.setLocation((screenSize.width-frameSize.width)/2,
				(screenSize.height-frameSize.height)/2);
		p.setLayout(new BorderLayout());
		p.add(scroll,BorderLayout.CENTER);
		mainFrame.add(label,BorderLayout.NORTH);
		mainFrame.add(btnQuery,BorderLayout.SOUTH);
		btnQuery.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				label.setText("员工信息如下：");
				getEmployees();
			}
		});
		
		mainFrame.setVisible(true);
	}
	/**
	 * 获取所有员工的信息，将其显示到JTable中
	 *
	 */
	public void getEmployees(){
		//TableModel的一个实现，使用一个Vector来存储单元个的值对象，构造一个零行零列的表
		DefaultTableModel dt = new DefaultTableModel();
		//从数据库得到结果集
		ResultSet rs = DAO.getEmployee();
		try{
			//用于获取ResultSet对象中列的类型和属性的对象
			ResultSetMetaData rsmd = rs.getMetaData();
			//得到列的数量
			int numOfCol = rsmd.getColumnCount();
			int b = 1;
			//向TableModel中添加列
			while(b<=numOfCol){
				dt.addColumn(rsmd.getColumnName(b));
				b++;
			}
			table.getTableHeader().setVisible(true);
			//table.setAutoCreateColumnsFromModel(true);
			//将结果集中的每条记录封装到vector向量中
			while(rs.next()){
				Vector newRow = new Vector();
				int c = 1;
				while(c<=numOfCol){
					newRow.addElement(rs.getString(c));
					c++;
				}
				//向TableModel中添加行
				dt.addRow(newRow);
			}
		}catch(Exception ex){
			System.out.println(ex.getMessage());
		}
		//将Table的数据模型设置为dt
		table.setModel(dt);
		//scroll.setViewportView(table);
		
		
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		EmployeeManager em = new EmployeeManager();
		em.init();
		

	}

}