初学Mybatis

官网地址:https://mybatis.org/mybatis-3/

1、准备开发环境

 pom.xml文件引入所需要的jar包:

mybatis jar包:
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.3</version>
</dependency>

mysql 数据库所需jar包:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.48</version>
</dependency>

2、创建数据库:

CREATE TABLE user(
 id bigint(20) not null auto_increment,
 user_name varchar(60) default null,
 age int(3) default null,
 phone varchar(11) default  null,
 description varchar(200) default null,
 primary key (id)
)ENGINE=InnoDB auto_increment=1 default charset=utf8;

插入两条数据:

insert into user (user_name,age,phone,description) values ("张三",10,"11111111111","张三的自我介绍");

insert into user (user_name,age,phone,description) values ("李四",11,"11111111112","李四的自我介绍");

3、通过使用xml配置方式获取表中的数据

（1）在resources文件夹下创建mybatis配置文件: mybatis-config.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>
    <!--setting修改运行时行为-->
    <!--<settings>
        <setting name="" value=""/>
    </settings>-->
    <typeAliases>
        <typeAlias type="com.web.entity.User" alias="User"/>
    </typeAliases>
    <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://localhost:3306/tl-vip"/>
                <property name="username" value="root"/>
                <property name="password" value="mysql"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--注意文件所在位置-->
        <!--注册userMapper.xml文件-->
        <mapper resource="mybatis/UserMapper.xml"/>
    </mappers>
</configuration>

（2）实体类:

public class User implements Serializable {
    private Integer id;
    private String user_name;
    private int age;
    private String phone;
    private String description;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUser_name() {
        return user_name;
    }

    public void setUser_name(String user_name) {
        this.user_name = user_name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", user_name='" + user_name + '\'' +
                ", age=" + age +
                ", phone='" + phone + '\'' +
                ", description='" + description + '\'' +
                '}';
    }
}

(3)定义操作user表的映射文件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="com.web.mapper.UserMapper">
    <select id="byId" resultType="User">
        select * from user where id = #{id}
    </select>
</mapper>

(4)测试类

@Slf4j
public class MybatisTest {
    @Test
    public void test() throws IOException {
        //Mybatis的配置文件
        String resource = "mybatis-config.xml";
        //使用类加载器加载Mybatis的配置文件(它也加载关联的映射文件)
        InputStream inputStream = Resources.getResourceAsStream(resource);
        //构建sqlSession的工厂
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //创建能执行映射文件中sql的sqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();
        /**
         * 映射sql的标识字符串
         * com.web.mapper.UserMapper是userMapper.xml文件中mapper标签的namespace属性值
         * byId是select标签的id属性值,通过select标签的id属性值可以找到要执行的SQL
         */
        String statment = "com.web.mapper.UserMapper.byId";//映射sql的标识字符串
        //执行查询返回一个唯一user对象的sql
        User user = sqlSession.selectOne(statment, 1);
        System.out.println(user == null ? null : user.toString());
        log.info("user:{}", user == null ? null : user.toString());
    }
}

执行结果如下: