spring整合mybatis

一、maven依赖包

<project xmlns="http://maven.apache.org/POM/4.0.0"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xsi:schemaLocation="http://maven.apache.org/POM/4.0.0  http://maven.apache.org/xsd/maven-4.0.0.xsd">

       <modelVersion>4.0.0</modelVersion>

       <groupId>mvn.spring.mybatis</groupId>

       <artifactId>springMybatis</artifactId>

       <version>0.0.1-SNAPSHOT</version>

       <packaging>jar</packaging>

       <name>springMybatis</name>

       <url>http://maven.apache.org</url>

       <properties>

              <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

              <spring-version>5.1.6.RELEASE</spring-version>

              <mybatis-version>3.5.1</mybatis-version>

              <mybatis-spring-version>2.0.1</mybatis-spring-version>

       </properties>

       <dependencies>

              <dependency>

                     <groupId>junit</groupId>

                     <artifactId>junit</artifactId>

                     <version>3.8.1</version>

                     <scope>test</scope>

              </dependency>

              <dependency>

                     <groupId>commons-logging</groupId>

                     <artifactId>commons-logging</artifactId>

                     <version>1.2</version>

              </dependency>

              <dependency>

                     <groupId>mysql</groupId>

                     <artifactId>mysql-connector-java</artifactId>

                     <version>8.0.16</version>

              </dependency>

              <!-- srping -->

              <dependency>

                     <groupId>org.springframework</groupId>

                     <artifactId>spring-core</artifactId>

                     <version>${spring-version}</version>

              </dependency>

              <dependency>

                     <groupId>org.springframework</groupId>

                     <artifactId>spring-context</artifactId>

                     <version>${spring-version}</version>

              </dependency>

              <dependency>

                     <groupId>org.springframework</groupId>

                     <artifactId>spring-test</artifactId>

                     <version>${spring-version}</version>

              </dependency>

              <dependency>

                     <groupId>org.springframework</groupId>

                     <artifactId>spring-tx</artifactId>

                     <version>${spring-version}</version>

              </dependency>

              <dependency>

                     <groupId>org.springframework</groupId>

                     <artifactId>spring-beans</artifactId>

                     <version>${spring-version}</version>

              </dependency>

              <dependency>

                     <groupId>org.springframework</groupId>

                     <artifactId>spring-jdbc</artifactId>

                     <version>${spring-version}</version>

              </dependency>

              <!-- mybatis -->

              <dependency>

                     <groupId>org.mybatis</groupId>

                     <artifactId>mybatis</artifactId>

                     <version>${mybatis-version}</version>

              </dependency>

              <dependency>

                     <groupId>org.mybatis</groupId>

                     <artifactId>mybatis-spring</artifactId>

                     <version>${mybatis-spring-version}</version>

              </dependency>

       </dependencies>

</project>

 

二、spring配置文件：ApplicationContext.xml

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

<beans xmlns="http://www.springframework.org/schema/beans"

       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

       xsi:schemaLocation="http://www.springframework.org/schema/beans

        https://www.springframework.org/schema/beans/spring-beans.xsd">

       <!-- 数据源设置 -->

       <bean id="dataSource"

              class="org.springframework.jdbc.datasource.DriverManagerDataSource">

              <property name="driverClassName"

                     value="com.mysql.cj.jdbc.Driver"></property>

              <property name="url"  value="jdbc:mysql://localhost:3306/ssm"></property>

              <property name="username" value="root"></property>

              <property name="password" value="password"></property>

       </bean>

       <!-- sqlsessionfactory -->

       <bean id="factory"

              class="org.mybatis.spring.SqlSessionFactoryBean">

              <property name="dataSource" ref="dataSource"></property>

       </bean>

       <!-- mapper -->

       <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

              <property name="basePackage"  value="spring.mybatis.mapper"></property>

       </bean>

</beans>

 

三、mapper接口

package spring.mybatis.mapper;

 

import org.apache.ibatis.annotations.Select;

import spring.mybatis.pojo.Student;

 

public interface StudentMapper {

    @Select("select * from stu where name=#{0}")

    Student selOne(String name);

}

 

四、使用

package spring.mybatis.service;

 

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import spring.mybatis.mapper.StudentMapper;

import spring.mybatis.pojo.Student;

 

public class Service {

    public static void main(String[] args) {

        ApplicationContext ac = new ClassPathXmlApplicationContext("ApplicationContext.xml");

        StudentMapper sm = ac.getBean("studentMapper", StudentMapper.class);

        Student stu=sm.selOne("lisi");

        System.out.println(stu);

    }

}