java的druid连接

导入jar包

将druid配置文件放到src目录下

import cn.silence2.domain.Student;
import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

/**
 * java的druid连接
 */
public class DruidTest1 {
    public static void main(String[] args) throws Exception {
        //获取配置文件流对象
        InputStream inputStream = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
        Properties prop = new Properties();
        //将druid配置文件加载到prop
        prop.load(inputStream);
        //将prop对象传给druid工厂类，返回一个数据库连接池对象
        DataSource dataSource = DruidDataSourceFactory.createDataSource(prop);
        //通过数据库连接池对象，建立与数据库的连接
        Connection connection = dataSource.getConnection();
        // sql 语句
        String sql = "select * from student";
        //通过数据库连接获得执行者对象，对sql语句进行预编译
        PreparedStatement prepare = connection.prepareStatement(sql);
        //执行查询sql语句，获得结果集
        ResultSet resultSet = prepare.executeQuery();

        while (resultSet.next()) {
            int sid = resultSet.getInt("sid");
            String name = resultSet.getString("name");
            int age = resultSet.getInt("age");
            Date birthday = resultSet.getDate("birthday");
            //封装到student
            Student student = new Student(sid, name, age, birthday);
            System.out.println(student);
        }
        resultSet.close();
        prepare.close();
        connection.close();
    }
}

编写测试类