package com.lib.db.oper;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import com.lib.DBConnection;
import com.lib.db.Borr;

//登錄操作
public class Login {
	// 用flag來標識 登錄狀態
	// flag == n 未登錄
	// flag == a 管理員
	// flag == b 學生或老師(借閱者)
	public static char FLAG = 'n';
	// 登錄ID記錄(保存到Borr值對象中)
	public static Borr BORR = null;
	

	public static Connection con = DBConnection.getConnection();

	/**
	 * 通過對lib_admin表和lib_borrower表中 查詢 管理員或用戶 的名字,得到其密碼,用于登錄時密碼確認
	 * 
	 * @param username
	 * @return
	 */
	public static String getPwd(String username) {
		String tmppwd = null;		
		Statement stmt = null;
		
		String str = "Select pwd from lib_admin where admin_id = '"+username+"'";

		String str1 = "Select * from lib_borr where login = '"+username+"'";
		try {
			stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(str);
			if (rs.next()) {
				tmppwd = rs.getString("pwd");
				FLAG = 'A';
			} else {
				rs.close();
				System.out.println("檢查是否為用戶登錄");
				rs = stmt.executeQuery(str1);
				if (rs.next()) {
					System.out.println("用戶登錄");					
					
					
					String card_id = rs.getString("card_id");
					String borrower_id = rs.getString("borrower_id");
					String borrower = rs.getString("borrower");
					//String login = rs.getString("login");
					String login = username;
					String email = rs.getString("email");
					String phone = rs.getString("phone");
					String isStudent = rs.getString("isStudent");
					int borrow_num = rs.getInt("borrow_num");
					
					tmppwd = rs.getString("pwd");
					FLAG = 'B';
					
					BORR = new Borr(card_id, borrower_id, borrower, login, tmppwd, email, phone, isStudent, borrow_num);
				}
			}
		}catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				stmt.close();
				// con.close();
			} catch (Exception ee) {
				ee.printStackTrace();
			}
		}
		return tmppwd;

	}
}