笔记-mybatis初识

简介

MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Ordinary Java Object,普通的 Java对象)映射成数据库中的记录。

开发环境

创建项目
使用idea创建一个普通maven项目

添加依赖
mybatis依赖和数据库驱动包

mybatis查询数据

1：定义表对应的实体类

public class Cust implements Serializable {
    /**
     * 用户编号
     */
    private String custCode;

    /**
     * 手机号
     */
    private String mobile;

    public String getCustCode() {
        return custCode;
    }

    public void setCustCode(String custCode) {
        this.custCode = custCode;
    }

    public String getMobile() {
        return mobile;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }

    @Override
    public String toString() {
        return "Cust{" +
                "custCode='" + custCode + '\'' +
                ", mobile='" + mobile + '\'' +
                '}';
    }
}

2：创建操作数据库表的sql映射文件CustMapper.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="mapper.CustMapper">

    <resultMap id="BaseResultMap" type="entity.Cust">
        <result column="CUST_CODE" jdbcType="VARCHAR" property="custCode" />
        <result column="MOBILE" jdbcType="VARCHAR" property="mobile" />
    </resultMap>

    <select id="selectListByCode" parameterType="string" resultMap="BaseResultMap">
        select CUST_CODE , MOBILE as mobile from TEST_CUST where CUST_CODE=#{custCode}
    </select>
</mapper>

注意namespace+id要在整个配置中保证唯一

3：添加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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
                <property name="url" value="url"/>
                <property name="username" value="username"/>
                <property name="password" value="password"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mapper/CustMapper.xml"/>
    </mappers>
</configuration>

4：创建测试类测试

package test;

import entity.Cust;
import lombok.extern.slf4j.Slf4j;
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;

@Slf4j
public class MybatisTest {
    public static void main(String[] args) {
        try{
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            SqlSessionFactory sessionFactory =new SqlSessionFactoryBuilder().build(is);
            SqlSession sqlSession = sessionFactory.openSession();
            Cust cust = sqlSession.selectOne("mapper.CustMapper.selectListByCode","001");
            log.info(cust.toString());
        }catch (Exception e){
            log.error(e.getMessage());
        }
    }
}

执行结果

对应数据库数据

至此，一个完整的查询数据库表，经过映射返回到业务代码实体的操作完成了。

另外，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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin:@10.16.41.207:1522:gccsdev1"/>
                <property name="username" value="GCCSDB"/>
                <property name="password" value="ka8O#5I29"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--<mapper resource="mapper/CustMapper.xml"/>-->
        <mapper class="mapper.CustMapper"></mapper>
    </mappers>
</configuration>

这个时候我们就需要创建一个CustMapper.class

package mapper;

import entity.Cust;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CustMapper {
    @Select("select CUST_CODE as custCode, MOBILE as mobile from TEST_CUST where CUST_CODE=#{custCode}")
    Cust selectListByCode(String code);
}

CustMapper.xml这个时候就可以不需要，测试时候如果没有删除CustMapper.xml文件，记得把

<!--<select id="selectListByCode" parameterType="string" resultMap="BaseResultMap">
        select CUST_CODE , MOBILE from TEST_CUST where CUST_CODE=#{custCode}
    </select>-->

注释掉，否则会报错

测试代码也需要相应修改一下

package test;

import entity.Cust;
import lombok.extern.slf4j.Slf4j;
import mapper.CustMapper;
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;

@Slf4j
public class MybatisTest {
    public static void main(String[] args) {
        try{
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
            SqlSessionFactory sessionFactory =new SqlSessionFactoryBuilder().build(is);
            SqlSession sqlSession = sessionFactory.openSession();
            /*Cust cust = sqlSession.selectOne("mapper.CustMapper.selectListByCode","001");*/
            CustMapper mapper = sqlSession.getMapper(CustMapper.class);
            Cust cust = mapper.selectListByCode("001");
            log.info(cust.toString());
        }catch (Exception e){
            log.error(e.getMessage());
        }
    }
}

最终返回结果也是一样的

再另外，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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin:@10.16.41.207:1522:gccsdev1"/>
                <property name="username" value="GCCSDB"/>
                <property name="password" value="ka8O#5I29"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--<mapper resource="mapper/CustMapper.xml"/>-->
        <!--<mapper class="mapper.CustMapper"></mapper>-->
        <package name="mapper"></package>
    </mappers>
</configuration>

测试代码不用修改，CustMapper.class上面的注解和CustMapper.xml中的id="selectListByCode"保存任意一个可以。但是要注意如果是保留CustMapper.xml的查询，CustMapper.xml和CustMapper接口要在同一个包名内