擅长:python、mysql、java
<p>假设您总是使用相同的查询参数,而不是定义变量,循环遍历字符串列表并将它们作为键值对</p>
<p>填充</p>
<pre><code>items = ["wonum", "description"]
resp = {k: request.getQueryParam(k) for k in items}
</code></pre>
<p>然后设置</p>
<pre><code>for i in items:
woMbo.setValue(i, resp[i])
</code></pre>
<hr/>
<p>否则,您将寻找<a href="https://docs.oracle.com/javase/tutorial/networking/urls/urlInfo.html" rel="nofollow noreferrer">^{<cd1>}</a>和<code>getQuery</code>方法,然后是一个<code>split("=")</code>,例如,给您<code>["wonum", "WO0001", "description", "Legacy"]</code>,您可以循环其他元素以获得动态条目</p>
<pre><code>l = ["wonum", "WO0001", "description", "Legacy"]
for i in range(0, len(l)-1, 2):
print(f'key:{l[i]}\tvalue:{l[i+1]}')
</code></pre>
<p/><p/>
<pre><code>key:wonum value:WO0001
key:description value:Legacy
</code></pre>
<hr/>
<p>注意:这会受到SQL注入攻击,应予以修复</p>
<pre><code>whereClause = "wonum= '" + wonum + "'"
</code></pre>