11. Java链接mysql数据库

package com.xuteng.util;

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

/**
 * 数据库连接包
 * @author 物业小学徒
 *
 */
public class DBUtil {
	
	private String driver = "com.mysql.jdbc.Driver";
	private String username = "root";
	private String password = "rootroot";
	private String url = "jdbc:mysql://localhost:3306/db_book?useUnicode=true&characterEncoding=UTF8";
	
	/**
	 * 获取数据库连接
	 * @return
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public Connection getConn() throws ClassNotFoundException, SQLException {
		Class.forName(driver);
		Connection connection = DriverManager.getConnection(url, username, password);
		return connection;
	}
	
	/**
	 * 数据库连接关闭
	 * @param connection
	 * @throws SQLException
	 */
	public void close(Connection connection) throws SQLException {
		if(connection!=null) {
			connection.close();
		}
	}
	
	public static void main(String[] args) {
		DBUtil dbUtil = new DBUtil();
		Connection connection = null;
		try {
			connection = dbUtil.getConn();
			System.out.println("数据库连接成功");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				dbUtil.close(connection);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	

}