hibernate 查询语句数据库

我写个简单的例子，楼主可以参考下public int getLogin(String username,String password)
{ String sql="select * from user_table where username=? and password=?";
SQLQuery query=getSession().createSQLQuery(sql).addEntity(UserTable.class);
query.setString(0,username);
query.setString(1,password);
return Integer.parseInt(query.uniqueResult().toString());

}
public static void main(String[] args) {
new UserTableDAO().getLogin("zhang","yuan");
}

---

　　H将SQL语句封装了 直接调用H里的方法

---

　　如何用hibernate直接进行sql语句查询
public int getlogin(string username,string password)
{ string sql="select * from user_table where username=? and password=?";
sqlquery query=getsession().createsqlquery(sql).addentity(usertable.class);
query.setstring(0,username);
query.setstring(1,password);
return integer.parseint(query.uniqueresult().tostring());

}
public static void main(string[] args) {
new usertabledao().getlogin("zhang","yuan");
}

---

　　String sql="SQL语句";session.createSqlQuery(sql);