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();
			}
		}
	}
	

}