作者:1157476701qq | 来源:互联网 | 2023-08-28 15:03
原标题:Mybatis-plus 多表联合查询(注解方式)最简单的方式springboot + mybatis-plus
第一步:加入mybatis-plus依赖
第二步:配置数据源
spring:
thymeleaf:
cache: false
encoding: utf-8
prefix: classpath:/templates/
suffix: .html
enabled: true
datasource:
url: jdbc:mysql://192.168.1.152:3306/timo?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoRecOnnect=true&failOverReadOnly=false&serverTimezOne=GMT%2B8
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: root
type: com.alibaba.druid.pool.DruidDataSource
mybatis-plus:
configuration:
map-underscore-to-camel-case: true
log-impl: org.apache.ibatis.log文章来源站点https://www.yii666.com/ging.stdout.StdOutImpl
第三步:创建两张有关联关系的表(我的如下 )
sys_user:用户表
sys_role:权限表
第四步:将两张表映射到实体类bean(其实sys_role建不建都无所谓,可以不建sys_role的实体类)
@Data
@TableName("sys_user") //当实体类名(前提是开启驼峰)与数据库表名一致时可不写
public class SysUser extends Model {
@TableId(type = IdType.AUTO)
private Long id;
private String username;
private String password;
private String salt;
private Integer deptId;
private String picture;
private String sex;
private String email;
private String phone;
@Version
private Integer version;
@TableField(fill = FieldFill.INSERT)
private Date createDate;
@TableField(fill = FieldFill.INSERT_UPDATE)
private Date updateDate;
private Integer status;
********************不想建这个实体类就不建 没有意义
public class SysRole {
private long id;
private String roleName;
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getRoleName() {
return roleName;
}
public void setRoleName(String roleName) {
this.roleName = roleName;
}
}
第五步:定义mapper(注意看这个@Select里面的SQL)
第六步:定义一个通用实体类Record
import com.alibaba.druid.proxy.jdbc.ClobProxyImpl;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import javax.servlet.http.HttpServletRequest;
import java.io.BufferedReader;
import java.io.Reader;
import java.util.*;
/**
* @author Wxiaokun
* @version 1.0
* @date 2020/9/25 0025 下午 4:15
*/
public class Record extends HashMap implements Map {
private static final long serialVersiOnUID= 1L;
Map map = null;
HttpServletRequest request;
public Record(HttpServletRwww.yii666.comequest request){
this.request = request;
Map properties = request.getParameterMap();
Map returnMap = new HashMap();
Iterator entries = properties.entrySet().iterator();
Map.Entry entry;
String name = "";
String value = "";
while (entries.hasNext()) {
entry = (Map.Entry) entries.next();
name = (String) entry.getKey();
Object valueObj = entry.getValue();
文章来源地址33110.html if(null == valueObj){
value = "";
}else if(valueObj instanceof String[]){
String[] values = (String[])va文章来源地址33110.htmllueObj;
for(int i=0;i value = values[i] + ",";
}
value = value.substring(0, value.length()-1);
}else{
value = valueObj.toString();
}
returnMap.put(name, value);
}
map = returnMap;
}
public Record() {
map = new HashMap();
}
@Override
public Object get(Object key) {
Object obj = null;
if(map.get(key) instanceof Object[]) {
Object[] arr = (Object[])map.get(key);
obj = request == null ? arr:(request.getParameter((String)key) == null ? arr:arr[0]);
} else {
obj = map.get(key);
}
return obj;
}
public String getString(Object key) {
return (String)get(key);
}
@SuppressWarnings("unchecked")
@Override
public Object put(Object key, Object value) {
if(value instanceof ClobProxyImpl){ // 这里必须要到如durid数据源的依赖 读取数据库 Clob类型数据
try {
ClobProxyImpl cpi = (ClobProxyImpl)value;
Reader is = cpi.getCharacterStream(); //获取流
BufferedReader br = new BufferedReader(is);
String str = br.readLine();
StringBuffer sb = new StringBuffer();
while(str != null){ //循环读取数据拼接到字符串
sb.append(str);
sb.append("\n");
str = br.readLine();
}
value = sb.toString();
} catch (Exception e) {
e.printStackTrace();
}
}
return map.put(key, value);
}
@Override
public Object remove(Object key) {
return map.remove(key);
}
@Override
public void clear() {
map.clear();
}
@Override
public boolean containsKey(Object key) {
return map.containsKey(key);
}
@Override
public boolean conwww.yii666.comtainsValue(Object value){
return map.containsValue(value);
}
public Set entrySet() {
return map.entrySet();
}
@Override
public boolean isEmpty() {
return map.isEmpty();
}
public Set keySet() {
return map.keySet();
}
@SuppressWarnings("unchecked")
@Override
public void putAll(Map t) {
map.putAll(t);
}
@Override
public int size() {
return map.size();
}
public Collection values() {
return map.values();
}
}
第七步:接下来就是测试了
测试结果如下:
至此 到这里 我觉得这个东西就有点像Jfinal底层封装的Record类了,在多表联合查询的情况下,我们可以方便的使用mybatis-plus来进行了。大家有什么问题的话就在评论区讨论哈
来源于:Mybatis-plus 多表联合查询(注解方式)最简单的方式springboot + mybatis-plus