1031 封装connection和close

package com.company;

import java.sql.*;

/**
 * Created by ttc on 16-10-31.
 */
public class DbUtils
{
    //连接url
    public static String strUrl= "jdbc:oracle:thin:@localhost:1521:orcl";
    static {
        //加载驱动
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        }

    }

    public static Connection GetConnection() throws ClassNotFoundException, SQLException
    {


        //获取数据库连接
        Connection con= DriverManager.getConnection(strUrl,"scott","tiger");

        return con;
    }

    public  static void Close(Connection con,Statement st) throws SQLException
    {
        st.close();
        con.close();
    }
    public  static void CloseEx(Connection con,Statement st,ResultSet rs) throws SQLException
    {
        Close(con,st);
        rs.close();
    }
}