Spring-Mybatis初结合

Spring-MyBatis初结合

环境：

• 本地数据库wampserver
• 编译器
• 数据库管理工具Navicat

步骤：

1、打开编译器新建Maven项目

2、创建src/main/resources资源文件夹

3、打开pom.xml导入需要的依赖包

• junit依赖：

	<!--  junit依赖 -->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>

• mysql依赖：

    <!--  mysql依赖 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.23</version>
    </dependency>

• mybatis依赖：

    <!--  mybatis依赖 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.2</version>
    </dependency>

• mybatis-spring依赖:

    <!--  mybatis-spring依赖 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>

• 4个springframework框架依赖：

    <!--  spring-context依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.0.8.RELEASE</version>
    </dependency>
    <!--  spring-core依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>5.0.8.RELEASE</version>
    </dependency>
    <!--  spring-test依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.0.8.RELEASE</version>
    </dependency>
    <!--  spring-jdbc依赖 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.0.8.RELEASE</version>
    </dependency>

• 阿里巴巴的druib依赖：

    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.22</version>
    </dependency>

添加好以后编译器会自动下载依赖包

4、新建src/main/java文件夹新建pojo包并对应数据库的字段和数据类型，再右击自动生成setter、getter和toString方法

User.java：

public class User {
    private int uid;
    private String username;
    private String password;
    private int age;
    public int getUid() {
        return uid;
    }
    public void setUid(int uid) {
        this.uid = uid;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    @Override
    public String toString() {
        return "User{" +
                "uid=" + uid +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", age=" + age +
                '}';
    }
}

5、在src/main/resources里新建mappers包存放pojo相对应的XxxMapper文件

UserMapper.xml：

<?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="user">
    <!--    查询用户    -->
    <select id="findUser" parameterType="cn.yznu.pojo.User"
            resultType="cn.yznu.pojo.User">
        SELECT
            *
        FROM
            user
        <trim prefix="where" prefixOverrides="and">
            <if test=" uid!=null and uid!='' ">
                AND uid=#{uid}
            </if>
            <if test=" username!=null and username!='' ">
                AND username=#{username}
            </if>
        </trim>
    </select>
    
    ······
    
</mapper>

6、在resources文件夹里新建db.properties文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/um?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
jdbc.username=root
jdbc.password=

7、在resources文件夹里新建Spring容器配置文件取名spring.xml

• 新建数据源对象dataSource（连接数据库）
• 获取sqlSessionFactory对象
• 通过sqlSessionFactory对象获取sqlSession对象

以上bean都会被装入到spring容器里，用Autowired即可取出，就不需要用new方法新建
比如：

@Autowired
DataSource dataSource;			//自动装配DataSource对象

8、在src/main/test下写测试

文件大致架构

red即可取出，就不需要用new方法新建
比如：

@Autowired
DataSource dataSource;			//自动装配DataSource对象

8、在src/main/test下写测试

[外链图片转存中…(img-6x4zhIIY-1586870135539)]

文件大致架构