123

// 教师授课
public void teaSelectCourse(CzpCourse course, CzpTeacher teacher) {
final CzpCourse tempCourse = course;
final CzpTeacher tempTeacher = teacher;
Object[] obj = { course, teacher };
List list = getHibernateTemplate().find(
"from CzpCT where czpCourse=? and czpTeacher=?", obj);
if (list.size() == 0) {
getHibernateTemplate().execute(new HibernateCallback() {


public Object doInHibernate(Session session)
throws HibernateException, SQLException {
// 执行存储过程
CallableStatement stCall = session.connection()
.prepareCall("{call " + "C_T_lastOne" + "}");
stCall.execute();
ResultSet rs = stCall.getResultSet();
String last = new String();
while (rs.next()) {
last = rs.getString("C_T_id");
}
BigInteger bigInteger = new BigInteger(last);
// 执行存储过程
stCall = session.connection().prepareCall(
"{call " + "teacherInsertCourse(?,?,?)" + "}");
stCall.setString(1, bigInteger.add(BigInteger.ONE)
.toString());
stCall.setString(2, tempTeacher.getTeaId());
stCall.setString(3, tempCourse.getCouId());
stCall.execute();
return null;
}
});
} else {
return;
}
}