spring 将不同类型的参数传递给 jdbctemplate 查询
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/27663170/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
passing different types of arguments to jdbctemplate query
提问by Suleman khan
I am trying to retrieve records from the database by using where clause with few different types of arguments. This is the simple method which I wrote where I am passing breedId and gender as an arguments.
我试图通过使用带有几种不同类型参数的 where 子句从数据库中检索记录。这是我编写的简单方法，我在其中传递了品种 ID 和性别作为参数。
public List<Dog> listByBreedIdAndGender(long breedId, String gender) {
return query("SELECT * FROM dog_entity WHERE breed__id = ? AND gender = ?",
new MapSqlParameterSource(":breedId", breedId)
.addValue(":gender", gender));
}
private List<Dog> query(String sql, MapSqlParameterSource parameters) {
List<Dog> dogs = jdbcTemplate.query(sql, new DogRowMapper(), parameters);
return dogs;
}
I ran this method but got below exception. Can anyone let me know how to pass multiple arguments to the jdbcTemplate.query(), I am kinda new to it.
我运行了这个方法，但得到了以下异常。任何人都可以让我知道如何将多个参数传递给 jdbcTemplate.query()，我对它有点陌生。
{
timestamp: 1419637479460
status: 500
error: "Internal Server Error"
exception: "org.springframework.dao.TransientDataAccessResourceException"
message: "PreparedStatementCallback; SQL [SELECT * FROM dog_entity WHERE breed__id = ? AND gender = ?]; Invalid argument value: java.io.NotSerializableException; nested exception is java.sql.SQLException: Invalid argument value: java.io.NotSerializableException"
path: "/api/2/m"
}
回答by Michal
Please use
请用
public List<Dog> listByBreedIdAndGender(long breedId, String gender) {
return jdbcTemplate.query("SELECT * FROM dog_entity WHERE breed__id = :breedId AND gender =:gender",
new MapSqlParameterSource()
.addValue("breedId", breedId)
.addValue("gender", gender));
}
Please make sure the jdbcTemplate is NamedParameterJdbcTemplate.
请确保 jdbcTemplate 是NamedParameterJdbcTemplate。
If you need to use JdbcTemplatethen
如果你需要使用JdbcTemplate那么
public List<Dog> listByBreedIdAndGender(long breedId, String gender) {
return jdbcTemplate.query
("SELECT * FROM dog_entity WHERE breed__id = ? AND gender = ?",
new Object[] { breedId, gender },
new DogRowMapper());
}
or if you insist on usage of the private query method
或者如果您坚持使用私有查询方法
public List<Dog> listByBreedIdAndGender(long breedId, String gender) {
return query
("SELECT * FROM dog_entity WHERE breed__id = ? AND gender = ?",
new Object[] { breedId, gender });
}
private List<Dog> query(String sql, Object[] parameters) {
List<Dog> dogs = jdbcTemplate.query(sql, parameters, new DogRowMapper());
return dogs;
}
}
Please make sure breed__id has correct number of _ characters.
请确保breed__id 的_ 字符数正确。
The concept is to either use NamedParameterJdbcTemplate with parameters designated by :name (such as :gender) or simple JdbcTemplate with positional parameters (such as new Object[] { breedId, gender } where breedId matches the first ? and the gender the second ?).
这个概念是使用 NamedParameterJdbcTemplate 与指定的参数 :name（例如 :gender）或简单的 JdbcTemplate 与位置参数（例如 new Object[] {breedId,gender} 其中breedId 匹配第一个？和第二个匹配的性别？） .
