java 连接MySql

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

public class DBHelper {
	private static final String URL = "jdbc:mysql://localhost:3306/gv?useUnicode=true&characterEncoding=UTF-8";
	private static final String DRIVER = "com.mysql.jdbc.Driver";
	private static final String USER = "root";
	private static final String PASSWORD = "root";
	private Connection conn;
	private PreparedStatement pstmt;
	public ResultSet rs;
	/***
	 * 加载驱动
	 */
	static {
		try {
			Class.forName(DRIVER);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}

	}

	/***
	 * 获取连接
	 * @throws SQLException
	 */
	public void getConnect() throws SQLException {
		conn = DriverManager.getConnection(URL, USER, PASSWORD);
	}
/***
 * 关闭资源
 * @throws SQLException
 */
	public void closeDB() throws SQLException {
		if (rs != null) {
			rs.close();
		}
		if (pstmt != null) {
			pstmt.close();
		}
		if (conn != null) {
			conn.close();
		}
	}
/***
 * 查询结果集
 * @param sql 查询语句
 * @param pram 参数
 * @return 返回结果集
 * @throws SQLException
 */
	public ResultSet excuteQuery(String sql, String[] pram) throws SQLException {
		this.getConnect();
		pstmt = conn.prepareStatement(sql);
		if (pram != null && pram.length > 0) {
			for (int i = 0; i < pram.length; i++) {
				pstmt.setString(i + 1, pram[i]);
			}
		}
		rs = pstmt.executeQuery();
		return rs;
	}
/****
 * 进行增删改
 * @param sql  增删改 的sql语句
 * @param pram 参数
 * @return 返回影响的行数
 * @throws SQLException
 */
	public int excuteUpdate(String sql, String[] pram) throws SQLException {
		int result = 0;
		this.getConnect();
		pstmt = conn.prepareStatement(sql);
		if (pram != null && pram.length > 0) {
			for (int i = 0; i < pram.length; i++) {
				pstmt.setString(i + 1, pram[i]);
			}
		}
		result = pstmt.executeUpdate();
		return result;
	}

}