【Spring】Spring整合Mybatis（双版本）

最新推荐文章于 2024-05-03 12:05:30 发布

Steph Wae

最新推荐文章于 2024-05-03 12:05:30 发布

阅读量536

点赞数

分类专栏： Spring Mybatis 文章标签： spring 数据库 java java-ee

本文链接：https://blog.csdn.net/qq_54179913/article/details/127931509

版权

Spring 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

Mybatis

2 篇文章 0 订阅

订阅专栏

Spring整合Mybatis

一、基于xml配置文件

1、项目结构

2、导入依赖

<dependencies>
    <!--junit-->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.13.2</version>
        <scope>test</scope>
    </dependency>
    <!-- log4j-core -->
    <dependency>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-core</artifactId>
        <version>2.17.1</version>
    </dependency>
    <!--lombok-->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.24</version>
        <scope>provided</scope>
    </dependency>
    <!--Spring-->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>5.2.10.RELEASE</version>
    </dependency>
    <!--MyBatis-->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.11</version>
    </dependency>
    <!--druid连接池-->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.2.8</version>
    </dependency>
    <!--mybatis-spring包-->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.3.0</version>
    </dependency>
    <!--mysql驱动-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>
    <!--spring-jdbc-->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>5.2.10.RELEASE</version>
    </dependency>
    <!--spring-test-->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>5.2.10.RELEASE</version>
        <scope>test</scope>
    </dependency>
</dependencies>

3、创建数据表、编写实体类

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_book
-- ----------------------------
DROP TABLE IF EXISTS `tb_book`;
CREATE TABLE `tb_book`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `book_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `publisher` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `price` decimal(10, 2) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `unique_book_name`(`book_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_book
-- ----------------------------
INSERT INTO `tb_book` VALUES (25, '水浒传', '人民教育出版社', '人物', '施耐庵', 88.00);
INSERT INTO `tb_book` VALUES (26, '三国演义', '人民教育出版社', '历史', '罗贯中', 88.00);
INSERT INTO `tb_book` VALUES (27, '红楼梦', '人民教育出版社', '爱情', '曹雪芹', 188.00);
INSERT INTO `tb_book` VALUES (28, '西游记', '人民教育出版社', '神话', '吴承恩', 188.00);

SET FOREIGN_KEY_CHECKS = 1;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Book {
    private Integer id;
    private String bookName;
    private String publisher;
    private String category;
    private String author;
    private Double price;
}

4、编写mapper接口

public interface BookMapper {
   List<Book> getBooks();
}

5、编写映射文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--mapper接口的全类名和映射文件的命名空间（namespace）保持一致-->
<mapper namespace="com.wae.mapper.BookMapper">
    <select id="getBooks" resultType="Book">
        select * from tb_book
    </select>
</mapper>

6、log4j日志

log4j.rootLogger=INFO,STDOUT
log4j.appender.STDOUT=org.apache.log4j.ConsoleAppender
log4j.appender.STDOUT.layout=org.apache.log4j.PatternLayout
log4j.appender.STDOUT.layout.ConversionPattern=%c %x %m%n
# trace要对应自己的mapper包的路径
log4j.logger.com.wae.mapper=trace

7、简化MyBatis核心配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <!--驼峰命名-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <!--开启log4j日志-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
</configuration>

8、编写数据库资源文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring_mybatis?useUnicode=true&characterEncoding=utf8&useSSL=false
jdbc.username=root
jdbc.password=123456

9、编写spring核心配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd">

    <!--加载数据库资源文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>

    <!--配置druid数据源 bean-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <!--配置sqlSessionFactory bean-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--注入数据源-->
        <property name="dataSource" ref="dataSource"/>
        <!--指定mybatis核心配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!--实体类起别名-->
        <property name="typeAliasesPackage" value="com.wae.entity"/>
    </bean>


    <!--扫描mapper包，告诉Spring应该代理实现哪些mapper接口-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.wae.mapper"/>
    </bean>
</beans>

10、Spring整合Junit并测试

@RunWith(SpringJUnit4ClassRunner.class)
//引入Spring核心配置文件
@ContextConfiguration(value = "classpath:applicationContext.xml")
public class BookTest {

    //自动装配sqlSessionFactory
    @Autowired
    SqlSessionFactory sqlSessionFactory;

    @Test
    public void test(){

        SqlSession sqlSession = sqlSessionFactory.openSession(true);
        BookMapper mapper = sqlSession.getMapper(BookMapper.class);
        List<Book> list = mapper.getBooks();
        list.forEach(System.out::println);

    }

}

11、打印结果

二、基于配置类和注解

1、项目结构

2、基础环境

基础环境同上

3、数据源配置类

public class JDBCConfig {

    @Value("${jdbc.driver}")
    private String driver;

    @Value("${jdbc.url}")
    private String url;

    @Value("${jdbc.username}")
    private String username;

    @Value("${jdbc.password}")
    private String password;

    //把dataSource注册到ioc容器中
    @Bean
    public DataSource dataSource(){
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setDriverClassName(driver);
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        return dataSource;
    }
}

4、SqlSessionFactory配置类

public class MyBatisConfig {

    //把sqlSessionFactory注册到ioc容器中
    //小tip:dataSource已经在ioc容器中注册过了，可以把它作为方法参数直接使用
    @Bean
    public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource){
        SqlSessionFactoryBean ssfb = new SqlSessionFactoryBean();

        //注入数据源
        ssfb.setDataSource(dataSource);
        //设置别名
        ssfb.setTypeAliasesPackage("com.wae.entity");

        Configuration configuration = new Configuration();
        //开启驼峰命名
        configuration.setMapUnderscoreToCamelCase(true);
        //开启日志
        configuration.setLogImpl(StdOutImpl.class);
        ssfb.setConfiguration(configuration);
        return ssfb;
    }


    //把代理实现mapper接口的实现类注册到ioc容器中
    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer(){
        MapperScannerConfigurer msc = new MapperScannerConfigurer();
        //扫描指定包
        msc.setBasePackage("com.wae.mapper");
        return msc;
    }

}

5、Spring配置类

//标记为配置类
@Configuration
//扫描包，使注解生效
@ComponentScan("com.wae")
//加载数据库资源文件
@PropertySource("classpath:jdbc.properties")
//把数据源、SqlSessionFactory配置类注册到ioc容器中
@Import({JDBCConfig.class,MyBatisConfig.class})
public class SpringConfig {
}

6、测试

@RunWith(SpringJUnit4ClassRunner.class)
//引入Spring配置类
@ContextConfiguration(classes = SpringConfig.class)
public class BookTest {

    @Test
    public void test(){
        //获取context上下文
        AnnotationConfigApplicationContext context = new AnnotationConfigApplicationContext(SpringConfig.class);

        BookMapper mapper = context.getBean(BookMapper.class);
        List<Book> bookList = mapper.getBooks();
        bookList.forEach(System.out::println);

    }

}