mybatis简单查询无法封装对象

薄荷味的炫迈

于 2024-08-20 19:29:19 发布

阅读量65

点赞数 2

文章标签： mybatis

本文链接：https://blog.csdn.net/weixin_70545647/article/details/141366573

版权

sql：

select OBJECTID,
               STREET_NAME,
               STREET_CODE,
               DISTRICT,
               Shape_Length,
               Shape_Area,
               rings,
               MAKEDATE,
               MODIFYDATE
from TB_STREET_LOCATION_AREA

实体类应使用驼峰，就能正确映射

@Data
public class StreetLocationArea implements Serializable {
    @TableId(type = IdType.INPUT)
    private Integer OBJECTID;

    private String streetName;

    private String streetCode;

    private String DISTRICT;

    private Double shapeLength;

    private Double shapeArea;

    private String rings;

    private Date makedate;

    private Date modifydate;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
}