dbinitial.java

一个完整的XACML工程,学习XACML技术的好例子!

/*
* Copyright (c) 2006, University of Kent
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without 
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this 
* list of conditions and the following disclaimer.
* 
* Redistributions in binary form must reproduce the above copyright notice, 
* this list of conditions and the following disclaimer in the documentation 
* and/or other materials provided with the distribution. 
*
* 1. Neither the name of the University of Kent nor the names of its 
* contributors may be used to endorse or promote products derived from this 
* software without specific prior written permission. 
*
* 2. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS  
* IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
* THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR 
* PURPOSE ARE DISCLAIMED. 
*
* 3. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE 
* LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 
* POSSIBILITY OF SUCH DAMAGE.
*
* 4. YOU AGREE THAT THE EXCLUSIONS IN PARAGRAPHS 2 AND 3 ABOVE ARE REASONABLE
* IN THE CIRCUMSTANCES.  IN PARTICULAR, YOU ACKNOWLEDGE (1) THAT THIS
* SOFTWARE HAS BEEN MADE AVAILABLE TO YOU FREE OF CHARGE, (2) THAT THIS
* SOFTWARE IS NOT "PRODUCT" QUALITY, BUT HAS BEEN PRODUCED BY A RESEARCH
* GROUP WHO DESIRE TO MAKE THIS SOFTWARE FREELY AVAILABLE TO PEOPLE WHO WISH
* TO USE IT, AND (3) THAT BECAUSE THIS SOFTWARE IS NOT OF "PRODUCT" QUALITY
* IT IS INEVITABLE THAT THERE WILL BE BUGS AND ERRORS, AND POSSIBLY MORE
* SERIOUS FAULTS, IN THIS SOFTWARE.
*
* 5. This license is governed, except to the extent that local laws
* necessarily apply, by the laws of England and Wales.
*/
/*
 * Created on 11-Apr-2005
 *
 * TODO All
 */
package uk.ac.kent.dpa.mysql.init;

import ke.files.*;
import java.util.Properties;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import ke.defaultimpl.utils.*;
import ke.defaultimpl.utils.Utils;

//import java.util.Properties;

/**
 * @author Linying Su James Cunningham 
 * 
 * @version
 *
 * TODO All
 */

public class DbInitial
{

    /**
     * param@ database configuration file
     */
    public DbInitial(String nameIn) throws DatabaseException
    {
        super();
        Config config = new Config();
        try {
            this.initDbConnectionPool(config.getURL(nameIn));
            this.connection = this.dbConnectionPool.getConnection();
            this.statement = this.connection.createStatement();
        } catch (ConfigException ce) {
            throw new DatabaseException("invalid DB configuration file name:"+ce);
        } catch (SQLException se) {
            throw new DatabaseException("MySQL DB cannot be initialised:"+se);
        }
        this.configName = nameIn;
    }
    
    public DbInitial(String nameIn, String dbURL) throws DatabaseException
    {
        super();
        Config config = new Config();
        try {
            this.initDbConnectionPool(config.getURL(nameIn),dbURL);
            this.connection = this.dbConnectionPool.getConnection();
            this.statement = this.connection.createStatement();
        } catch (ConfigException ce) {
            throw new DatabaseException("invalid DB configuration file name:"+ce);
        } catch (SQLException se) {
            throw new DatabaseException("MySQL DB cannot be initialised:"+se);
        }
        this.configName = nameIn;
    }
    
    private void initDbConnectionPool(String url) throws DatabaseException{
        if(this.dbConnectionPool == null) {
            Properties props = new DbUtils().getDbProperties(url);
            this.dbConnectionPool = new DbConnectionPool().getInstance(props.getProperty("dbDriverName"),
                                                                props.getProperty("dbDriverPrefix"),
                                                                props.getProperty("dbURL"),
                                                                props.getProperty("dbUserName"),
                                                                props.getProperty("dbPassWd"),
                                                                (byte)0,
                                                                false,
                                                                3);
        }
    }

    private void initDbConnectionPool(String url,String dbURL) throws DatabaseException{
        if(this.dbConnectionPool == null) {
            Properties props = new DbUtils().getDbProperties(url);
            this.dbConnectionPool = new DbConnectionPool().getInstance(props.getProperty("dbDriverName"),
                                                                props.getProperty("dbDriverPrefix"),
                                                                dbURL,
                                                                props.getProperty("dbUserName"),
                                                                props.getProperty("dbPassWd"),
                                                                (byte)0,
                                                                false,
                                                                3);
        }
    }
    
    public Statement getConnection() {
        return this.statement;
    }

    public Connection getDB() {
        return this.connection;
    }
    
    public DbConnectionPool getPool() {
        return this.dbConnectionPool;
    }
    
    private Statement statement;
    private String configName;
    private DbConnectionPool dbConnectionPool = null;
    private Connection connection = null;
}