2021-09-29 Spring整合Mybatis

方式一：用SqlSessionTemplate 1.导包

1. junit
2. mysql
3. mybatis
4. spring
5. aop织入
6. mybatis-spring
7. spring-jdbc

  
      
    
      junit
      junit
      4.11
      test
    
      
    
    
      org.mybatis
      mybatis
      3.5.6
    
      
    
    
      mysql
      mysql-connector-java
      8.0.11
    
      
    
    
      org.aspectj
      aspectjweaver
      1.9.4
    
      
    
    
      org.springframework
      spring-webmvc
      5.3.9
    
      
    
    
      org.mybatis
      mybatis-spring
      2.0.6
    
      
    
    
      org.springframework
      spring-jdbc
      5.3.9
    
  

2.配置数据源

3.配置SqlSessionFactory的bean

4.配置SqlSession的bean

5.编写mapper接口

public interface UserMapper
{
    public List select();
}

6.编写mapper.xml文件

    
        select * from user
    

7.配置mapper的bean，注入SqlSession

8.为了注入SqlSession，得实现mapper接口，写mapper接口的实现类

因为得写set方法，接口不能配bean

public class UserMapperImpl implements UserMapper
{
    private SqlSessionTemplate sqlSession;

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

    @Override
    public List select() {
       return sqlSession.getMapper(UserMapper.class).select();
    }
}

10.测试，从spring配置文件中获取mapper

    public static void main(String[] args)
    {
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationcontext.xml");
        UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
        List users=userMapper.select();
        for (User user : users) {
            System.out.println(user);
        }
    }

方式二：SqlSessionDaoSupport