teacherbeanbo.java

课程管理系统

//这个类是定义一些操作teacher表的一些方法；
package cn.rludrea.model;

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

public class teacherBeanBO {
	//定义一些变量[]；
	private ResultSet rs=null;
	private Connection ct=null;
	private PreparedStatement ps=null;
	public boolean  LoginCheck(String teaName,String teaPwd)
	{
		boolean b=false;
		try
		{
			ct=new ConnDB().getConn();
			ps=ct.prepareStatement("select top 1 teaPwd from teacher where teaName=?");
			ps.setString(1, teaName);
			rs=ps.executeQuery();
			if(rs.next())
			{
				if(teaPwd.equals(rs.getString(1)));
				{
					b=true;
				}
			}
		}catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			new close().Close();
		}
		return b;
	}
}