resultMap主要是解决实体类的属性和字段名不一致的问题。
resultMap结果映射
这是官方给出的解释
resultMap 元素是 MyBatis 中最重要最强大的元素。它可以让你从 90% 的 JDBC ResultSets 数据提取代码中解放出来,
并在一些情形下允许你进行一些 JDBC 不支持的操作。实际上,在为一些比如连接的复杂语句编写映射代码的时候,
一份 resultMap 能够代替实现同等功能的数千行代码。ResultMap 的设计思想是,对简单的语句做到零配置,对于复杂一点的语句,
只需要描述语句之间的关系就行了。
我们现在先学习一下他简单的是用使用方式。
他的使用方式很简单,我们就是把我们的结果集类型换成结果集映射,映射这里填的是我们上面resultMap标签的id。创建的resultMap标签 type是属性值的类,我们在里面写result标签,column代表字段名,property代表属性名,这样是让他们产生对应关系。
<resultMap id="resMap" type="user">
<result column="password" property="pwd"/>
</resultMap>
<select id="getUserList" resultMap="resMap">
select * from user;
</select>
对于高级的映射以后在进行补充。
日志
我们在了解核心配置文件的时候在setting中看到了logimpl的设置。
logImpl 指定 MyBatis 所用日志的具体实现,未指定时将自动查找。
SLF4J
LOG4J(掌握)
LOG4J2
JDK_LOGGING
COMMONS_LOGGING
STDOUT_LOGGING(掌握)标准日志输出。
NO_LOGGING
目前我们只需要找到这两种就行。
先来学习一下简单日志的输出。
这里要注意的他大小写 不能有空格。
这是在控制台进行输出的,他会输出详细的信息。
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
Class not found: org.jboss.vfs.VFS
JBoss 6 VFS API is not available in this environment.
Class not found: org.jboss.vfs.VirtualFile
VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
Using VFS adapter org.apache.ibatis.io.DefaultVFS
Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo
Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo
Reader entry: User.class
Listing file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo
Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo/User.class
Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo/User.class
Reader entry: ���� 4 =
Checking to see if class pojo.User matches criteria [is assignable to Object]
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao
Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao
Reader entry: UserMapper.class
Reader entry: UserMapper.xml
Listing file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao
Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao/UserMapper.class
Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao/UserMapper.class
Reader entry: ���� 4 getUserList ()Ljava/util/List; Signature ()Ljava/util/List<Lpojo/User;>; getUser (I)Lpojo/User; addUser (Lpojo/User;)I
Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao/UserMapper.xml
Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao/UserMapper.xml
Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
Checking to see if class dao.UserMapper matches criteria [is assignable to Object]
Opening JDBC Connection
Created connection 345281752.
Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@149494d8]
==> Preparing: select * from user;
==> Parameters:
<== Columns: id, username, password
<== Row: 1, 阿威, 1111
<== Row: 2, 阿牛, 1111
<== Row: 3, s, 22
<== Row: 4, 老四, 1111
<== Total: 4
User{id=1, username='阿威', password='1111'}
User{id=2, username='阿牛', password='1111'}
User{id=3, username='s', password='22'}
User{id=4, username='老四', password='1111'}
Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@149494d8]
Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@149494d8]
Returned connection 345281752 to pool.
LOG4J日志
这是百度给出的解释
Log4j是Apache的一个开源项目,通过使用Log4j,我们可以控制日志信息输送的目的地是控制台、文件、GUI组件。这些可以通过一个配置文件来灵活地进行配置,而不需要修改应用的代码。
首先这个不能直接使用,我们需要先进行导报,然后配置好他相应的文件。
在maven中进行导入
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.12</version>
</dependency>
我们需要在资源文件夹下建一个log4j.properties文件,他的配置信息如下
#将等级为DEBUG的日志信息输出到console和file这两个目的地,console和file的定义在下面的代码
log4j.rootLogger=DEBUG,console,file
#控制台输出的相关设置
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%c]-%m%n
#文件输出的相关设置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/aw.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%p][%d{yy-MM-dd}][%c]%m%n
#日志输出级别
log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
对于这些配置行的具体讲解,可以直接百度有很多,这个东西不需要记住,拿过来会用,结果会看就行。
他和标准日志基本上差不多。他的样式是可以自己定义的。
[org.apache.ibatis.logging.LogFactory]-Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
[org.apache.ibatis.logging.LogFactory]-Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
[org.apache.ibatis.io.VFS]-Class not found: org.jboss.vfs.VFS
[org.apache.ibatis.io.JBoss6VFS]-JBoss 6 VFS API is not available in this environment.
[org.apache.ibatis.io.VFS]-Class not found: org.jboss.vfs.VirtualFile
[org.apache.ibatis.io.VFS]-VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.
[org.apache.ibatis.io.VFS]-Using VFS adapter org.apache.ibatis.io.DefaultVFS
[org.apache.ibatis.io.DefaultVFS]-Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo
[org.apache.ibatis.io.DefaultVFS]-Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo
[org.apache.ibatis.io.DefaultVFS]-Reader entry: User.class
[org.apache.ibatis.io.DefaultVFS]-Listing file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo
[org.apache.ibatis.io.DefaultVFS]-Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo/User.class
[org.apache.ibatis.io.DefaultVFS]-Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/pojo/User.class
[org.apache.ibatis.io.DefaultVFS]-Reader entry: ���� 4 =
[org.apache.ibatis.io.ResolverUtil]-Checking to see if class pojo.User matches criteria [is assignable to Object]
[org.apache.ibatis.datasource.pooled.PooledDataSource]-PooledDataSource forcefully closed/removed all connections.
[org.apache.ibatis.datasource.pooled.PooledDataSource]-PooledDataSource forcefully closed/removed all connections.
[org.apache.ibatis.datasource.pooled.PooledDataSource]-PooledDataSource forcefully closed/removed all connections.
[org.apache.ibatis.datasource.pooled.PooledDataSource]-PooledDataSource forcefully closed/removed all connections.
[org.apache.ibatis.io.DefaultVFS]-Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao
[org.apache.ibatis.io.DefaultVFS]-Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao
[org.apache.ibatis.io.DefaultVFS]-Reader entry: UserMapper.class
[org.apache.ibatis.io.DefaultVFS]-Reader entry: UserMapper.xml
[org.apache.ibatis.io.DefaultVFS]-Listing file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao
[org.apache.ibatis.io.DefaultVFS]-Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao/UserMapper.class
[org.apache.ibatis.io.DefaultVFS]-Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao/UserMapper.class
[org.apache.ibatis.io.DefaultVFS]-Reader entry: ���� 4 getUserList ()Ljava/util/List; Signature ()Ljava/util/List<Lpojo/User;>; getUser (I)Lpojo/User; addUser (Lpojo/User;)I
[org.apache.ibatis.io.DefaultVFS]-Find JAR URL: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao/UserMapper.xml
[org.apache.ibatis.io.DefaultVFS]-Not a JAR: file:/D:/java/mybatis_sum/mybatis_1/target/classes/dao/UserMapper.xml
[org.apache.ibatis.io.DefaultVFS]-Reader entry: <?xml version="1.0" encoding="UTF-8" ?>
[org.apache.ibatis.io.ResolverUtil]-Checking to see if class dao.UserMapper matches criteria [is assignable to Object]
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Opening JDBC Connection
[org.apache.ibatis.datasource.pooled.PooledDataSource]-Created connection 520022247.
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1efee8e7]
[dao.UserMapper.getUserList]-==> Preparing: select * from user;
[dao.UserMapper.getUserList]-==> Parameters:
[dao.UserMapper.getUserList]-<== Total: 4
User{id=1, username='阿威', password='1111'}
User{id=2, username='阿牛', password='1111'}
User{id=3, username='s', password='22'}
User{id=4, username='老四', password='1111'}
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@1efee8e7]
[org.apache.ibatis.transaction.jdbc.JdbcTransaction]-Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@1efee8e7]
[org.apache.ibatis.datasource.pooled.PooledDataSource]-Returned connection 520022247 to pool.
他也可以单独写一个测试类,这里需要注意他的导包
public class Log4j {
static Logger logger = Logger.getLogger(Log4j.class);
@Test
public void test(){
logger.info("这是info输出");
logger.debug("这是debug输出");
logger.error("这是error输出");
}
}