如何学习mybatis

1、如何获取mybatis

maven仓库：https://mvnrepository.com/artifact/org.mybatis/mybatis

  <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.5</version>
    </dependency>`

Github：https://github.com/mybatis/mybatis-3/releases
中文文档：https://github.com/search?q=mybatis

2、第一个mybatis程序

思路：搭建环境>导入mybatis> 编写代码>测试

创建一个maven项目

在pom.xml中导入jar包

<dependencies>
    <!-- mysql驱动-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.6</version>
    </dependency>
    <!-- mybatis-->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.5</version>
    </dependency>
    <!--单元测试 -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>
</dependencies>

创建一个工具类

package com.xrq.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

//SqlSessionFactory
public class mybatisUtils {
  static {
      String resource = "mybatis-config.xml";
      InputStream inputStream = null;
      try {
          inputStream = Resources.getResourceAsStream(resource);
          SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
      } catch (IOException e) {
          e.printStackTrace();
      }

  }
}

创建接口和对应的配置文件

import com.xrq.pojo.User;

import java.util.List;

public interface UserDao {
    //查询
    public List<User> selectUser();
    //添加
    public   int addUser(User user);
    //删除
    public  int deleteUser(int  id);
}

配置文件

<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--绑定一个对应的dao -->
<mapper namespace="com.xrq.dao.UserDao">
    <!--id 就是对应的namespace中的方法名 ，resultType是sql语句的返回值，parameterType是传递参数类型-->
    <select id="selectUser" resultType="com.xrq.pojo.User">
        select * from user;
    </select>
   <insert id="addUser" parameterType="com.xrq.pojo.User">
       insert into user (id ,name ,pwd) values (#{id},#{name},#{pwd});
   </insert>
  <delete id="deleteUser" parameterType="int">
      delete from user where id=#{id};
  </delete>
</mapper>

id 就是对应的namespace中的方法名 ，resultType是sql语句的返回值，parameterType是传递参数类型