StringBuffer sql = new StringBuffer();
sql.append("update userinfo set password= :password where userid= :userid");
namedjdbctemp.batchUpdate(sql.toString(), SqlParameterSourceUtils.createBatch(list.toArray()));
list里面是实体类
添加和修改都可用此方法,只需改一下SQL语句
StringBuffer sql = new StringBuffer();
sql.append("update userinfo set password= :password where userid= :userid");
namedjdbctemp.batchUpdate(sql.toString(), SqlParameterSourceUtils.createBatch(list.toArray()));
list里面是实体类
添加和修改都可用此方法,只需改一下SQL语句