JPA 视图查询 SELECT NEW

转自 : http://blog.csdn.net/chaijunkun/article/details/8442406

适应场景: 

1 用SpringJPA框架

2 需要选取多个实体表的字段, 组装成一个类时(例如下面例子中的GoodsSales类是由Order类的数据组成的)

1. DTO 类 GoodsSales

package com.exodus.weistore.goods.data;

import java.io.Serializable;

public class GoodsSales implements Serializable{
	private static final long serialVersionUID = 4497500574990765498L; 
	
	//产品id
	private String goodsId;
	//产品总销量
	private Long amount;

	public GoodsSales()
	{ };
	
	p