jdbc util

来源：互联网发布：avfun邀请码淘宝编辑：程序博客网时间：2024/05/17 07:56
package util;import java.io.IOException;import java.io.InputStream;import java.net.URL;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; /** * 2017-04-13 07:50:48 *  */public class JdbcUtil { private static String username;private static String password;private static String url;private static String dirver;static{ // 加载一次Properties properties = new Properties();InputStream inStream = JdbcUtil.class.getResourceAsStream("/jdbc.properties"); try {properties.load(inStream); username = properties.getProperty("username"); password = properties.getProperty("password"); url = properties.getProperty("url"); dirver = properties.getProperty("driver");} catch (IOException e) {e.printStackTrace();}try {Class.forName(dirver);} catch (ClassNotFoundException e) {e.printStackTrace();}  }/** * 2017-04-13 08:21:38 * @param sql * 获取传输器 */public static PreparedStatement  getPrepareStatement(String sql) {Connection connection = getConnection();try {PreparedStatement st = connection.prepareStatement(sql);return st;} catch (SQLException e) {e.printStackTrace();throw new RuntimeException();}}/** * 2017-04-13 08:07:42 *  */public static Connection getConnection(){try {Connection conn = DriverManager.getConnection(url, username, password);return conn;} catch (SQLException e) {e.printStackTrace();throw new RuntimeException(e);}}  /** * 2017-04-13 08:11:33 * @param conn * @param stmt * 关闭资源 */public static void close(Connection conn,Statement stmt){if(stmt!=null){try {stmt.close();} catch (SQLException e) {e.printStackTrace();throw new RuntimeException(e);}}if(conn!=null){try {conn.close();} catch (SQLException e) {e.printStackTrace();throw new RuntimeException(e);}}}public static void close(Connection conn,Statement stmt,ResultSet rs){if(rs!=null)try {rs.close();} catch (SQLException e1) {e1.printStackTrace();throw new RuntimeException(e1);}if(stmt!=null){try {stmt.close();} catch (SQLException e) {e.printStackTrace();throw new RuntimeException(e);}}if(conn!=null){try {conn.close();} catch (SQLException e) {e.printStackTrace();throw new RuntimeException(e);}}}}
阅读全文
0 0