mybatis查询结果字段与实体类中对应的字段名不相同

Question

实体类

package com.example.main.domain;

import java.util.Date;

public class User {
    private Integer MU_ID;

    private String MU_NO;

    private String MU_NAME;

    private Integer MI_ID;

    private Integer MR_ID;

    private String MU_PASSWORD;

    private String DEL_FLAG;

    private Date ADD_DATETIME;

    private String ADD_USER;

    private Date UPD_DATETIME;

    private String UPD_USER;

    private Date DEL_DATETIME;

    private String DEL_USER;

    public Integer getMU_ID() {
        return MU_ID;
    }

    public void setMU_ID(Integer MU_ID) {
        this.MU_ID = MU_ID;
    }

    public String getMU_NO() {
        return MU_NO;
    }

    public void setMU_NO(String MU_NO) {
        this.MU_NO = MU_NO;
    }

    public String getMU_NAME() {
        return MU_NAME;
    }

    public void setMU_NAME(String MU_NAME) {
        this.MU_NAME = MU_NAME;
    }

    public Integer getMI_ID() {
        return MI_ID;
    }

    public void setMI_ID(Integer MI_ID) {
        this.MI_ID = MI_ID;
    }

    public Integer getMR_ID() {
        return MR_ID;
    }

    public void setMR_ID(Integer MR_ID) {
        this.MR_ID = MR_ID;
    }

    public String getMU_PASSWORD() {
        return MU_PASSWORD;
    }

    public void setMU_PASSWORD(String MU_PASSWORD) {
        this.MU_PASSWORD = MU_PASSWORD;
    }

    public String getDEL_FLAG() {
        return DEL_FLAG;
    }

    public void setDEL_FLAG(String DEL_FLAG) {
        this.DEL_FLAG = DEL_FLAG;
    }

    public Date getADD_DATETIME() {
        return ADD_DATETIME;
    }

    public void setADD_DATETIME(Date ADD_DATETIME) {
        this.ADD_DATETIME = ADD_DATETIME;
    }

    public String getADD_USER() {
        return ADD_USER;
    }

    public void setADD_USER(String ADD_USER) {
        this.ADD_USER = ADD_USER;
    }

    public Date getUPD_DATETIME() {
        return UPD_DATETIME;
    }

    public void setUPD_DATETIME(Date UPD_DATETIME) {
        this.UPD_DATETIME = UPD_DATETIME;
    }

    public String getUPD_USER() {
        return UPD_USER;
    }

    public void setUPD_USER(String UPD_USER) {
        this.UPD_USER = UPD_USER;
    }

    public Date getDEL_DATETIME() {
        return DEL_DATETIME;
    }

    public void setDEL_DATETIME(Date DEL_DATETIME) {
        this.DEL_DATETIME = DEL_DATETIME;
    }

    public String getDEL_USER() {
        return DEL_USER;
    }

    public void setDEL_USER(String DEL_USER) {
        this.DEL_USER = DEL_USER;
    }
}

表的字段名

查询出来的数据
[{"del_FLAG":"0","add_DATETIME":"2019-04-26T12:21:33.000+0000","mr_ID":1,"add_USER":"s","upd_DATETIME":"2019-04-03T12:21:50.000+0000","del_DATETIME":"2019-04-10T12:21:43.000+0000","upd_USER":"adad","del_USER":"dada","mu_PASSWORD":"123456","mu_ID":1,"mu_NO":"95927","mi_ID":1,"mu_NAME":"admin"},{"del_FLAG":"0","add_DATETIME":null,"mr_ID":1,"add_USER":null,"upd_DATETIME":null,"del_DATETIME":null,"upd_USER":null,"del_USER":null,"mu_PASSWORD":"123456","mu_ID":2,"mu_NO":"95544","mi_ID":1,"mu_NAME":"dada"}]

为什么下划线前面的字段会变成小写 有什么办法能变成大写吗

Answer 1

将查回来的字段和java实体做个映射

    <resultMap id="BaseResultMap" type="com.example.main.domain.User">
        <id column="mu_ID" property="MU_ID" jdbcType="INTEGER"/>
        <result column="mu_NO" property="MU_NO" jdbcType="VARCHAR"/>
    </resultMap>
    <sql id="Base_Column_List">
        mu_ID, mu_NO
    </sql>
    <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer">
        select
        <include refid="Base_Column_List"/>
        from user
        where mu_ID = #{MU_ID,jdbcType=INTEGER}
    </select>