我使用 Spring S SimpleJdbcInsert 类来创建实体, 例如:
final SimpleJdbcInsert insert = new SimpleJdbcInsert(dataSource).withTableName("abc");
insert.execute(new BeanPropertySqlParameterSource(abc));
是否有类似此类的更新?举例来说,下面这样的东西会是一个方便的界面,假设我们处理的是单列主钥匙:
final SimpleJdbcUpdate update = new SimpleJdbcUpdate(dataSource).withTableName("abc").withIdColumn("abcId");
update.execute(new BeanPropertySqlParameterSource(abc));
斯普林是否在某个地方 提供了这个功能的外在功能?
Thanks Jay
您必须使用 JdbcTemplate
E.X:
this.jdbcTemplate.update(
"update t_actor set = ? where id = ?",
"Banjo", 5276L);
对于任何未来的读者来说,我利用反思提出了便利功能;
用于简单的 pojos 工作 :
public void dao_update(NamedParameterJdbcTemplate database, String table, Object pojo, String[] keys) {
StringBuilder sqlBuilder = new StringBuilder("UPDATE ");
sqlBuilder.append(table);
sqlBuilder.append(" SET ");
boolean first = true;
for (Field field : pojo.getClass().getDeclaredFields()) {
if (!first) {
sqlBuilder.append(",");
}
first = false;
sqlBuilder.append(field.getName());
sqlBuilder.append(" = :");
sqlBuilder.append(field.getName());
}
first = true;
for (String key : keys) {
if (first) {
sqlBuilder.append(" WHERE ");
} else {
sqlBuilder.append(" AND ");
}
first = false;
sqlBuilder.append(key);
sqlBuilder.append("= :");
sqlBuilder.append(key);
}
database.getJdbcOperations().update(sqlBuilder.toString(), new BeanPropertySqlParameterSource(pojo));
}
实例使用:
dao_update(database, "employee", my_employee, "id");
生成结果 :
更新的雇员SET id =:id,名称=:名称,工资=:薪金=:
Spring JIRA中有一个问题,即缺少一个 您可以使用简单JdbcTemplate而不是 JdbcTemplate 来获取更相似的效果, 并且通过扩展简单JdbcDaoSuppy, 将所有 DB 操作都放入 DAO 类 : 这样做的简单方式是:(source )
I am trying to update my table 1 with some field value from table 2 based on a condition. But am unable to get the proper query. Here s the condition:
I have a table 1 with date field which should be ...
I m looking for a way to update just a portion of a string via MySQL query.
For example, if I have 10 records all containing string as part of the field value, is there a way to change string to ...
I want to convert a table storing in Name-Value pair data to relational form in SQL Server 2008.
Source table
Strings
ID Type String
100 1 John
100 2 Milton
101 1 Johny
101 2 Gaddar
...
I want to update a row which has some html tags inside. For instance:
src= /imagem.png ></ p></ body>
> UPDATE ISTANBUL_TABLE SET TEXT = <
> body>< p>< img ...
I want to update two fields of table (Store) from a select of others tables, but i don´t know how i can do it. The SQL system is in AS/400, so doesn´t have SQL Server or Oracle tricks :(
Here is the ...
Im trying to UPDATE queueStatusINT WHERE statusINT is 8 and queueStatusINT is NOT equal to 2 and type is $type.
But I keep getting an error:
ERROR 1064 (42000) at line 1: You have an error in your ...
I am looking for a simple way to query an update or insert based on if the row exists in the first place. I am trying to use Python s MySQLdb right now.
This is how I execute my query:
self.cursor....
I m creating an update trigger that goes like this (SQL Server 2005):
Is the state column of the row is 23 or 25 don t update it. Else update it. It s very simple. I m trying
OldState = (Select ...
SproJdbcUptidate 类:
import java.util.List;
import javax.sql.DataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.namedparam.BeanPropertySqlParameterSource;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.SqlParameterSource;
import org.springframework.jdbc.core.simple.SimpleJdbcDaoSupport;
import org.springframework.stereotype.Repository;
@Repository
public class BankDaoImpl extends SimpleJdbcDaoSupport implements BankDao {
@Autowired
public BankDaoImpl(@Qualifier("dataSource") DataSource dataSource) {
setDataSource(dataSource);
}
@Override
public void insert(Bank bank) {
String sql = "INSERT INTO BANK (id, oib, short_name, name, street, town, postal_code, homepage_url, last_change) VALUES (NEXT VALUE FOR bank_seq, :oib, :shortName, :name, :street, :town, :postalCode, :homepageUrl, CURRENT_TIMESTAMP)";
SqlParameterSource parameterSource = new BeanPropertySqlParameterSource(
bank);
getSimpleJdbcTemplate().update(sql, parameterSource);
}
@Override
public void update(Bank bank) {
String sql = "UPDATE BANK SET oib=:oib, short_name=:shortName, name=:name, street=:street, town=:town, postal_code=:postalCode, homepage_url=:homepageUrl, last_change=CURRENT_TIMESTAMP WHERE id=:id";
SqlParameterSource parameterSource = new BeanPropertySqlParameterSource(
bank);
getSimpleJdbcTemplate().update(sql, parameterSource);
}
@Override
public void delete(String id) {
String sql = "DELETE FROM BANK WHERE id=:id";
getSimpleJdbcTemplate().update(sql,
new MapSqlParameterSource("id", id));
}
@Override
public Bank findById(String id) {
String sql = "select b.ID, b.OIB, b.SHORT_NAME, b.NAME, b.STREET, b.TOWN, b.POSTAL_CODE, b.HOMEPAGE_URL, b.LAST_CHANGE, CASE WHEN count(f.id) = 0 THEN 0 ELSE 1 END AS ready " +
"from BANK WHERE b.ID = :id";
return getSimpleJdbcTemplate().queryForObject(sql,
BeanPropertyRowMapper.newInstance(Bank.class),
new MapSqlParameterSource("id", id));
}
}
public void setName(int id, String name) {
this.jdbcTemplate.update("update mytable set name = ? where id = ?",
new Object[] {name, new Integer(id)});
}
相关问题
Update a table with records from another table
MySql - Way to update portion of a string?
Updating Uncommitted data to a cell with in an UPDATE statement
Using comma with an update sentence
SQL Update from a Select
How to MYSQL UPDATE fieldINT!=‘4’ doesn’t work [closed]
Python MySQLdb: Update if exists, else insert
SQL Trigger 1 row at a time