studentbeanbo.java

课程管理系统

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 ;
	}
}