问题描述:
学习了Mybatis-plus的基础的增删改查之后,突然想知道Mybatis-plus是如何进行自定义SQL来进行查询语句的?
其实Mybatis-plus和Mybatis在利用xml文件进行查询是一样的!
但是在这里遇到了一个大坑:CONDITIONS EVALUATION REPORT错误!至于如何解决的,听我细细道来!
1.先贴文件结构目录:
2.开发过程:
(1)导入Mybatis-plus相应jar包
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!--mybatis-plus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.1</version>
</dependency>
(2)编写Mapper层:注意这里的@Mapper注解和@Repository
package com.swagger.swaggerdemo1.Mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.swagger.swaggerdemo1.Pojo.User2;
import org.mapstruct.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
@Mapper
@Repository //代表持久层
public interface UserMapper extends BaseMapper<User2> {
//所有的CRUD已经编写完成
List<User2> queryList();
}
(3)在启动类上添加扫描:注意这里的扫描非常关键
package com.swagger.swaggerdemo1;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@MapperScan({"com.swagger.swaggerdemo1.Mapper"})
@SpringBootApplication
public class Swaggerdemo1Application {
public static void main(String[] args) {
SpringApplication.run(Swaggerdemo1Application.class, args);
}
}
(4)然后,这一步不是必须的,因为我一开始没加这个,也可以运行,但是在网上其他教程都说加一下,但是我试了不加也可以!就是mybatis-plus:
mapper-locations: classpath:mapper/*.xml这一句!!
server:
port: 8080
spring:
datasource:
username: root
password: 123456789
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/mybatis_st?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
mybatis-plus:
mapper-locations: classpath:mapper/*.xml
(5)编写xml语句:
<?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="com.swagger.swaggerdemo1.Mapper.UserMapper">
<!--public Account getAcct(Long id);-->
<select id="queryList" resultType="com.swagger.swaggerdemo1.Pojo.User2">
select * from user2 where id = 1
</select>
</mapper>
(6)至此配置完毕:
package com.swagger.swaggerdemo1;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.swagger.swaggerdemo1.Dao.User2Dao;
import com.swagger.swaggerdemo1.Mapper.UserMapper;
import com.swagger.swaggerdemo1.Pojo.User2;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.List;
@SpringBootTest
class Swaggerdemo1ApplicationTests {
@Autowired
UserMapper userMapper;
@Autowired
private User2Dao user2Dao;
@Test
public void getListDao(){
List<User2> user2s = user2Dao.queryList();
user2s.forEach(System.out::println);
}
@Test
void getList(){
List<User2> user2s = userMapper.queryList();
user2s.forEach(System.out::println);
}
@Test
void test(){
QueryWrapper wrapper = new QueryWrapper();
wrapper.select("id");
List list = userMapper.selectList(wrapper);
list.forEach(System.out::println);
}
@Test
void contextLoads() {
List<User2> user2s = userMapper.selectList(null);
for(User2 u:user2s){
System.out.println(u);
}
}
}
重点
总结一下自己的错误:CONDITIONS EVALUATION REPORT
问题描述:
因为我又写重新建了一个文件夹,然后重新写了一个mapper,就开始报错了!
其他配置和之前一样:
但是再次调用:
错误原因:
解决办法:再配置一个包扫描
问题解决: