package spring2.integration;

import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
public class ExecuteAnUpdate {
    private JdbcTemplate jt;
private DataSource dataSource;
//直接執(zhí)行SQL語句更新數(shù)據(jù)庫，調(diào)用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;
    }
}