jdbc 简单工具类的使用
package Jdbcday02;import java.io.IOException;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 ConnectionUtils {private static String url;private static String driver;private static String username;private static String password;static {Properties props = new Properties();try {props.load(ConnectionUtils.class.getClassLoader().getResourceAsStream("Jdbcday02/db_oracle.properties"));} catch (IOException e) {}if (props != null) {url = props.getProperty("url");driver = props.getProperty("driver");username = props.getProperty("username");password = props.getProperty("password");try {Class.forName(driver);} catch (ClassNotFoundException e) {}}}public static Connection openConnection() throws SQLException {return DriverManager.getConnection(url, username, password);}public static void closeConnection(Connection con) {try {if (con != null) {con.close();}} catch (SQLException e) {}}public static void closeStatement(Statement stmt) {try {if (stmt != null) {stmt.close();}} catch (SQLException e) {}}public static void closeStatement(PreparedStatement pstmt) {try {if (pstmt != null) {pstmt.close();}} catch (SQLException e) {}}public static void closeResultSet(ResultSet rs) {try {if (rs != null) {rs.close();}} catch (SQLException e) {}}}