Java学习路线-61：MyBatis声明式事务

1、完整配置

（1）beans.xml

（2）mybatis-config.xml

（3）StudentMapper.xml

    
        select * from students where id = #{id}
    

    
        select * from students
    

    
        update students set age = #{age} where id = #{id}
    

    
        
        deletes from students where id = #{id}
    

2、DAO

（1）接口

package com.pengshiyu.mybatis.dao;

import com.pengshiyu.mybatis.entity.Student;

public interface StudentDao {

    public void update(Student studentA, int id);
    public Student getById(int id);

}

（2）实现

package com.pengshiyu.mybatis.dao.impl;

import com.pengshiyu.mybatis.dao.StudentDao;
import com.pengshiyu.mybatis.entity.Student;
import org.mybatis.spring.SqlSessionTemplate;

public class StudentDaoImpl implements StudentDao {
    private SqlSessionTemplate sqlSession;

    @Override
    public Student getById(int id) {
        return sqlSession.selectOne("com.pengshiyu.mybatis.entity.StudentMapper.getById", id);
    }

    @Override
    public void update(Student studentA, int id) {
        sqlSession.update("com.pengshiyu.mybatis.entity.StudentMapper.updateById", studentA);
        sqlSession.delete("com.pengshiyu.mybatis.entity.StudentMapper.deleteById", id);
    }

    public void setSqlSession(SqlSessionTemplate sqlSession) {
        this.sqlSession = sqlSession;
    }
}

3、测试

package com.pengshiyu.mybatis.test;

import com.pengshiyu.mybatis.dao.StudentDao;
import com.pengshiyu.mybatis.entity.Student;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.io.IOException;

public class Demo {
    public static void main(String[] args) throws IOException {
        ApplicationContext context = new ClassPathXmlApplicationContext("beans.xml");

        StudentDao studentDao = (StudentDao) context.getBean("StudentDao");

        Student studentA = studentDao.getById(1);
        studentA.setAge(25);

        studentDao.update(studentA, 3);
    }
}