自定义列输出
大约 4 分钟
自定义列输出
easy-query的select目前支持两种方式返回自定义列，一个是自己手动进行select的column一个是加入返回对象，返回对象被解析的columnName和sql的返回列名一致才会
java对象
@Data
@EntityProxy //注意如果手动赋值必须要加这个注解使用代理对象去操作
public class BlogEntityTest2 {
/**
* 标题
*/
private String title;
/**
* 内容
*/
private String content;
/**
* 博客链接
*/
@Column("my_url")
private String url;
/**
* 点赞数
*/
private Integer star;
/**
* 发布时间
*/
private LocalDateTime publishTime;
/**
* 评分
*/
private BigDecimal score;
/**
* 状态
*/
private Integer status;
/**
* 排序
*/
private BigDecimal order;
/**
* 是否置顶
*/
private Boolean isTop;
/**
* 是否置顶
*/
private Boolean top;
}
@Data
public class BlogEntityTest2 {
/**
* 标题
*/
private String title;
/**
* 内容
*/
private String content;
/**
* 博客链接
*/
@Column("my_url")
private String url;
/**
* 点赞数
*/
private Integer star;
/**
* 发布时间
*/
private LocalDateTime publishTime;
/**
* 评分
*/
private BigDecimal score;
/**
* 状态
*/
private Integer status;
/**
* 排序
*/
private BigDecimal order;
/**
* 是否置顶
*/
private Boolean isTop;
/**
* 是否置顶
*/
private Boolean top;
}
输出指定列
//BlogEntityTest2Proxy 由代理对象BlogEntityTest2+@EntityProxy生成
List<BlogEntityTest2> blogEntityTest2s = easyEntityQuery.queryable(BlogEntity.class)
.select(o -> new BlogEntityTest2Proxy()
.url().set(o.url())
).toList();
==> Preparing: SELECT t.`url` AS `my_url` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
List<BlogEntityTest2> blogEntityTest2s = easyQuery.queryable(BlogEntity.class)
.select(BlogEntityTest2.class, o -> o.columnAs(BlogEntity::getUrl, BlogEntityTest2::getUrl)).toList();
==> Preparing: SELECT t.`url` AS `my_url` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
相同属性不同列名不映射
BlogEntity.url和BlogEntityTest2.url在Bean层面拥有一样的属性名称一样的属性类型,但是因为BlogEntityTest2.url映射到my_url列上所以无法自动映射
//BlogEntityTest2Proxy 由代理对象BlogEntityTest2+@EntityProxy生成
//以下三种都可以 区别就是前两种无法后续继续操作而第三种可以继续在select后进行where筛选,但是前两种不需要添加注解
List<BlogEntityTest2> blogEntityTest2s = easyEntityQuery.queryable(BlogEntity.class)
.select(BlogEntityTest2.class).toList();
List<BlogEntityTest2> blogEntityTest2s = easyEntityQuery.queryable(BlogEntity.class)
.toList(BlogEntityTest2.class);
List<BlogEntityTest2> blogEntityTest2s = easyEntityQuery.queryable(BlogEntity.class)
.select(o->new BlogEntityTest2Proxy()).toList();
==> Preparing: SELECT t.`title`,t.`content`,t.`star`,t.`publish_time`,t.`score`,t.`status`,t.`order`,t.`is_top`,t.`top` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
//以下两种都可以
List<BlogEntityTest2> blogEntityTest2s = easyQuery.queryable(BlogEntity.class)
.select(BlogEntityTest2.class).toList();
List<BlogEntityTest2> blogEntityTest2s = easyQuery.queryable(BlogEntity.class)
.toList(BlogEntityTest2.class);
==> Preparing: SELECT t.`title`,t.`content`,t.`star`,t.`publish_time`,t.`score`,t.`status`,t.`order`,t.`is_top`,t.`top` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
全字段查询
全字段查询自动以resultClass为主映射columnName相同列
//BlogEntityTest2Proxy 由代理对象BlogEntityTest2+@EntityProxy生成
//默认不需要加selectAll因为加不加都是对主表进行selectAll但是如果存在多个表那么比如
//.select((a,b)->new BlogEntityTest2Proxy().selectAll(b))这时候可以自行选择
List<BlogEntityTest2> blogEntityTest2s = easyEntityQuery.queryable(BlogEntity.class)
.select(o->new BlogEntityTest2Proxy().selectAll(o)).toList();
==> Preparing: SELECT t.`title`,t.`content`,t.`star`,t.`publish_time`,t.`score`,t.`status`,t.`order`,t.`is_top`,t.`top` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
List<BlogEntityTest2> blogEntityTest2s = easyQuery.queryable(BlogEntity.class)
.select(BlogEntityTest2.class,o->o.columnAll()).toList();
==> Preparing: SELECT t.`title`,t.`content`,t.`star`,t.`publish_time`,t.`score`,t.`status`,t.`order`,t.`is_top`,t.`top` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
追加映射字段
//BlogEntityTest2Proxy 由代理对象BlogEntityTest2+@EntityProxy生成
List<BlogEntityTest2> blogEntityTest2s = easyEntityQuery.queryable(BlogEntity.class)
.select(o->{
BlogEntityTest2Proxy result = new BlogEntityTest2Proxy();
result.selectAll(o);
result.url().set(o.url());//因为结果的url是my_url字段和数据库的不一致所以selectAll并不会映射上去要手动指定
return result;
}).toList();
==> Preparing: SELECT t.`title`,t.`content`,t.`star`,t.`publish_time`,t.`score`,t.`status`,t.`order`,t.`is_top`,t.`top`,t.`url` AS `my_url` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
List<BlogEntityTest2> blogEntityTest2s = easyQuery.queryable(BlogEntity.class)
.select(BlogEntityTest2.class,o->o.columnAll().columnAs(BlogEntity::getUrl,BlogEntityTest2::getUrl)).toList();
==> Preparing: SELECT t.`title`,t.`content`,t.`star`,t.`publish_time`,t.`score`,t.`status`,t.`order`,t.`is_top`,t.`top`,t.`url` AS `my_url` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
忽略查询字段
查询映射到对象BlogEntityTest2在原来的查询结果上忽略BlogEntity.title字段的查询映射,因为columnAll如果真是查询表所有字段但是映射到BlogEntityTest2后会丢失所以没有必要查询全字段,直接查询映射字段即可
//BlogEntityTest2Proxy 由代理对象BlogEntityTest2+@EntityProxy生成
List<BlogEntityTest2> blogEntityTest2s = easyEntityQuery.queryable(BlogEntity.class)
.select(o->new BlogEntityTest2Proxy()
.selectAll(o).selectIgnores(o.title())
.url().set(o.url())
).toList();
==> Preparing: SELECT t.`content`,t.`star`,t.`publish_time`,t.`score`,t.`status`,t.`order`,t.`is_top`,t.`top`,t.`url` AS `my_url` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100
List<BlogEntityTest2> blogEntityTest2s = easyQuery.queryable(BlogEntity.class)
.select(BlogEntityTest2.class,o->o.columnAll().columnIgnore(BlogEntity::getTitle).columnAs(BlogEntity::getUrl,BlogEntityTest2::getUrl)).toList();
==> Preparing: SELECT t.`content`,t.`star`,t.`publish_time`,t.`score`,t.`status`,t.`order`,t.`is_top`,t.`top`,t.`url` AS `my_url` FROM t_blog t WHERE t.`deleted` = ?
==> Parameters: false(Boolean)
<== Total: 100