Spring中 mybatis的配置

素颜马尾好姑娘i 2022-03-17 01:40 196阅读 0赞

# Spring中 mybatis的配置 #

> 配置相关步骤：
> 
> 1. 添加相关依赖
> 
>     
>     <dependency>
>         <groupId>org.springframework</groupId>
>         <artifactId>spring-context</artifactId>
>         <version>4.3.22.RELEASE</version>
>     </dependency>
>     
>     
>     <dependency>
>         <groupId>com.alibaba</groupId>
>         <artifactId>druid</artifactId>
>         <version>1.1.13</version>
>     </dependency>
>     
>     
>     <dependency>
>         <groupId>com.zaxxer</groupId>
>         <artifactId>HikariCP</artifactId>
>         <version>3.3.1</version>
>     </dependency>
>     
>     
>     <dependency>
>         <groupId>mysql</groupId>
>         <artifactId>mysql-connector-java</artifactId>
>         <version>5.1.47</version>
>     </dependency>
>     
>     
>     <dependency>
>         <groupId>org.mybatis</groupId>
>         <artifactId>mybatis</artifactId>
>         <version>3.4.6</version>
>     </dependency>
>     
>     
>     <dependency>
>         <groupId>org.mybatis</groupId>
>         <artifactId>mybatis-spring</artifactId>
>         <version>1.3.2</version>
>     </dependency>
>     
>     
>     <dependency>
>         <groupId>org.springframework</groupId>
>         <artifactId>spring-jdbc</artifactId>
>         <version>4.3.22.RELEASE</version>
>     </dependency>
> 
> 2. 把 mybatis 中 sqlSessionFactory 交给 spring 管理
> 
>     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
>         
>         <property name="dataSource" ref="dataSource"/>
>     </bean>
> 
> 3. 把 mybatis 中 的 接口mapper 交给 spring 容器管理
> 
>     <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
>         <property name="basePackage" value="包名.接口包名"/>
>     </bean>
>     
>     
>     <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
>         <property name="basePackage" value="com.westos.dao"/>
>     </bean>
> 
> 4. 使用 mapper 接口
> 
> 可以直接用 \`context.getBean(mapper接口.class)\` 来获取
> 
> 5. 日志配置
> 
> pom.xml中添加日志相关的依赖  
> 
> 
>     
>     <dependency>
>         <groupId>ch.qos.logback</groupId>
>         <artifactId>logback-classic</artifactId>
>         <version>1.2.3</version>
>     </dependency>
>     
>     <dependency>
>         <groupId>org.slf4j</groupId>
>         <artifactId>jcl-over-slf4j</artifactId>
>         <version>1.7.2</version>
>     </dependency>
>     
>     <dependency>
>         <groupId>commons-logging</groupId>
>         <artifactId>commons-logging</artifactId>
>         <version>1.2</version>
>         <scope>provided</scope>
>     </dependency>
> 
> 需要提供 main/resources/logback.xml 配置文件