我现在有一个数据库webases中有userinfo表,主键是id varchar(45),想用creatQuery查询id为yet的密码 password,进行登陆验证。但是怎么查找都查不到。(数据库中有id为yet的信息.)
public Userinfo getUserAccount(String username){
try{
session = SessionFactory.currentSession();
tx = session.beginTransaction();
Userinfo userinfo;
SQLQuery sqlQuery = session.createSQLQuery("select s.id as {user.id}," +
"s.password as {user.password} " +
"from userinfo s where s.id='" + username + "'");
sqlQuery.addEntity("user",Userinfo.class); //加入查询实体
it = sqlQuery.list().iterator(); //执行查询
tx.commit(); //提交查询
if(it.hasNext()){
userinfo = (Userinfo) it.next();
return userinfo;
}
else{
userinfo = null;
return userinfo;
}
}catch(HibernateException e){
e.printStackTrace();
if(tx != null){
tx.rollback();
}
return null;
}finally{
session.close();
}
}查询语句是select s.id as {user.id},s.password as {user.password} from userinfo s where s.id='" + username + "'"
我后来换成了select * from webases.userinfo 都查询不到结果.不知是哪里出错了.还忘大侠们指点.谢谢!
public Userinfo getUserAccount(String username){
try{
session = SessionFactory.currentSession();
tx = session.beginTransaction();
Userinfo userinfo;
SQLQuery sqlQuery = session.createSQLQuery("select s.id as {user.id}," +
"s.password as {user.password} " +
"from userinfo s where s.id='" + username + "'");
sqlQuery.addEntity("user",Userinfo.class); //加入查询实体
it = sqlQuery.list().iterator(); //执行查询
tx.commit(); //提交查询
if(it.hasNext()){
userinfo = (Userinfo) it.next();
return userinfo;
}
else{
userinfo = null;
return userinfo;
}
}catch(HibernateException e){
e.printStackTrace();
if(tx != null){
tx.rollback();
}
return null;
}finally{
session.close();
}
}查询语句是select s.id as {user.id},s.password as {user.password} from userinfo s where s.id='" + username + "'"
我后来换成了select * from webases.userinfo 都查询不到结果.不知是哪里出错了.还忘大侠们指点.谢谢!
解决方案 »
- sql2005 或者2000中新手问题,建立表
- 【【【【【【【【【【【请问如何设置扫描仪进行连续扫描】】】】】】】】】~~~~~~~~在线等
- 表单多下拉列表的处理---大虾请进
- 我刚发的帖子怎么找不着了?
- 求一正则表达式
- 关于tomcat的问题
- 怎么在Action中读取表单上输入框的值,急用,在线等!!thx!!
- 修改了resin.conf中的<war-dir id='webapps'/>后,为什么session不能正确显示了
- 大家用什么工具预编译JSP文件?
- jspsmartupload的设置问题,如能回答正确再加50分!!
- JSP与ORACLE简单的问题,请前辈帮帮忙,多谢多谢!!!!!!!!!!!!!!!!!!!!!!!!!
- 下载RAR格式的文件出错
String password = user.getPassword();你的HQL好复杂啊
按照你的做法HQL我会这样写select user.password from Userinfo as user where id=yet