Mybatis 学习
Mybatis 环境搭建用的是 mybatis-3.1.1 版本,用 log4j 来打出 log 日志
1.log4j.properties 文件配置
# Rules reminder:
# DEBUG < INFO < WARN < ERROR < FATAL
# Global logging con+guration
log4j.rootLogger=DEBUG, stdout
# My logging con+guration...
log4j.logger.org.mybatis.jpetstore=DEBUG
## Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p %d %C: %m%n
2。配置 mybatis 中的 mybatis.cfg.xml 文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE con+guration PUBLIC
"-//mybatis.org//DTD Con+g 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-con+g.dtd">
<con+guration>
<typeAliases>
<typeAlias alias="UserInfo" type="com.user.UserInfo" />
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="oracle.jdbc.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
<property name="username" value="stock" />
<property name="password" value="stock" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/user/sqlmap/UserInfo.xml" />
</mappers>
</con+guration>
3 .sql 文件配置文件
<?xml version="1.0" encoding="UTF-8" ?>