获取数据库连接工具类

package com.power.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * @author chengwei
 * @date 2017年7月13日上午10:35:59
 * @description:获取数据库连接工具类
 */
public class ConnectionUtil {

	private ConnectionUtil() {
	};

	// 加载数据驱动类 第一次运行时加载一次即可
	static {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			throw new RuntimeException(e);
		}
	}

	/**
	 * 获取连接
	 */
	public static Connection getConnection() throws SQLException {
		return DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/cw_database", "root", "123456");
	}

	/**
	 * 关闭连接
	 */
	public static void closeConnection(Connection connection) {
		try {
			if (null != connection) {
				connection.close();
			}
		} catch (SQLException e) {
			System.out.println("关闭连接时发生异常");
		}
	}

	/**
	 * 测试
	 */
	public static void main(String[] args) {
		try {
			Connection connection = getConnection();
			System.out.println(connection);
			System.out.println(connection.isClosed());
			closeConnection(connection);
			System.out.println(connection.isClosed());
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}