org.b3log.latke.repository.jdbc

Interface JdbcDatabase

All Known Implementing Classes:

AbstractJdbcDatabaseSolution, JdbcFactory

public interface JdbcDatabase

interface JdbcDatabase.

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.
String	getRandomlySql(String tableName, int fetchSize) getRandomlySql.
String	queryPage(int start, int end, String selectSql, String filterSql, String orderBySql, String tableName) queryPage sql.

Method Detail

existTable

boolean existTable(String tableName)

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

Parameters:

tableName - the given table name

Returns:

true if it exists, returns false otherwise

Since:

2.4.43

createTable

boolean createTable(RepositoryDefinition repositoryDefinition)
             throws SQLException

Creates table with the specified repository definition.

Parameters:

repositoryDefinition - the specified repository definition

Returns:

true if successfully, returns false otherwise

Throws:

SQLException - SQLException

queryPage

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

queryPage sql.

Parameters:

start - start

end - end

selectSql - selectSql

filterSql - filterSql

orderBySql - orderBySql

tableName - tableName

Returns:

sql

getRandomlySql

String getRandomlySql(String tableName,
                      int fetchSize)

getRandomlySql.

Parameters:

tableName - tableName

fetchSize - fetchSize

Returns:

sql sql