2020/1/13工作日志

115 阅读 0 评论 76 点赞

我是靠谱客的博主鲤鱼巨人，这篇文章主要介绍2020/1/13工作日志，现在分享给大家，希望可以做个参考。

1，进行了MyBatis Plus 的了解，了解了

复制代码

1
2
    QueryWrapper<Object> objectQueryWrapper = new QueryWrapper<>();

复制代码

1
2
        CriteriaQuery<Object> criteriaQuery = new CriteriaQuery<>();

学习了MP的 CriteriaQuery对象sql语句的写法

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
CriteriaQuery.select("member.member_id AS memberId,"
                + "member.address AS address,"
                + "member.mobile AS mobile,"
                + "member.update_user AS updateUser,"
                + "member.update_time AS updateTime,"
                + "member.card_no AS cardNo,"
                + "member.org_id AS orgId,"
                + "member.ca_no AS caNo,"
                + "member.area_id AS areaId,"
                + "member.create_time AS createTime,"
                + "member.name AS name,"
                + "member.create_user AS createUser,"
                + "member.status AS status,"
                + "area.area_name AS areaName");
        CriteriaQuery.createAlias(BaseArea.class);

其中 BaseArea.class 是需要关联查询的副类，即

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
@TableAlias("area")
@TableName("base_area")
@ApiModel(value="BaseArea对象", description="行政区划")
public class BaseArea extends AbstractEntity {

    private static final long serialVersionUID=1L;

    @ApiModelProperty(value = "区划ID")
    @TableId(value = "area_id", type = IdType.AUTO)
    private Long areaId;

    @ApiModelProperty(value = "区划名称")
    private String areaName;

    @ApiModelProperty(value = "上级id")
    private Long parentId;
    
    @ApiModelProperty(value = "小区标记 1是0否")
    private Integer villageMark;
    
    @ApiModelProperty(value = "上级ids")
    private String parentIds;
}

还学习了使用 CriteriaQuery.apply 方法进行sql语句查询

复制代码

1
2
3
CriteriaQuery.apply(ToolUtil.isNotEmpty(area_id),  " (member.area_id = " + area_id.toString() + " or find_in_set(" + area_id.toString() + ",area.parent_ids))");