Spring整合mybatis环境搭建


1.导包


    
    
        junit
        junit
        4.12
        test
    
    
    
        mysql
        mysql-connector-java
        5.1.47
    
    
    
        org.mybatis
        mybatis
        3.5.2
    
    
    
        org.springframework
        spring-webmvc
        5.1.9.RELEASE
    
    
    
        org.springframework
        spring-jdbc
        5.1.9.RELEASE
    
    
    
        org.aspectj
        aspectjweaver
        1.8.13
        runtime
    
    
    
        org.mybatis
        mybatis-spring
        2.0.2
    




    
        
            src/main/resources
            
                **/*.properties
                **/*.xml
            
            true
        
        
            src/main/java
            
                **/*.properties
                **/*.xml
            
            true
        
    

2.配置文件

1.applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>

    

    
    
    

    
        
    

2.spring-dao.xml

<?xml version="1.0" encoding="UTF-8"?>

    
    
        
        
        
        
    

    
    
        
        
        
        
    

    
    
        
        
    

    
    
        
    


    
    
    
        
        
        




            
        
    

    
    
        
        
    


3.mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>



    
        
        

    

    
    
        
    


Mapper实现类

public class UserMapperImpl implements UserMapper {
    // 我们的所有操作,都使用sqlSession来执行,在原来
    // 现在都使用SqlSessionTemplate
    private SqlSessionTemplate sqlSession;

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

    public List selectUser() {
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        return mapper.selectUser();
    }
}