-
public void deleteTbTest(Long id) {
-
String hql = “DELETE FROM TbTest WHERE ID = ?”;
-
this.getSession().createQuery(hql).setLong(0, id).executeUpdate();
-
}
-
public void updateTbTest(Date date, boolean flag) {
-
String sql = “update tb_test set t_name=? where t_status!=1 and t_date” + (flag ? “<?” : “=?”);
-
SQLQuery query = this.getSession().createSQLQuery(sql);
-
query.setString(0,flag ? “hello”: “hi”).setDate(1, date).executeUpdate();
-
}
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代码