de.uhilger.baselink

Class Util

java.lang.Object

de.uhilger.baselink.Util

public class Util
extends java.lang.Object

Utility methods for the BaseLink package

Version:

1, October 31, 2014

Author:

Copyright (c) Ulrich Hilger, http://uhilger.de, Published under the terms and conditions of the GNU General Public License

Field Summary

Fields

Modifier and Type	Field and Description
static boolean	DO_INCLUDE_BLOBS
static boolean	DONT_INCLUDE_BLOBS

Constructor Summary

Constructors

Constructor and Description
Util()

Method Summary

Modifier and Type	Method and Description
java.lang.String	generateDAO(PersistenceManager pm, java.lang.String schemaName, java.lang.String tableName) Generate a database transfer object (DTO) for a table This method is kept for compatibility reasons, it maps to generateDTO.
java.lang.String	generateDTO(PersistenceManager pm, java.lang.String schemaName, java.lang.String tableName) Generate a database transfer object (DTO) for a table
java.util.List<java.util.List<java.lang.String>>	getColumns(PersistenceManager pm, java.sql.Connection c, java.lang.String schemaName, java.lang.String tableName) Get a description of the columns of a database table
java.util.List<java.util.List<java.lang.String>>	getPrimaryKeys(PersistenceManager pm, java.sql.Connection c, java.lang.String schemaName, java.lang.String tableName) Get a description of the primary keys of a database table

Methods inherited from class java.lang.Object

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

Field Detail

DO_INCLUDE_BLOBS

public static final boolean DO_INCLUDE_BLOBS

See Also:

Constant Field Values

DONT_INCLUDE_BLOBS

public static final boolean DONT_INCLUDE_BLOBS

See Also:

Constant Field Values

Constructor Detail

Util

public Util()

Method Detail

generateDTO

public java.lang.String generateDTO(PersistenceManager pm,
                                    java.lang.String schemaName,
                                    java.lang.String tableName)

Generate a database transfer object (DTO) for a table

Parameters:

pm - an object to be used for database access

schemaName - name of database schema that contains the table

tableName - name of table to create DAO for

Returns:

java source code of DTO

generateDAO

public java.lang.String generateDAO(PersistenceManager pm,
                                    java.lang.String schemaName,
                                    java.lang.String tableName)

Generate a database transfer object (DTO) for a table This method is kept for compatibility reasons, it maps to generateDTO.

Parameters:

pm - an object to be used for database access

schemaName - name of database schema that contains the table

tableName - name of table to create DAO for

Returns:

java source code of DTO

getColumns

public java.util.List<java.util.List<java.lang.String>> getColumns(PersistenceManager pm,
                                                                   java.sql.Connection c,
                                                                   java.lang.String schemaName,
                                                                   java.lang.String tableName)

Get a description of the columns of a database table

Parameters:

pm - an object to be used for database access

c - the database connection that has been opened for this action

schemaName - name of database schema that contains the table

tableName - name of table to get column descriptions for

Returns:

column description as returned by java.sql.DatabaseMetaData, transformed to a List of rows, each row being a List of Strings, each String being a field of the column description for respective table column

getPrimaryKeys

public java.util.List<java.util.List<java.lang.String>> getPrimaryKeys(PersistenceManager pm,
                                                                       java.sql.Connection c,
                                                                       java.lang.String schemaName,
                                                                       java.lang.String tableName)

Get a description of the primary keys of a database table

Parameters:

pm - an object to be used for database access

c - the database connection that has been opened for this action

schemaName - name of database schema that contains the table

tableName - name of table to get primary key descriptions for

Returns:

primary key description as returned by java.sql.DatabaseMetaData, transformed to a List of rows, each row being a List of Strings, each String being a field of the primary key description for respective table