JPA 中 sql 预编译 -- EntityManager 使用 预编译

  @PersistenceContext
    private EntityManager entityManager;

  @PersistenceUnit
    private EntityManagerFactory emf;

 private EntityManager getEm() {
        return this.entityManager;
 }

  /**
     * 得EntityManager
     *
     * @return
     */
    private EntityManager getEm() {
        return emf.createEntityManager();
    }

   EntityManager em = getEm();
   String getAllTask = "SELECT ID,DEPARTMENT,WBS,CODE,NAME,PARENT_CODE FROM GAEI_WORK_TASK" +
                    " WHERE WBS = ? AND DEPARTMENT = ? ";
            Query query = em.createNativeQuery(getAllTask);
            query.setParameter(1, wbs);
            query.setParameter(2, ((Department) userService.getSecondDepartmentByUserId(uid)).getId());
            List<Object> taskList = query.getResultList();

 String sql = " SELECT" +
                    " pro.id," +
                    " pro.CODE," +
                    " pro.PROJECT_NAME," +
                    " pro.PROJECT_DIRECTOR_NO 'PROJECT_DIRECTOR_NO.id'," +
                    " pro.source," +
                    " gaei_pro.WBS," +
                    " app_user.fullname 'PROJECT_DIRECTOR_NO.fields'," +
                    " gaei_pro.STATUS" +
                    " FROM" +
                    " GAEI_PROJECT pro" +
                    " LEFT JOIN appbricks_user app_user ON gaei_pro.PROJECT_DIRECTOR_NO = app_user.id" +
                    " WHERE app_user.id = '" + approveId + "'" +
                    " ORDER BY pro.CODE ASC";

            List<Object> resultList = getResultList(em, sql);

 // 执行查询
    public static <T> List<T> getResultList(EntityManager em, String sql) {
        List<T> resultList = em.createNativeQuery(sql).getResultList();
        return resultList;
    }