java jdbc工具类

package lmq.util;

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

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;

import java.util.Properties;

public class JdbcUtils {
	
	public static Connection getConnection() throws Exception{
		Connection con = null;
		String url = null;
		String username = null;
		String password = null;
		String driverClass = null;
		
		Properties pro = new Properties();
		pro.load(JdbcUtils.class.getResourceAsStream("/jdbc.properties"));
		//从配置文件读取数据
		url = pro.getProperty("url");
		username = pro.getProperty("username");
		password = pro.getProperty("password");
		driverClass = pro.getProperty("driverClass");
		//加载驱动
		Class.forName(driverClass);
		//获得连接
		con = (Connection) DriverManager.getConnection(url, username, password);
		
		return con;
	}

	/**
	 * 释放资源
	 * @param rs
	 * @param st
	 * @param col
	 */
	public static void releaseAll(ResultSet rs, PreparedStatement pst, Connection con) {
		
		if(null!=rs){
			try {
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				rs = null;
			}
		}
		
		if(null!=pst){
			try {
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				pst = null;
			}
		}
		
		if(null!=con){
			try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				con = null;
			}
		}
	}

}