详解Spring如何整合Mybatis 详解Spring如何整合Mybatis

第一步导入相关jar包

mysqlmysql-connector-java8.0.21 org.mybatismybatis3.4.6 junitjunit4.13.2test org.springframeworkspring-webmvc5.3.8 org.springframeworkspring-jdbc5.3.8 org.aspectjaspectjweaver1.9.6 org.mybatismybatis-spring2.0.6 org.projectlomboklombok1.18.20provided src/main/resources**/*.properties**/*.xmltruesrc/main/java**/*.properties**/*.xmltrue

第二步编写配置文件
resources下：
spring-config.xml，此配置文件下，连接数据库，创建SqlSessionFactory

mybatis-config.xml，下边 mybatis 的配置在上边 spring-config.xml 也可以，但是为了更加清晰，职责明确，把别名配置放在了mybatis-config.xml 中配置了。

实体类User

package com.lxc.domain; import lombok.Data; @Datapublic class User {private String name; private String password; }

UserMapper 接口

package com.lxc.dao; import com.lxc.domain.User; import java.util.List; public interface UserMapper {public List getList(); }

UserMapperImp 实现接口

package com.lxc.dao; import com.lxc.domain.User; import org.mybatis.spring.SqlSessionTemplate; import java.util.List; // 《实现接口的类 UserMapperImp》// 需要把这个类注入到Spring中去。public class UserMapperImp implements UserMapper{// 我们所有操作都是用sqlSession 来执行的private SqlSessionTemplate sqlSession; public void setSqlSession(SqlSessionTemplate sqlSession) {this.sqlSession = sqlSession; }@Overridepublic List getList() {UserMapper userMapper = sqlSession.getMapper(UserMapper.class); return userMapper.getList(); }}

UserMapper.xml

select * from mybatis

第三步测试

import com.lxc.dao.UserMapper; import com.lxc.domain.User; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; public class Test {@org.junit.Testpublic void test() {ApplicationContext ctx = new ClassPathXmlApplicationContext("spring-config.xml"); UserMapper userMapper = ctx.getBean("userMapper", UserMapper.class); for (User item : userMapper.getList()) {System.out.println(item); }}}

输出：