JPA 使用EntityManager
@Service
public class MyJpaService {
@PersistenceContext
EntityManager entityManager;
/**
* 方法如下
* @param
*/
public void continuousFailed() {
// 获取当天0点时间
String startTime = DateUtil.getCurrDate();
// 统计当天魔盒挖矿失败次数
String sql = "select deviceid,count(id) as total from error_log where type=1 and create_time<'"+startTime+"' group by deviceid";
Query query = entityManager.createNativeQuery(sql);
List rows = query.getResultList();
for (Object row : rows) {
Object[] cells = (Object[]) row;
System.out.println(cells[0]);
System.out.println(cells[1]);
}
}
}