hibernate 执行原生sql,select返回string,long(1)

Java代码  

1. public void deleteTbTest(Long id) {

2. String hql = “DELETE FROM TbTest WHERE ID = ?”;

3. this.getSession().createQuery(hql).setLong(0, id).executeUpdate();

4. }

Java代码  

1. public void updateTbTest(Date date, boolean flag) {

2. String sql = “update tb_test set t_name=? where t_status!=1 and t_date” + (flag ? “<?” : “=?”);

3. SQLQuery query = this.getSession().createSQLQuery(sql);

4. query.setString(0,flag ? “hello”: “hi”).setDate(1, date).executeUpdate();

5. }

3.执行sql，查询单表中多条数据

//尽量避免适用"*"

String sql = “select * from employee e where e.valid=1 and not exists (select employeeid from attendance a where a.employeeid=e.employeeid and a.date = ?)”;

SQLQuery query = getSession().createSQLQuery(sql);

query.addEntity(Employee.class).setDate(0, day);

List retList = query.list();

4.查询多表

Java代码