jdbc公共操作之建立连接和释放资源

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

public class JdbcDao {
	private static String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
	private static String userName = "root";
	private static String password = "root";
	
	//加载驱动
	static{
		try{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
		}catch(Exception ex){
			ex.printStackTrace();
		}
	}
	
	
	/**
	 * 获取连接
	 * @return
	 * @throws SQLException
	 */
	protected static Connection getConnection() throws SQLException{
		return DriverManager.getConnection(url, userName, password);
	}
	
	
	/**
	 * 释放资源
	 * @param rs
	 * @param ps
	 * @param conn
	 */
	protected static void free(ResultSet rs, PreparedStatement ps, Connection conn){
		try{
			if (rs != null){
				rs.close();
			}
		}catch(SQLException ex){
			ex.printStackTrace();
		}finally{
			try{
				if (ps != null){
					ps.close();
				}
			}catch(SQLException ex){
				ex.printStackTrace();
			}finally{
				try{
					if (conn != null){
						conn.close();
					}
				}catch(SQLException ex){
					ex.printStackTrace();
				}
			}
		}
	}
}