DBUtils

 

 

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();
		}
	}
}