예제 #1
0
  @Override
  public AcademicKPIWrapper getAllByAcademicYear(String getByAcademicYear) {

    String sqlpbp_work_type =
        " select *  from pbp_work_type where academic_year ='" + getByAcademicYear + "'";

    logger.info("  getAllByAcademicYear  sqlpbp_work_type:" + sqlpbp_work_type);

    AcademicKPIWrapper academicKPIWrapper = new AcademicKPIWrapper();

    List<PBPWorkType> pBPWorkTypeList =
        this.jdbcTemplate.query(sqlpbp_work_type, new PBPWorkTypeMapper());

    for (PBPWorkType tmp : pBPWorkTypeList) {

      String sqlkpi =
          " select *  from academic_kpi where academic_year ='"
              + getByAcademicYear
              + "' and work_type_code ='"
              + tmp.getCode()
              + "' order by order_no";
      logger.info(" sqlkpi:" + sqlkpi);
      List<AcademicKPI> academicKPIList = null;

      try {
        academicKPIList = this.jdbcTemplate.query(sqlkpi, new AcademicKPIMapper());

      } catch (org.springframework.dao.EmptyResultDataAccessException ex) {
        ex.printStackTrace();
      }

      for (AcademicKPI tmpxx : academicKPIList) {
        String sqlAttribute =
            " select *  from academic_kpi_attribute where academic_year ='"
                + tmpxx.getAcademicYear()
                + "' and academic_kpi_code ='"
                + tmpxx.getCode()
                + "'";
        List<AcademicKPIAttribute> academicKPIAttributeList = new ArrayList();
        try {
          academicKPIAttributeList =
              this.jdbcTemplate.query(sqlAttribute, new AcademicKPIAttributeMapper());
        } catch (org.springframework.dao.EmptyResultDataAccessException ex) {
          ex.printStackTrace();
        }

        tmpxx.setAcademicKPIAttributeList(academicKPIAttributeList);
      }
      tmp.setAcademicKPIList(academicKPIList);
    }

    academicKPIWrapper.setpBPWorkTypeList(pBPWorkTypeList);

    return academicKPIWrapper;
  }
예제 #2
0
  @Override
  public AcademicKPI getById(String id) {
    String sql = " select *  from academic_kpi where academic_kpi_id =" + id + "";
    logger.info(" sql:" + sql);
    AcademicKPI academicKPI =
        academicKPI = this.jdbcTemplate.queryForObject(sql, new AcademicKPIMapper());
    if (academicKPI != null) {
      String sqlAttribute =
          " select *  from academic_kpi_attribute where academic_kpi_code ='"
              + academicKPI.getCode()
              + "' and academic_year='"
              + academicKPI.getAcademicYear()
              + "'";
      logger.info(" sqlAttribute:" + sqlAttribute);
      List<AcademicKPIAttribute> academicKPIAttributeList =
          this.jdbcTemplate.query(sqlAttribute, new AcademicKPIAttributeMapper());

      academicKPI.setAcademicKPIAttributeList(academicKPIAttributeList);
    }

    return academicKPI;
  }