jpa自定义查询，用自定义dto接收

可以用List<Object[]>来接收自定义查询的结果。

@Query(value = "select id,name from user where name = ?1", nativeQuery = true)
	public List<UserCustomFail> ttt(String name);

UserCustomFail类的代码如下：

@SqlResultSetMapping(name = "ttt", // 如果@Query 不指定name 会默认使用方法名
classes = { 
	@ConstructorResult(targetClass = com.example.accessingdatamysql.UserCustomFail.class, columns = {
		@ColumnResult(name = "id", type = Integer.class),
		@ColumnResult(name = "name", type = String.class) 
	}) 
})
public class UserCustomFail {
	private Integer id;

	private String name;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

}