package deep.common;

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

/**
 * jdbc数据帮助类
 * @author DeepSleeping
 *
 */
public class DBUtil {
    
    private static String driver;
    private static String url;
    private static String userName;
    private static String userPassword;

    //获取连接
    static{    
        try {
            InputStream ins = DBUtil.class.getClassLoader().getResourceAsStream("db.properties");
            Properties prop = new Properties();
            prop.load(ins);
            
            //获取数据库连接必要数据
            driver = prop.getProperty("driver");
            url = prop.getProperty("url");
            userName = prop.getProperty("userName");
            userPassword = prop.getProperty("userPassword");
            
            System.out.println("driver = " + driver);
            System.out.println("url = " + url);
            System.out.println("userName = " + userName);
            System.out.println("userPassword = " + userPassword);
            
            //加载驱动
            Class.forName(driver);
            
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    
    /**
     * 获取连接
     * @return
     * @throws SQLException 
     */
    public static Connection getConnection() throws SQLException{
        /*用变量userName就会出错不知道为什么*/
        return DriverManager.getConnection(url,userName,userPassword);
    }
    
    /**
     * 释放连接
     */
    
    public static  void release(Connection conn,PreparedStatement ps,ResultSet rs){
        
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        if (ps != null) {
            try {
                ps.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}