gif网站素材,网站外部优化,wordpress怎么对接公众号,上海做展会的网站都有哪些实体如下#xff1a; IntegralGoods 积分商品 IntegralGoodsImg 积分商品图片 ShelfLog 积分商品自动上架记录 IntegralGoods #xff1a;IntegralGoodsImg#xff1a;ShelfLog 1#xff1a;n#xff1a;1 1#xff1a;1的多表联查或者m:n的多表联查 很简… 实体如下 IntegralGoods 积分商品 IntegralGoodsImg 积分商品图片 ShelfLog 积分商品自动上架记录 IntegralGoods IntegralGoodsImgShelfLog 1n1 11的多表联查或者m:n的多表联查 很简单 现在出现1n的情况一种积分商品可能有多张图片 所以在最后的返回结果里想用LIstIntegralGoodsImg作为IntegralGoods 的一个字段作为参数进行接收 那mybatis怎么实现查询呢 1.IntegralGoods 实体【只关注字段即可】尤其是 Transient private ListIntegralGoodsImg imgList;//图片们 这个字段就是用来接收多个图片实体的 package com.pisen.cloud.luna.ms.jifen.base.domain;import java.util.ArrayList;
import java.util.Date;
import java.util.List;import javax.persistence.*;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;import org.apache.commons.lang3.StringUtils;
import org.hibernate.annotations.Type;
import org.springframework.data.jpa.domain.Specification;import com.pisen.cloud.luna.ms.jifen.base.common.BaseDomain;/*** 积分商品表*/
Entity
Table(uniqueConstraints { UniqueConstraint(columnNames { uid })})
public class IntegralGoods extends BaseDomain {public static final int DELETE_FLAG_DELETE 1;//删除public static final int DELETE_FLAG_DISDELETE 0;//未删除public static final int SHELF_ON 1;//上架public static final int SHELF_OFF 0;//下架public static final int SHOW_HOME_FLAG_YES 1;//首页展示public static final int SHOW_HOME_FLAG_NO 0;//不在首页展示
Type(type text)private String description; //商品描述private String cdKey;//虚拟物品激活码 ---弃用
Column(nullable false)private String name; // 名称
Column(nullable false)private Float marketValue; // 原价
Column(nullable false)private Integer integral; // 兑换积分private Integer type; // (1:实物 2:虚拟)
Column(nullable false)private Integer stock; // 库存数量(-1时无限量 : 正常扣除)
Column(nullable false)private Integer saleNum; // 销量 已兑换数量private Integer version;/*** 新增字段*/Column(nullable false)private Integer limitNum;//限兑数量private String goodsCode;//商品编号
Column(nullable false)private String specification;//商品规格 实物商品必填private Integer deleteFlag;//删除标识
Column(nullable false)private Integer shelfFlag;//上架标识
Column(nullable false)private Integer homeShowFlag;//是否首页展示private String remark; //备注
Transientprivate String order;//排序字段Transientprivate String orderType;//排序方法Transientprivate String headImg;//首页图片
Transientprivate ListString imgUrlList;//接收前台URL集合使用
Transientprivate Date shelfDate;//上架时间 接收前台字段
Transientprivate Date obtainedDate;//下架时间 接收前台字段private String shelfRemark;//上架信息 备注
Transientprivate ListIntegralGoodsImg imgList;//图片们public String getRemark() {return remark;}public void setRemark(String remark) {this.remark remark;}public String getShelfRemark() {return shelfRemark;}public void setShelfRemark(String shelfRemark) {this.shelfRemark shelfRemark;}public Integer getHomeShowFlag() {return homeShowFlag;}public void setHomeShowFlag(Integer homeShowFlag) {this.homeShowFlag homeShowFlag;}public Integer getShelfFlag() {return shelfFlag;}public void setShelfFlag(Integer shelfFlag) {this.shelfFlag shelfFlag;}public Integer getLimitNum() {return limitNum;}public void setLimitNum(Integer limitNum) {this.limitNum limitNum;}public String getGoodsCode() {return goodsCode;}public void setGoodsCode(String goodsCode) {this.goodsCode goodsCode;}public String getSpecification() {return specification;}public void setSpecification(String specification) {this.specification specification;}public Integer getDeleteFlag() {return deleteFlag;}public void setDeleteFlag(Integer deleteFlag) {this.deleteFlag deleteFlag;}public ListIntegralGoodsImg getImgList() {return imgList;}public void setImgList(ListIntegralGoodsImg imgList) {this.imgList imgList;}public Integer getVersion() {return version;}public void setVersion(Integer version) {this.version version;}public String getOrder() {return order;}public void setOrder(String order) {this.order order;}public String getOrderType() {return orderType;}public void setOrderType(String orderType) {this.orderType orderType;}public String getName() {return name;}public void setName(String name) {this.name name;}public Integer getIntegral() {return integral;}public void setIntegral(Integer integral) {this.integral integral;}public String getDescription() {return description;}public void setDescription(String description) {this.description description;}public String getCdKey() {return cdKey;}public void setCdKey(String cdKey) {this.cdKey cdKey;}public Integer getType() {return type;}public void setType(Integer type) {this.type type;}public Integer getStock() {return stock;}public void setStock(Integer stock) {this.stock stock;}public Float getMarketValue() {return marketValue;}public void setMarketValue(Float marketValue) {this.marketValue marketValue;}public String getHeadImg() {if(imgList ! null){for (IntegralGoodsImg integralGoodsImg : imgList) {if(integralGoodsImg.getType() 1){headImg integralGoodsImg.getSrc();break;}}}return headImg;}public void setHeadImg(String headImg) {this.headImg headImg;}public Integer getSaleNum() {return saleNum;}public void setSaleNum(Integer saleNum) {this.saleNum saleNum;}public ListString getImgUrlList() {return imgUrlList;}public void setImgUrlList(ListString imgUrlList) {this.imgUrlList imgUrlList;}public Date getShelfDate() {return shelfDate;}public void setShelfDate(Date shelfDate) {this.shelfDate shelfDate;}public Date getObtainedDate() {return obtainedDate;}public void setObtainedDate(Date obtainedDate) {this.obtainedDate obtainedDate;}public static SpecificationIntegralGoods where(final IntegralGoods entity) {return new SpecificationIntegralGoods() {Overridepublic Predicate toPredicate(RootIntegralGoods root, CriteriaQuery? query, CriteriaBuilder cb) {ListPredicate predicates new ArrayListPredicate();//商品名称String name entity.getName();if (StringUtils.isNotBlank(name)) {predicates.add(cb.like(root.Stringget(name), % name %));}// 等于// uidString uid entity.getUid();if (StringUtils.isNotBlank(uid)) {predicates.add(cb.equal(root.Stringget(uid), uid));}// tidString tid entity.getTid();if (StringUtils.isNotBlank(tid)) {predicates.add(cb.equal(root.Stringget(tid), tid));}// 积分Integer integral entity.getIntegral();if (integral ! null) {predicates.add(cb.equal(root.Stringget(integral), integral));}// 类型Integer type entity.getType();if (type ! null) {predicates.add(cb.equal(root.Stringget(type), type));}//库存Integer stock entity.getStock();if (stock ! null) {predicates.add(cb.equal(root.Stringget(stock), stock));}//激活码String cdKey entity.getCdKey();if (StringUtils.isNotBlank(cdKey)){predicates.add(cb.equal(root.get(cdKey),cdKey));}//商品编号String goodsCode entity.getGoodsCode();if (StringUtils.isNotBlank(goodsCode)){predicates.add(cb.equal(root.get(goodsCode),goodsCode));}//上架标识Integer shelfFlag entity.getShelfFlag();if (shelfFlag ! null){predicates.add(cb.equal(root.get(shelfFlag),shelfFlag));}return query.where(predicates.toArray(new Predicate[predicates.size()])).getRestriction();}};}} View Code 2.IntegralGoodsImg实体 package com.pisen.cloud.luna.ms.jifen.base.domain;import java.util.ArrayList;
import java.util.List;import javax.persistence.Entity;
import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;import org.apache.commons.lang3.StringUtils;
import org.springframework.data.jpa.domain.Specification;import com.pisen.cloud.luna.ms.jifen.base.common.BaseDomain;Entity
Table(uniqueConstraints { UniqueConstraint(columnNames { uid }),UniqueConstraint(columnNames { imgKey })})
public class IntegralGoodsImg extends BaseDomain {public static final int IMG_TYPE_MAIN 1;//商品主图public static final int IMG_TYPE_OTHER 2;//其他商品图片private String integralGoodsId; //积分商品idprivate Integer type; // 图片类型(1:首页展示,2:详情图片,3:自定义图片)private String src; // 图片路径private Integer sort; // 图片顺序private String tid;//租户idprivate String imgKey;//七牛云存储图片的keyprivate String imgName; //用户上传的文件名public String getIntegralGoodsId() {return integralGoodsId;}public void setIntegralGoodsId(String integralGoodsId) {this.integralGoodsId integralGoodsId;}public Integer getType() {return type;}public void setType(Integer type) {this.type type;}public String getSrc() {return src;}public void setSrc(String src) {this.src src;}public Integer getSort() {return sort;}public void setSort(Integer sort) {this.sort sort;}public String getTid() {return tid;}public void setTid(String tid) {this.tid tid;}public String getImgKey() {return imgKey;}public void setImgKey(String imgKey) {this.imgKey imgKey;}public String getImgName() {return imgName;}public void setImgName(String imgName) {this.imgName imgName;}public static SpecificationIntegralGoodsImg where(final IntegralGoodsImg entity) {return new SpecificationIntegralGoodsImg() {Overridepublic Predicate toPredicate(RootIntegralGoodsImg root, CriteriaQuery? query, CriteriaBuilder cb) {ListPredicate predicates new ArrayListPredicate();// 等于// uidString uid entity.getUid();if (StringUtils.isNotBlank(uid)) {predicates.add(cb.equal(root.Stringget(uid), uid));}// 积分商品idString integralGoodsId entity.getIntegralGoodsId();if (StringUtils.isNotBlank(integralGoodsId)) {predicates.add(cb.equal(root.Stringget(integralGoodsId), integralGoodsId));}// 图片类型Integer type entity.getType();if (type ! null) {predicates.add(cb.equal(root.Stringget(type), type));}//tidString tid entity.getTid();if (StringUtils.isNotBlank(tid)) {predicates.add(cb.equal(root.Stringget(tid), tid));}return query.where(predicates.toArray(new Predicate[predicates.size()])).getRestriction();}};}} View Code 3.ShelfLog实体 package com.pisen.cloud.luna.ms.jifen.base.domain;import javax.persistence.*;
import java.util.Date;/*** 自动上架 下架时间 记录表** 单位控制到天** 定时任务每天定时扫描 完成积分商品自动上架下架状态的改变*/
Entity
Table(uniqueConstraints { UniqueConstraint(columnNames { integralGoodsUid })})
public class ShelfLog {public static final int DEAL_FLAG_DO 1;//已处理public static final int DEAL_FLAG_NOT_HAVING_DO 0;//未处理
IdGeneratedValue(strategy GenerationType.IDENTITY)private Long id;// 主键 自增
Column(nullable false)private String integralGoodsUid;//积分商品ID 本记录表中唯一private Date shelfDate;//自定义自动上架时间private Date obtainedDate;//自定义自动下架时间private Integer shelfDealFlag;//上架是否处理private Integer obtainedFlag;//下架是否处理public Long getId() {return id;}public void setId(Long id) {this.id id;}public String getIntegralGoodsUid() {return integralGoodsUid;}public void setIntegralGoodsUid(String integralGoodsUid) {this.integralGoodsUid integralGoodsUid;}public Date getShelfDate() {return shelfDate;}public void setShelfDate(Date shelfDate) {this.shelfDate shelfDate;}public Date getObtainedDate() {return obtainedDate;}public void setObtainedDate(Date obtainedDate) {this.obtainedDate obtainedDate;}public Integer getShelfDealFlag() {return shelfDealFlag;}public void setShelfDealFlag(Integer shelfDealFlag) {this.shelfDealFlag shelfDealFlag;}public Integer getObtainedFlag() {return obtainedFlag;}public void setObtainedFlag(Integer obtainedFlag) {this.obtainedFlag obtainedFlag;}} View Code 4.最后着重看mybatis的xml怎么写 select idfind parameterTypecom.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods resultMapbaseResBeanselect a.id as id,a.uid as uid,a.create_date as createDate,a.update_date as updateDate,a.update_id as updateId,a.create_id as createId,a.brand_uid as brandUid,a.tid as tid,a.stock as stock,a.name as name,a.goods_code as goodsCode,a.market_value as marketValue,a.specification as specification,a.remark as remark,a.integral as integral,a.description as description,a.sale_num as saleNum,a.limit_num as limitNum,a.shelf_flag as shelfFlag,a.home_show_flag as homeShowFlag,sl.shelf_date as shelfDate,sl.obtained_date as obtainedDate,b.src b_src,b.type b_type,b.sort b_sortfrom integral_goods aleft joinintegral_goods_img bon a.uid b.integral_goods_idleft joinshelf_log slon a.uid sl.integral_goods_uidwherea.delete_flag ${com.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoodsDELETE_FLAG_DISDELETE}and a.tid #{tid}if testuid ! null and uid ! and a.uid #{uid}/ifif testbrandUid ! null and brandUid ! and a.brand_uid #{brandUid}/ifif testname ! null and name ! and a.name like CONCAT(%,#{name},%)/if/where/selectresultMap typecom.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods idbaseResBeanid columnid propertyid/result columnuid propertyuid/result columncreateDate propertycreateDate/result columnupdateDate propertyupdateDate/result columncreateId propertycreateId/result columnupdateId propertyupdateId/result columntype propertytype/result columntid propertytid/result columnstock propertystock/result columnname propertyname/result columngoodsCode propertygoodsCode/result columnmarketValue propertymarketValue/result columnspecification propertyspecification/result columnbrandUid propertybrandUid/result columnremark propertyremark/result columnintegral propertyintegral/result columndescription propertydescription/result columnsaleNum propertysaleNum/result columnlimitNum propertylimitNum/result columnshelfFlag propertyshelfFlag/result columnhomeShowFlag propertyhomeShowFlag/result columnshelfDate propertyshelfDate/result columnobtainedDate propertyobtainedDate/collection propertyimgList columnPrefixb_ofTypecom.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoodsImgid columnid propertyid/result columnsrc propertysrc/result columntype propertytype/result columnsort propertysort//collection/resultMap View Code 5.最后补充一下mapper.java ListIntegralGoods find(IntegralGoods entity); 展示一下最后的查询结果【注意最后的total总数有问题需要单独处理一下】 【total8表示数据库中查出的数据是8条在组装返回List以后就是3条了】 {success: true,msg: successful,code: 200,total: 8,rows: [{fields: null,orders: null,pageSize: 10,pageNum: 0,id: 48,createDate: 1533689800000,updateDate: 1533689800000,updateId: defUserId,createId: defUserId,uid: 42832f275248456f8a8ff6b855f55e95,tid: 9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba,brandUid: 974fcd3a139f4b19a632bc40b6eec7b9,description: null,cdKey: null,name: 统一方便面,marketValue: 100,integral: 100,type: null,stock: 200,saleNum: 0,version: null,limitNum: 2,goodsCode: null,specification: 105g/桶*12桶/件,deleteFlag: null,shelfFlag: 0,homeShowFlag: 1,remark: null,order: null,orderType: null,headImg: http://p2ognrwoi.bkt.clouddn.com/fed69bb7be9416ed56916aea8ffad38f_UI_UPLOAD_IMG?e1533562337tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:96nPcK9nruoaT3s_rNEzlQJrQeQ?imageView2/1/w/50/h/50,imgUrlList: null,shelfDate: 1533859200000,obtainedDate: 1533945600000,shelfRemark: null,imgList: [{fields: null,orders: null,pageSize: 10,pageNum: 0,id: null,createDate: 1533698803047,updateDate: 1533698803047,updateId: null,createId: null,uid: null,tid: null,brandUid: null,integralGoodsId: null,type: 1,src: http://p2ognrwoi.bkt.clouddn.com/fed69bb7be9416ed56916aea8ffad38f_UI_UPLOAD_IMG?e1533562337tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:96nPcK9nruoaT3s_rNEzlQJrQeQ?imageView2/1/w/50/h/50,sort: 1,imgKey: null,imgName: null},{fields: null,orders: null,pageSize: 10,pageNum: 0,id: null,createDate: 1533698803052,updateDate: 1533698803052,updateId: null,createId: null,uid: null,tid: null,brandUid: null,integralGoodsId: null,type: 2,src: http://p2ognrwoi.bkt.clouddn.com/b07121eeadc1e42dbde765af569356a3_UI_UPLOAD_IMG?e1533563250tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:W_EObH6d7O_QrqRQeX1CSmba0KE?imageView2/1/w/50/h/50,sort: 2,imgKey: null,imgName: null},{fields: null,orders: null,pageSize: 10,pageNum: 0,id: null,createDate: 1533698803055,updateDate: 1533698803055,updateId: null,createId: null,uid: null,tid: null,brandUid: null,integralGoodsId: null,type: 2,src: http://p2ognrwoi.bkt.clouddn.com/237d4a191de7b25897cdb49117dfb9ec_UI_UPLOAD_IMG?e1533563617tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:M3FJDLzza80U72934OT7B8ya_Yw?imageView2/1/w/50/h/50,sort: 3,imgKey: null,imgName: null}]},{fields: null,orders: null,pageSize: 10,pageNum: 0,id: 49,createDate: 1533698513000,updateDate: 1533698513000,updateId: defUserId,createId: defUserId,uid: 17c2050b247a45f0ae092d48b035c9e5,tid: 9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba,brandUid: 974fcd3a139f4b19a632bc40b6eec7b9,description: null,cdKey: null,name: 统一方便面,marketValue: 100,integral: 100,type: null,stock: 200,saleNum: 0,version: null,limitNum: 2,goodsCode: null,specification: 105g/桶*12桶/件,deleteFlag: null,shelfFlag: 0,homeShowFlag: 1,remark: null,order: null,orderType: null,headImg: http://p2ognrwoi.bkt.clouddn.com/fed69bb7be9416ed56916aea8ffad38f_UI_UPLOAD_IMG?e1533562337tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:96nPcK9nruoaT3s_rNEzlQJrQeQ?imageView2/1/w/50/h/50,imgUrlList: null,shelfDate: 1533859200000,obtainedDate: null,shelfRemark: null,imgList: [{fields: null,orders: null,pageSize: 10,pageNum: 0,id: null,createDate: 1533698803068,updateDate: 1533698803068,updateId: null,createId: null,uid: null,tid: null,brandUid: null,integralGoodsId: null,type: 1,src: http://p2ognrwoi.bkt.clouddn.com/fed69bb7be9416ed56916aea8ffad38f_UI_UPLOAD_IMG?e1533562337tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:96nPcK9nruoaT3s_rNEzlQJrQeQ?imageView2/1/w/50/h/50,sort: 1,imgKey: null,imgName: null},{fields: null,orders: null,pageSize: 10,pageNum: 0,id: null,createDate: 1533698803070,updateDate: 1533698803070,updateId: null,createId: null,uid: null,tid: null,brandUid: null,integralGoodsId: null,type: 2,src: http://p2ognrwoi.bkt.clouddn.com/b07121eeadc1e42dbde765af569356a3_UI_UPLOAD_IMG?e1533563250tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:W_EObH6d7O_QrqRQeX1CSmba0KE?imageView2/1/w/50/h/50,sort: 2,imgKey: null,imgName: null}]},{fields: null,orders: null,pageSize: 10,pageNum: 0,id: 46,createDate: 1533689464000,updateDate: 1533689464000,updateId: defUserId,createId: defUserId,uid: 629669683bf34ecdbb81ac8bbc236845,tid: 9f63f84f-52c6-4c8e-b3c3-66b9f1f283ba,brandUid: 974fcd3a139f4b19a632bc40b6eec7b9,description: null,cdKey: null,name: 统一方便面,marketValue: 100,integral: 100,type: null,stock: 200,saleNum: 0,version: null,limitNum: 2,goodsCode: null,specification: 105g/桶*12桶/件,deleteFlag: null,shelfFlag: 0,homeShowFlag: 1,remark: null,order: null,orderType: null,headImg: http://p2ognrwoi.bkt.clouddn.com/fed69bb7be9416ed56916aea8ffad38f_UI_UPLOAD_IMG?e1533562337tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:96nPcK9nruoaT3s_rNEzlQJrQeQ?imageView2/1/w/50/h/50,imgUrlList: null,shelfDate: null,obtainedDate: null,shelfRemark: null,imgList: [{fields: null,orders: null,pageSize: 10,pageNum: 0,id: null,createDate: 1533698803082,updateDate: 1533698803082,updateId: null,createId: null,uid: null,tid: null,brandUid: null,integralGoodsId: null,type: 1,src: http://p2ognrwoi.bkt.clouddn.com/fed69bb7be9416ed56916aea8ffad38f_UI_UPLOAD_IMG?e1533562337tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:96nPcK9nruoaT3s_rNEzlQJrQeQ?imageView2/1/w/50/h/50,sort: 1,imgKey: null,imgName: null},{fields: null,orders: null,pageSize: 10,pageNum: 0,id: null,createDate: 1533698803085,updateDate: 1533698803085,updateId: null,createId: null,uid: null,tid: null,brandUid: null,integralGoodsId: null,type: 2,src: http://p2ognrwoi.bkt.clouddn.com/b07121eeadc1e42dbde765af569356a3_UI_UPLOAD_IMG?e1533563250tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:W_EObH6d7O_QrqRQeX1CSmba0KE?imageView2/1/w/50/h/50,sort: 2,imgKey: null,imgName: null},{fields: null,orders: null,pageSize: 10,pageNum: 0,id: null,createDate: 1533698803088,updateDate: 1533698803088,updateId: null,createId: null,uid: null,tid: null,brandUid: null,integralGoodsId: null,type: 2,src: http://p2ognrwoi.bkt.clouddn.com/237d4a191de7b25897cdb49117dfb9ec_UI_UPLOAD_IMG?e1533563617tokenlPDJgKX4JP-SQBa1EWaSt88UJAOpkW1n0JGv3gCQ:M3FJDLzza80U72934OT7B8ya_Yw?imageView2/1/w/50/h/50,sort: 3,imgKey: null,imgName: null}]}]
}
