package spring2.integration;

import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
public class RunAQuery {
    private JdbcTemplate jt;
    private DataSource dataSource;
    //利用JdbcTemplate類執(zhí)行SQL查詢
    public int getCount() {
        jt = new JdbcTemplate(dataSource);
        int count = jt.queryForInt("select count(*) from mytable");
        return count;
}
//利用JdbcTemplate類執(zhí)行SQL查詢，帶條件查詢
    public String getName() {
        jt = new JdbcTemplate(dataSource);
        //直接返回結(jié)果對(duì)象，而不是需要如JDBC一樣分析結(jié)果集
        String name = (String) jt.queryForObject("select name from mytable", String.class);
        return name;
    }
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }
}