JDBC连接MySQL的一个工具类DBUtil

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

public class DBUtil 
{
	private static String driverString = "com.mysql.jdbc.Driver";
	private static String connectionString = "jdbc:mysql://localhost:3306/jpetstore"; //假设所连接的数据库名为jpetstore
	private static String username = "root";                                          //要正确输入自己的用户名和密码
	private static String password = "123456";
	public static Connection getConnection() throws Exception {
		Connection connection = null;
		try {
			Class.forName(driverString);
			connection = DriverManager.getConnection(connectionString,username,password);
		} catch (Exception e) {
			throw e;
		}
		return connection;
	}
	public static void closeStatement(Statement statement) throws Exception {
		statement.close();
	}
	public static void closePreparedStatement(PreparedStatement pStatement)
			throws Exception {
		pStatement.close();
	}
	public static void closeResultSet(ResultSet resultSet) throws Exception {
		resultSet.close();
	}
	public static void closeConnection(Connection connection) throws Exception {
		connection.close();
	}
	
	/* test the DB Connection
	public static void main(String[] args) throws Exception {
		Connection conn = DBUtil.getConnection();
		System.out.println(conn);
	}*/
}