如何在Spring jdbcTemplate中将Array/List设置为参数? [英] How set Array/List in Spring jdbcTemplate as parameter?
本文介绍了如何在Spring jdbcTemplate中将Array/List设置为参数?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有很多占位符'?'的SQL查询,该占位符是动态生成的,我想放置值数组来替换占位符.数组的大小每次都可以不同.数组按顺序由所有参数组成.
I have SQL query with many placeholders '?', that builds dynamically, I want to put array of values to replace placeholders. Size of array can be different every time. Array consists from all parameters in order.
return jdbcTemplate.query(Queries.someQuery,
new Object[] {/* Array must be here */},
new ResultSetExtractor<List<String>>() {
@Override
public List<String> extractData(ResultSet resultSet)
}
});
sql代的示例:
for (int j = 0; j < y; j++) {
conditionsBuilder.append("\n and p"+i+".object_id=o.object_id\n" +
" and p"+i+".attr_id =?\n" +
" and p"+i+".value =?\n");
tablesBuilder.append(",patameters p"+i+" ");
i++;
}
推荐答案
使用ArrayList
:
ArrayList<Object> values = new ArrayList<>;
在您的for
循环中,应按在查询中出现的顺序添加值:
In your for
loop you should add the values in the order they appear in the query:
values.add(value);
然后将其转换为数组:
return jdbcTemplate.query(query, values.toArray(), resultSetExtractor);
这篇关于如何在Spring jdbcTemplate中将Array/List设置为参数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文