配置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.baidu</groupId>
    <artifactId>Test003</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>

    <dependencies>
<!--        mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
<!--        sql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>
<!--        记录日志-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>
<!--        单元测试-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
        </dependency>
    </dependencies>
</project>

mybatis环境搭建

在resource目录下创建log4j.properties

# Set root category priority to INFO and its only appender to CONSOLE.
#log4j.rootCategory=INFO, CONSOLE            debug   info   warn error fatal
log4j.rootCategory=debug, CONSOLE, LOGFILE

# Set the enterprise logger category to FATAL and its only appender to CONSOLE.
log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE

# CONSOLE is set to be a ConsoleAppender using a PatternLayout.
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n

# LOGFILE is set to be a File appender using a PatternLayout.
log4j.appender.LOGFILE=org.apache.log4j.FileAppender
log4j.appender.LOGFILE.File=d:axis.log
log4j.appender.LOGFILE.Append=true
log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n

在resource目录下创建mybaties的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">
<!--    mybatis的主配置文件-->
<configuration>
<!--    配置环境-->
    <environments default="mysql">
<!--        配置mysql的环境-->
        <environment id="mysql">
<!--            上面两个名字叫什么都可以,但需要一样-->
<!--            配置事务类型-->
            <transactionManager type="JDBC"></transactionManager>
<!--            配置数据源(连接池)-->
            <dataSource type="POOLED">
<!--                配置连接数据库的四个基本信息-->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/temp"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
<!--            指定映射配置文件的位置,映射配置文件指的是每个dao独立的配置文件
               如果使用注解的话，此处应该使用class属性指定被注解的dao全限定类名
-->
    <mappers>
<!--        <mapper class="com.baidu.dao.IPeopleDao"></mapper>-->
        <mapper resource="com/baidu/dao/IPeopleDao.xml" />
    </mappers>
</configuration>

在java目录下创建对应的接口类

package com.baidu.dao;

import com.baidu.domain.People;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface IPeopleDao {
    //使用注解的方式
//    @Select("select * from people")
    List<People> findAll();

    void savePeople(People people);

    void deletePeople(Integer id);

    void updatePeople(People people);

    People findById(Integer id);

    Integer selectTotal();

    List<People> selectByName(String username);
}

在resource目录下创建和dao接口一样的目录结构的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">
            <!--    配置查询所有-->
        <mapper namespace="com.baidu.dao.IPeopleDao">
<!--    <resultMap id="userMap" type="com.baidu.domain.People">-->
<!--&lt;!&ndash;        如果属性名和mysql数据库中的字段名不一样，可以在查询的时候起别名，也可以配置查询结果的列名和实体类的属性名的对应关系&ndash;&gt;-->
<!--&lt;!&ndash;        主键字段对应,前者是实体类的属性名，后者是数据库字段的名字 &ndash;&gt;-->
<!--        <id property="userId" column="id"></id>-->
<!--&lt;!&ndash;        非主键字段的对应 前者是java中的,严格区分大小写&ndash;&gt;-->
<!--        <result property="userName" column="username"></result>-->
<!--        <result property="UserSex" column="sex"></result>-->
<!--    </resultMap>-->
<!--            如果使用了上面的方法,那么resultType就没有用了，用resultMap标签指向resultMap标签的id-->
<!--            <select id="findAll" resultMap="userMap"></select>-->
    <!--            id为方法名称  -->
            <select id="findAll" resultType="com.baidu.domain.People">
              select * from people
            </select>
        <insert id="savePeople" parameterType="com.baidu.domain.People" >
<!--            <selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">-->
<!--                select last_insert_id();-->
<!--            </selectKey>-->
--         以上三句是配置得到插入语句的自增长的id 属性分别为 实体类id 数据库id 返回值类型 在执行语句之后 sql语句是查询最后一次插入的id
            insert into people(username,birthday,sex,adress) values(#{username},#{birthday},#{sex},#{adress});
        </insert>
<!--        传入参数为Integer类型,id参数只是一个占位符，可以随便起-->
        <delete id="deletePeople" parameterType="java.lang.Integer">
            delete from people where id = #{pid}
        </delete>

        <update id="updatePeople" parameterType="com.baidu.domain.People">
            update people set username = #{username},birthday = #{birthday},
            sex = #{sex},adress = #{adress}  where id = #{id}
        </update>

        <select id="findById" parameterType="Integer" resultType="com.baidu.domain.People">
            select * from people where id = #{userId}
        </select>

        <select id="selectTotal" resultType="INT">
            select count(*) from people
        </select>

        <select id="selectByName" parameterType="String" resultType="com.baidu.domain.People">
            select * from people where username like #{username}
        </select>
        </mapper>

创建测试类并进行测试

package com.baidu.test;
import com.baidu.dao.IPeopleDao;
import com.baidu.domain.People;
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 org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.File;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TestMybatis01 {
        private InputStream is;
        private SqlSessionFactoryBuilder builder;
        private SqlSession session;
        private  IPeopleDao peopleDao;
    @Before
    public void init() throws Exception{
        //1.读取配置文件
         is = Resources.getResourceAsStream("SqlMapConfig.xml");
        //2.创建SqlSessionFactory工厂
         builder = new SqlSessionFactoryBuilder();
        SqlSessionFactory factory = builder.build(is);
        //3.使用工厂生产SqlSession对象
        session = factory.openSession();
        //4.使用SqlSession创建接口代理对象
         peopleDao = session.getMapper(IPeopleDao.class);
    }
    @After
    public void destory() throws Exception{
        session.commit();
        //6.释放资源
        session.close();
        is.close();
    }
    public static void main(String[] args) throws Exception{
        File f = new File("f:/a");
        f.mkdir();
        ArrayList list = new ArrayList();

    }
    @Test
    public void findAll(){
    //5.使用代理对象执行方法
        List<People> list = peopleDao.findAll();
        for (People p: list) {
            System.out.println(p);
        }
    }
    @Test
    public void savePeople(){
        People people = new People();
        people.setSex("F");
        people.setBirthday(new Date());
        people.setUsername("保存操作");
        people.setAdress("半夜");
        peopleDao.savePeople(people);

    }
    @Test
    public void deleteById(){
        Integer id = 5;
        peopleDao.deletePeople(id);
    }
    @Test
    public void update(){
        People people = new People();
        people.setSex("F");
        people.setId(6);
        people.setBirthday(new Date());
        people.setUsername("update");
        people.setAdress("afternoon");
        peopleDao.updatePeople(people);
    }
    @Test
    public void findById(){
        Integer id = 2;
        People p = peopleDao.findById(id);
        System.out.println(p);
    }

    @Test
    public void selectTotal(){
        int count = peopleDao.selectTotal();
        System.out.println(count);
    }
    @Test
    public  void selectByName(){
        List<People> list = peopleDao.selectByName("%四%");
        for(People people :list){
            System.out.println(people);
        }
    }
}