Mybatis获取不到查询结果

0 0

Mybatis获取不到查询结果0

配置文件如下：

<select id="searchHiddenListDetailList" parameterType="java.util.Map" resultType="AqGenerallyHidden">
        SELECT
            GENERALLY_HIDDEN_ID AS generallyHiddenId,
            CHECK_DATE AS checkDate,
            DICT_CHECK_TYPE_ID AS dictCheckTypeId,
            CHECK_DEPT_ID AS checkDeptId,
            HIDDEN_DEPT_ID AS hiddenDeptId,
            LAST_DEPT_ID AS lastDeptId,
            GENERALLY_PROBLEMS AS generallyProblems,
            RECTIFICATION_STATUS AS rectificationStatus,
            REPORTED_USER_NAME AS reportedUserName,
            REPORTED_USER_ID AS reportedUserId,
            REPORTED_DATE AS reportedDate,
            RECTIFICATION_DATE AS rectificationDate,
            DICT_WARN_LEVEL_ID AS dictWarnLevelId,
            CUR_WARN_LEVEL_ID AS curWarnLevelId,
            HIST_WARN_LEVEL_ID AS histWarnLevelId,
            REVIEW_USER_NAME AS reviewUserName,
            REVIEW_DATE AS reviewDate,
            THIRD_DEPT_ID AS thirdDeptId,
            HAZARD_ID AS hazardId,
            DICT_RECTIFICATION_TYPE_ID AS dictRectificationTypeId,
            CREATE_USER_NAME AS createUserName,
            DELAY_STATUS AS isDelayAudit,
            DELAY_AUDIT_STATUS AS delayAuditStatus,
            DELAY_AUDIT_USER_ID AS delayAuditUserId,
            DELAY_CONFIM_DATE AS delayConfimDate,
            RESPON_USER_ID AS responUserId,
            FOUR_CONFIRM_FLAG AS fourConfirmFlag,
            FOUR_CONFIRM_STATUS AS fourConfirmStatus,
            DICT_HIDDEN_LEVEL_ID AS dictHiddenLevelId,
            GENERALLY_ADDRESS AS generallyAddress,
            DICT_SPECIALTY_TYPE_ID AS dictSpecialtyTypeId,
            RECTIFICATION_MANDATE AS rectificationMandate,
            RECT_USER_ID AS rectUserId,
            DICT_BELONGS_PLATE_ID AS dictBelongsPlateId,
            DESTROY_STATUS AS destroyStatus,
            GENERALLY_HIDDEN_STATUS AS generallyHiddenStatus,
            PENALTY_POINTS AS penaltyPoints
        FROM AQ_GENERALLY_HIDDEN LEFT JOIN (SELECT CONFIG_ID,DICT_HIDDEN_LEVEL_ID FROM AQ_HAZARD_INFO, AQ_HAZARD_CONFIG WHERE AQ_HAZARD_INFO.HAZARD_ID = AQ_HAZARD_CONFIG.HAZARD_ID) TEMP
        ON AQ_GENERALLY_HIDDEN.HAZARD_ID = TEMP.CONFIG_ID
        <trim prefix="WHERE" prefixOverrides="AND | OR">
        <if test="subDeptId != null and subDeptId != ''">
           AND SUB_DEPT_ID = #{subDeptId}
        </if>
        <if test="startDate != null and startDate != ''">
           AND CHECK_DATE &gt;= #{startDate}
        </if>
        <if test="endDate != null and endDate != ''">
           AND CHECK_DATE &lt;= #{endDate}
        </if>
        <if test="checkDeptId != null and checkDeptId == '1'.toString()">
           AND CHECK_DEPT_ID NOT IN (11111111, 11111112, 11111113, 11111114, 11111115)
        </if>
        <if test="checkDeptId != null and checkDeptId != '1'.toString()">
           AND CHECK_DEPT_ID = #{checkDeptId}
        </if>
        <if test="hiddenDeptId != null">
           AND HIDDEN_DEPT_ID = #{hiddenDeptId}
        </if>
        <if test="deleteFlag != null">
           AND DELETE_FLAG = #{deleteFlag}
        </if>
        <if test="deptId != null and deptId != ''">
           AND LAST_DEPT_ID = #{deptId}
        </if>
        <if test="isAllFlag != null and isAllFlag == '1'.toString()">
           AND RECTIFICATION_STATUS = 1
        </if>
        <if test="isAllFlag != null and isAllFlag == '2'.toString()">
           AND RECTIFICATION_STATUS IN (0,1)
        </if>
        </trim>
        ORDER BY GENERALLY_HIDDEN_ID DESC
     </select>

entity如下

public class AqGenerallyHidden extends BaseEntity {

    private static final long serialVersionUID = -5069942087880879743L;

    /**
     * 一般隐患ID
     */
    private Long generallyHiddenId = null;

    /**
     * 检查日期
     */
    private String checkDate = null;

    /**
     * 检查类型
     */
    private Long dictCheckTypeId = null;
.
.
.

Dao如下

public abstract List<AqGenerallyHidden> searchHiddenListDetailList(Map<String, String> paramMap);

service如下：

public List<AqGenerallyHidden> searchHiddenListDetailList(Map<String, String> paramMap) {
        try {
            List<AqGenerallyHidden> list = ((AqGenerallyStatisticsDao) super.getBaseDao()).searchHiddenListDetailList(paramMap);
            return list;
        } catch (Exception e) {
            e.printStackTrace();
            throw new BusinessException("[searchHiddenListDetailList]操作异常");
        }
    }

现在程序执行不报错。能打印sql语句。sql语句可以执行，并且能查询到数据。
但是返回的List<AqGenerallyHidden>为空。
不知道为什么，求各位指教。

2014年8月20日 10:19

Fox_ed
2
0 0 4

3个答案按时间排序按投票排序

0 0

我觉得应该是AqGenerallyHidden的属性没有些set和get方法。

2014年8月21日 10:19

FireZHFox
148
0 1 12

添加评论

0 0

应该是entity类没有set/get方法引起的。请检查。

2014年8月21日 07:51

lhbthanks
30
0 0 1

添加评论

0 0

resultType="AqGenerallyHidden"这个应该就是你的Domain对象，你上述的查询没有赋值进去可能是你使用的数据库（如oracle）查询出来的结果列没有跟Domain对象中的setXXX对应上，有种情况就是AS查询后你的列如”generallyHiddenId“变成全大写的，自然在设置值得时候就设置不上，如果使用oracle建议as后的别名加上双引号""。

上述问题我没遇到，但是如果我没有加双引号返回到前台的JSON就是全部大写，所以我初略估计你也应该是这个问题（前台是使用同一SQL后台查询是有数据的前提下）

2014年8月20日 17:55