jdbc util

package util;

import java.io.IOException;
import java.io.InputStream;
import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
 

/**
 * 2017-04-13 07:50:48
 * 
 */
public class JdbcUtil {
	 
	private static String username;
	private static String password;
	private static String url;
	private static String dirver;
	static{ // 加载一次
		Properties properties = new Properties();
		InputStream inStream = JdbcUtil.class.getResourceAsStream("/jdbc.properties");
	 
		try {
			properties.load(inStream);
		
			 username = properties.getProperty("username");
			 password = properties.getProperty("password");
			 url = properties.getProperty("url");
			 dirver = properties.getProperty("driver");
		} catch (IOException e) {
			e.printStackTrace();
		}
		
		try {
			Class.forName(dirver);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	 
	 }
	/**
	 * 2017-04-13 08:21:38
	 * @param sql
	 * 获取传输器
	 */
	public static PreparedStatement  getPrepareStatement(String sql) {
		Connection connection = getConnection();
		try {
			PreparedStatement st = connection.prepareStatement(sql);
			return st;
		} catch (SQLException e) {
			e.printStackTrace();
			throw new RuntimeException();
		}
	}
	/**
	 * 2017-04-13 08:07:42
	 * 
	 */
		public static Connection getConnection(){
			try {
				Connection conn = DriverManager.getConnection(url, username, password);
				return conn;
			} catch (SQLException e) {
				e.printStackTrace();
				throw new RuntimeException(e);
			}
		}
  
		/**
		 * 2017-04-13 08:11:33
		 * @param conn
		 * @param stmt
		 * 关闭资源
		 */
		public static void close(Connection conn,Statement stmt){
			if(stmt!=null){
				try {
					stmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
					throw new RuntimeException(e);
				}
			}
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
					throw new RuntimeException(e);
				}
			}
		}
		
		public static void close(Connection conn,Statement stmt,ResultSet rs){
			if(rs!=null)
				try {
					rs.close();
				} catch (SQLException e1) {
					e1.printStackTrace();
					throw new RuntimeException(e1);
				}
			if(stmt!=null){
				try {
					stmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
					throw new RuntimeException(e);
				}
			}
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
					throw new RuntimeException(e);
				}
			}
		}
}