mybatis入门

什么是mybatis

1.MyBatis 是一款优秀的持久层框架，它支持自定义 SQL、高级映射。
2.MyBatis 免去了复杂的jdbc。
3.MyBatis 可以通过简单的 XML 或注解来配置和映射原始类型、接口和 Java POJO为数据库中的记录。

简单入门

环境搭建

1.引入mybatis的jar包，maven项目导入mybatis依赖。

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

配置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="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>

    <!--使用相对路径-->
    <!--<mapper resource="UserMapper.xml"></mapper>-->
    <!-- 使用映射器接口实现类的完全限定类名 -->
    <mapper class="org.cc.mapper.UserMapper"></mapper>


    </mappers>
</configuration>

映射mapper.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">
<!--绑定UserMapper-->
<mapper namespace="org.cc.mapper.UserMapper">
    
    <select id="getAllUser" resultType="org.cc.pojo.User">
    select * from mybatis.user
  </select>
    
    <select id="getUserLike" resultType="org.cc.pojo.User">
    select * from mybatis.user where name like "%"#{value}"%"
  </select>

    <insert id="addUser" parameterType="org.cc.pojo.User" >
        insert into mybatis.user(id, name, pwd) VALUE (#{id},#{name},#{pwd})
    </insert>

    <update id="updateUser" parameterType="org.cc.pojo.User">
        update mybatis.user set name = #{name}, pwd = #{pwd} where id = #{id}
    </update>

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

简单示例

导入需要的依赖

 <!--获取mybatis依赖-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <!--获取数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.48</version>
        </dependency>
        <!--单元测试-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

测试

    @Test
    public void getAllUser() throws IOException {
        //读取配置文件
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        //获得SqlSessionFactory
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //获得SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();
        UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
        List<User> users = userMapper.getAllUser();
        for (User user : users) {
            System.out.println(user);
        }

    }