spring和mybatis整合：使用xml方式

spring和mybatis整合：使用xml方式

1. 创建数据库

DROP DATABASE IF EXISTS `crm`;
CREATE DATABASE `crm`;
use `crm`;
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `user_tel` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,  `registration_time` datetime DEFAULT CURRENT_TIMESTAMP,  PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARSET=utf8;

INSERT INTO `t_user` VALUES ('1', '13880000001', '金庸', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', '2018-12-15 06:54:16'),
 ('2', '13880000002', '张三丰', '875f26fdb1cecf20ceb4ca028263dec6', '2018-12-15 06:54:16'), 
 ('3', '13880000003', '张无忌', 'c1f68ec06b490b3ecb4066b1b13a9ee9', '2018-12-15 06:54:16'), 
 ('4', '13880000004', '黄蓉', '980ac217c6b51e7dc41040bec1edfec8', '2018-12-15 06:54:16'), 
 ('5', '13880000005', '郭靖', 'cd87cd5ef753a06ee79fc75dc7cfe66c', '2018-12-15 06:54:16'),
 ('6', '13880000006', '周伯通', 'eed8cdc400dfd4ec85dff70a170066b7', '2018-12-15 06:54:16'),
  ('7', '13880000006', '杨过', '594f803b380a41396ed63dca39503542', '2018-12-17 17:05:40');

2. 创建工程，pom.xml文件如下：

<?xml version="1.0" encoding="UTF-8"?><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>com.yingside</groupId>
    <artifactId>mybatisdemo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <!--mysql数据库驱动包-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!--引入mybatis包-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <!--引入junit测试包-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
    </dependencies></project>

3. 依赖下载地址如下：

https://mvnrepository.com/

4. 配置mybatis的全局配置,在resources目录中加入mybatis-configuration.xml文件

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>    
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/crm"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments></configuration>

5. 定义表所对应的实体类,一般在bean目录下，或者pojo目录下

package com.yingside.bean;public class User {    
    private int id;    
    private String userTel;    
    private String username;    
    private String password;    
    private String registrationTime;    
    public int getId() {        
        return id;
    }    
    public void setId(int id) {        
        this.id = id;
    }    
    public String getUserTel() {        
        return userTel;
    }    
    public void setUserTel(String userTel) {        
        this.userTel = userTel;
    }    
    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 String getRegistrationTime() {        
        return registrationTime;
    }    
    public void setRegistrationTime(String registrationTime) {        
        this.registrationTime = registrationTime;
    }    
    @Override
    public String toString() {        
        return "User{" +
               "id=" + id +
               ", userTel='" + userTel + '\'' +
               ", username='" + username + '\'' +
               ", password='" + password + '\'' +                ", registrationTime='" + registrationTime + '\'' +                '}';
    }
}

6. 定义操作 t_user 表的sql映射文件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">
<!-- 这个XML文件其实就相当于我们三层架构中的DAO层的实现类xxxDaoImpl,如果拿它跟具有相同功能的 JDBC 代码进行对比，你会立即发现省掉了将近 95% 的代码。
    也就是说,有了这个配置文件,至少之前原始JDBC中经常出现的Connection,PreparedStatement,ResultSet这些接口不需要你再创建了
    当然要编写这个文件,需要对<mapper>标签中出现的属性和标签都要熟悉,不过没有必要去一一熟悉,用到什么我们再去查询就行了
-->
<!-- 为这个mapper指定一个唯一的namespace，namespace的值习惯上设置成包名+sql映射文件名，这样就能够保证namespace的值是唯一的
例如namespace="om.yingside.mapper.UserMapper"就是com.yingside.mapper(包名)+UserMapper(UserMapper.xml文件去除后缀)
 -->
<mapper namespace="com.yingside.mapper.UserMapper">
    <!--
       根据 id 查询 user 表中的数据
       id:唯一标识符，此文件中的id值不能重复,简单来说,就是DAO层中的方法名
       resultType:返回值类型，一条数据库记录也就对应实体类的一个对象,注意现在要跟上全名(包名+类名)
       parameterType:参数类型，也就是查询条件的类型
       #{}表示一个占位符即?,在使用时不需要关心参数值的类型，mybatis会自动进行java类型和jdbc类型的转换。
     -->
    <select id="getUser" parameterType="int"
            resultType="com.yingside.bean.User">
        select * from t_user where id=#{id}    
    </select>
</mapper>

7. 在mybatis-configuration.xml配置文件中注册UserMapper.xml文件

mybatis-configuration.xml文件的<configuration></configuration>标签中加入<mappers></mappers>标签

<!-- 注册UserMapper.xml文件,
       UserMapper.xml位于com.yingside.mapper这个包下,
       所以resource写成com/yingside/mapper/UserMapper.xml-->
    <mappers>
        <mapper resource="com/yingside/mapper/UserMapper.xml" />
    </mappers>

8. 文件结构