Spring中的Jdbc的模板类是什么?

最常用的就是jdbcTemplate类了，把jdbc的增删改查等都封装起来了，可以直接调用，
用之前，配置一个数据源，也就是DataSource,非常的方便！

你的DAO可以继承spring提供好的JdbcDaoSupport就可以了，看下面的模板代码：
public class StatDaoImpl_Derby extends JdbcDaoSupport implements StatDao, InitializingBean {

@Override
public StatCount getVisitCount() {
String sql = "select t.totalCount tc, t.monthCount mc, t.weekCount wc, t.dayCount dc from statCount t";
StatCount statCount = this.getJdbcTemplate().queryForObject(sql, new RowMapper(){
@Override
public StatCount mapRow(ResultSet rs, int index) throws SQLException {
StatCount count = new StatCount();
long totalCount = rs.getLong("tc");
long monthCount = rs.getLong("mc");
long weekCount = rs.getLong("wc");
long dayCount = rs.getLong("dc");

count.setTotalCount(totalCount);
count.setMonthCount(monthCount);
count.setWeekCount(weekCount);
count.setDayCount(dayCount);
return count;
}
});
return statCount;
}

@Override
public int updateVisitCount(StatCount statCount) {
if(statCount == null) return 0;
String updateSql = "update statCount set totalCount=?, monthCount=?, weekCount=?, dayCount=?";
return this.getJdbcTemplate().update(updateSql, new Object[]{statCount.getTotalCount(), statCount.getMonthCount(), statCount.getWeekCount(), statCount.getDayCount()});
}

org.springframework.jdbc.datasource.DriverManagerDataSource
里面有driverClassName，url，username，password这四个属性，含义你知道的，同普通的djbc连接一样的

JdbcTemplate这个