mybatis快速入门

添加依赖

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.7</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.26</version>
</dependency>

创建mybatisConfig.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="properties/jdbc.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.user}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
</configuration>

创建mapper接口

public interface UserMapper {
    int  insert();
}

创建XxxMapperxml文件,并填写相关的sql语句

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

<!--namespace要与接口同名同路径，全类名一致-->
<mapper namespace="com.hly.mybatis.mapper.UserMapper">

    <!--int insert() 中的sql语句-->
    <insert id="insert">
        insert into t_user values (null,'admin','123456',23,'男','123@qq.com')
    </insert>
</mapper>

在xml中添加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>
	...
    ...
    <mappers>
        <!--引入mapper相关xml -->
        <mapper resource="mappers/UserMapper.xml"></mapper>
    </mappers>

</configuration>

创建代理实现类对象，执行方法

public static void main( String[] args ) throws IOException {

    //绑定xml文件,org包下的
    InputStream is = Resources.getResourceAsStream("mybatisConfig.xml");

    //获取工厂Builder对象
    SqlSessionFactoryBuilder sqlSessionFactoryBuilder =new SqlSessionFactoryBuilder();

    // 获取SqlSessionFactory工厂
    SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(is);

    //获取SqlSession对象
    SqlSession sqlSession = sqlSessionFactory.openSession();

    /*
    自动提交事务
    SqlSession sqlSession = sqlSessionFactory.openSession(ture);
    */
    	
    // 获取UserMapper接口的代理实现类对象 （通过xml文件，找到映射文件，找到Sql语句）使用动态代理对象
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    mapper.insert();

    //需要提交事务
    sqlSession.commit();
    sqlSession.close();

}