Java处理Dbutils返回回来的数据

刚开始用dbutils，记录一下，挺简单，适合我这种傻瓜式入门的： 

1、新建一个JDBCUtils类

package com.yx.tools;

import org.apache.commons.dbcp.BasicDataSource;

import javax.sql.DataSource;

public class JDBCUtils {
    //创建basicDataSource类
    private static BasicDataSource basicDataSource = new BasicDataSource();

    static {
        basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
        basicDataSource.setUrl("jdbc:mysql://10.6.1.2:3306/test");
        basicDataSource.setUsername("a");
        basicDataSource.setPassword("b");

        //可选配置
        basicDataSource.setMaxActive(10);//连接池最大连接数
        basicDataSource.setMaxIdle(5);//连接池最大空闲数
        basicDataSource.setMinIdle(3);//连接池最小空闲数
        basicDataSource.setInitialSize(10);//初始化连接池时的连接数
    }

    //返回BasicDatasource类，通过调用静态getDatasource方法，拿到实现接口的类
    public static DataSource getDataSource(){
        return basicDataSource;
    }
}

 

@Test
    public void t2() throws SQLException {
        QueryRunner qr = new QueryRunner(JDBCUtils.getDataSource());
        String sql="select * from student";
        List<Object[]> list = qr.query(sql,new ArrayListHandler());
        for(Object[] obj:list){
            System.out.println(obj[0]+"|"+obj[1]);
        }
        System.out.println("------------------");

        List<Map<String,Object>> res = qr.query(sql,new MapListHandler());
        System.out.println(res);
        for(Map<String,Object> o:res){
            System.out.println(o.get("Sno")+"|"+o.get("Sname"));
        }
    }

package com.yx.tools;

import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;

import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Properties;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.PropertiesLoaderUtils;

public class JDBCUtils {
    //创建basicDataSource类
    private static BasicDataSource basicDataSource = new BasicDataSource();

    static {
        //读取配置文件
        Resource resource = new ClassPathResource("application.properties");
        Properties props = null;
        try {
            props = PropertiesLoaderUtils.loadProperties(resource);
        } catch (IOException e) {
            e.printStackTrace();
        }
        String driver = props.getProperty("spring.datasource.driver-class-name");
        String url = props.getProperty("spring.datasource.url");
        String username = props.getProperty("spring.datasource.username");
        String password = props.getProperty("spring.datasource.password");

        basicDataSource.setDriverClassName(driver);
        basicDataSource.setUrl(url);
        basicDataSource.setUsername(username);
        basicDataSource.setPassword(password);
        //可选配置
        basicDataSource.setMaxActive(10);//连接池最大连接数
        basicDataSource.setMaxIdle(5);//连接池最大空闲数
        basicDataSource.setMinIdle(3);//连接池最小空闲数
        basicDataSource.setInitialSize(10);//初始化连接池时的连接数
    }

    //返回BasicDatasource类，通过调用静态getDatasource方法，拿到实现接口的类
    public static DataSource getDataSource(){
        return basicDataSource;
    }
}