druid和dbuilts的结合使用

1、新建工程，新建lib文件夹，上传jar包到lib下，添加build path。

2、在src下，新建driuid.properties，文件。并添加相应的配置。

3、新建一个类，与数据库中的属性相对应。
我的数据库属性如下：

类如下：

package druidAndDbutils;

public class Student {
    private int id;
    private String name;
    private String project;
    private int score;

    public Student() {
    }

    public Student(int id, String name, String project, int score) {
        this.id = id;
        this.name = name;
        this.project = project;
        this.score = score;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getProject() {
        return project;
    }

    public void setProject(String project) {
        this.project = project;
    }

    public int getScore() {
        return score;
    }

    public void setScore(int score) {
        this.score = score;
    }

    @Override
    public String toString() {
        return "Student [id=" + id + ", name=" + name + ", project=" + project + ", score=" + score + "]";
    }

}

4、新建DruidDemo类。

package druidAndDbutils;

import java.io.InputStream;
import java.util.List;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.junit.Test;
import com.alibaba.druid.pool.DruidDataSourceFactory;


public class DruidDemo {
    @Test
    public void test() {
        //建立一个数据源工厂
        DruidDataSourceFactory factory = new DruidDataSourceFactory();
        Properties p = new Properties();
        try {
            InputStream in = DruidDemo.class.getClassLoader().getResourceAsStream("druid.properties");
            p.load(in);
            //获取数据库
            DataSource dataSource = factory.createDataSource(p);
            //执行sql语句
            QueryRunner qr = new QueryRunner(dataSource);
            //将结果保存到对象列表中
            List<druidAndDbutils.Student> list = qr.query("select * from student", new BeanListHandler<Student>(Student.class));
            for (Student student : list) {
                System.out.println(student);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

5、结果为：