package myBeans;
import java.sql.*;

public class Query {
	String Eno,name,sex,age,Department,email,phone,EnrollmentDate,monthWorkLoad,yearWorkLoad;
	String message;
	Connection con;
	Statement sql;
	ResultSet rs;
	public Query(){
		//加載橋接器
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
	}
	//設(shè)置屬性值、獲取屬性值的方法
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	public String getDepartment() {
		return Department;
	}
	public void setDepartment(String department) {
		Department = department;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getEno() {
		return Eno;
	}
	public void setEno(String eno) {
		Eno = eno;
	}
	public String getEnrollmentDate() {
		return EnrollmentDate;
	}
	public void setEnrollmentDate(String enrollmentDate) {
		EnrollmentDate = enrollmentDate;
	}
	public String getMonthWorkLoad() {
		return monthWorkLoad;
	}
	public void setMonthWorkLoad(String monthWorkLoad) {
		this.monthWorkLoad = monthWorkLoad;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getYearWorkLoad() {
		return yearWorkLoad;
	}
	public void setYearWorkLoad(String yearWorkLoad) {
		this.yearWorkLoad = yearWorkLoad;
	}
	
	//查詢員工信息
	public String getMessage(){
		try{
			con=DriverManager.getConnection("jdbc:odbc:bysj","","");
			sql=con.createStatement();
			String condition="SELECT * FROM employees";
			System.out.println(condition);
			rs=sql.executeQuery(condition);
			int rowcount=0;
			while(rs.next()){
				rowcount++;
				System.out.print("員 工 號 "+rs.getString("Eno"));
				System.out.print("姓    名 "+rs.getString("name"));
				System.out.print("性    別 "+rs.getString("sex"));
				System.out.print("出生年月 "+rs.getDate("age"));
				System.out.print("部門名稱 "+rs.getString("Department"));
				System.out.print("電子郵箱 "+rs.getString("email"));
				System.out.print("電    話 "+rs.getString("phone"));
				System.out.print("上崗時間 "+rs.getString("EnrollmentDate"));
				System.out.print("月工作量 "+rs.getString("monthWorkLoad"));
				System.out.println("年工作量 "+rs.getString("yearWorkLoad"));
			}
			if (rowcount!=0){
				 message="ok";
			}else{
				System.out.println("目前沒有記錄");
				 message="empty";
			}
			con.close();
			return message;
		}catch(SQLException e){
			message="empty";
			return message;
		}
	}
}