//員工信息查詢類




package classsource;

import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.JScrollPane.*;
import java.sql.*;

public class BIQ extends JInternalFrame{

	JLabel lbl1=new JLabel("基 本 信 息 查 詢");
   	JLabel lbl2=new JLabel("員工編號：");
   	JLabel lbl3=new JLabel("員工姓名：");
   	JTextField btxtid=new JTextField(10);
   	JTextField btxtname=new JTextField(10);
   	JButton btn1=new JButton("查詢");

   	JTable table;
	DefaultTableModel dtm;

    String columns[] = {"員工編號","員工姓名"," 性別 ","出生日期","婚姻狀況","政治面貌"," 學歷 ","進入公司時間","轉正時間"," 部門 "," 職務 ","員工狀態"," 備注 "};
	public BIQ(){
		setTitle("基 本 信 息 查 詢");

		dtm = new DefaultTableModel();
		table = new JTable(dtm);


		JScrollPane sl = new JScrollPane();
		sl.getViewport().add(table);
		dtm.setColumnCount(5);
		dtm.setColumnIdentifiers(columns);
	//	sl.getViewport().add(table,null);

	    //sl.setVerticalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
		//sl.setver
//
//		sl.HORIZONTAL_SCROLLBAR_ALWAYS;
//		sl.VERTICAL_SCROLLBAR_ALWAYS;
		//new JScrollPane().add(table);

		//dtm.setColumnCount(columns.length);
	//	dtm.insertRow(0,columns);

		//sl.setAutoscrolls(true);
		//設列頭
/*		dtm.setColumnIdentifiers(columns);
		TableColumnModel tcm = table.getColumnModel();
		for(int i=0;i<columns.length;i++)
		{
			tcm.getColumn(i).setWidth(180);
		}
---------------------------------------------------------------------------------
*/

		getContentPane().setLayout(null);
		lbl1.setBounds(240,10,300,30);
		lbl1.setFont(new Font("宋體",Font.BOLD,24));
		getContentPane().add(lbl1);

		Font f=new Font("宋體",Font.PLAIN,12);
		lbl2.setBounds(10,60,80,25);
		lbl2.setFont(f);
		getContentPane().add(lbl2);
		btxtid.setBounds(80,60,80,23);
		btxtid.setFont(f);
		getContentPane().add(btxtid);
		lbl3.setBounds(10,90,80,25);
		lbl3.setFont(f);
   	    getContentPane().add(lbl3);
   	    btxtname.setBounds(80,90,80,23);
   	    btxtname.setFont(f);
   	    getContentPane().add(btxtname);
   	    btn1.setBounds(90,130,60,25);
   	    btn1.setFont(f);
   	    getContentPane().add(btn1);


		sl.setBounds(180,60,500,370);
		getContentPane().add(sl);

		//設置邊框
        btxtid.setBorder(BorderFactory.createLineBorder(Color.black));
   	    btxtname.setBorder(BorderFactory.createLineBorder(Color.black));
   	    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
        sl.setBorder(BorderFactory.createLineBorder(Color.black));

//----連接數據庫--------------------------------------------------------------------------
		Database.joinDB();
		String sql="select * from EmployeeInformation";
		if(Database.query(sql)){
		   System.out.println(sql);
		   try{
		   	  while(Database.rs.next()){
		   	  	 String eNumber=(""+Database.rs.getInt("E_Number"));
		   	  	 System.out.println(eNumber);
		   	  	 String eName=Database.rs.getString("E_Name");
		   	  	 System.out.println(eName);
		   	  	 String eSex=Database.rs.getString("E_Sex");
		   	  	 System.out.println(eSex);
		   	  	 String eBornDate=Database.rs.getString("E_BornDate");
		   	  	 System.out.println(eBornDate);
		   	  	 String eMarriage=Database.rs.getString("E_Marriage");
		   	  	 System.out.println(eMarriage);
		   	  	 String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
		   	  	 System.out.println(ePoliticsVisage);
		   	  	 String eSchoolAge=Database.rs.getString("E_SchoolAge");
		   	  	 System.out.println(eSchoolAge);
		   	  	 String eEnterDate=Database.rs.getString("E_EnterDate");
		   	  	 System.out.println(eEnterDate);
		   	  	 String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
		   	  	 System.out.println(eInDueFormDate);
		   	  	 String eDepartment=Database.rs.getString("E_Department");
		   	  	 System.out.println(eDepartment);
		   	  	 String eHeadship=Database.rs.getString("E_Headship");
		   	  	 System.out.println(eHeadship);
		   	  	 String eEstate=Database.rs.getString("E_Estate");
		   	  	 System.out.println(eEstate);
		   	  	 String eRemark=Database.rs.getString("E_Remark");
		   	  	 System.out.println(eRemark);

		   	     Vector v=new Vector();
		   	     v.add(eNumber);
				 v.add(eName);
				 v.add(eSex);
				 v.add(eBornDate);
				 v.add(eMarriage);
				 v.add(ePoliticsVisage);
				 v.add(eSchoolAge);
		   	     v.add(eEnterDate);
				 v.add(eInDueFormDate);
				 v.add(eDepartment);
				 v.add(eHeadship);
				 v.add(eEstate);
				 v.add(eRemark);
				 dtm.addRow(v);
		   	  }

		   }
		   catch(Exception eBIQ){
		     System.out.println("初始化數據失敗！");
		   }

		}
//為查詢按鈕加事件--------------------------------------------------------
		btn1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent eBIQ){
				System.out.println("按鈕事件");
				String esql;

        		int rc=dtm.getRowCount();
        		for(int i=0;i<rc;i++){
        			dtm.removeRow(0);
        		}
				if(btxtid.getText().equals("")&&btxtname.getText().equals("")){
				   esql="select * from EmployeeInformation";
				}
				else if(btxtname.getText().equals("")){
					esql="select * from EmployeeInformation where E_Number = '" + btxtid.getText() +"'";
					}
				else{
        		   esql="select * from EmployeeInformation where E_Number = '" + btxtid.getText() +"' or E_Name like '%"+ btxtname.getText() +"%'";
				}
				System.out.println(esql);
				if(Database.query(esql)){
				   try{
				   	  while(Database.rs.next()){
				   	  	 String eNumber=(""+Database.rs.getInt("E_Number"));
				   	  	 System.out.println(eNumber);
				   	  	 String eName=Database.rs.getString("E_Name");
				   	  	 System.out.println(eName);
				   	  	 String eSex=Database.rs.getString("E_Sex");
				   	  	 System.out.println(eSex);
				   	  	 String eBornDate=Database.rs.getString("E_BornDate");
				   	  	 System.out.println(eBornDate);
				   	  	 String eMarriage=Database.rs.getString("E_Marriage");
				   	  	 System.out.println(eMarriage);
				   	  	 String ePoliticsVisage=Database.rs.getString("E_PoliticsVisage");
				   	  	 System.out.println(ePoliticsVisage);
				   	  	 String eSchoolAge=Database.rs.getString("E_SchoolAge");
				   	  	 System.out.println(eSchoolAge);
				   	  	 String eEnterDate=Database.rs.getString("E_EnterDate");
				   	  	 System.out.println(eEnterDate);
				   	  	 String eInDueFormDate=Database.rs.getString("E_InDueFormDate");
				   	  	 System.out.println(eInDueFormDate);
				   	  	 String eDepartment=Database.rs.getString("E_Department");
				   	  	 System.out.println(eDepartment);
				   	  	 String eHeadship=Database.rs.getString("E_Headship");
				   	  	 System.out.println(eHeadship);
				   	  	 String eEstate=Database.rs.getString("E_Estate");
				   	  	 System.out.println(eEstate);
				   	  	 String eRemark=Database.rs.getString("E_Remark");
				   	  	 System.out.println(eRemark);

				   	     Vector v=new Vector();
				   	     v.add(eNumber);
						 v.add(eName);
						 v.add(eSex);
						 v.add(eBornDate);
						 v.add(eMarriage);
						 v.add(ePoliticsVisage);
						 v.add(eSchoolAge);
				   	     v.add(eEnterDate);
						 v.add(eInDueFormDate);
						 v.add(eDepartment);
						 v.add(eHeadship);
						 v.add(eEstate);
						 v.add(eRemark);
						 dtm.addRow(v);
				   	  }

				   }
				   catch(Exception eB){

				   }
				}

			}



		});


//------------------------------------------------------------------

    	setSize(700,480);
		this.setClosable(true);
		setVisible(true);
		}
	}