package com.xuanke.student.model;

import java.sql.*;

import com.xuanke.utils.JDBCBase;
import com.xuanke.utils.MyJDBCException;

public class UserDAO extends JDBCBase {

	public UserDAO(Connection conn) {
		super(conn);
	}

	public UserBean findUser(String username,String password) throws MyJDBCException {
		
		UserBean result = null;
		String sql = "select * from Users where ID='" +username+ "' and Pass='"+password+"'";
		ResultSet rs = this.qry(sql);
		if (rs == null)
			return null;
			
		try {
			rs.beforeFirst();
			if (rs.next()) {
				UserBean bean = new UserBean();
				bean.setUsername(rs.getString(1));
				bean.setPassword(rs.getString(2));
				result = bean;
			}
			rs.getStatement().close();
		} catch (SQLException e) {
			// TODO 自動生成 catch 塊
			throw new MyJDBCException("讀取數據失敗");
		}

		return result;
	}
	
	

}