public class JDBCUtil {

private static  String driverClass;

private static  String url;

private static  String username;

private static  String password;

private JDBCUtil() {}

static {

//读取配置文件,并完成连接字符串

Properties p = new Properties();

try {

p.load(JDBCUtil.class.getResourceAsStream("JDBC.properties"));

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String ip = p.getProperty("IPAdress");

String port = p.getProperty("port");

String db = p.getProperty("database");

String tz = p.getProperty("timezone");

driverClass = p.getProperty("driverClass");

url = "jdbc:mysql://"+ip+":"+port+"/"+db+"?useUnicode=true&characterEncoding=utf-8&serverTimezone="+tz;

username = p.getProperty("username");

password = p.getProperty("password");

try {

Class.forName(driverClass);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static Connection getConnection() {

Connection conn = null;

try {

conn = DriverManager.getConnection(url, username, password);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

public static void close(Connection conn, Statement pst, ResultSet rs) {

if(rs != null) {

try {

rs.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

rs = null;

}

if(pst != null) {

try {

pst.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

pst = null;

}

if(conn != null) {

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

conn = null;

}

}

public static void close(Connection conn, Statement pst) {

close(conn, pst, null);          

}

public static void close(Connection conn) {

close(conn, null, null);

}

public static void close(Statement pst, ResultSet rs) {

close(null, pst, rs);

}