runaquery.java

白广元写的java web整合开发完全自学手册的源代码

package spring2.integration;

import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
public class RunAQuery {
    private JdbcTemplate jt;
    private DataSource dataSource;
    //利用JdbcTemplate类执行SQL查询
    public int getCount() {
        jt = new JdbcTemplate(dataSource);
        int count = jt.queryForInt("select count(*) from mytable");
        return count;
}
//利用JdbcTemplate类执行SQL查询，带条件查询
    public String getName() {
        jt = new JdbcTemplate(dataSource);
        //直接返回结果对象，而不是需要如JDBC一样分析结果集
        String name = (String) jt.queryForObject("select name from mytable", String.class);
        return name;
    }
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
    }
}