mybatis的环境搭建

MyBatis 是一款优秀的半自动的ORM持久层框架,它支持自定义,SQL存储过程以及高级映射.

MyBatis避免了几乎所有的JDBC代码手动设置参数以及手动获取结果集的操作.

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

数据持久层:Dao层,也叫数据访问层,可以立即保存在磁盘上,在这里可以理解为与数据库相关操作.

创建一张表和表对应的实体类

在MySQL中创建一张表

导入 MyBatis jar 包,mysql 数据库驱动包

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.28</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.2</version>
        </dependency>

创建 MyBatis 全局配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
<!--  设置数据库连接池  -->
    <properties resource="config.properties"></properties>
<!--  设置日志打印  -->
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
<!--  配置类型别名  -->
    <typeAliases>
<!--<typeAlias type="com.ffyc.mybatispro.model.Admin" alias="Admin"></typeAlias>-->
    <package name="com.ffyc.mybatispro.model"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${dirver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${uname}"/>
                <property name="password" value="${upwd}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mappers/AdminMapper.xml"/>
    </mappers>
</configuration>

创建 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.ffyc.mybatispro.dao.AdminDao">
    <delete id="deleteAdmin" parameterType="int">
        delete from admin where id = #{id}
    </delete>

    <select id="find" resultType="Admin" parameterType="int" >
        select * from admin where id =#{id}
    </select>

    <select id="selectAdmin" resultType="com.ffyc.mybatispro.model.Admin">
        select * from admin where id = #{id}
    </select>

    <insert id="saveAdmin" parameterType="string" >
        insert into admin(account) value (#{accout})
    </insert>

    <insert id="saveAdmin1">
        insert into admin(account,password) value (#{acc},#{pwd})
    </insert>

    <insert id="saveAdmin2" useGeneratedKeys="true" keyColumn="id" keyProperty="id">
        insert into admin(account,password) value (#{account},#{password})
    </insert>

</mapper>

定义接口

测试 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.IOException;
import java.io.Reader;

public class Demo {
    public static void main (String[] args) throws IOException {
//        读取mybatis核心配置文件
        Reader reader = Resources.getResourceAsReader("mybatis.xml");
//        创建SqlSessionFactory
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
//        创建SqlSession  session会话,一次与数据库交互,类似于之前使用的Connection
        SqlSession sqlSession = sessionFactory.openSession();
//        创建访问接口代理对象
        AdminDao adminDao = sqlSession.getMapper(AdminDao.class);
//        使用代理对象访问接口中对应的方法,本质是调用接口对应的sql映射文件中的sql
        Admin a = new Admin();
        a.setAccount("333");
        a.setPassword("jim");
        try{
//            Admin admin = adminDao.find(1);
             adminDao.saveAdmin("111");
             adminDao.saveAdmin1("222","22");
             adminDao.saveAdmin2(a);
             int id = a.getId();
             adminDao.deleteAdmin(id);
             sqlSession.commit();
        }catch (Exception e){
          e.printStackTrace();
        }finally {
            sqlSession.close();
        }
        


//        关闭与数据库连接

    }
}