JdbcUtils工具类

public class JdbcUtils {
	// 创建一个连接池连接池
	static DruidDataSource dataSource;
	static {
		try {
			InputStream inputStream = JdbcUtils.class.getClassLoader()
					.getResourceAsStream("jdbc.properties");
			Properties properties = new Properties();
			properties.load(inputStream);
			inputStream.close();

			dataSource = (DruidDataSource) DruidDataSourceFactory
					.createDataSource(properties);

			System.out.println(dataSource);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 从数据库连接池 获取连接
	 * 
	 * @return 返回null，说明获取连接失败<br/>
	 *         有值就成功
	 */
	public static Connection getConnection() {
		Connection connection = null;

		try {
			connection = dataSource.getConnection();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return connection;
	}

	public static void close(Connection connection) {
		try {
			if (connection != null) {
				connection.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public static void close(ResultSet rs, Statement statement,
			Connection connection) {
		try {
			if (rs != null) {
				rs.close();
			}
			if (statement != null) {
				statement.close();
			}
			if (connection != null) {
				connection.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}

JdbcUtils工具类模板