MyBatis-03
一、日志实现
在MyBatis中通过在config配置文件中增添settings属性来实现日志
官方描述:
完整的settings属性设置:
<settings>
<setting name="cacheEnabled" value="true"/>
<setting name="lazyLoadingEnabled" value="true"/>
<setting name="multipleResultSetsEnabled" value="true"/>
<setting name="useColumnLabel" value="true"/>
<setting name="useGeneratedKeys" value="false"/>
<setting name="autoMappingBehavior" value="PARTIAL"/>
<setting name="autoMappingUnknownColumnBehavior" value="WARNING"/>
<setting name="defaultExecutorType" value="SIMPLE"/>
<setting name="defaultStatementTimeout" value="25"/>
<setting name="defaultFetchSize" value="100"/>
<setting name="safeRowBoundsEnabled" value="false"/>
<setting name="mapUnderscoreToCamelCase" value="false"/>
<setting name="localCacheScope" value="SESSION"/>
<setting name="jdbcTypeForNull" value="OTHER"/>
<setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString"/>
</settings>
之后会实现如下三种方式:
- SLF4J
- LOG4J2
- STDOUT_LOGGING
1、STDOUT_LOGGING
在 mybatis-config.xml 文件中添加 *settings 属性配置,将 name 属性设置为 logImpl ,将 value 属性设置为 STDOUT_LOGGING
mybatis-config.xml:
<settings>
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
测试:
2、LOG4J2 + SLF4J
在 mybatis-config.xml 文件中添加 settings 属性配置,将 name 属性设置为 logImpl ,将 value 属性设置为 LOG4J2
mybatis-config.xml:
<settings>
<setting name="logImpl" value="LOG4J2"/>
</settings>
导入相关jar包:
<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-log4j2 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-log4j2</artifactId>
<version>2.6.3</version>
</dependency>
实现相关配置:
<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="WARN">
<Appenders>
<Console name="Console" target="SYSTEM_OUT">
<PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
</Console>
</Appenders>
<Loggers>
<Root level="info">
<AppenderRef ref="Console" />
</Root>
</Loggers>
</Configuration>
相关参数描述:
测试:
UerMapperTest:
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class UserMapperTest {
private static final Logger log = LoggerFactory.getLogger(UserMapperTest.class);
/**
* 测试查询操作
*/
@Test
public void testSelect(){
SqlSession sqlSession = MyBatisUtils.getSqlSession();
log.info("==========进入testSelect测试方法~==========");
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> userList = mapper.getUserList();
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
log.info("==========结束testSelect测试方法~==========");
}
}
输出:
20:11:08.655 [main] INFO com.jack.dao.UserMapperTest - 进入testSelect测试方法~
User(id=1, name=Jone, age=18, email=test1@baomidou.com)
User(id=2, name=飞飞, age=23, email=xxxxxxxxxx@qq.com)
User(id=3, name=Tom, age=28, email=test3@baomidou.com)
User(id=4, name=Sandy, age=21, email=test4@baomidou.com)
User(id=5, name=狗子, age=12, email=xxxxxxxxxx@qq.com)
User(id=6, name=Jack, age=22, email=xxxxxxxxxx@qq.com)
20:11:08.851 [main] INFO com.jack.dao.UserMapperTest - 结束testSelect测试方法~
二、分页实现
主要都是通过limit实现
#startIndex从0开始
select * from user limit startIndex,pageSize
查询结果:
实现方式有三种:
- Limit实现
- RowBounds实现
- PageHelper插件实现
1、Limit实现
首先在UserMapper接口中定义一个方法:
List<User> getUserList(Map<String,Integer> map);
在UserMapper.xml文件中写SQL语句:
<select id = "getUserList" parameterType = "map" resultType = "User">
select * from test.user limit #{startIndex},#{pageSize}
</select>
单元测试:
@Test
public void testPaging(){
SqlSession sqlSession = MyBatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
HashMap<String, Integer> map = new HashMap<>();
map.put("startIndex",1);
map.put("pageSize",2);
List<User> userList = mapper.getUserList2(map);
for (User user : userList) {
System.out.println(user);
}
}
输出:
User(id=2, name=飞飞, age=23, email=xxxxxxxxxx@qq.com)
User(id=3, name=Tom, age=28, email=test3@baomidou.com)
2、RowBounds实现:
首先在UserMapper接口中定义一个方法:
List<User> getUserList2(Map<String,Integer> map);
在UserMapper.xml文件中写SQL语句:
<select id = "getUserList2" resultType = "User">
select * from test.user
</select>
单元测试:
@Test
public void testPagingByRowBounds(){
SqlSession sqlSession = MyBatisUtils.getSqlSession();
RowBounds rowBounds = new RowBounds(1,2);
List<User> userList = sqlSession.selectList("com.jack.dao.UserMapper.getUserList3", null, rowBounds);
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
}
输出:
User(id=2, name=飞飞, age=23, email=xxxxxxxxxx@qq.com)
User(id=3, name=Tom, age=28, email=test3@baomidou.com)
3、PageHelper插件实现:
添加如下依赖:
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.3.0</version>
</dependency>
首先在UserMapper接口中定义一个方法:
List<User> getUserList3();
在UserMapper.xml文件中写SQL语句:
<select id = "getUserList3" resultType = "User">
select * from test.user
</select>
单元测试:
@Test
public void testPagingByPageHelper(){
SqlSession sqlSession = MyBatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
PageHelper.startPage(1,3);
List<User> userList = mapper.getUserList3();
for (User user : userList) {
System.out.println(user);
}
sqlSession.close();
}
其他分页方式参考官方文档:
三、注解开发:
不必再xml文件中配置,直接再方法上面添加注解即可
首先在UserMapper接口中定义一个方法:
@Select("select * from user where id = #{uid}")
User getUser(@Param("uid") long id);
单元测试:
@Test
public void testAnnotation(){
SqlSession sqlSession = MyBatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.getUser(3);
System.out.println(user);
sqlSession.close();
}
输出:
User(id=3, name=Tom, age=28, email=test3@baomidou.com)
四、MyBatis执行流程
暂略
五、通过注解实现增删改查
同上,不再赘述,简化开发,但是复杂的情况下不建议使用(例如一对多,多对一)
首先在UserMapper中定义增删改查接口:
//增删改查操作利用注解实现
@Insert("insert into user (id,name,age,email) values(#{id},#{name},#{age},#{email})")
int addUser(User user);
@Delete("delete from user where id = #{uid}")
int deleteUser(@Param("uid") long id);
@Update("update user set name = #{name},age = #{age},email = #{email} where id = #{id}")
int updateUser(User user);
@Select("select * from user where name like #{like}")
List<User> getUserList5(@Param("like") String name);
单元测试:
@Test
public void testCRUD(){
SqlSession sqlSession = MyBatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
mapper.addUser(new User(8,"jid",23,"xxxxxxxx@qq.com"));
log.info("Add完成");
mapper.deleteUser(3);
log.info("Del完成");
mapper.updateUser(new User(1,"gg",45,"xxxxxxxxxx@163.com"));
log.info("Update完成");
List<User> userList = mapper.getUserList5("%J%");
for (User user : userList) {
System.out.println(user);
}
log.info("Search完成");
sqlSession.close();
}
输出:
22:31:14.619 [main] INFO com.jack.dao.UserMapperTest - Add完成
22:31:14.680 [main] INFO com.jack.dao.UserMapperTest - Del完成
22:31:14.725 [main] INFO com.jack.dao.UserMapperTest - Update完成
User(id=6, name=Jack, age=22, email=xxxxxxxxx@qq.com)
User(id=7, name=jack, age=34, email=xxxxxxxxx@qq.com)
User(id=8, name=jid, age=23, email=xxxxxxxx@qq.com)
22:31:14.741 [main] INFO com.jack.dao.UserMapperTest - Search完成
注:只需要在MyBatisUtils工具类中设置sqlSessionFactory.openSession(true)即可无需再commit提交事务
六、LomBok使用
LomBok可用于简化代码,提高效率,但是有人缺不以为然,甚至认为其改变了Java代码架构,因此,请自行谨慎使用
添加如下依赖:
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.22</version>
</dependency>
常用注解:
@Data //提供setter和getter以及其他方法
@AllArgsConstructor //提供全参构造函数
@NoArgsConstructor //提供无参构造函数
@ToString //提供ToString方法
在实体类中使用:
@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class User {
private long id;
private String name;
private Integer age;
private String email;
}
Structure of Class:
相关文章:
- 什么是MyBatis
- 为什么要用MyBatis
- 如何使用MyBatis?
- 增删改查实现
- Map以及模糊查询
- 配置属性优化
- 配置别名优化
- 配置映射器说明
- 生命周期以及作用域
- ResultMap结果集映射
- 复杂查询环境搭建
- 多对一处理
- 一对多处理
- 动态SQL环境搭建
- IF标签
- 常用标签
- WHERE
- CHOOSE
- WHEN
- TRIM
- OTHERWISE
- SET
- ForEach标签
- 缓存简介
- 一级缓存
- 二级缓存
- MyBatis缓存原理