DBUtils

来源：互联网发布：显示自己是阿里云的ip 编辑：程序博客网时间：2024/05/01 19:07
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();}}}