Druid连接池的使用例子

测试类：

package com.test;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

import javax.sql.DataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

public class Test5 {
	public static void main(String[] args) {
//		创建Properties对象
		Properties properties = new Properties();

		try {
//			加载properties文件
			properties.load(new FileInputStream("src/druid.properties"));
//			创建连接池对象
			DataSource createDataSource = DruidDataSourceFactory.createDataSource(properties);
//			获取连接池
			Connection connection = createDataSource.getConnection();
			PreparedStatement preparedStatement = connection.prepareStatement("select * from u_p");
			ResultSet rs = preparedStatement.executeQuery();
//			遍历输出数据库中的内容
			while (rs.next()) {
				System.out.println(rs.getInt("id") + "---" + rs.getString("username") + "---" + rs.getString("pw"));
			}

		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}