package com.neusoft.hotelmanage.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class DBUtils { private static DBUtils dBUtils; private final static String url = "jdbc:oracle:thin:@localhost:1521:XE"; private final static String UserName = "scott"; private final static String PassWD = "tiger"; private DBUtils() { // 1. 加载Oracle驱动 try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (Exception e) { e.printStackTrace(); } } public static Connection getConnection() { Connection conn = null; if (dBUtils == null) { dBUtils = new DBUtils(); } try { // 2. 获得Connection conn = DriverManager .getConnection(url, UserName, PassWD); } catch (SQLException e) { e.printStackTrace(); } return conn; } public static void beginTransaction(Connection conn) { try { conn.setAutoCommit(false); } catch (SQLException e) { e.printStackTrace(); } } public static void commit(Connection conn) { try { conn.commit(); conn.setAutoCommit(true); } catch (SQLException e) { e.printStackTrace(); } } public static void rollback(Connection conn) { try { conn.rollback(); conn.setAutoCommit(true); } catch (SQLException e) { e.printStackTrace(); } } public static void closeConnection(Connection conn) { try { if (conn != null) { conn.close(); } } catch (SQLException e) { e.printStackTrace(); } } public static void closeStatement(Statement stmt) { try { if (stmt != null) { stmt.close(); } } catch (SQLException e) { e.printStackTrace(); } } }