From e378f3ffd7ec94674048454a12e8047aa69e43ae Mon Sep 17 00:00:00 2001
From: whyclxw <http://whyclxw@118.89.139.230:10101/r/~whyclxw/IdeaTest.git>
Date: 星期四, 15 四月 2021 15:43:46 +0800
Subject: [PATCH] 提交
---
target/classes/mapper/User_infMapper.xml | 19 +++++++++++++++++++
src/main/java/com/example/lxw/pojo/UserBattgroupBaojigroupUsr.java | 23 +++++++++++++++++++++++
target/classes/com/example/lxw/pojo/UserBattgroupBaojigroupUsr.class | 0
3 files changed, 42 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/example/lxw/pojo/UserBattgroupBaojigroupUsr.java b/src/main/java/com/example/lxw/pojo/UserBattgroupBaojigroupUsr.java
new file mode 100644
index 0000000..f827c81
--- /dev/null
+++ b/src/main/java/com/example/lxw/pojo/UserBattgroupBaojigroupUsr.java
@@ -0,0 +1,23 @@
+package com.example.lxw.pojo;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import lombok.AllArgsConstructor;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+import lombok.ToString;
+
+/**
+ * @author lxw
+ * @create 2021-04-15 11:24
+ */
+@Data
+@ToString
+@AllArgsConstructor
+@NoArgsConstructor
+public class UserBattgroupBaojigroupUsr {
+ @TableField(exist = false)
+ private long num;
+ private long baojiGroupId;
+ @TableField(exist = false)
+ private long uId;
+}
diff --git a/target/classes/com/example/lxw/pojo/UserBattgroupBaojigroupUsr.class b/target/classes/com/example/lxw/pojo/UserBattgroupBaojigroupUsr.class
new file mode 100644
index 0000000..50f8aaf
--- /dev/null
+++ b/target/classes/com/example/lxw/pojo/UserBattgroupBaojigroupUsr.class
Binary files differ
diff --git a/target/classes/mapper/User_infMapper.xml b/target/classes/mapper/User_infMapper.xml
new file mode 100644
index 0000000..c2651c3
--- /dev/null
+++ b/target/classes/mapper/User_infMapper.xml
@@ -0,0 +1,19 @@
+<?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.example.lxw.mapper.User_InfMapper" >
+
+ <resultMap id="baojiUserMap" type="User_inf">
+ <result column="uSnId" property="uSnId" />
+ <result column="uName" property="uName" />
+ <association property="UserBattgroupBaojigroupUsr">
+ <result property="baojiGroupId" column="baojiGroupId"/>
+ </association>
+ </resultMap>
+
+ <select id="searchByBaojiUsr" resultMap="baojiUserMap">
+ SELECT tb_user_inf.*,tb_user_battgroup_baojigroup_usr.baoji_group_id
+ from tb_user_inf
+ LEFT JOIN tb_user_battgroup_baojigroup_usr ON tb_user_inf.uId=tb_user_battgroup_baojigroup_usr.uId
+ order by tb_user_inf.uid
+ </select>
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.1