package com.blogspot.sontx.web.helloworld.model.dao;

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

import com.blogspot.sontx.web.helloworld.model.bean.Account;

import net.ucanaccess.jdbc.UcanaccessDriver;

public class ProcessLoginDAO {
	// đường dẩn đến file csdl của bạn
	private String url = UcanaccessDriver.URL_PREFIX + "D:/admin.accdb";
	private String driver = "net.ucanaccess.jdbc.UcanaccessDriver";
	private Connection cnn = null;
	private Statement stm = null;

	public boolean checkLogin(String username, String password){
	 	try {
	 	 	ResultSet rs = stm.executeQuery("SELECT username, password FROM admin");
	 	 	while(rs.next()){
	 	 	 	if(username.equals(rs.getString("username")) && password.equals(rs.getString("password"))){
	 	 	 		rs.close();
	 	 	 		return true;
	 	 	 	}
	 	 	}
	 	 	rs.close();
	 	} catch (SQLException e) {
	 		e.printStackTrace();
	 	}
	 	return false;
	}

	public ProcessLoginDAO(){
	 	try {
	 	 	Class.forName(driver);
	 	 	// 2 đối số cuối cùng ta truyền chuổi rổng vì csdl của ta
	 	 	// không có user và password
	 	 	cnn = DriverManager.getConnection(url, "", "");
	 	 	stm = cnn.createStatement();
	 	} catch (ClassNotFoundException | SQLException e) {
	 	 	e.printStackTrace();
	 	}
	}

	public Account getAccount(String username) {
	 	Account account = null;
	 	try {
	 	 	ResultSet rs = stm.executeQuery("SELECT * FROM info WHERE username = '" + username + "'");
	 	 	if(rs.next()){
	 	 	 	account = new Account();
	 	 	 	account.setUserName(rs.getString("username"));
	 	 	 	account.setFullName(rs.getString("fullname"));
	 	 	 	account.setAge(rs.getInt("age"));
	 	 	 	account.setAddress(rs.getString("address"));
	 	 	}
	 	 	rs.close();
	 	} catch (SQLException e) {
	 	 	e.printStackTrace();
	 	}
	 	return account;
	}
}