spring MVC + JDBC(包括触发器，AOP等)

package com.lizc.service; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; import com.lizc.dao.StudentEvent; import com.lizc.dao.StudentQuery; import com.lizc.entity.StudentEntity; import com.lizc.exception.UpdateStudentException; import com.lizc.param.ParamResponse; import com.lizc.param.resp.StudentResp; import com.lizc.utils.StringUtils; /** * 学生业务处理 * @author think * */ @Service public class StudentService { @Autowired private StudentQuery stuQuery; @Autowired private StudentEvent stuEvent; /** * 获取学生 * @return */ public List<StudentEntity> queryAllStudent(){ return stuQuery.queryAllStudentToObject(); } /** * 保存学生 * @param student * @return * @throws UpdateStudentException 更新学生信息失败异常 */ @Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class) public ParamResponse saveStudent(StudentEntity student) { StudentResp studentResp = new StudentResp(); try { /* 添加学生 */ stuEvent.saveStudent(student); /* 将该学生信息返回给页面 */ studentResp.setRealName(student.getRealName()); studentResp.setUserName(student.getUserName()); studentResp.setSex(student.getSex()); studentResp.setPassWord(student.getPassWord()); studentResp.setClassId(student.getClassId()); studentResp.setDesc(student.getDesc()); /* 添加成功的返回码 */ studentResp.setResultCode("200"); studentResp.setResultMsg("添加成功"); } catch (UpdateStudentException e) { e.printStackTrace(); studentResp.setResultCode("500"); studentResp.setResultMsg("添加失败"); } catch (Exception e) { e.printStackTrace(); studentResp.setResultCode("500"); studentResp.setResultMsg("服务异常"); } return studentResp; } /** * 删除学生 * @param userNameStr */ @Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class) public void removeStudent(String removeStr){ try { String userNameStr = StringUtils.splitStrByLine(removeStr, null); if(userNameStr != null && !"".equals(userNameStr)){ stuEvent.removeStudent(userNameStr); } System.out.println(userNameStr); } catch (UpdateStudentException e) { e.printStackTrace(); } catch (Exception e){ e.printStackTrace(); } } public static void main (String args[]){ try { ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml"); StudentService stuService = (StudentService)context.getBean("studentService"); // StudentEntity stu = new StudentEntity(); // stu.setRealName("西方求败"); // stu.setUserName("xifangqiubai"); // stu.setPassWord("xifangqiubai"); // stu.setSex("女"); // stu.setDesc("邋遢大王"); // stu.setClassId(2); // // stuService.saveStudent(stu); stuService.queryAllStudent(); // System.out.println("sssssss"); } catch (Exception e) { e.printStackTrace(); } } }