獲取驅動，連接資料庫，關閉資源

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DBUtil {

//初始化資料庫四個準備條件

private static final String DRIVER_CLASS = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=epet";

private static final String USERNAME = "sa";

private static final String PASSWORD = "sa";

//創建資料庫的驅動

static {

try {

Class.forName(DRIVER_CLASS);

System.out.print("獲取驅動成功！");

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

//創建連接資料庫

public static Connection getConnection() throws SQLException{

//Connection conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);

//return conn;

return DriverManager.getConnection(URL,USERNAME,PASSWORD);

}

//關閉資源，釋放資源

public static void closeAll(Connection conn ,Statement stmt,ResultSet rst) {

if(rst!=null) {

try {

rst.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

if(stmt!=null) {

try {

stmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

if(conn!=null) {

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}

喜歡這篇文章嗎？立刻分享出去讓更多人知道吧！