JDBC连接数据库(Sql Server 2008)

JDBC连接Sql Server 2008：

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.sql.Statement;
import java.util.Properties;

public class JDBCUtils {

    private static Properties properties;// 用于读取配置文件对象；
    static {
        properties = new Properties();
        try (InputStream is = JDBCUtils.class
                .getResourceAsStream("/CdcIfsDb.properties");) {// 获取输入流
            properties.load(is);// 加载
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    //获得数据库连接；
    public static Connection getConnection() {
        Connection conn = null;
        String sql = null;
        ResultSet rs = null;
        PreparedStatement pst = null;
        String DBDRIVER = properties.getProperty("driver");
        String DBURL = properties.getProperty("DBURL");
        String DBUSER = properties.getProperty("DBUSER");
        String DBPASSWORD = properties.getProperty("DBPASSWORD");
        try {
            Class.forName(DBDRIVER);
            conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
            if (conn != null) {
                return conn;
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    //关闭连接(没有打开的参数为null)；
    public void closeAll(Connection conn, Statement st, ResultSet rs) {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (st != null) {
            try {
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}