package com.mitsui.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.mitsui.domain.Admin;
import com.mitsui.util.ConnectionUtil;

public class AdminDao {
	public Admin queryAdmin(Admin Admin){
		String sql = "select * from administrator where admin_username = ?";
		Connection conn = ConnectionUtil.getConection();
		PreparedStatement ps = null;
		try {
			ps = conn.prepareStatement(sql);
			ps.setObject(1, Admin.getAdmin_username());
			ResultSet rs = ps.executeQuery();
			Admin u = null;
			if(rs.next()){
				Integer admin_id = rs.getInt("admin_id");
				String admin_username = rs.getString("admin_username");
				String admin_password = rs.getString("admin_password");
				//u = new Staff(p_id, p_name, sex, degree, department, position, state, user_name,user_password);
				u=new Admin(admin_id,admin_username,admin_password);
			}
			if(u.getAdmin_password().equals(Admin.getAdmin_password())){
				return u;
			}else{
				return null;
			}
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}
	}
}