MyBatis复习（2）

SqlMapConfig.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">
<configuration>
<properties resource="db.properties"></properties>
<typeAliases>
    <package name="com.ask.pojo"/>
</typeAliases>
   <!-- 和spring整合后 environments配置将废除-->
   <environments default="development">
      <environment id="development">
      <!-- 使用jdbc事务管理-->
         <transactionManager type="JDBC" />
      <!-- 数据库连接池-->
         <dataSource type="POOLED">
            <property name="driver" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
         </dataSource>
      </environment>
   </environments>
  <mappers>
      <mapper resource="mapper/UserMapper.xml"/>

      <package name="com.ask.mapper"/>
  </mappers>
</confssiguration>

db.properties 和log4j.properties

“`
db.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost/mydb?useUnicode=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=root

log4j.properties

Global logging configuration

log4j.rootLogger=DEBUG, stdout

Console output…

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

“`

3