001: /*
002: * ====================================================================
003: *
004: * XFLOW - Process Management System
005: * Copyright (C) 2003 Rob Tan
006: * All rights reserved.
007: *
008: * Redistribution and use in source and binary forms, with or without
009: * modification, are permitted provided that the following conditions
010: * are met:
011: *
012: * 1. Redistributions of source code must retain the above copyright
013: * notice, this list of conditions, and the following disclaimer.
014: *
015: * 2. Redistributions in binary form must reproduce the above copyright
016: * notice, this list of conditions, and the disclaimer that follows
017: * these conditions in the documentation and/or other materials
018: * provided with the distribution.
019: *
020: * 3. The name "XFlow" must not be used to endorse or promote products
021: * derived from this software without prior written permission. For
022: * written permission, please contact rcktan@yahoo.com
023: *
024: * 4. Products derived from this software may not be called "XFlow", nor
025: * may "XFlow" appear in their name, without prior written permission
026: * from the XFlow Project Management (rcktan@yahoo.com)
027: *
028: * In addition, we request (but do not require) that you include in the
029: * end-user documentation provided with the redistribution and/or in the
030: * software itself an acknowledgement equivalent to the following:
031: * "This product includes software developed by the
032: * XFlow Project (http://xflow.sourceforge.net/)."
033: * Alternatively, the acknowledgment may be graphical using the logos
034: * available at http://xflow.sourceforge.net/
035: *
036: * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
037: * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
038: * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
039: * DISCLAIMED. IN NO EVENT SHALL THE XFLOW AUTHORS OR THE PROJECT
040: * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
041: * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
042: * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
043: * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
044: * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
045: * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
046: * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
047: * SUCH DAMAGE.
048: *
049: * ====================================================================
050: * This software consists of voluntary contributions made by many
051: * individuals on behalf of the XFlow Project and was originally
052: * created by Rob Tan (rcktan@yahoo.com)
053: * For more information on the XFlow Project, please see:
054: * <http://xflow.sourceforge.net/>.
055: * ====================================================================
056: */
057: package xflow.util;
058:
059: import java.sql.*;
060: import java.util.*;
061:
062: public class Db {
063:
064: public static ConnectionPool connectionPool;
065: public static String user = null;
066: public static String password = null;
067: public static String driver = null;
068: public static String dbURL = null;
069:
070: public static void init(Properties prop) {
071:
072: user = prop.getProperty("DBUSER");
073: password = prop.getProperty("DBPASSWORD");
074: driver = prop.getProperty("DBDRIVER");
075: dbURL = prop.getProperty("DBURL");
076: }
077:
078: public static Connection getConnection() {
079:
080: if (connectionPool == null) {
081:
082: if (user == null) {
083: System.err.println("DBUSER property not defined.");
084: return null;
085: }
086: if (driver == null) {
087: System.err.println("DBDRIVER property not defined.");
088: return null;
089: }
090: if (password == null) {
091: System.err.println("DBPASSWORD property not defined.");
092: return null;
093: }
094: if (dbURL == null) {
095: System.err.println("DBURL property not defined.");
096: return null;
097: }
098:
099: try {
100: connectionPool = new ConnectionPool(driver, user,
101: password, dbURL);
102: } catch (Exception e) {
103: e.printStackTrace();
104: System.err.println("Failed to create Connection Pool");
105: }
106: }
107:
108: try {
109: Connection con = connectionPool.getConnection();
110: return con;
111: } catch (Exception e) {
112: e.printStackTrace();
113: return null;
114: }
115:
116: }
117:
118: public static void returnConnection(Connection con) {
119: connectionPool.returnConnection(con);
120: }
121:
122: }
|