[JAVA, SPRING] SPRING JDBC, TRANSACTION-MANAGER

@Repository //DAO 객체 등록
public class StudentDAOSpring implements StudentDAO{
	
	@Autowired //타입 주입
	private JdbcTemplate spring;
	
	// SQL 명령어
	private final String STUDENT_INSERT = "insert into student(num, sex, name, role) values((select nvl(max(seq), 0) + 1 from student), ?, ?, ?)";
	private final String STUDENT_UPDATE = "update student set name = ?, role = ? where num = ?";
	private final String STUDENT_DELETE = "delete student where num = ?";
	private final String STUDENT_LIST_N = "select * from student where name like '%'||?||'%' order by num desc";
	private final String STUDENT_LIST_R = "select * from student where role like '%'||?||'%' order by num desc";
	private final String STUDENT_GET  = "select * from student where num = ?";
	
	// CRUD 기능의 메소드
	// 학생 정보 등록
	public void insertStudent(StudentVO vo) {
		System.out.println("===> SPRING 기반으로 insertStudent() 기능 처리");
		spring.update(STUDENT_INSERT, vo.getSex(), vo.getName(), vo.getRole());
		
	}
	
	// 학생 정보 수정
	public void updateStudent(StudentVO vo) {
		System.out.println("===> SPRING 기반으로 updateStudent() 기능 처리");
		spring.update(STUDENT_UPDATE,vo.getName(),vo.getRole(),vo.getNum());
	}
	
	// 학생 정보 삭제
	public void deleteStudent(StudentVO vo) {
		System.out.println("===> SPRING 기반으로 deleteStudent() 기능 처리");
		spring.update(STUDENT_DELETE,vo.getNum());
	}
    
    // 학생 상세 조회
	public StudentVO getStudent(StudentVO vo) {
		System.out.println("===> SPRING 기반으로 getStudent() 기능 처리");
		return spring.queryForObject(STUDENT_GET, new StudentRowMapper(), vo.getNum());
	}
	
	// 학생 목록 검색
	public List<StudentVO> getStudentList(StudentVO vo) {
		System.out.println("===> SPRING 기반으로 getStudentList() 기능 처리");
		if(vo.getSearchCondition().equals("NAME")) {
			return spring.query(STUDENT_LIST_N, new StudentRowMapper(), vo.getSearchKeyword() );
		}else if(vo.getSearchCondition().equals("ROLE")) {
			return spring.query(STUDENT_LIST_R,new StudentRowMapper(), vo.getSearchCondition());
		}
		return null;
		}
}
    

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.jdbc.core.RowMapper;

public class StudentRowMapper implements RowMapper<StudentVO> {

	@Override
	public StudentVO mapRow(ResultSet rs, int rowNum) throws SQLException {
		StudentVO student = new StudentVO();
		student.setNum(rs.getInt("NUM"));
		student.setSex(rs.getString("SEX"));
		student.setName(rs.getString("NAME"));
		student.setRole(rs.getString("ROLE"));
		student.setRegDate(rs.getDate("REGDATE"));
		return student;
	}
}