Service层调用hibernete的findByPrimaryId(s),控制台没有sql语句执行,可获取到对象,对象内实体类状态status为1;Service层调用hibernete的findByPojo(Class<?> className)返回的list中status为1,sql直接在数据库运行,查询的记录里status为10,其余值一致。
//逻辑代码
WorkItem workItem =new WorkItem();
workItem.setId(workItemId);
List<POJO> iList = serviceWorkItem.findByPOJO(workItem);
if(iList !=null &&!iList.isEmpty()){
workItem = (WorkItem) iList.get(0);
}else{
throw new OperationsException(TransCode.ERROR_QUERYIMG.getCode());
}
//WorkItem workItem = (WorkItem) serviceWorkItem.findByPrimaryId(workItemId);
if(workItem!=null){
int ocrStatue = workItem.getStatus();
//实体类
/**
* 返回状态属性的值
* @return Integer
*/
public Integer getStatus() {
return this.status;
}
/**
* 设置状态的值
* @param status Integer
*/
public void setStatus(Integer status) {
this.status = status;
}
```![图片说明](https://img-ask.csdn.net/upload/201905/21/1558427281_248287.png)
sql语句:SELECT
this_.ID AS ID21_0_,
this_. CODE AS CODE21_0_,
this_. NAME AS NAME21_0_,
this_. STATUS AS STATUS21_0_,
this_.DESCRIPTION AS DESCRIPT5_21_0_,
this_.TYPE AS TYPE21_0_,
this_.ROLE AS ROLE21_0_,
this_.OPERATOR AS OPERATOR21_0_,
this_.CREATE_TIME AS CREATE9_21_0_,
this_.FINISH_TIME AS FINISH10_21_0_,
this_.ACQUIRE_TIME AS ACQUIRE11_21_0_,
this_.EX_OPERATOR1 AS EX12_21_0_,
this_.EX_OPERATOR2 AS EX13_21_0_,
this_.SCAN_BATCH_ID AS SCAN14_21_0_,
this_.BATCH_ID AS BATCH15_21_0_,
this_.IMAGE_ID AS IMAGE16_21_0_,
this_.PRIORITY AS PRIORITY21_0_,
this_.BIZ_DATE AS BIZ18_21_0_,
this_.CH_WORKLOAD AS CH19_21_0_,
this_.EN_WORKLOAD AS EN20_21_0_,
this_.FIELD_NUM AS FIELD21_21_0_,
this_.VALID_OPER AS VALID22_21_0_,
this_.VALID_FIELD_NUM AS VALID23_21_0_,
this_.PROJECT_ID AS PROJECT24_21_0_,
this_.BILL_ID AS BILL25_21_0_,
this_.PROCESS_TIME AS PROCESS26_21_0_,
this_.BATCH_CTIME AS BATCH27_21_0_,
this_.IMAGE_BLOCK_ID AS IMAGE28_21_0_,
this_.EX_WORK_ITEM_ID AS EX29_21_0_,
this_.INPUT_NO AS INPUT30_21_0_,
this_. MONTH AS MONTH21_0_,
this_. YEAR AS YEAR21_0_,
this_. DAY AS DAY21_0_,
this_.OPERATOR_NAME AS OPERATOR34_21_0_,
this_.QUEUE_NAME AS QUEUE35_21_0_,
this_.OBTAINED_TIME AS OBTAINED36_21_0_,
this_.UPDATE_ASS AS UPDATE37_21_0_
FROM
WORK_ITEM this_
WHERE
this_.ID ='4028abad6ad95dfc016ad963f3cf0002'