dbutil.java

来自「我自己写的javabean+jsp+servlet」· Java 代码 · 共 49 行

package com.gke;

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

public class DBUtil {
	static String sDBDriver = "com.mysql.jdbc.Driver";
	static String dbName = "gke";
	static String dbUser = "root";
	static String dbPwd = "root";
	static String sConnStr = "jdbc:mysql://localhost/"+dbName;
	
	public static Connection getConnection() throws ClassNotFoundException, SQLException{
		Connection conn = null;
		
		try {
			Class.forName(sDBDriver).newInstance();
		} catch (InstantiationException e) {
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			e.printStackTrace();
		};
		conn = DriverManager.getConnection(sConnStr,dbUser,dbPwd);
		
		return conn;
	}
	
	public static void closeResultSet(ResultSet rs) throws SQLException{
		if(rs!=null){
			rs.close();
		}
	}
	public static void closeStatement(Statement stmt) throws SQLException{
		if(stmt!=null){
			stmt.close();
		}
	}
	
	public static void closeConnection(Connection conn) throws SQLException{
		if(conn!=null){
			conn.close();
		}
	}

}