【Mybatis】Mybatis学习与搭建

Mybatis

什么是Mybatis

MyBatis 是一款优秀的持久层框架，它支持自定义 SQL、存储过程以及高级映射。

MyBatis 免除了几乎所有的 JDBC 代码以及设置参数和获取结果集的工作。

MyBatis 可以通过简单的 XML 或注解来配置和映射原始类型、接口和 Java POJO（Plain Old Java Objects，普通老式 Java 对象）为数据库中的记录。

搭建项目

1.创建maven项目

1.1使用maven仓库引入需要的配置

1.2导入Mybatis需要的依赖

   <dependencies>
       <!--Mysql依赖-->
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>5.1.47</version>
           <scope>provided</scope>
       </dependency>
       <!--junit依赖-->
       <dependency>
           <groupId>junit</groupId>
           <artifactId>junit</artifactId>
           <version>4.12</version>
       </dependency>
       <!--Mybatis依赖-->
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis</artifactId>
           <version>3.5.2</version>
       </dependency>
   </dependencies>

2.搭建mybatis配置

2.1从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>
    <properties resource="db.properties">
        <!--内部配置-->
    </properties>
    <typeAliases>
        <package name="com.cxy.pojo"/>
    </typeAliases>
    <environments default="test">
        <!--配置方式1-->
        <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/mybatis?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=CST"/>
                <property name="username" value="root"/>
                <property name="password" value="6800"/>
            </dataSource>
        </environment>
        <!--配置方式2-->
        <environment id="test">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--配置mapper路径-->
    <mappers>
         <!--如果使用resource路径,则路径必须使用'/'分割,不可以使用'.'-->
        <mapper resource="com/cxy/dao/UserMapper.xml"/>
    </mappers>

</configuration>

1.2.1配置方式2需要导入properties

driver = com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=CST
username=root
password=6800

3.构建 SqlSessionFactory

3.1通过工具类构建

package com.cxy.utils;
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.IOException;
import java.io.InputStream;
public class MybatisUtils {
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
   }
   //返回sqlsession对象
   public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession();
   }
}

4.创建实体类(pojo)

4.1实体类搭建

package com.cxy.pojo;

import org.apache.ibatis.type.Alias;

@Alias("User")
public class User {
    private int id;
    private String name;
    private String pwd;
    public User(){};
    public User(int id, String name, String pwd) {
        this.id = id;
        this.name = name;
        this.pwd = pwd;
    }
    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 String getPwd() {
        return pwd;
    }
    public void setPwd(String pwd) {
        this.pwd = pwd;
    }
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", pwd='" + pwd + '\'' +
                '}';
    }
}

5.创建接口和xml操作数据

5.1创建接口

package com.cxy.dao;

import com.cxy.pojo.User;

import java.util.List;

public interface UserMapper {
    //查询返回集合列表
    List<User> getUserList();
    //通过id查询
    User getUserById(int id);
    //添加一个用户
    int addUser(User user);
    //修改一个用户
    int updateUser(User user);
    //删除一个用户
    int deleteUser(int id);

}

5.2创建xml文件,并写入一些sql语句

<?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.cxy.dao.UserMapper">
    <select id="getUserList" resultType="User">
        select id,uname as name,upwd as pwd from mybatis.user
    </select>

    <select id="getUserById" parameterType="int" resultType="User">
        select * from mybatis.user where id = #{id}
    </select>
    
    <insert id="addUser" parameterType="User">
        insert into mybatis.user values(#{id},#{name},#{pwd})
    </insert>

    <update id="updateUser" parameterType="User">
        update mybatis.user set uname = #{name},upwd = #{pwd} where(id = #{id});
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from mybatis.user where id = #{id}
    </delete>
</mapper>

测试

1.测试代码

package com.cxy.dao;

import com.cxy.pojo.User;
import com.cxy.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;

import java.util.List;

public class UserMapperTest {
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    @Test
    public void getListTest(){
        //方式一
        List<User> userList = mapper.getUserList();
        for (User item:userList) {
            System.out.println(item);
        }
        //关闭sqlsession对象

        sqlSession.close();
    }

    @Test
    public void getUserByIdTest(){
        User user = mapper.getUserById(1);
        System.out.println(user);
        sqlSession.close();
    }
    @Test
    public void addUserTest(){
        int res = mapper.addUser(new User(5, "陈新予", "000000"));
        if (res>0){
            System.out.println("插入成功!");
        }
        //提交事务
        sqlSession.commit();
        sqlSession.close();
    }
    @Test
    public void updateUserTest(){
        int res = mapper.updateUser(new User(5,"陈新予","555555"));
        if(res>0){
            System.out.println("修改成功!");
        }
        sqlSession.commit();
        sqlSession.close();
    }
    @Test
    public void deleteUserTest(){
        int res = mapper.deleteUser(1);
        if(res>0){
            System.out.println("成功删除"+res+"条数据!");
        }
        sqlSession.commit();
        sqlSession.close();
    }
}