driver=com.mysql.jdbc.Driver

 url=jdbc:mysql://127.0.0.1:3306/testdb

 username=root

 password=wjb

 log4j.rootLogger=DEBUG,CONSOLE,file

 #log4j.rootLogger=ERROR,ROLLING_FILE

 log4j.logger.cn.jbit.dao=debug

 log4j.logger.com.ibatis=debug

 log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=debug

 log4j.logger.com.ibatis.common.jdbc.ScriptRunner=debug

 log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=debug

 log4j.logger.java.sql.Connection=debug

 log4j.logger.java.sql.Statement=debug

 log4j.logger.java.sql.PreparedStatement=debug

 log4j.logger.java.sql.ResultSet=debug

 log4j.logger.org.tuckey.web.filters.urlrewrite.UrlRewriteFilter=debug

 ######################################################################################

 # Console Appender  \u65e5\u5fd7\u5728\u63a7\u5236\u8f93\u51fa\u914d\u7f6e

 ######################################################################################

 log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender

 log4j.appender.Threshold=error

 log4j.appender.CONSOLE.Target=System.out

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

 log4j.appender.CONSOLE.layout.ConversionPattern= [%p] %d %c - %m%n

 ######################################################################################

 # DailyRolling File  \u6bcf\u5929\u4ea7\u751f\u4e00\u4e2a\u65e5\u5fd7\u6587\u4ef6\uff0c\u6587\u4ef6\u540d\u683c\u5f0f:log2009-09-11

 ######################################################################################

 log4j.appender.file=org.apache.log4j.DailyRollingFileAppender

 log4j.appender.file.DatePattern=yyyy-MM-dd

 log4j.appender.file.File=log.log

 log4j.appender.file.Append=true

 log4j.appender.file.Threshold=error

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

 log4j.appender.file.layout.ConversionPattern=%d{yyyy-M-d HH:mm:ss}%x[%5p](%F:%L) %m%n

 log4j.logger.com.opensymphony.xwork2=error  

 <?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>

      <properties resource="jdbc.properties">

      </properties>

      <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="dao/UserMapper.xml"/>

      </mappers>

  </configuration>

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

     <select id="count" resultType="int">

         select count(1) from user

     </select>

 </mapper>

 package test;

 import static org.junit.Assert.*;

 import java.io.IOException;

 import java.io.InputStream;

 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.apache.log4j.Logger;

 import org.junit.Test;

 public class UserTest {

     private Logger logger = Logger.getLogger(UserTest.class);

     @Test

     public void countTest() {

         String resource = "mybatis-config.xml";

         int count = 0;

         SqlSession sqlSession = null;

         //1,读取配置文件mybatis-config.xml输入流

         try {

             InputStream is = Resources.getResourceAsStream(resource);

             //2,创建sqlsessionfactory

             SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);

             //3,创建sqlsession

             sqlSession =     factory.openSession();

             //4,调用mapper配置文件

             count = sqlSession.selectOne("dao.UserMapper.count");

             logger.debug(count);

         } catch (IOException e) {

             e.printStackTrace();

         }finally{

             sqlSession.close();

         }

     }

 }