org.b3log.latke.repository.jdbc

Class JdbcFactory

java.lang.Object

org.b3log.latke.repository.jdbc.JdbcFactory

All Implemented Interfaces:

JdbcDatabase

public final class JdbcFactory
extends Object
implements JdbcDatabase

JDBC Factory.

Version:

2.0.0.1, Feb 21, 2019

Author:

Love Yao, Liang Ding

Method Summary

Modifier and Type	Method and Description
boolean	createTable(RepositoryDefinition repositoryDefinition) Creates table with the specified repository definition.
boolean	existTable(String tableName) Checks whether a table specified by the given table name exists.
static JdbcFactory	getInstance() Gets the singleton instance of JdbcFactory.
String	getRandomlySql(String tableName, int fetchSize) getRandomlySql.
String	queryPage(int start, int end, String selectSql, String filterSql, String orderBySql, String tableName) queryPage sql.

Methods inherited from class java.lang.Object

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

Method Detail

existTable

public boolean existTable(String tableName)

Description copied from interface: JdbcDatabase

Checks whether a table specified by the given table name exists.

Specified by:

existTable in interface JdbcDatabase

Parameters:

tableName - the given table name

Returns:

true if it exists, returns false otherwise

createTable

public boolean createTable(RepositoryDefinition repositoryDefinition)
                    throws SQLException

Description copied from interface: JdbcDatabase

Creates table with the specified repository definition.

Specified by:

createTable in interface JdbcDatabase

Parameters:

repositoryDefinition - the specified repository definition

Returns:

true if successfully, returns false otherwise

Throws:

SQLException - SQLException

getInstance

public static JdbcFactory getInstance()

Gets the singleton instance of JdbcFactory.

Returns:

JdbcFactory singleton instance

queryPage

public String queryPage(int start,
                        int end,
                        String selectSql,
                        String filterSql,
                        String orderBySql,
                        String tableName)

Description copied from interface: JdbcDatabase

queryPage sql.

Specified by:

queryPage in interface JdbcDatabase

Parameters:

start - start

end - end

selectSql - selectSql

filterSql - filterSql

orderBySql - orderBySql

tableName - tableName

Returns:

sql

getRandomlySql

public String getRandomlySql(String tableName,
                             int fetchSize)

Description copied from interface: JdbcDatabase

getRandomlySql.

Specified by:

getRandomlySql in interface JdbcDatabase

Parameters:

tableName - tableName

fetchSize - fetchSize

Returns:

sql sql