mysql连接

package com.bochy.jdbc;

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

/**
 * @author zhaoYuguang
 * @version 1.0 链接Mysql数据库工具类
 * */
public class DBConnection {
	private Connection connection;// 数据库链接对象jdbc:mysql://ip地址:端口号/库名
	private final String URL = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312";
	private final String USERNAME = "root";
	private final String PWD = "admin";

	// 构造方法，实例化DBConnection对象时，就获取数据库链接
	public DBConnection() {

		try {
			Class.forName("com.mysql.jdbc.Driver"); // 加载数据库驱动(根据以下驱动的类路径，找到这个类，加载这个类)
			this.connection = DriverManager.getConnection(URL, USERNAME, PWD);

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

	}

	/**
	 * 获取数据库链接方法
	 * */
	public Connection getConnection() {
		return this.connection;
	}

	// 测试是否链接成功
	public static void main(String args[]) {
		DBConnection db = new DBConnection();
		Connection conn = db.getConnection();
		System.out.println(conn.toString());
		System.out.println(conn == null);
	}

}