JDBC包装类

package com.qf.utils;import java.io.File;import java.io.FileNotFoundException;import java.io.FileReader;import java.io.IOException;import java.io.InputStream;import java.io.InputStreamReader;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.Properties;public class JDBCUtil {private static String driverClass;private static String url;private static String user;private static String password;static {Properties p = new Properties();try {InputStream in = JDBCUtil.class.getResourceAsStream("/db.properties");p.load(in);driverClass = p.getProperty("driverClass");// System.out.println(driverClass);url = p.getProperty("url");user = p.getProperty("user");password = p.getProperty("password");Class.forName(driverClass);} catch (IOException | ClassNotFoundException e) {// TODOe.printStackTrace();}}@SuppressWarnings("finally")public static Connection getconnetion() {Connection conn = null;try {conn = DriverManager.getConnection(url, user, password);} catch (SQLException e) {// TODOe.printStackTrace();} finally {return conn;}}public static void close(Connection conn, PreparedStatement pstat, ResultSet rs) {try {if (rs != null) {rs.close();}if (pstat != null) {pstat.close();}if (conn != null) {conn.close();}} catch (SQLException e) {// TODOe.printStackTrace();}}public static void close(Connection conn, PreparedStatement pstat) {try {if (pstat != null) {pstat.close();}if (conn != null) {conn.close();}} catch (SQLException e) {// TODOe.printStackTrace();}}}