<?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="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?characterEncoding=utf-8"/>

              <property name="username"value="root" />

              <property name="password"value="1234" />

           </dataSource>

       </environment>

    </environments>

</configuration>

package com.itcodeschool.domain;

publicclass User {

    privateintid;

    private String name;

    private String password;

    privateintage;

    private String address;

}

//省略get/set/toString方法

<?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="UserMapper">

    <!-- id：设置唯一值，resultType 配置返回值类型为User-->

<select id="findUser"resultType="com.itcodeschool.domain.User"> 

    <!-- 编写 SQL 语句 -->

        SELECT *FROM User

    </select>

</mapper>

    <!-- 加载UserMapper映射文件 -->

    <mappers>

     <mapper resource="com/itcodeschool/mapper/UserMapper.xml"/>

    </mappers>

package com.itcodeschool.test;

import java.io.IOException;

import java.io.InputStream;

import java.util.List;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

importorg.apache.ibatis.session.SqlSessionFactoryBuilder;

import org.apache.tomcat.util.collections.SynchronizedStack;

import com.itcodeschool.domain.User;

publicclass UserTest {

    publicstaticvoid main(String[] args) {

        //1、读取配mybatis核心置文件，转换为输入流

        String resource = "SqlMapConfig.xml";

        InputStream in = null;

        try {

            in = Resources.getResourceAsStream(resource);

        } catch (IOException e) {

            e.printStackTrace();

        }

        //2、根据mybatis核心配置文件输入流构建一个session工厂，SqlSessionFactory

        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(in);

        //3、根据SqlSessionFactory对象开启一个会话：SqlSession

        SqlSession sqlSession = sqlSessionFactory.openSession();

        List<User> list = sqlSession.selectList("UserMapper.findUser");

        System.out.println("总数量："+list.size());

        for(User user : list) {

        System.out.println(user);

        }

      //释放资源

        sqlSession.close();

    }

}

##########Set Log Levels###############

log4j.rootLogger = DEBUG,console

######### Output to console ####################

log4j.appender.console = org.apache.log4j.ConsoleAppender

log4j.appender.console.Target = System.out

log4j.appender.console.layout = org.apache.log4j.PatternLayout

log4j.appender.console.layout.ConversionPattern = %d{ABSOLUTE}%5p%c{ 1:%L-%m%n