Package org.conical.common.bbl.db.querier

Class MySqlQuerier

java.lang.Object

org.conical.common.bbl.db.querier.Querier

org.conical.common.bbl.db.querier.MySqlQuerier

public class MySqlQuerier
extends Querier

Implementation of Querier for MySQL databases.

Author:

rdoherty

Constructor Summary

Constructors

Constructor	Description
MySqlQuerier(DataSourceReference dbInfo)	Creates a MySql-specific Querier using the passed data source

Method Summary

Modifier and Type	Method	Description
protected ColumnModel	getColumnModelFromResult(ResultSet rs)
protected PreparedStatement	getPsForColumnLookup(Connection conn, String tableName)
protected String	getTableSelectionSql()

Methods inherited from class org.conical.common.bbl.db.querier.Querier

assignKeyInformation, getColumnsFromTable, getConnection, getTableNames

Methods inherited from class java.lang.Object

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

Constructor Details

MySqlQuerier

public MySqlQuerier(DataSourceReference dbInfo)

Creates a MySql-specific Querier using the passed data source

Parameters:

dbInfo -

Method Details

getTableSelectionSql

protected String getTableSelectionSql()

Specified by:

getTableSelectionSql in class Querier

getPsForColumnLookup

protected PreparedStatement getPsForColumnLookup(Connection conn,
 String tableName)
                                          throws SQLException

Specified by:

getPsForColumnLookup in class Querier

Throws:

SQLException

getColumnModelFromResult

protected ColumnModel getColumnModelFromResult(ResultSet rs)
                                        throws SQLException

Specified by:

getColumnModelFromResult in class Querier

Throws:

SQLException