package com.jxyd.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.jxyd.sql.Mysql;
import com.jxyd.sql.SimpleSqlControl;
import com.jxyd.vo.AdminBean;
import com.jxyd.vo.UserBean;

public class LoginDAO {
	private String User_table = "user";
	private String Admin_table = "admin";

	/**
	 * 用戶登錄驗證 sign為1時表示管理員登錄驗證，為2時表示用戶
	 * 
	 * @param username
	 * @param pwd
	 * @param sign
	 * @return
	 */
	public boolean LoginValidate(String username, String pwd, Integer sign) {
		boolean flag = false;
		String sql = null;
		Mysql ms = new Mysql();
		if (sign == 1) {
			sql = "select * from " + Admin_table + " where WorkNum='"
					+ username + "' and Password='" + pwd + "'";
		} else if (sign == 2) {

			sql = "select * from " + User_table + " where UserId='" + username
					+ "' and Password='" + pwd + "'";
		}
		try {
			ms.prepareStatement(sql);
			ResultSet rs = ms.executeQuery(sql);
			if (rs.next()) {
				flag = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			ms.freeResource();
		}
		return flag;
	}
	
	public UserBean selectuser(String username){
		String sql="select * from "+User_table+" where UserId="+username;
		SimpleSqlControl scon=new SimpleSqlControl();
		UserBean ub=null;
		try {
			ub=(UserBean)scon.sqlSearchObject(sql, "com.jxyd.vo.UserBean");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return ub;
	}
	
	public AdminBean selectadmin(String username){
		String sql="select * from "+Admin_table+" where WorkNum="+username;
		SimpleSqlControl scon=new SimpleSqlControl();
		AdminBean ab=null;
		try {
			ab=(AdminBean)scon.sqlSearchObject(sql, "com.jxyd.vo.AdminBean");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return ab;
	}

}