使用方法:
String hql = " select {pro. * } from T_ES_PreengageOdd pro where 1 = 1 ";
SQLQuery sqlQuery = this.getSession().createSQLQuery(hql);
sqlQuery.addEntity("pro",PreengageOddPO.class);
List list = sqlQuery.list();
return list;
说明:T_ES_PreengageOdd是你数据库中实际的表名.
PreengageOddPO是你PO对象,它对应映射成表T_ES_PreengageOdd.
String hql = " select {pro. * } from T_ES_PreengageOdd pro where 1 = 1 ";
SQLQuery sqlQuery = this.getSession().createSQLQuery(hql);
sqlQuery.addEntity("pro",PreengageOddPO.class);
List list = sqlQuery.list();
return list;
说明:T_ES_PreengageOdd是你数据库中实际的表名.
PreengageOddPO是你PO对象,它对应映射成表T_ES_PreengageOdd.
SQLQuery sqlQuery1
=
this.getSession().createSQLQuery(
" select {ep. * } from T_ES_Equipment ep where ep.CHNNAME like :equipname and ep.equip_id = :equipid");
sqlQuery1.addEntity("ep", EquipmentPO.class);
sqlQuery1.setString("equipname", " % 系统 % ");
sqlQuery1.setString("equipid", " 11020874 ");
List result = sqlQuery1.list();
if (result != null && result.size() > 0 ) {
for ( int i = 0 ; i < result.size(); i ++ ) {
EquipmentPO equipmentPO = (EquipmentPO) result.get(i);
System.out.println("equipname ===> " + equipmentPO.getChineseName());
}
}
打印结果:
equipname ===> 气质系统
" select {ep. * } from T_ES_Equipment ep where ep.CHNNAME like :equipname and ep.equip_id = :equipid");
sqlQuery1.addEntity("ep", EquipmentPO.class);
sqlQuery1.setString("equipname", " % 系统 % ");
sqlQuery1.setString("equipid", " 11020874 ");
List result = sqlQuery1.list();
if (result != null && result.size() > 0 ) {
for ( int i = 0 ; i < result.size(); i ++ ) {
EquipmentPO equipmentPO = (EquipmentPO) result.get(i);
System.out.println("equipname ===> " + equipmentPO.getChineseName());
}
}
打印结果:
equipname ===> 气质系统