mybatis -- 5、①联合查询、②获取集合元素、③分步查询、④延迟查询

墨蓝 2022-11-25 00:46 51阅读 0赞

**目录**

2、select元素

5、联合查询

6、获取集合元素

7、分步查询

8、延迟查询（延迟加载方式）

方式一：

方式二：

--------------------

# 2、select元素 #

## 5、联合查询 ##

<groupId>com.mashibing</groupId>
        <artifactId>mybatis_helloworld</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <dependencies>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.4</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.19</version>
            </dependency>
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.13</version>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
    
        </dependencies>

**Emp.****java**

public class Emp {
    
        private Integer empno; //员工编号
        private String ename;  //员工姓名
        private String job;    //职业
        private Integer mgr;   //上级编号
        private Date hiredate; //入职日期
        private Double sal;    //工资
        private Double comm;   //商品
        private Dept dept;     //部门（点进去会跳转到Dept.java）
    
        public Integer getEmpno() {return empno;}
        public void setEmpno(Integer empno) {this.empno = empno;}
    
        public String getEname() {return ename;}
        public void setEname(String ename) {this.ename = ename;}
    
        public String getJob() {return job;}
        public void setJob(String job) {this.job = job;}
    
        public Integer getMgr() {return mgr;}
        public void setMgr(Integer mgr) {this.mgr = mgr;}
    
        public Date getHiredate() {return hiredate;}
        public void setHiredate(Date hiredate) {this.hiredate = hiredate;}
    
        public Double getSal() {return sal;}
        public void setSal(Double sal) {this.sal = sal;}
    
        public Double getComm() {return comm;}
        public void setComm(Double comm) {this.comm = comm;}
    
        public Integer getDeptno() {return deptno;}
        public void setDeptno(Integer deptno) {this.deptno = deptno;}
    
        @Override
        public String toString() {
            return "Emp{" +
                    "empno=" + empno +
                    ", ename='" + ename + '\'' +
                    ", job='" + job + '\'' +
                    ", mgr=" + mgr +
                    ", hiredate=" + hiredate +
                    ", sal=" + sal +
                    ", comm=" + comm +
                    ", deptno=" + deptno +
                    '}';
        }
    }

**Dept****.****java****（部门）**

public class Dept {
        private Integer deptno;//部门编号
        private String dname;  //部门名称
        private String loc;    //地方
    
        public Integer getDeptno() {return deptno;}
        public void setDeptno(Integer deptno) {this.deptno = deptno;}
    
        public String getDname() {return dname;}
        public void setDname(String dname) {this.dname = dname;}
    
        public String getLoc() {return loc;}
        public void setLoc(String loc) {this.loc = loc;}
    
        @Override
        public String toString() {
            return "Dept{" +
                    "deptno=" + deptno +
                    ", dname='" + dname + '\'' +
                    ", loc='" + loc + '\'' +
                    ", emps=" + emps +
                    '}';
        }
    }

**EmpDao.****java**

public interface EmpDao {
    
        public Emp selectEmpByEmpno(Integer empno);
    }

**EmpDao.****xml**

**MyTest.****java**

public class MyTest {
    
        SqlSessionFactory sqlSessionFactory =  null;
    
        @Before
        public void init(){
            String resource = "mybatis-config.xml";
            InputStream inputStream = null;
            try {
                inputStream = Resources.getResourceAsStream(resource);
            } catch (IOException e) {
                e.printStackTrace();
            }
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        }
        @Test
        public void test01() throws IOException {
    //获取与数据库相关的会话
            SqlSession sqlSession线程 = sqlSessionFactory.openSession();
    //获取对应的映射接口对象
            EmpDao mapper映射 = sqlSession.getMapper(EmpDao.class);
            Emp emp = mapper.selectEmpByEmpno(7369);
            System.out.println(emp);
    //关闭会话
            sqlSession.close();
        }
    }

![20200806203709567.png][]

![2020080620371320.png][]** ****//****该集合中还存在null**

**EmpDao.****xml**

通过dept.XXX方式将主键拿出来

![20200806203744617.png][]

## 6、获取集合元素 ##

**EmpDao.****xml**

![20200806203808973.png][]

//将上面的 * 改为empno，ename，job，dname
       <select id="selectEmpByEmpno" resultMap结果映射="myEmp">
            select * from emp left join dept on emp.deptno = dept.deptno where empno = #{empno}
        </select>

![20200806203832284.png][]** //取不到**

**//****改回\***

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70][]

**DeptDao.****java**

public interface DeptDao {
    
        public Dept selectDeptByDeptno(Integer deptno);
    }

**DeptDao.****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.mashibing.dao.DeptDao">
        <resultMap结果映射 id="myDept" type="com.mashibing.bean.Dept">
            <id column="deptno" property="deptno"></id>
            <result property="dname" column="dname"></result>
            <result property="loc" column="loc"></result>
            <collection收集 property="emps" ofType类型筛选="com.mashibing.bean.Emp">
                <id column列="empno" property属性="empno"></id>
                <result column="ename" property="ename"></result>
                <result column="job" property="job"></result>
                <result column="mgr" property="mgr"></result>
                <result column="hiredate" property="hiredate"></result>
                <result column="sal" property="sal"></result>
                <result column="comm" property="comm"></result>
            </collection>
        </resultMap>
       <select id="selectDeptByDeptno" resultMap结果映射="myDept">
            select * from emp left join dept on emp.deptno = dept.deptno where empno = #{empno}
       </select>
    </mapper>

**MyTest.****java**

@Test
        public void test02() throws IOException {
    
    //获取与数据库相关的会话
            SqlSession sqlSession线程 = sqlSessionFactory.openSession();
    //获取对应的映射接口对象
            DeptDao mapper映射 = sqlSession.getMapper(DeptDao.class);
            Dept dept = mapper.selectDeptByDeptno(10);
            System.out.println(dept);
    //关闭会话
            sqlSession.close();
        }
    }

![20200806203941732.png][]

## 7、分步查询 ##

在上述逻辑的查询中，是由我们自己来完成sql语句的关联查询的，那么，我们能让mybatis帮我们实现自动的关联查询吗?

**DeptDao.****java**

public interface DeptDao {
    
        public Dept selectDeptByDeptno(Integer deptno);
    ================================== 添加 =======================================
        public Dept selectDeptByStep(Integer deptno);
    ===============================================================================
    }

**DeptDao.****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.mashibing.dao.DeptDao">
        <resultMap结果映射 id="myDept" type="com.mashibing.bean.Dept">
            <id column="deptno" property="deptno"></id>
            <result property="dname" column="dname"></result>
            <result property="loc" column="loc"></result>
            <collection收集 property="emps" ofType类型筛选="com.mashibing.bean.Emp">
                <id column列="empno" property属性="empno"></id>
                <result column="ename" property="ename"></result>
                <result column="job" property="job"></result>
                <result column="mgr" property="mgr"></result>
                <result column="hiredate" property="hiredate"></result>
                <result column="sal" property="sal"></result>
                <result column="comm" property="comm"></result>
            </collection>
        </resultMap>
       <select id="selectDeptByDeptno" resultMap结果映射="myDept">
            select * from emp left join dept on emp.deptno = dept.deptno where empno = #{empno}
       </select>
    ================================== 添加 =======================================
    <select id="selectDeptByStep" resultType结果类型="com.mashibing.bean.Dept">
            select * from dept where deptno = #{deptno}
        </select>
    ===============================================================================
    </mapper>

**EmpDao.****java**

public interface EmpDao {
    
        public Emp selectEmpByEmpno(Integer empno);
    ================================== 添加 =======================================
    public Emp selectEmpByStep(Integer empno);
    ===============================================================================
    }

**EmpDao.****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.mashibing.dao.EmpDao">
    //将每一个属性值都映射成对象中的数据，如果有实体类对象，就写成对象.属性的方式
    
    
    
    
    
    
    
    
    
    
    
    
    
    //推荐使用第二种方式
        <resultMap结果映射 id="myEmp" type="com.mashibing.bean.Emp">
            <id column="empno" property="empno"></id>
            <result column="ename" property="ename"></result>
            <result column="job" property="job"></result>
            <result column="mgr" property="mgr"></result>
            <result column="hiredate" property="hiredate"></result>
            <result column="sal" property="sal"></result>
            <result column="comm" property="comm"></result>
            <association关联 property="dept" javaType ="com.mashibing.bean.Dept">
                <id property属性="deptno" column列="deptno"></id>
                <result property="dname" column="dname"></result>
                <result property="loc" column="loc"></result>
            </association>
        </resultMap>
    <select id="selectEmpByEmpno" resultMap结果映射="myEmp">
            select * from emp left join dept on emp.deptno = dept.deptno where empno = #{empno}
        </select>
    ================================== 添加 =======================================
        <select id="selectEmpByStep" resultMap结果映射="empDept">
            select * from emp where empno = #{empno}
        </select>
    
    <resultMap结果映射 id="empDept" type="com.mashibing.bean.Emp">
            //将上面的复制下来
            <id column列="empno" property="empno"></id>
            <result column="ename" property="ename"></result>
            <result column="job" property="job"></result>
            <result column="mgr" property="mgr"></result>
            <result column="hiredate" property="hiredate"></result>
            <result column="sal" property="sal"></result>
            <result column="comm" property="comm"></result>
            //dept是对象，不是属性（鼠标点进去转到另一个表）
            <association关联 property="dept" select="com.mashibing.dao.DeptDao.selectDeptByStep" column列="deptno"></association>
        </resultMap>
    ===============================================================================
    </mapper>

**MyTest.****java**

@Test
        public void test03() throws IOException {
    //获取与数据库相关的会话
            SqlSession sqlSession线程 = sqlSessionFactory.openSession();
    //获取对应的映射接口对象
            EmpDao mapper映射 = sqlSession.getMapper(EmpDao.class);
            Emp emp = mapper.selectEmpByStep(7369);
            System.out.println(emp);
    //关闭会话
            sqlSession.close();
        }

![20200807093322614.png][]

![20200807093326735.png][]

## 8、延迟查询（延迟加载方式） ##

当我们在进行表关联的时候，有可能在查询结果的时候不需要关联对象的属性值，那么此时可以通过延迟加载来实现功能。在全局配置文件中添加如下属性

**DeptDao.****java**

public interface DeptDao {
    
        public Dept selectDeptByDeptno(Integer deptno);
        public Dept selectDeptByStep(Integer deptno);
    ================================== 添加 =======================================
        public Dept selectDeptByStemp2(Integer deptno);
    ===============================================================================
    }

**DeptDao.****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.mashibing.dao.DeptDao">
        <resultMap结果映射 id="myDept" type="com.mashibing.bean.Dept">
            <id column="deptno" property="deptno"></id>
            <result property="dname" column="dname"></result>
            <result property="loc" column="loc"></result>
            <collection收集 property="emps" ofType类型筛选="com.mashibing.bean.Emp">
                <id column列="empno" property属性="empno"></id>
                <result column="ename" property="ename"></result>
                <result column="job" property="job"></result>
                <result column="mgr" property="mgr"></result>
                <result column="hiredate" property="hiredate"></result>
                <result column="sal" property="sal"></result>
                <result column="comm" property="comm"></result>
            </collection>
        </resultMap>
       <select id="selectDeptByDeptno" resultMap结果映射="myDept">
            select * from emp left join dept on emp.deptno = dept.deptno where empno = #{empno}
       </select>
    <select id="selectDeptByStep" resultType结果类型="com.mashibing.bean.Dept">
            select * from dept where deptno = #{deptno}
        </select>
    ================================== 添加 =======================================
        <select id="selectDeptByStemp2" resultMap="deptEmp">
            select * from dept where deptno = #{deptno}
        </select>
    
    <resultMap id="deptEmp" type="com.mashibing.bean.Dept">
            //下面三行，是从上面直接复制的
            <id column="deptno" property="deptno"></id>
            <result property="dname" column="dname"></result>
            <result property="loc" column="loc"></result>
            <collection收藏 property="emps" ofType类型筛选="com.mashibing.bean.Emp" select="com.mashibing.dao.EmpDao.selectEmpByStep2" column列="deptno">
            </collection>
        </resultMap>
    ===============================================================================
    </mapper>

**EmpDao.****java**

public interface EmpDao {
    
        public Emp selectEmpByEmpno(Integer empno);
    public Emp selectEmpByStep(Integer empno);
    ================================== 添加 =======================================
    public Emp selectEmpByStep2(Integer deptno);
    ===============================================================================
    }

**EmpDao.****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.mashibing.dao.EmpDao">
    //将每一个属性值都映射成对象中的数据，如果有实体类对象，就写成对象.属性的方式
    
    
    
    
    
    
    
    
    
    
    
    
    
    //推荐使用第二种方式
        <resultMap结果映射 id="myEmp" type="com.mashibing.bean.Emp">
            <id column="empno" property="empno"></id>
            <result column="ename" property="ename"></result>
            <result column="job" property="job"></result>
            <result column="mgr" property="mgr"></result>
            <result column="hiredate" property="hiredate"></result>
            <result column="sal" property="sal"></result>
            <result column="comm" property="comm"></result>
            <association关联 property="dept" javaType ="com.mashibing.bean.Dept">
                <id property属性="deptno" column列="deptno"></id>
                <result property="dname" column="dname"></result>
                <result property="loc" column="loc"></result>
            </association>
        </resultMap>
    <select id="selectEmpByEmpno" resultMap结果映射="myEmp">
            select * from emp left join dept on emp.deptno = dept.deptno where empno = #{empno}
        </select>
        <select id="selectEmpByStep" resultMap结果映射="empDept">
            select * from emp where empno = #{empno}
        </select>
    
    <resultMap结果映射 id="empDept" type="com.mashibing.bean.Emp">
            //将上面的复制下来
            <id column列="empno" property="empno"></id>
            <result column="ename" property="ename"></result>
            <result column="job" property="job"></result>
            <result column="mgr" property="mgr"></result>
            <result column="hiredate" property="hiredate"></result>
            <result column="sal" property="sal"></result>
            <result column="comm" property="comm"></result>
            //dept是对象，不是属性（鼠标点进去转到另一个表）
            <association关联 property="dept" select="com.mashibing.dao.DeptDao.selectDeptByStep" column列="deptno"></association>
        </resultMap>
    ================================== 添加 =======================================
        <select id="selectEmpByStep2" resultType="com.mashibing.bean.Emp">
            select * from dept where deptno = #{deptno}
        </select>
    ===============================================================================
    </mapper>

**MyTest.****java**

@Test
        public void test04() throws IOException {
    //获取与数据库相关的会话
            SqlSession sqlSession = sqlSessionFactory.openSession();
    //获取对应的映射接口对象
            DeptDao mapper映射 = sqlSession.getMapper(DeptDao.class);
            Dept dept = mapper.selectDeptByStemp2(10);
    //关闭会话
            sqlSession.close();
        }

![20200807093502464.png][]

![20200807093505781.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 2][]

**去除无关的东西：****延时查询（延时加载）**

### **方式一：** ###

**mybatis-config.****xml**

//可以影响mybatis运行时的行为，包含N多个属性，需要什么引入什么
    <settings>
    //开启驼峰标识验证
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    ================================== 添加 =======================================
    //配置懒加载开关
        <setting name="lazyLoadingEnabled" value="true"/>
    ===============================================================================
    </settings>

![20200807093539119.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 5][] **//除了lasy懒惰之外，还有eager急切**

**lasy****懒惰（默认）：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 6][]

如果设置了全局加载，但是希望在某一个sql语句查询的时候不适用延时策略，可以添加如下属性：

**eager****急切：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 7][]

### **方式二：** ###

**mybatis-config.****xml**

//可以影响mybatis运行时的行为，包含N多个属性，需要什么引入什么
    <settings>
    //开启驼峰标识验证
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    //配置懒加载开关
        <setting name="lazyLoadingEnabled" value="true"/>
    ================================== 添加 =======================================
        <setting name="aggressiveLazyLoading" value="true"/>
    ===============================================================================
    </settings>

**eager****急切：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 8][]

**lasy****懒惰：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 9][]

aggressiveLazyLoading在3.4.1版本之前默认之前而为true

![20200807093656900.png][]** //如果需要的话，可通过通过该方式应用**

[20200806203709567.png]: /images/20221124/f63c8745750b421eb8f12d4c2e9621c5.png
[2020080620371320.png]: /images/20221124/6383ee43294b44ec94b87e3ca7da801c.png
[20200806203744617.png]: /images/20221124/c9661b164896493a9caaa5433bf06917.png
[20200806203808973.png]: /images/20221124/616ef7a6e1384bef8c6b462229b89e61.png
[20200806203832284.png]: /images/20221124/3ce45b51bc1b4f91bfe03ab45571ab30.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70]: /images/20221124/96d9ddb9fd064d92b3f5b6b02c80100d.png
[20200806203941732.png]: /images/20221124/eff710e3ac334e849b1df6500e2c7a88.png
[20200807093322614.png]: /images/20221124/ba742be37cb04fd5ab89835f8b3e372c.png
[20200807093326735.png]: /images/20221124/e0a67bd362344d77a64f540fef7723c2.png
[20200807093502464.png]: /images/20221124/207f29ee4117430e9fb35bfea36f07d2.png
[20200807093505781.png]: /images/20221124/8f270933552f4995a52b238f176a02c0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 1]: /images/20221124/165b81fc364947d99267601af6e9f9ef.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 2]: /images/20221124/d5bfc853447b49e7afb4d3733f2d2535.png
[20200807093539119.png]: /images/20221124/fca0f669b6834c8ab65f07f79daaada2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 3]: /images/20221124/fb58566ecd704097b81246298916a834.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 4]: /images/20221124/a4b528d0a95f4a5a990a13969414b8e6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 5]: /images/20221124/b6e24201e86d4d589cd873c240a8c749.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 6]: /images/20221124/15abfae49ebc4d92b343c1d42b106346.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 7]: /images/20221124/377695d4e53546dbb86d2abfec87915a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 8]: /images/20221124/6f8e838fb76b4265a2f86e8b8597203f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTA0MjU2OQ_size_16_color_FFFFFF_t_70 9]: /images/20221124/7fc9cd5864f343bda747616b32463be5.png
[20200807093656900.png]: /images/20221124/d65104829fbb4d94be93b138d7f771d0.png