DBUtil.java

Go to the documentation of this file.

package cedar.jetweb.db;

import java.sql.*;
import cedar.jetweb.JetWebException;

import java.lang.reflect.*;
import java.util.Vector;
import java.util.HashMap;

public abstract class DBUtil{

    private static HashMap<String, HashMap<String, Vector<Method> > >
        availableMethodsMap_ = 
        new HashMap<String, HashMap<String, Vector<Method> > >();

    public static Vector<Method> availableMethods(Object obj, String prefix){

    if(obj==null) return new Vector<Method>(0);

        Vector<Method> methods;
        HashMap<String, Vector<Method> > foundMethods = 
            availableMethodsMap_.get(obj.getClass().toString());
        
        boolean findMethods = false;
        boolean foundObject = false;
        
        if(foundMethods==null){
            findMethods = true;
        }else if(!foundMethods.containsKey(prefix)){
            findMethods = true;
            foundObject = true;
        }else{
        
            methods = foundMethods.get(prefix);
            return(methods);
        }
    
    methods = new Vector<Method>();
    
        if(findMethods){
            Class objClass = obj.getClass();
            Method[] objMethods = objClass.getMethods();
            for(int ii=0; ii!= objMethods.length; ++ii){
                if(objMethods[ii].
                   getName().
                   substring(0,prefix.length()).
                   equals(prefix)){
                    methods.add(objMethods[ii]);
                }
            }
            
            if(!foundObject){
                foundMethods = new HashMap<String, Vector<Method> >();
            }
        
            foundMethods.put(prefix, methods);
        }
    
        availableMethodsMap_.put(obj.getClass().toString(), foundMethods);
        
        return(methods);
    }


    public static Integer getNextIndex(String col, String table)
    throws JetWebException{

    String select = "SELECT MAX(" + col + ") FROM " + table;

    Integer index = 1;

    try{
        Statement stmt = DBConfig.getConnection().createStatement();
        ResultSet rs = stmt.executeQuery(select);
            
        if(rs!=null && rs.next()){
        index = rs.getInt(1);
        ++index;
        }
    }catch(SQLException err){
        throw new JetWebException(err);
    }
    return index;
    }

    public static String unCamelMe(String input){

    String word = input;

        for(int ii=0; ii< word.length()-1; ++ii){
            char letter = word.charAt(ii);
            if(Character.isUpperCase(letter)){
                String decapitalised = new String();
                decapitalised += Character.toLowerCase(letter);
                if(ii!=0) decapitalised = "_"+decapitalised;
                word = word.substring(0,ii) + 
                    decapitalised+ 
                    word.substring(ii+1);

            }
        }
        return(word);
    }

}

Generated Wed Jan 17 09:14:27 GMT 2007