搭建MyBatis框架

一、创建一个maven类型的项目，使用maven帮我们导入框架需要的jar包

   <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.5</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
    </dependencies>

二、创建数据库和表 

 定义操作xxx表的sql映射文件xxxMapper.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">

<!-- namespace属性的作用是用来关联该文件对应的dao接口的 -->
<mapper namespace="xxx.xxx">

</mapper>

 三、创建MyBatis配置文件conf.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="dev">
        <environment id="dev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis62?serverTimezone=UTC&amp;characterEncoding=UTF-8&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="wmjwzgwcm"/>
            </dataSource>
        </environment>
    </environments>

</configuration>

四、一个简单小项目实例

1.需求：对数据库中的user表进行增删改查

2.具体代码实现

package com.haina.mybatis;


import java.io.Serializable;

//这是与数据库表进行映射的类，成员变量名尽量与表中的字段名一致
public class User implements Serializable {
    private int id;
    private String name;
    private int age;
    private String phone;

    public int getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = 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;
    }
}

package com.haina.mybatis;


import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Update;

import java.util.List;

//dao Data Access Object 用来做数据访问
public interface UserDao {
    //根据id去数据库中查询用户的方法
    User selectById(int id);

    List<User> selectAll();

    int insertUser(User u);

    //可以直接使用注解写sql语句,注解和配置文件不要同时作用在同一个方法上
    @Delete("delete from user where id=#{id}")
    int deleteById(int id);

    @Update("update user set name=#{name},age=#{age},phone=#{phone} where id=#{id}")
    int updateById(User u);
}

package com.haina.mybatis;

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 java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

public class Test {

    public static void main(String[] args) throws Exception{
        String name = "mybatis-config.xml";
        //读取mybatis的核心配置文件，返回一个输入流对象
        InputStream in = Resources.getResourceAsStream(name);

        //创建连接工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);

        //从工厂中获取一个连接对象
        SqlSession session = factory.openSession();

        //从mybatis李获取一个UserDao的对象
        //mybatis会给我们的dao接口生成实现类对象，我们直接从mybatis李获取对象
        UserDao userDao = session.getMapper(UserDao.class);

        User user = userDao.selectById(1);
        System.out.println(user.getName());

        List<User> users = userDao.selectAll();
        System.out.println(users.size());

        User u = new User();
        u.setName("lisi");
        u.setAge(22);
        u.setPhone("789456");
        userDao.insertUser(u);

        userDao.deleteById(3);

        user.setAge(23);
        userDao.updateById(user);


        //新增，修改，删除，操作需要提交事务才会生效
        session.commit();
    }
}

3.文件配置 

<?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">

<!-- namespace属性的作用是用来关联该文件对应的dao接口的 -->
<mapper namespace="com.haina.mybatis.UserDao">
    <cache>
        <property name="size" value="10"/>
    </cache>
<!--id必须与方法名一致，resultType写的是这个sql语句查询结果的类型-->
    <select id="selectById" resultType="user" useCache="true">
        select * from user where id=#{id}
    </select>

    <select id="selectAll" resultType="user">
        select * from user
    </select>

    <insert id="insertUser">
        insert into user values (default,#{name},#{age},#{phone})
    </insert>
</mapper>

<?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>

    <settings>
<!--打印mybatis执行的sql语句，帮助我们排查问题-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
<!--开启二级缓存的总开关-->
        <setting name="cacheEnabled" value="true"/>
<!--开启下划线和驼峰式命名的自动转换-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>

    <typeAliases>
        <typeAlias type="com.haina.mybatis.User" alias="user"/>
    </typeAliases>

    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis63?serverTimezone=UTC&amp;characterEncoding=UTF-8&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="wmjwzgwcm"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="userMapper.xml"/>
    </mappers>

</configuration>