sql hql 查询

package cn.grassinfo.rmon.system.dao.impl;


@Repository("registcodeDao")
public class RegistcodeDaoImpl extends BaseDaoImpl<Registcode, Long> implements
RegistcodeDao{
// @Resource
// public void setDao(RegistcodeDao dao) {
// this.dao = dao;
// }
@SuppressWarnings("unchecked")
@Override
public Date getDate(String number) {
// TODO Auto-generated method stub
//sql查询
Session session = getSession();
SQLQuery query=session.createSQLQuery("select * from sm_t_registcode where PhoneNumber='"+number+"'");
query.addEntity(Registcode.class);
List<Registcode> list=query.list();

//hql查询
Registcode rg = new Registcode();
rg.setPhoneNumber(number);
String hql = "from Registcode r where r.phoneNumber=:phoneNumber";
List<Registcode> list3 =this.queryHQL(hql, rg);

return (Date)list.get(0).getUpdateDate();

}
}