多层级联，在底层接收外部传入的参数方法

素颜马尾好姑娘i 2022-05-25 04:19 26阅读 0赞

## **\*\*\*\* 多层级联，在底层接收外部传入的参数方法：在外层查出来，在传入里层** ##

（可能看起来很蠢，但是这是我能想到的唯一办法了![大哭][wail.gif]）

**<resultMaptype="com.statistic.entity"id="userProject">**

**      <id property="id"column="id"/>**

**      <result property="name"column="name" />**

**      <collection property="basicAttributes"javaType="java.util.List"  column="\{id=id,user\_id=user\_id,year=year,month=month\}"**

**         ofType="com..statistic.entity."select="selectBasicAttribute" >**

**      </collection>**

**   </resultMap>**

**  **

**   <select id="selectProject"resultMap="userProject">**

**      SELECTdistinct pp.id id ,pp.\`name\` ,ti.user\_iduser\_id,YEAR(ti.modified\_time) year,MONTH(ti.modified\_time) month  FROM p\_task\_info  ti**

# **\*\*\*  可以吧变量放进参数查出来** #

select nc.\*,\#\{loginUser\_id\} loginUser\_id

,uu.nicknamenickname, uui.head\_pic\_path headPic,count(nl.id) likeNum

# \*\*\* Delete语句中使用select语句 #

delete news\_comment FROM news\_comment

join (SELECT id fromnews\_comment  where 1=1

<includerefid="conds" />) t

on news\_comment.parent\_id=t.id

# \*\*\* 加入自己下载下来的jar包 #

<groupId>com.woun.product</groupId>

<artifactId>jakarta\-oro</artifactId>

</dependency>

![70][]

\*\*\* 阿里云Maven仓库地址：[http://maven.aliyun.com/nexus/\#view-repositories;public~browsestorage][http_maven.aliyun.com_nexus_view-repositories_public_browsestorage]

在maven的settings.xml 文件里配置mirrors的子节点，添加如下mirror

<id>nexus-aliyun</id>

<name>Nexus aliyun</name>

<url>http://maven.aliyun.com/nexus/content/groups/public</url>

</mirror>

# #

## \*\*\*注入参数写法 ##

task\_ids:\[1,2,3\]

@RequestParam**(**"task\_ids"**)**List<Long> taskIds

ids：“abc，cde，def”

**@RequestParam("ids")String ids**

public Result updateAuditors(String data) \{  
         //data="\{'task\_ids':\[1,2,3\],'auditor\_id':5,'auditor\_hierarchy':2,'auditor\_type':'2','auditor\_name':'余家辉'\}";  
        AuditorsVo auditorsVo = JSON.parseObject(data, AuditorsVo.class);

# \*\*\*统计sql语句 #

SELECT IFNULL((SELECT remaining\_sum fromu\_wallet\_info WHERE user\_id=\#\{user\_id\}),0) AS sumMoney,

IFNULL((SELECT SUM(freeze\_price) fromu\_freeze\_record WHERE user\_id=\#\{user\_id\}),0) as freezeMoney,

sum( CASE WHEN trade\_type='1' THENtrade\_price ELSE 0 END) as rechargeMoney,

sum( CASE WHEN trade\_type='2' THENtrade\_price ELSE 0 END) as withdrawMoney,

sum( CASE WHEN trade\_type='4' ORtrade\_type='6' OR trade\_type='10' OR trade\_type='8' THEN trade\_price ELSE 0END) as incomeMoney,

sum(CASE WHEN trade\_type='5' OR trade\_type='7' OR trade\_type='11' ORtrade\_type='9'THEN trade\_price ELSE 0 END) as payMoney

FROM u\_trade\_record

WHERE user\_id=\#\{user\_id\}

[wail.gif]: https://static-blog.csdn.net/xheditor/xheditor_emot/default/wail.gif
[70]: /images/20220525/bff12667a59746869f73936c908f6dd1.png
[http_maven.aliyun.com_nexus_view-repositories_public_browsestorage]: http://maven.aliyun.com/nexus/#view-repositories;public~browsestorage