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) {


// TODO
e.printStackTrace();


}
}


@SuppressWarnings("finally")
public static Connection getconnetion() {
Connection conn = null;
try {
conn = DriverManager.getConnection(url, user, password);
} catch (SQLException e) {


// TODO
e.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) {


// TODO
e.printStackTrace();


}


}


public static void close(Connection conn, PreparedStatement pstat) {


try {


if (pstat != null) {
pstat.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {


// TODO
e.printStackTrace();


}


}
}