package cn.rludrea.model;
import java.sql.*;

public class studentBeanBO {
	
	//定義一些變量[]；
	private ResultSet rs=null;
	private Connection ct=null;
	private PreparedStatement ps=null;
	
	/**
	 * @author rludrea
	 * 這是一個驗證該學生的用戶名密碼是否正確，正確則登陸，失敗則返回原來的頁面；
	 * @param stuName 
	 * @param stuPwd
	 * @return b;
	 */
	public boolean LoginCheak(String stuName,String stuPwd)
	{
		boolean b=false;
		try
		{
			ct=new ConnDB().getConn();
			ps=ct.prepareStatement("select top 1 stuPwd from student where stuName=?");
			ps.setString(1, stuName);
			rs=ps.executeQuery();
			if(rs.next())
			{
				String stupasswd=rs.getString(1);
				if(stupasswd.equals(stuPwd))
				{
					b=true;
				}
			}
			
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			new close().Close();
		}
		return b ;
	}
}