xiachong_xie 2019-05-21 16:35 采纳率: 0%
浏览 242
已结题

findByPojo查值放入对象中和sql在数据库直接执行值不匹配,求救?

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'
  • 写回答

1条回答 默认 最新

  • dabocaiqq 2019-05-22 09:04
    关注
    评论

报告相同问题?

悬赏问题

  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 对于相关问题的求解与代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料