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("員工管理系統(tǒng)");
	JPanel p = new JPanel();
	JTable table = new JTable();
	JLabel label = new JLabel();
	JScrollPane scroll = new JScrollPane();
	/**
	 * @param args
	 */
	public void init(){
		mainFrame.add(p, BorderLayout.CENTER);
		mainFrame.pack();
		mainFrame.setSize(new Dimension(400,300));
		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);
		scroll.add(table,BorderLayout.CENTER);
		mainFrame.add(label,BorderLayout.NORTH);
		label.setText("員工信息如下：");
		getEmployees();
		mainFrame.setVisible(true);
	}
	public void getEmployees(){
		DefaultTableModel dt = new DefaultTableModel();
		ResultSet rs = DAO.getEmployee();
		String[] tableHeaders = new String[]{"d","d","d","d","d","d","d"};
		//dt.setColumnIdentifiers(tableHeaders);
		dt.addRow(tableHeaders);
		try{
			ResultSetMetaData rsmd = rs.getMetaData();
			int numOfCol = rsmd.getColumnCount();
			int b = 1;
			while(b<=numOfCol){
				dt.addColumn(rsmd.getColumnName(b));
				b++;
			}
			//table.setAutoCreateColumnsFromModel(true);
			while(rs.next()){
				Vector newRow = new Vector();
				int c = 1;
				while(c<=numOfCol){
					newRow.addElement(rs.getString(c));
					c++;
				}
				dt.addRow(newRow);
			}
		}catch(Exception ex){
			System.out.println(ex.getMessage());
		}
		table.setModel(dt);
		
		
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		EmployeeManager em = new EmployeeManager();
		em.init();
		

	}

}