mybatis基本使用,不使用spring

pom文件 

 <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.2</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

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://localhost:3306/aaa?serverTimezone=UTC"/>
                <property name="username" value="root"/>
                <property name="password" value="123"/>
            </dataSource>
        </environment>
    </environments>
    <mappers >
        <mapper class="com.UserMapper"></mapper>
    </mappers>
</configuration>

Mapper

public interface UserMapper {
    @Select("select * from user where id =#{value}")
    User selectUserById(Integer id);
}

测试

public class MyTest {
    public static void main(String[] args) throws IOException {

        SqlSession sqlSession = null;
        try{
            String resource = "my.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);


            sqlSession = sessionFactory.openSession();

            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            User user = mapper.selectUserById(1);
            System.out.println(user.getName());
            sqlSession.commit();
        }catch (Exception e){

        }finally {
            sqlSession.close();
        }


    }
}

注意注意,sqlsession必须要close,无论如何都要close