package cn.edu.qust.news.dao;

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

import cn.edu.qust.news.dao.AdminDao;
import cn.edu.qust.news.domain.Admin;
import cn.edu.qust.news.utils.JdbcUtil;

public class AdminDao {

	public AdminDao() {
		// TODO Auto-generated constructor stub
	}

	public Admin findAdminByName(String adminName) {
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtil.getConnection();
			stmt = conn
					.prepareStatement("select f_adminname from t_admin where f_adminname=?");
			stmt.setString(1, adminName);
			rs = stmt.executeQuery();
			if (rs.next()) {
				Admin admin = new Admin();
				admin.setAdminName(rs.getString("f_adminname"));
				return admin;
			} else
				return null;
		} catch (Exception e) {
			throw new RuntimeException(e);
		} finally {
			JdbcUtil.release(rs, stmt, conn);
		}
	}

	public Admin findAdmin(String adminName, String passWord) {
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtil.getConnection();
			stmt = conn
					.prepareStatement("select f_adminname,f_adminpassword from t_admin where f_adminname=? and f_adminpassword=?");
			stmt.setString(1, adminName);
			stmt.setString(2, passWord);
			rs = stmt.executeQuery();
			if (rs.next()) {
				Admin admin = new Admin();
				admin.setAdminName(rs.getString("f_adminname"));
				admin.setAdminPassWord(rs.getString("f_adminpassword"));
				return admin;
			} else
				return null;
		} catch (Exception e) {
			throw new RuntimeException(e);
		} finally {
			JdbcUtil.release(rs, stmt, conn);
		}
	}

	public void updateAdmin(String passWord) {
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		try {
			conn = JdbcUtil.getConnection();
			stmt = conn
					.prepareStatement("update t_admin set f_adminpassword=?");
			stmt.setString(1, passWord);
			stmt.executeUpdate();

		} catch (Exception e) {
			throw new RuntimeException(e);
		} finally {
			JdbcUtil.release(rs, stmt, conn);
		}
	}

}