/**
* 添加
*
* @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;
}
}
/**
* 为学院添加年级
*
* @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;
}
}
/**
* 删除一条学院记录
*
* @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;
}
}
/**
* 修改学院信息
*
* @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;
}
}