mybatis02(继上一个)解决数据库字段和实体类字段不对应的

    科技2022-07-15  122

    如果出现工程太庞大导致实体类太多而无法与数据库中表的字段一一对应怎么办? 比如把上篇博客(https://blog.csdn.net/qq_45020745/article/details/108919646)的User中的id改成bid,下面提供了一种解决方法

    package com.ygkj.pojo; public class User { private Integer bid; private String userName; private String passWord; public User(Integer bid, String userName, String passWord) { this.bid = bid; this.userName = userName; this.passWord = passWord; } public User() { } public Integer getBid() { return bid; } public void setBid(Integer bid) { this.bid = bid; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassWord() { return passWord; } public void setPassWord(String passWord) { this.passWord = passWord; } @Override public String toString() { return "User{" + "bid=" + bid + ", userName='" + userName + '\'' + ", passWord='" + passWord + '\'' + '}'; } }

    此时只需要修改一下UserMapper.xml文件即可

    <resultMap id="userVo" type="com.ygkj.pojo.User"> <!--主键字段的对应--> <id property="bid" column="id"></id> <!--非主键字段的对应--> <result property="userName" column="username"/> <result property="passWord" column="password"/> </resultMap> <select id="findAll" resultMap="userVo"> select *from tb_user; </select>
    Processed: 0.222, SQL: 8