Overview

Package

Class

Use

Tree

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.orange.util.integration
Class JDBCDAO

Direct Known Subclasses:: AbilityJDBCDAO, OwnerJDBCDAO, EmployeeJDBCDAO, RelationshipTypeJDBCDAO, SkillJDBCDAO, Populate.ArianeDAOImpl

public abstract class JDBCDAO

Common JDBC Data Access Objects (DAOs) ancestor.

Every DAO subclassing this class can ask for a connection through the getConnection() method.
The mechanism to obtain connections depends on the value of the CONNECTION_FACTORY_CLASS_NAME key in the class' Preferences :

org.orange.util.integration.DriverJDBCConnectionFactory to get connections from the DriverManager

org.orange.util.integration.J2EEJDBCConnectionFactory to get connections from a J2EE, JNDI-published DataSource

org.orange.util.integration.StrutsJDBCConnectionFactory to get connections from a Struts DataSourceli>

This class aussi contains various String CONSTANTS useful to build SQL queries (avoid mistyping in queries).

Author:: Jérôme Beau
Version: 0.2

Field Summary
`final static String`	`AND`
`final static String`	`CONNECTION_FACTORY_CLASS_NAME`
`final static String`	`CONNECTION_FACTORY_CLASS_NAME_DEFAULT`
`final static String`	`DELETE_FROM`
`final static String`	`DISTINCT`
`final static String`	`EQUAL_PARAMETER`
`final static String`	`FROM`
`final static String`	`IN`
`final static String`	`INSERT_INTO`
`final static String`	`LIKE`
`final static String`	`NOT`
`final static String`	`OR`
`final static String`	`ORDER_BY`
`final static String`	`SELECT`
`final static String`	`SET`
`final static String`	`UPDATE`
`final static String`	`VALUES`
`final static String`	`WHERE`

Method Summary
`Connection`	`getConnection()` Return a connection from the connection factory

Field Detail

AND

public final static String AND

CONNECTION_FACTORY_CLASS_NAME

public final static String CONNECTION_FACTORY_CLASS_NAME

CONNECTION_FACTORY_CLASS_NAME_DEFAULT

public final static String CONNECTION_FACTORY_CLASS_NAME_DEFAULT

DELETE_FROM

public final static String DELETE_FROM

DISTINCT

public final static String DISTINCT

EQUAL_PARAMETER

public final static String EQUAL_PARAMETER

FROM

public final static String FROM

IN

public final static String IN

INSERT_INTO

public final static String INSERT_INTO

LIKE

public final static String LIKE

NOT

public final static String NOT

OR

public final static String OR

ORDER_BY

public final static String ORDER_BY

SELECT

public final static String SELECT

SET

public final static String SET

UPDATE

public final static String UPDATE

VALUES

public final static String VALUES

WHERE

public final static String WHERE

Method Detail

getConnection

public Connection getConnection()
                          throws java.sql.SQLException

Return a connection from the connection factory

Association Links

to Class java.lang.String

to Class java.lang.String

to Class org.orange.util.integration.JDBCConnectionFactory

Supplier Qualifier Connection factory

Dependency Links

to Class java.lang.String

to Class java.lang.Class

to Class org.orange.util.integration.DriverJDBCConnectionFactory

to Class org.orange.util.integration.DAOException

to Class org.orange.util.Preferences

to Class java.lang.reflect.Constructor