jdbc util

青旅半醒 2021-09-14 01:38 325阅读 0赞

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);
    				}
    			}
    		}
    }