首先看jdbctemplate配置

id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> name="dataSource"> bean="dataSource"/> 
这个dataSource就不用说了吧,跟Hibernate使用同一个数据源
DAO层写法
id="serviceAnalyserJdbcDao" class="com.fruitking.dao.jdbcdao.impl.ServiceAnalyserDaoImpl"> name="jdbcTemplate" ref="jdbcTemplate" /> 
service层写法
id="serviceAnalyserJdbcService" class="com.fruitking.service.jdbcservice.impl.ServiceAnalyserServiceImpl"> name="serviceAnalyserJdbcDao" ref="serviceAnalyserJdbcDao" /> 
Spring配置就是这么简单了
当然在DAO层的程序里面我们一般使用一个对象包装
- import org.springframework.jdbc.core.RowMapper;
 - import org.springframework.jdbc.core.support.JdbcDaoSupport;
 - import com.fruitking.dao.jdbcdao.IAccessAnalyserDao;
 - import com.fruitking.entity.AccessAnalyser;
 - public class AccessAnalyserDaoImpl extends JdbcDaoSupport implements IAccessAnalyserDao{
 - public List
 countGroupByYear(){ - String sql ="select to_char(t.createddate, 'yyyy') as cyear, count(*) as yearcount from accessanalyser t group by to_char(t.createddate, 'yyyy')";
 - List
 accessAnalyserList = this.getJdbcTemplate().query(sql, new AccessAnalyserRowMapper()); - return accessAnalyserList;
 - }
 - class AccessAnalyserRowMapper implements RowMapper {
 - public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
 - AccessAnalyser accessAnalyser = new AccessAnalyser();
 - accessAnalyser.setYearName(rs.getString("cyear"));
 - accessAnalyser.setClickTimes(rs.getLong("yearcount"));
 - return accessAnalyser;
 - }
 - }
 - }
 
这样就可以像Hibernate一样在Spring框架中使用JDBC了,只不过你可以任意的使用JDBC的东西
Copyright © 2009-2022 www.wtcwzsj.com 青羊区广皓图文设计工作室(个体工商户) 版权所有 蜀ICP备19037934号