executeanupdate.java

来自「白广元写的java web整合开发完全自学手册的源代码」· Java 代码 · 共 18 行

package spring2.integration;

import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
public class ExecuteAnUpdate {
    private JdbcTemplate jt;
private DataSource dataSource;
//直接执行SQL语句更新数据库，调用JdbcTemplate的update方法
    public void setName(int id, String name) {
        jt = new JdbcTemplate(dataSource);
        jt.update("update mytable set name = ? where id = ?", new Object[] {name, new Integer(id)});
    }
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }
}