jpaHelper

    <dependency>
        <groupId>cn.craccd</groupId>
        <artifactId>jpaHelper</artifactId>
        <version>0.3.2</version>
    </dependency>

@ComponentScan("cn.cucc")
@Configuration
public class WebConfig {

}

spring:
  datasource: #数据库配置(jpa会根据url协议自动判断数据库类型)
    url: jdbc:postgresql://xxx.xxx.xxx.xxx:5432/database
    username: postgres
    password: postgres
  jpa:
    properties:
      hibernate.globally_quoted_identifiers: true #对jpa sql关键字进行转义
      hibernate.globally_quoted_identifiers_skip_column_definitions: true #不要对字段类型进行转义
    hibernate: 
      ddl-auto: update #自动更新数据库表,如不需要自动更新数据库,则取消此参数

@Entity
public class User{
	@Id // 主键注解
	String id;
	@CreateTime // 自动插入创建时间戳的注解
	Long createTime;
	@UpdateTime // 自动插入更新时间戳的注解
	Long updateTime;
		
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public Long getCreateTime() {
		return createTime;
	}
	public void setCreateTime(Long createTime) {
		this.createTime = createTime;
	}
	public Long getUpdateTime() {
		return updateTime;
	}
	public void setUpdateTime(Long updateTime) {
		this.updateTime = updateTime;
	}
}

// 根据输入条件进行查询
public List<User> search(String word, Integer type) {
	ConditionAndWrapper conditionAndWrapper = new ConditionAndWrapper();

	if (StrUtil.isNotEmpty(word)) {
		conditionAndWrapper.and(new ConditionOrWrapper().like(User::getName, word).like(User::getPhone, word));
	}
	if (type != null) {
		conditionAndWrapper.eq(User::getType, type);
	}
		
	List<User> userList = jpaHelper.findListByQuery(conditionAndWrapper, User.class);

	return userList ;
}

// 查出订单下的所有商品（OrderProduct.class为订单商品对照表）
public List<Product> getProductList(String orderId) {
	List<String> productIds = jpaHelper.findPropertiesByQuery(new ConditionAndWrapper().eq(OrderProduct::getOrderId, orderId), OrderProduct.class,  OrderProduct::getProductId, String.class);
	return jpaHelper.findListByQuery(new ConditionAndWrapper().in(Product::getId, productIds), Product.class);
}


// 根据产品名查出所有订单
public PageResp<Order> search(PageReq pageReq, String keywords) {
	ConditionOrWrapper conditionOrWrapper = new ConditionOrWrapper();
		
	if (StrUtil.isNotEmpty(keywords)) {
			
	    List<String> productIds = jpaHelper.findIdsByQuery(new ConditionAndWrapper().like(Product::getName, keywords), Product.class);
	    List<String> orderIds = jpaHelper.findPropertiesByQuery(new ConditionAndWrapper().in(OrderProduct::getProductId, productIds), OrderProduct.class,  OrderProduct::getOrderId, String.class);
	
	    conditionOrWrapper.in(Order::getId, orderIds);
	}

	PageResp<Order> page = jpaHelper.findPage(conditionOrWrapper, pageReq, Order.class);
	return page;
}

public PageResp<User> search(PageReq pageReq, String word, Integer type) {
    ConditionAndWrapper conditionAndWrapper = new ConditionAndWrapper();

	if (StrUtil.isNotEmpty(word)) {
		conditionAndWrapper.and(new ConditionOrWrapper().like(User::getName", word).like(User::getPhone, word));
	}
	if (type != null) {
		conditionAndWrapper.eq(User::getType, type);
	}
	Sort sort = new Sort(User:getCreatTime, Direction.DESC);	
	PageResp<User> page = jpaHelper.findPage(conditionAndWrapper, sort, pageReq, User.class);

	return page;
}