org.javaWebGen.data.util
Class DataMapper

java.lang.Object
  org.javaWebGen.data.util.DataMapper

public class DataMapper
extends java.lang.Object

Helper object used by the code Generator classes to map db columns to java object, methods, and variables

Version:

$Revision: 1.2 $

Author:

Kevin Scott

Field Summary

static boolean

useUpCaseTableName

Constructor Summary

DataMapper()

Method Summary

static java.lang.String	formatClassName(java.lang.String name) converts Table name to a proper class name
static java.lang.String	formatMethodName(java.lang.String name) formats a name
static java.lang.String	formatVarName(java.lang.String name) formats a name
static java.util.ArrayList<java.lang.String>	getPrimaryKeys(java.sql.Connection con, java.lang.String tableName) get list of columns with a primary key
static int[]	getPrimaryType(java.util.ArrayList<java.lang.String> primaryKeys, java.lang.String[] colNames, int[] colType)
protected static java.lang.String	makeGettersSetters(java.lang.String[] cols, int[] types) gen getter and setter methods
protected static java.lang.String	makeOverloadSetters(java.lang.String[] cols, int[] types) gen setter for non String data Will convert from string input
protected static java.lang.String	makePrivateVars(java.lang.String[] cols, int[] types) gen all private vars
protected static java.lang.String	makeSetDataMethod(java.lang.String[] cols, int[] types) gen setData metod
static java.lang.String	mapGetData(java.lang.String fieldNames, java.math.BigDecimal type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.Boolean type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.Byte type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.util.Date type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.Double type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.Float type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.Integer type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.Long type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.Object type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.Short type, int position) build get data method
static java.lang.String	mapGetData(java.lang.String fieldNames, java.lang.String type, int position) generate getData method
protected static java.lang.String	mapGetDataMethod(java.lang.String[] cols, int[] types) returns GetData Method
static java.lang.String	mapInsertSQL(java.lang.String[] fieldNames, java.lang.String tableName) build insert SQL
static java.lang.String	mapLoad(java.lang.String[] fieldNames, java.lang.String tableName) build select for loadData method
static java.lang.String	mapMethod(java.lang.String fieldName, java.math.BigDecimal value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.Boolean value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.Byte value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.util.Date value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.Double value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.Float value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.Integer value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.Long value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.Object value) build getter setter for Blobs may not work!
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.Short value) build getter setter
static java.lang.String	mapMethod(java.lang.String fieldName, java.lang.String value) build getter setter
static java.lang.String	mapParm(java.lang.String fieldName, java.math.BigDecimal value) Map PARM
static java.lang.String	mapParm(java.lang.String fieldName, java.lang.Boolean value) map PARM
static java.lang.String	mapParm(java.lang.String fieldName, java.lang.Byte value) mapParm
static java.lang.String	mapParm(java.lang.String fieldName, java.util.Date value) map PARM
static java.lang.String	mapParm(java.lang.String fieldName, java.lang.Double value) mapParm
static java.lang.String	mapParm(java.lang.String fieldName, java.lang.Float value) mapParm
static java.lang.String	mapParm(java.lang.String fieldName, java.lang.Integer value) mapParm
static java.lang.String	mapParm(java.lang.String fieldName, java.lang.Object value)
static java.lang.String	mapParm(java.lang.String fieldName, java.lang.Short value) mapParm
static java.lang.String	mapParm(java.lang.String fieldName, java.lang.String value) map PARM
static java.lang.String	mapSelectSQL(java.lang.String[] fieldNames, java.lang.String tableName) build select statment
static java.lang.String	mapSetData(java.lang.String fieldNames, java.math.BigDecimal type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.Boolean type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.Byte type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.util.Date type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.Double type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.Float type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.Integer type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.Long type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.Object type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.Short type, int position) build set data method
static java.lang.String	mapSetData(java.lang.String fieldNames, java.lang.String type, int position) build get data method
static java.lang.String	mapUpdateSQL(java.lang.String[] fieldNames, java.lang.String tableName) build update sql
static java.lang.String	mapVar(java.lang.String fieldName, java.math.BigDecimal value) map vars
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.Boolean value) map vars
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.Byte value) /** map vars
static java.lang.String	mapVar(java.lang.String fieldName, java.util.Date value) map vars
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.Double value)
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.Float value)
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.Integer value) map vars
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.Long value) map vars
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.Object value) map vars
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.Short value)
static java.lang.String	mapVar(java.lang.String fieldName, java.lang.String value) map vars

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

useUpCaseTableName

public static boolean useUpCaseTableName

Constructor Detail

DataMapper

public DataMapper()

Method Detail

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.Integer value)

map vars

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.Long value)

map vars

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.Byte value)

/** map vars

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.Short value)

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.Float value)

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.Double value)

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.String value)

map vars

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.util.Date value)

map vars

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.Boolean value)

map vars

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.lang.Object value)

map vars

mapVar

public static java.lang.String mapVar(java.lang.String fieldName,
                                      java.math.BigDecimal value)

map vars

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.lang.Integer value)

mapParm

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.lang.Short value)

mapParm

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.lang.Byte value)

mapParm

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.lang.Float value)

mapParm

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.lang.Double value)

mapParm

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.lang.Object value)

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.lang.String value)

map PARM

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.util.Date value)

map PARM

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.lang.Boolean value)

map PARM

mapParm

public static java.lang.String mapParm(java.lang.String fieldName,
                                       java.math.BigDecimal value)

Map PARM

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.Integer value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.Short value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.Byte value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.Float value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.Long value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.String value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.util.Date value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.Boolean value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.math.BigDecimal value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.Double value)

build getter setter

mapMethod

public static java.lang.String mapMethod(java.lang.String fieldName,
                                         java.lang.Object value)

build getter setter for Blobs may not work!

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.String type,
                                          int position)

generate getData method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.Integer type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.Short type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.Byte type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.Float type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.Long type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.Boolean type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.math.BigDecimal type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.Double type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.util.Date type,
                                          int position)

build get data method

mapGetData

public static java.lang.String mapGetData(java.lang.String fieldNames,
                                          java.lang.Object type,
                                          int position)

build get data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.String type,
                                          int position)

build get data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.Integer type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.Long type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.Byte type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.Short type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.Float type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.Double type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.math.BigDecimal type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.Boolean type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.util.Date type,
                                          int position)

build set data method

mapSetData

public static java.lang.String mapSetData(java.lang.String fieldNames,
                                          java.lang.Object type,
                                          int position)

build set data method

mapInsertSQL

public static java.lang.String mapInsertSQL(java.lang.String[] fieldNames,
                                            java.lang.String tableName)

build insert SQL

mapUpdateSQL

public static java.lang.String mapUpdateSQL(java.lang.String[] fieldNames,
                                            java.lang.String tableName)

build update sql

mapSelectSQL

public static java.lang.String mapSelectSQL(java.lang.String[] fieldNames,
                                            java.lang.String tableName)

build select statment

mapLoad

public static java.lang.String mapLoad(java.lang.String[] fieldNames,
                                       java.lang.String tableName)

build select for loadData method

formatVarName

public static java.lang.String formatVarName(java.lang.String name)

formats a name

formatMethodName

public static java.lang.String formatMethodName(java.lang.String name)

formats a name

formatClassName

public static java.lang.String formatClassName(java.lang.String name)

converts Table name to a proper class name

getPrimaryKeys

public static java.util.ArrayList<java.lang.String> getPrimaryKeys(java.sql.Connection con,
                                                                   java.lang.String tableName)
                                                            throws java.sql.SQLException

get list of columns with a primary key

Parameters:

con -

tableName -

Returns:

list of primary keys

Throws:

java.sql.SQLException

getPrimaryType

public static int[] getPrimaryType(java.util.ArrayList<java.lang.String> primaryKeys,
                                   java.lang.String[] colNames,
                                   int[] colType)
                            throws DBException

Throws:

DBException

makePrivateVars

protected static java.lang.String makePrivateVars(java.lang.String[] cols,
                                                  int[] types)
                                           throws java.lang.Exception

gen all private vars

Throws:

java.lang.Exception

mapGetDataMethod

protected static java.lang.String mapGetDataMethod(java.lang.String[] cols,
                                                   int[] types)

returns GetData Method

Parameters:

cols - names

types -

Returns:

get data text

makeSetDataMethod

protected static java.lang.String makeSetDataMethod(java.lang.String[] cols,
                                                    int[] types)

gen setData metod

makeOverloadSetters

protected static java.lang.String makeOverloadSetters(java.lang.String[] cols,
                                                      int[] types)
                                               throws java.lang.Exception

gen setter for non String data Will convert from string input

Throws:

java.lang.Exception

makeGettersSetters

protected static java.lang.String makeGettersSetters(java.lang.String[] cols,
                                                     int[] types)
                                              throws java.lang.Exception

gen getter and setter methods

Throws:

java.lang.Exception