Druid 数据库连接池的连接Demo

import com.alibaba.druid.pool.DruidDataSourceFactory;

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

/**
 * @author silence
 * <p>
 * Druid 数据库连接池的连接Demo
 */
public class DruidDemo1 {
    public static void main(String[] args) throws Exception {

        //获取类加载器，加载数据库连接配置文件，获得字节输入流
        InputStream input = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
        //通过Properties  加载数据库配置文件，将数据库连接信息加载到Properties中
        Properties prop = new Properties();
        prop.load(input);


        // 将获得配置文件后的prop 对象，传入DruidDataSourceFactory 获得数据库连接池对象
        //Druid 会自动读取prop 内的数据库连接信息
        DataSource dataSource = DruidDataSourceFactory.createDataSource(prop);
        //获得连接对象
        Connection connection = dataSource.getConnection();


        //编写SQL语句
        String sql = "select * from student";
        //通过连接对象获得执行者对象，传入SQL语句，进行预编译
        PreparedStatement prepare = connection.prepareStatement(sql);
        //执行SQL语句，获取resultSet 结果集
        ResultSet resultSet = prepare.executeQuery();


        //循环遍历结果集
        while (resultSet.next()) {
            System.out.print(resultSet.getString("id") + "\t\t");
            System.out.print(resultSet.getString("name") + "\t\t");
            System.out.print(resultSet.getString("age") + "\t\t");
            System.out.println(resultSet.getString("cid") + "\t\t");
        }

        //释放资源，将连接归还到数据库连接池
        resultSet.close();
        prepare.close();
        connection.close();
    }
}