mysql 一个错误

@Entity @Table(name="push") public class PushEntity implements Serializable{ @Id @Column(name = "id") private String id; @Column(name = "title") private String title;// 标题 @Column(name = "is_send") private Integer isSend;// 是否发送(1,发送)

@PersistenceContext private EntityManager em;

String appSql = "SELECT\n" + "\tid,\n" + "\ttitle,\n" + "\tdigest,\n" + "\tditch,\n" + "\tcontent,\n" + "\tscope,\n" + "\tis_send,\n" + "\tsend_status,\n" + "\topen_num \n" + "FROM push \n" + String formatAppSql = String.format(appSql,PushConstant.SendStatus.NO_SEND,PushConstant.ditch.APP ,currentDate); Query appQuery = em.createNativeQuery(formatAppSql, PushEntity.class); List listObj = appQuery.getResultList();

例如

SELECT id AS id,is_send AS isSend FROM push

sql 这样写会报错，去掉as 别名，就能执行ok.