mysql 一个错误

来源:互联网 发布:银行家算法详细流程 编辑:程序博客网 时间:2024/06/09 18:06

@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,发送)


@PersistenceContextprivate 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.



原创粉丝点击