Spring Named Parameters examples in SimpleJdbcTemplate
In JdbcTemplate, SQL parameters are represented by a special placeholder “?” symbol and bind it by position. The problem is whenever the order of parameter is changed, you have to change the parameters bindings as well, it’s error prone and cumbersome to maintain it.
To fix it, you can use “Named Parameter“, whereas SQL parameters are defined by a starting colon follow by a name, rather than by position. In additional, the named parameters are only support in SimpleJdbcTemplate and NamedParameterJdbcTemplate.
See following three examples to use named parameters in Spring.
Example 1
Example to show you how to use named parameters in a single insert statement.
//insert with named parameter
public void insertNamedParameter(Customer customer){
String sql = "INSERT INTO CUSTOMER " +
"(CUST_ID, NAME, AGE) VALUES (:custId, :name, :age)";
Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("custId", customer.getCustId());
parameters.put("name", customer.getName());
parameters.put("age", customer.getAge());
getSimpleJdbcTemplate().update(sql, parameters);
}
Example 2
Examples to show how to use named parameters in a batch operation statement.
public void insertBatchNamedParameter(final List<Customer> customers){
String sql = "INSERT INTO CUSTOMER " +
"(CUST_ID, NAME, AGE) VALUES (:custId, :name, :age)";
List<SqlParameterSource> parameters = new ArrayList<SqlParameterSource>();
for (Customer cust : customers) {
parameters.add(new BeanPropertySqlParameterSource(cust));
}
getSimpleJdbcTemplate().batchUpdate(sql,
parameters.toArray(new SqlParameterSource[0]));
}
Example 3
Another examples to use named parameters in a batch operation statement.
public void insertBatchNamedParameter2(final List<Customer> customers){
SqlParameterSource[] params =
SqlParameterSourceUtils.createBatch(customers.toArray());
getSimpleJdbcTemplate().batchUpdate(
"INSERT INTO CUSTOMER (CUST_ID, NAME, AGE) VALUES (:custId, :name, :age)",
params);
}
最新文章
- 分布式服务框架dubbo原理解析（转）
- eclipse中配置maven
- centos7下安装使用docker
- 解决linux yum无法安装mysql
- [BZOJ1072][SCOI2007] 排列prem
- 自定义Scrollview--实现仿淘宝Toolbar透明度渐变效果
- YTU 3006: 迷宫问题（栈与队列）
- Android 签名(3)已签名的apk中的文件
- The initialize list of C++ Class
- testlink（以及服务器）问题定位思路
- All-In-One方式-安装openstack
- 【转载】ASP.NET以Post方式抓取远程网页内容类似爬虫功能
- Spring Boot 技术总结
- 20155308『网络对抗技术』Exp5 MSF基础应用
- linux查找进程pid并杀掉
- nodejs(一)process模块
- Linux centos7 redis安装教程
- Redis数据结构（三）
- unity, UGUI Image shader
- luogu P1347 排序