JDBC連接數據庫

[Java]代碼    

package com.ant.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * @author 楊俊寧
 * 
 */
public class Connector {
    Connection con;
    PreparedStatement pstmt;
    ResultSet rs;
    private final String user = "root"; 
    private final String password = "jun19931129";
    private final String driver = "com.mysql.jdbc.Driver";
    private final String url = "jdbc:mysql://localhost:3306/ant?useUnicode=true&characterEncoding=gbk";
    /**
     * 該方法依次完成加載驅動??接數據庫的任務
     * @return con
     */
    public Connection getConnection()    
    {
        Connection con = null;
        try {   
            Class.forName(driver);
            //System.out.println(">>>>>>>>>JDBC Driver Manager加載成功);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            System.out.println(">>>>>>>>>JDBC Driver Mana");
        }

        try {   
            con = DriverManager.getConnection(url, user, password); 
            //System.out.println(">>>>>>>>>數據庫連接成功！");
        } catch (SQLException e) {
            e.printStackTrace();
            System.out.println("數據庫連接失敗！");
        }
        return con;
    }
    /**
     * 該方法依次關閉處理查詢結果集對象rs、預處理語句對象pstmt、連接數據庫對象con
     * @return 
     */
    public void closed()
    {
        try{
            if(rs!=null)
                rs.close();
                System.out.println("對象rs已關閉！");
        }catch(SQLException e){
                System.out.println("關閉rs對象異常");
                e.printStackTrace();
        }
        try{
            if(pstmt!=null)
                pstmt.close();
                System.out.println("對象pstmt已關閉！");
        }catch(SQLException e){
            System.out.println("關閉pstm對象失敗");
            e.printStackTrace();
        }
        try{
            if(con!=null){
                System.out.println("對象con已關閉！");
                con.close();
            }
        }catch(SQLException e){
            System.out.println("關閉con對象失敗");
            e.printStackTrace();
        }
        con=null;
    }
}