JpaRepository中new的方式产生新的对象,并配置好其构造函数
JPA对字段命名有一点规则,推荐使用驼峰式命名,如果下面的方法会报错,并且没有明确的报错信息,请先看字段是否合法!!!!!
下面是实例代码:
JpaRepository:
@Transactional
public interface PayeeDataRepo extends JpaRepository<PayeeData, String> {
@Query("select new com.stylefeng.guns.workday.bean.PayeeData(p.id,p.name,p.bankAccountNumberEncode,p.adhocPayeeID,p.isDomestic,p.bankAccountName ) from PayeeData p")
List<PayeeData> finddAllNoBankNumber();
}
PayeeData Bean:
public class PayeeData implements Serializable {
public PayeeData() {
}
public PayeeData(String id, String name, String bankAccountNumberEncode, String adhocPayeeID, Integer isDomestic, String bankAccountName) {
this.id = id;
this.name = name;
this.bankAccountNumberEncode = bankAccountNumberEncode;
this.adhocPayeeID = adhocPayeeID;
this.isDomestic = isDomestic;
this.bankAccountName = bankAccountName;
}
}