2-mybatis程序

jar包
pom.xml

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.8</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
        </dependency>

        <dependency>
            <groupId>apache-log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.15</version>
        </dependency>

    </dependencies>

mybatis配置文件
<?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://127.0.0.1:3306/test?characterEncoding=utf-8"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="sqlmap/user.xml"/>
    </mappers>
</configuration>

这里写代码片
package com.xia.mybatis.first;

import com.xia.mybatis.po.User;
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.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;


public class MybatisFirst {

    @Test
    public void findUserById() throws IOException {
        InputStream inputStream= Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession=sqlSessionFactory.openSession();
        User user = sqlSession.selectOne("test.findUserById", 2);
        System.out.println(user);
        sqlSession.close();
    }
    @Test
    public void findUserByName() throws IOException {
        InputStream inputStream= Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession=sqlSessionFactory.openSession();
        List<Object> user = sqlSession.selectList("test.findUserByName", "的");
        System.out.println(user);
        sqlSession.close();
    }
    @Test
    public void insertUser()throws IOException{
        InputStream inputStream= Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession=sqlSessionFactory.openSession();
        User user = new User();
        user.setSex(1);
        user.setUserName("fs");
        user.setAddress("zhengzou");
        sqlSession.insert("test.insertUser",user);
        sqlSession.commit();
        sqlSession.close();
        System.out.println(user);
    }

    @Test
    public void updateUser()throws IOException{
        InputStream inputStream= Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession=sqlSessionFactory.openSession();
        User user = new User();
        user.setId(11);
        user.setSex(2);
        user.setUserName("fs111");
        user.setAddress("zhengzou211");
        sqlSession.update("test.updateUser", user);
        sqlSession.commit();
        sqlSession.close();
        System.out.println(user);
    }

    @Test
    public void deleteUser()throws IOException{
        InputStream inputStream= Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession sqlSession=sqlSessionFactory.openSession();

        sqlSession.delete("test.deleteUser",11);
        sqlSession.commit();
        sqlSession.close();
    }
}

user.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="test">
    <select id="findUserById" parameterType="int" resultType="com.xia.mybatis.po.User">
        select * from user where id = #{id}
    </select>

    <select id="findUserByName" parameterType="String" resultType="com.xia.mybatis.po.User">
        select * from user where userName like'%${value}%'
    </select>

    <insert id="insertUser" parameterType="com.xia.mybatis.po.User">
        <selectKey resultType="int" keyProperty="id" order="AFTER">
            SELECT LAST_INSERT_ID()
        </selectKey>
        INSERT into `user` (userName,sex,address) VALUES(#{userName},#{sex},#{address})
    </insert>

    <update id="updateUser" parameterType="com.xia.mybatis.po.User">
        UPDATE  `user` set userName=#{userName},sex=#{sex},address=#{address} WHERE id =#{id}
    </update>

    <delete id="deleteUser" parameterType="int">
        DELETE  FROM `user` WHERE id=#{id}
    </delete>
</mapper>