Esempio n. 1
0
  /**
   * 添加
   *
   * @param academy
   * @return
   */
  public CommonResult addAcademies(Academy academy) {

    // 定义返回的结果
    CommonResult commonResult = new CommonResult();

    try {

      // 拿到之后首先检查该记录是否重了
      String sql = "select codeNumber,name FROM academy where codeNumber=? or name=?";
      List<Academy> result =
          jdbcTemplate.query(
              sql,
              new Object[] {academy.getCollegeid(), academy.getCollegename()},
              new RowMapper<Academy>() {
                @Override
                public Academy mapRow(ResultSet resultSet, int i) throws SQLException {
                  if (resultSet.next()) {
                    Academy academy1 = new Academy();
                    academy1.setCollegeid(resultSet.getInt("codeNumber"));
                    academy1.setCollegename(resultSet.getString("name"));
                    return academy1;
                  } else return null;
                }
              });
      // 说明添加了重复的元素
      if (result != null && result.size() > 0) {
        commonResult.setStatus(-1);
        commonResult.setDetail("禁止重复添加!");

        return commonResult;

      } else {
        // 插入数据
        jdbcTemplate.update(
            "INSERT INTO academy(codeNumber,name) VALUES('"
                + academy.getCollegeid()
                + "','"
                + academy.getCollegename()
                + "')");

        commonResult.setStatus(1);
        commonResult.setDetail("添加成功");
        return commonResult;
      }

    } catch (Exception ex) {

      commonResult.setDetail(ex.getMessage());
      commonResult.setStatus(-1);
      return commonResult;
    }
  }
Esempio n. 2
0
  /**
   * 为学院添加年级
   *
   * @param grade
   * @return
   */
  public CommonResult gradeAdd(final Grade grade) {

    // 定义返回的结果
    CommonResult commonResult = new CommonResult();

    try {
      // 拿到之后首先检查该记录是否重了
      String sql = "select year,academyid FROM grade where year=? AND academyid=?";
      List<Grade> result =
          jdbcTemplate.query(
              sql,
              new Object[] {grade.getYear(), grade.getAcademyid()},
              new RowMapper<Grade>() {
                @Override
                public Grade mapRow(ResultSet resultSet, int i) throws SQLException {
                  if (resultSet.next()) {
                    Grade grade1 = new Grade();
                    grade1.setYear(resultSet.getString("year"));
                    grade1.setAcademyid(resultSet.getInt("academyid"));
                    return grade1;
                  } else return null;
                }
              });
      // 说明添加了重复的元素
      if (result != null && result.size() > 0) {
        commonResult.setStatus(-1);
        commonResult.setDetail("禁止重复添加!");

        return commonResult;

      } else {
        // 插入数据
        jdbcTemplate.update(
            "INSERT INTO grade(year,academyid) VALUES('"
                + grade.getYear()
                + "','"
                + grade.getAcademyid()
                + "')");

        commonResult.setStatus(1);
        commonResult.setDetail("添加成功");
        return commonResult;
      }

    } catch (Exception ex) {

      commonResult.setDetail(ex.getMessage());
      commonResult.setStatus(-1);
      return commonResult;
    }
  }
Esempio n. 3
0
  /**
   * 删除一条学院记录
   *
   * @param collegeid
   * @return
   */
  public CommonResult deleteAcademies(int collegeid) {

    // 定义返回的结果
    CommonResult commonResult = new CommonResult();

    try {
      // 先不考虑外键
      jdbcTemplate.update("DELETE FROM academy WHERE codeNumber=" + collegeid);
      commonResult.setStatus(1);
      commonResult.setDetail("已删除");

      return commonResult;

    } catch (Exception ex) {

      commonResult.setStatus(-1);
      commonResult.setDetail(ex.getMessage());

      return commonResult;
    }
  }
Esempio n. 4
0
  /**
   * 修改学院信息
   *
   * @param academy
   * @return
   */
  public CommonResult editAcademy(Academy academy) {

    // 定义返回的结果
    CommonResult commonResult = new CommonResult();
    try {
      jdbcTemplate.update(
          "UPDATE academy SET codeNumber="
              + academy.getCollegeid()
              + ",name='"
              + academy.getCollegename()
              + "'WHERE codeNumber="
              + academy.getCollegeid());
      commonResult.setStatus(1);
      commonResult.setDetail("修改成功!");
      return commonResult;

    } catch (Exception ex) {

      commonResult.setDetail(ex.getMessage());
      commonResult.setStatus(-1);
      return commonResult;
    }
  }