package spring2.integration;

import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
public class ExecuteAStatement {
    // JdbcTemplate很多用用的方法
    private JdbcTemplate jt;
private DataSource dataSource;
    public void doExecute() {
        jt = new JdbcTemplate(dataSource);
        //創建表
        jt.execute("create table mytable (id integer， name varchar(100))");
    }
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }
}