hibernate list和pojo/*** 用户登录*/public Userinfo login(String schoolid,String username,String pas
hibernate list和pojo
/**
* 用户登录
*/
public Userinfo login(String schoolid,String username,String password) {
String sql="from Userinfo where schoolid='"+schoolid+"'";
if(!username.equals("")){
sql = sql+"and username='"+username+"'";
}
if(!password.equals("")){
sql = sql+"and password='"+password+"'";
}
List<Userinfo> list = this.baseDao.query(sql);
if (list != null && list.size() > 0) {
return list.get(0);
} else {
return null;
}
}
?
?
/**
* 我的课程
*/
public List<Course> Mycourse(String Schoolid,int pag, int pagesize,String cataid) {
?
String sql = "from Course where schoolid='"+Schoolid+"' and cataid='"+cataid+"'";
return baseDao.query(sql, pag, pagesize);
}