一.工程前的準(zhǔn)備工作

• 下載jdk（省略）
• 下載idea，并指定下載的jdk為源（省略）
• 下載maven，并配置到idea中（省略）

二.創(chuàng)建工程

• 新建JAVA工程，在JAVA工程中新建自己的的模塊
  目錄結(jié)構(gòu)如下

• 把模塊轉(zhuǎn)換成maven工程后，在pom.xml中添加如下配置信息

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>

        <groupId>com.it18zhang</groupId>
        <artifactId>mybatisdemo</artifactId>
        <version>1.0-SNAPSHOT</version>
        <dependencies>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.2.1</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.17</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.11</version>
            </dependency>
        </dependencies>
    </project>

• 新建mybatis-config.xml中，在resource中的同包名的目錄下

<?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="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${username}"/>
            <property name="password" value="${password}"/>
          </dataSource>
        </environment>
      </environments>
      <mappers>
        <mapper resource="org/mybatis/example/BlogMapper.xml"/>
      </mappers>
    </configuration>

數(shù)據(jù)庫(kù)的操作

• 在數(shù)據(jù)庫(kù)中建同名庫(kù)和表

   mysql>create database mybatis ;
   mysql>use mybatis ;
   mysql>create table users(id int primary key auto_increment , name varchar(20) ,age int) ;
   mysql>desc users ;
  

• 測(cè)試鏈接 在java下創(chuàng)建App.java

    package com.it18zhang.mybatisdemo;
    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.InputStream;

    /**
     *
     */
    public class App {
        public static void main(String[] args) {
            try {
                //指定配置文件的路徑(類路徑)
                String resource = "mybatis-config.xml";
                //加載文件
                InputStream inputStream = Resources.getResourceAsStream(resource);

                //創(chuàng)建會(huì)話工廠Builder,相當(dāng)于連接池
                SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);

                //通過(guò)sf開啟會(huì)話，相當(dāng)于打開連接。
                SqlSession s = sf.openSession();
                System.out.println(s);

            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

• 編寫Mapper文件

  創(chuàng)建User類，和users對(duì)應(yīng)
        public class User {
            private Integer id ;
            private String name ;
            private int age ;
            //get/set
        }
  

• 創(chuàng)建UserMapper.xml,存放在resources/目錄下

   <?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="users">
          <!-- 定義insert語(yǔ)句 -->
          <insert id="insert">
            insert into users(name,age) values(#{name},#{age})
          </insert>
      </mapper>
  

• 在resources/mybatis-config.xml文件中引入mapper的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"/>
                   <property name="username" value="root"/>
                   <property name="password" value="root"/>
               </dataSource>
           </environment>
       </environments>
       <!-- *****引入映射文件(新增部分)***** -->
       <mappers>
           <mapper resource="UserMapper.xml"/>
       </mappers>
   </configuration>
  

• 編寫單元測(cè)試，實(shí)現(xiàn)插入

  [test/com.it18zhang.mybatis.test.TestCRUD.java]
    /**
     * insert
     */
    @Test
    public void insert() throws Exception {
        //指定配置文件的路徑(類路徑)
        String resource = "mybatis-config.xml";
        //加載文件
        InputStream inputStream = Resources.getResourceAsStream(resource);
  
        //創(chuàng)建會(huì)話工廠Builder,相當(dāng)于連接池
        SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(inputStream);
  
        //通過(guò)sf開啟會(huì)話，相當(dāng)于打開連接。
        SqlSession s = sf.openSession();
        User u = new User();
  
        u.setName("jerry");
        u.setAge(2);
        s.insert("users.insert", u);
        s.commit();
        s.close();
    }