1.mybatis入门

Mybatis的安装步骤：

1. 创建数据库

create table users(
   id int primary key auto_increment,
   username varchar(20),
   password varchar(20),
   age int,
   sex varchar(4),
   birthday date
   
);

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>org.example</groupId>
    <artifactId>mybaits1</artifactId>
    <version>1.0-SNAPSHOT</version>
    <dependencies>
        <!--添加Mybatis的依赖-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <!--导入mysql依赖的jar-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.37</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <!--导入测试jar-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <build>
        <resources>
            <resource>
                <!--设置mapper的加载路径-->
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
        </resources>
    </build>

</project>

3. 编写核心配置文件

 <?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>
    <!--导入资源文件（数据库的配置信息）-->
    <properties resource="db.properties"></properties>
    <!--配置环境-->
    <environments default="development">
        <environment id="development">
            <!--配置事务管理器-->
            <transactionManager type="JDBC"/>
            <!--配置数据源-->
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--加载映射文件信息-->
        <mapper resource="com/qwy/mapper/UsersMapper.xml"/>
    </mappers>
</configuration>

4. 配置数据库资源文件（db.properties）

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mydb
jdbc.username=root
jdbc.password=admin

5. 编写日志文件（log4j.properties）

log4j.rootLogger=DEBUG,stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
1og4j.appender.stdout.layout.ConversionPattern=%5p [%t]-%m%n

6. 编写实体类

 package com.qwy.bean;

import java.util.Date;

/**
 * @author qwy
 * @create 2021-04-07 21:51
 **/
public class Users {
    private Integer id;
    private String username;
    private String password;
    private String sex;
    private Integer age;
    private Date birthday;

    public Users() {
    }

    public Users(Integer id, String username, String password, String sex, Integer age, Date birthday) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.sex = sex;
        this.age = age;
        this.birthday = birthday;
    }

    public Integer getId() {
        return id;
    }

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

    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 getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Integer getAge() {
        return age;
    }

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

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    @Override
    public String toString() {
        return "Users{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                ", birthday=" + birthday +
                '}';
    }
}

7. 编写mapper接口

 package com.qwy.mapper;

import com.qwy.bean.Users;

/**
 * @author qwy
 * @create 2021-04-07 21:57
 **/
public interface UsersMapper {
    /**
     * 添加操作
     * @param users
     * @return
     */
    public int saveUsers(Users users);
}

8. 配置mapper.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.qwy.mapper.UsersMapper">
    <!--public int saveUsers(Users users);-->
    <insert id="saveUsers" parameterType="com.qwy.bean.Users">
        insert into users(username,password,age,sex,birthday)
        values
        (#{username},#{password},#{age},#{sex},#{birthday})
    </insert>
</mapper>

9. 编写测试类

 package com.qwy.test;

import com.qwy.bean.Users;
import com.qwy.mapper.UsersMapper;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.Date;

/**
 * @author qwy
 * @create 2021-04-07 22:03
 **/
public class TestMybatis {
    private SqlSessionFactory sqlSessionFactory;
    @Before
    public void getSqlSessionFactory() throws IOException {
        String resource = "mybatis-config.xml";
        //加载核心配置文件
        InputStream inputStream = Resources.getResourceAsStream(resource);
        //创建SqlSessionFactory工厂
         sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

    }
    /**
     * 测试添加方法
     */
    @Test
    public void testInsert(){
        //获取SqlSession会话
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try{
            //获取接口代理
            UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);
            Users users= new Users();
            users.setUsername("齐大大");
            users.setPassword("123456");
            users.setAge(50);
            users.setBirthday(new Date());
            users.setSex("男");
            //添加操作
            final int result = mapper.saveUsers(users);
            //提交事务
            sqlSession.commit();
            System.out.println("result = " + result);//输出result = 1
        }finally {
            //关闭session
            sqlSession.close();
        }
    }
}

这个实例项目结构：

**
本文中适合刚入门mybatis的程序员学习，转载请标明出处，原创不易，请留下个小小的赞
**=