package frame;

import java.sql.*;
import com.DAO;
import java.awt.*;
import java.awt.Dimension;
import java.awt.Toolkit;
import model.FrameInit;
import javax.swing.*;
import java.awt.event.*;
public class QueryCondition extends JFrame{
	JFrame qc = new JFrame("條件查詢員工信息");
	JPanel p = new JPanel();
	JPanel p1 = new JPanel();
	JComboBox cbo = new JComboBox();
	JComboBox cbocon = new JComboBox();
	JLabel lblcon = new JLabel("請選擇查詢條件");
	JButton btnquery = new JButton("查詢");
	JTable tb = new JTable();
	JScrollPane scroll = new JScrollPane(tb);
	public QueryCondition(){
		init();
	}
	public void init(){
		FrameInit.InitFrame(qc, p);
		qc.add(p1,BorderLayout.NORTH);
		p1.add(lblcon);
		cbo.addItem("人員編碼");
		cbo.addItem("姓名");
		cbo.addItem("職務");
		cbo.addItem("年齡");
		cbo.addItem("性別");
		cbo.addItem("職稱");
		cbo.addItem("部門");
		cbo.addItem("受聘時間");
		cbo.addItem("籍貫");
		cbo.addItem("學位");
		cbo.addItem("政治面貌");
		p1.add(cbo);
		cbo.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				String con = cbo.getSelectedItem().toString().trim();
				if(con.equals("人員編碼")){
					try{
						ResultSet rs = DAO.getEmployeeId();
						while(rs.next()){
							cbocon.addItem(new Integer((rs.getInt("empid"))));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("姓名")){
					try{
						ResultSet rs = DAO.getEmployeeName();
						while(rs.next()){
							cbocon.addItem(rs.getString("ename"));
						}
					}catch(Exception ex){
						System.out.println(ex.getMessage());
					}
				}
				if(con.equals("職務")){
					
				}
				if(con.equals("年齡")){
					
				}
				if(con.equals("性別")){
					
				}
				if(con.equals("職稱")){
					
				}
				if(con.equals("部門")){
					
				}
				if(con.equals("受聘時間")){
					
				}
				if(con.equals("籍貫")){
					
				}
				if(con.equals("學位")){
					
				}
				if(con.equals("政治面貌")){
					
				}
				
			}
		});
		p1.add(cbocon);
		p1.add(btnquery);
		btnquery.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				String con = cbo.getSelectedItem().toString().trim();
				String conc = cbocon.getSelectedItem().toString();
				
			}
		});
		qc.setVisible(true);
		
	}
	private void setupComponent(JComponent component,int gridx,int gridy,
			int gridwidth,int ipadx,boolean fill){
		final GridBagConstraints g = new GridBagConstraints();
	}
}