文章目录
4. 配置文件的详解
mybatis-config文件解析
<?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 配置文件
settings mybatis设置
typeAliases 为Java类起别名
typeHandlers 类处理器
objectFactory 对象工厂
plugins 插件
environments 环境
transactionManager : 事务管理
dataSource : 数据源
mappers 映射器
优化我们的代码
优化配置文件
在resources目录下创建一个db.properties文件
driver = com.mysql.jdbc.Driver
url = jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=utf-8
username = root
password = 123456
在mybatis核心配置文件中引入properties配置文件,并用${}
表达式引入其中的值
注意:位置必须正确
<configuration>
<!--配置文件修改-->
<properties resource="database.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="com/westos/dao/UserMapper.xml"/>
</mappers>
</configuration>
为Java类取别名
注意点:位置必须正确,不确定位置可以点开configuration查看
在mybatis-config.xml中配置typeAliases属性
<!--配置别名-->
<typeAliases>
<!--配置指定类的别名-->
<typeAlias type="com.westos.pojo.User" alias="User"/>
<!--
可以为一个包的所有类指定别名,这个别名为类名
com.westos.pojo.User - > User
com.westos.pojo.Student - > Student
-->
<package name="com.westos.pojo"/>
</typeAliases>
优化完毕后我们在mapper映射文件中就可以使用别名了
<?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对应Mapper接口的类-->
<mapper namespace="com.westos.dao.UserDao">
<!--select标签的id对应映射接口的方法名字 resultType:返回结果的类型 中间就编写sql语句-->
<select id="selectUser" resultType="User">
select * from user;
</select>
<select id="selectUserById" resultType="User">
select * from user where id = #{id}
</select>
<!--返回值是基本数据类型 int-->
<!--我们需要接受一个自定义的对象(引用对象),需要设置parameterType,为参数类型,
接受者个对象的值,直接使用#{对象(字段名)}-->
<insert id="addUser" parameterType="User">
insert into user (id,name,pwd) values (#{id},#{name},#{pwd})
</insert>
<!--基本类型可以不用写-->
<delete id="deleteUserById" parameterType="int">
delete from user where id = #{id}
</delete>
<update id="updateUser" parameterType="User">
update user set name = #{name},pwd = #{pwd} where id = #{id}
</update>
</mapper>
环境配置
<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>
映射器
映射器用于奥苏Mybatis到哪去找到SQL映射语句(mapper映射文件),在mybatis的配置文件践行配置。
- resource 【推荐】
- url
- class
- package
【推荐使用】
<!-- 使用相对于类路径的资源引用 -->
<mappers>
<mapper resource="org/mybatis/builder/AuthorMapper.xml"/>
<mapper resource="org/mybatis/builder/BlogMapper.xml"/>
<mapper resource="org/mybatis/builder/PostMapper.xml"/>
</mappers>
5. 解决属性名和字段名不一致问题
字段名:数据库 id name pwd
属性名:实体类 id name password
我们修改下密码项,将pwd改为password,
修改后的实体类
package com.westos.pojo;
public class User {
private int id;
private String name;
private String password;
public User() {
}
public User(int id, String name, String password) {
this.id = id;
this.name = name;
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", password='" + password + '\'' +
'}';
}
}
去测试运行一下,出现的问题如下:
密码项全部为空。
分析
select * from user 等价于 select id,name,pwd from user;
mybatis会根据数据库的字段名去找对应的实体类的属性名,(他会将所有列名转换为小写,然后去找实体类中对应的 set方法 ,set方法后面的字段就对应数据库的字段名;如果不一样就会返回null)
解决方案
方案一: 修改set方法名字 【不推荐使用】
原理:mybatis会根据数据库的字段名去找对应到的实体类的属性名。会将所有的列名转换为小写,然后去找实体类中对应的set方法,set方法后面对应的数据库的字段名,如果找不到就会返回null
方案二:给sql语句取别名【字段少的时候推荐使用】
方案三: 结果集映射ResultMap 【最推荐的方式】
<!--设置结果的映射类型-->
<resultMap id="UserMap" type="User">
<!--
一般通过id标签来映射主键
column = 数据库的列名
property = 结果集对应的数据库列名的映射名
-->
<id column="id" property="id"/>
<result column="name" property="name"/>
<result column="pwd" property="password"/>
</resultMap>
<select id="selectUser" resultMap="UserMap">
select * from user
</select>
6. LOG4J实现
log4 java :Java日志的实现
日志—>控制台
boolean flag = true;
public void isPrint(String msg){
if (flag){
System.out.print(msg);
}else{
}
}
准备:导入Log4j包的依赖
Log4j依赖
在maven仓库中找到
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
log4j的配置文件
在resources目录下存放log4j.properties文件
### Log4j配置 ###
#定义log4j的输出级别和输出目的地(目的地可以自定义名称,和后面的对应)
#[ level ] , appenderName1 , appenderName2
log4j.rootLogger=DEBUG,console,file
#-----------------------------------#
#1 定义日志输出目的地为控制台
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
####可以灵活地指定日志输出格式,下面一行是指定具体的格式 ###
#%c: 输出日志信息所属的类目,通常就是所在类的全名
#%m: 输出代码中指定的消息,产生的日志具体信息
#%n: 输出一个回车换行符,Windows平台为"/r/n",Unix平台为"/n"输出日志信息换行
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=[%c]-%m%n
#-----------------------------------#
#2 文件大小到达指定尺寸的时候产生一个新的文件
log4j.appender.file = org.apache.log4j.RollingFileAppender
#日志文件输出目录
log4j.appender.file.File=log/info.log
#定义文件最大大小
log4j.appender.file.MaxFileSize=10mb
###输出日志信息###
#最低级别
log4j.appender.file.Threshold=ERROR
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=[%p][%d{yy-MM-dd}][%c]%m%n
#-----------------------------------#
#3 druid
log4j.logger.druid.sql=INFO
log4j.logger.druid.sql.DataSource=info
log4j.logger.druid.sql.Connection=info
log4j.logger.druid.sql.Statement=info
log4j.logger.druid.sql.ResultSet=info
#4 mybatis 显示SQL语句部分
log4j.logger.org.mybatis=DEBUG
#log4j.logger.cn.tibet.cas.dao=DEBUG
#log4j.logger.org.mybatis.common.jdbc.SimpleDataSource=DEBUG
#log4j.logger.org.mybatis.common.jdbc.ScriptRunner=DEBUG
#log4j.logger.org.mybatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
#log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
Mybatis的日志实现
-
默认的日志实现
在mybatis-config.xml文件中。加入下面这段代码,切记要放对位置,不然会报错。<settings> <setting name="logImpl" value="STDOUT_LOGGING"/> </settings>
结果展示:
D:\Java\jdk1.8.0_152\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:D:\Java\IntelliJ IDEA 2018.2.6\lib\idea_rt.jar=52113:D:\Java\IntelliJ IDEA 2018.2.6\bin" -Dfile.encoding=UTF-8 -classpath "D:\Java\IntelliJ IDEA 2018.2.6\lib\idea_rt.jar;D:\Java\IntelliJ IDEA 2018.2.6\plugins\junit\lib\junit-rt.jar;D:\Java\IntelliJ IDEA 2018.2.6\plugins\junit\lib\junit5-rt.jar;D:\Java\jdk1.8.0_152\jre\lib\charsets.jar;D:\Java\jdk1.8.0_152\jre\lib\deploy.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\access-bridge-64.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\cldrdata.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\dnsns.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\jaccess.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\jfxrt.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\localedata.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\nashorn.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\sunec.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\sunjce_provider.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\sunmscapi.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\sunpkcs11.jar;D:\Java\jdk1.8.0_152\jre\lib\ext\zipfs.jar;D:\Java\jdk1.8.0_152\jre\lib\javaws.jar;D:\Java\jdk1.8.0_152\jre\lib\jce.jar;D:\Java\jdk1.8.0_152\jre\lib\jfr.jar;D:\Java\jdk1.8.0_152\jre\lib\jfxswt.jar;D:\Java\jdk1.8.0_152\jre\lib\jsse.jar;D:\Java\jdk1.8.0_152\jre\lib\management-agent.jar;D:\Java\jdk1.8.0_152\jre\lib\plugin.jar;D:\Java\jdk1.8.0_152\jre\lib\resources.jar;D:\Java\jdk1.8.0_152\jre\lib\rt.jar;D:\学习文件\代码\MyBatis\ssm-mybatis-study\MyBatis05\target\test-classes;D:\学习文件\代码\MyBatis\ssm-mybatis-study\MyBatis05\target\classes;D:\Java\apache-maven-3.6.1-bin\apache-maven-3.6.1\mavenlib\repository\junit\junit\4.11\junit-4.11.jar;D:\Java\apache-maven-3.6.1-bin\apache-maven-3.6.1\mavenlib\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\Java\apache-maven-3.6.1-bin\apache-maven-3.6.1\mavenlib\repository\org\mybatis\mybatis\3.5.1\mybatis-3.5.1.jar;D:\Java\apache-maven-3.6.1-bin\apache-maven-3.6.1\mavenlib\repository\mysql\mysql-connector-java\5.1.47\mysql-connector-java-5.1.47.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 com.westos.dao.test,selectUser
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:/%e5%ad%a6%e4%b9%a0%e6%96%87%e4%bb%b6/%e4%bb%a3%e7%a0%81/MyBatis/ssm-mybatis-study/MyBatis05/target/classes/com/westos/pojo
Not a JAR: file:/D:/%e5%ad%a6%e4%b9%a0%e6%96%87%e4%bb%b6/%e4%bb%a3%e7%a0%81/MyBatis/ssm-mybatis-study/MyBatis05/target/classes/com/westos/pojo
Reader entry: User.class
Listing file:/D:/%e5%ad%a6%e4%b9%a0%e6%96%87%e4%bb%b6/%e4%bb%a3%e7%a0%81/MyBatis/ssm-mybatis-study/MyBatis05/target/classes/com/westos/pojo
Find JAR URL: file:/D:/%e5%ad%a6%e4%b9%a0%e6%96%87%e4%bb%b6/%e4%bb%a3%e7%a0%81/MyBatis/ssm-mybatis-study/MyBatis05/target/classes/com/westos/pojo/User.class
Not a JAR: file:/D:/%e5%ad%a6%e4%b9%a0%e6%96%87%e4%bb%b6/%e4%bb%a3%e7%a0%81/MyBatis/ssm-mybatis-study/MyBatis05/target/classes/com/westos/pojo/User.class
Reader entry: ���� 1 <
Checking to see if class com.westos.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.
Opening JDBC Connection
Created connection 767010715.
Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@2db7a79b]
==> Preparing: select * from user;
==> Parameters:
<== Columns: id, name, pwd
<== Row: 1, qingjaing, 123456
<== Row: 2, 张三, abcdef
<== Row: 3, 李四, 987654
<== Total: 3
Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@2db7a79b]
Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@2db7a79b]
Returned connection 767010715 to pool.
User{id=1, name='qingjaing', password='123456'}
User{id=2, name='张三', password='abcdef'}
User{id=3, name='李四', password='987654'}
Process finished with exit code 0
-
log4j日志实现
-
导包
-
配置文件编写
-
mybatis核心文件中进行配置
<settings> <setting name="logImpl" value="LOG4J"/> </settings>
-