背景：

操作关系型数据库的框架很多，其实最好的是jdbc不过开发量稍高那么有没有其他的相对合适的框架呢？此处选择了dbutils。那么就需要spring和dbutils集成，对事务要求不高，基于spring注解集成

环境：

    	
     
      org.springframework
     	
     
      spring-core
     	
     
      3.2.0.RELEASE
     
    
    	
     
      org.springframework
     	
     
      spring-context
     	
     
      3.2.0.RELEASE
     
    
    	
     
      org.springframework
     	
     
      spring-beans
     	
     
      3.2.0.RELEASE
     
    
    	
     
      commons-dbutils
     	
     
      commons-dbutils
     	
     
      1.5
     
    
    	
     
      commons-pool
     	
     
      commons-pool
     	
     
      1.6
     
    
    	
     
      commons-dbcp
     	
     
      commons-dbcp
     	
     
      20030825.184428
     
    
    	
     
      mysql
     	
     
      mysql-connector-java
     	
     
      5.1.28
     
    

实现：

1.spring-source.xml：

2.DBUtilsTemplate

@Service("dbUtilsTemplate")public class DBUtilsTemplate {	@Autowired	private DataSource dataSource;	private QueryRunner queryRunner;	private static final Log LOG = LogFactory.getLog(DBUtilsTemplate.class);	public void setDataSource(BasicDataSource dataSource) {		this.dataSource = dataSource;	}	/**	 * 执行sql语句	 * 	 * @param sql	 *            sql语句	 * @param params	 *            参数数组	 * @return 受影响的行数	 */	public int update(String sql, Object[] params) {		queryRunner = new QueryRunner(dataSource);		int affectedRows = 0;		try {			if (params == null) {				affectedRows = queryRunner.update(sql);			} else {				affectedRows = queryRunner.update(sql, params);			}		} catch (SQLException e) {			LOG.error("Error occured while attempting to update data", e);		}		return affectedRows;	}	/**	 * 执行批量sql语句	 * 	 * @param sql	 *            sql语句	 * @param params	 *            二维参数数组	 * @return 受影响的行数的数组	 */	public int[] batchUpdate(String sql, Object[][] params) {		queryRunner = new QueryRunner(dataSource);		int[] affectedRows = new int[0];		try {			affectedRows = queryRunner.batch(sql, params);		} catch (SQLException e) {			LOG.error("Error occured while attempting to batch update data", e);		}		return affectedRows;	}	/**	 * 执行查询，将每行的结果保存到一个Map对象中，然后将所有Map对象保存到List中	 * 	 * @param sql	 *            sql语句	 * @return 查询结果	 */	public List

3.测试：

public static ClassPathXmlApplicationContext context = null;public static ClassPathXmlApplicationContext getContextInstance() {	if (context == null) {		start();	}	if (!context.isRunning()) {		CopyOfApp.context.refresh();		context.registerShutdownHook();	}	return context;}private static void start() {	context = new ClassPathXmlApplicationContext(			"classpath:spring-source.xml");	context.registerShutdownHook();}public static void main(String[] args) throws Exception {	App.start();	App.context.refresh();	DBUtilsTemplate dbUtilsTemplate = CopyOfApp.context.getBean(			"dbUtilsTemplate", DBUtilsTemplate.class);	String sql = "select count(1) from admin";	List