org.b3log.latke.repository.oracle

Class OracleJdbcDatabaseSolution

java.lang.Object

org.b3log.latke.repository.jdbc.AbstractJdbcDatabaseSolution

org.b3log.latke.repository.oracle.OracleJdbcDatabaseSolution

All Implemented Interfaces:

JdbcDatabase

public class OracleJdbcDatabaseSolution
extends AbstractJdbcDatabaseSolution

Oracle database solution.

Since:

2.3.18

Version:

2.0.0.0, Mar 15, 2018

Author:

Liang Ding

Constructor Summary

Constructors

Constructor and Description
OracleJdbcDatabaseSolution() Public constructor.

Method Summary

Modifier and Type	Method and Description
void	clearTableSql(StringBuilder clearTableSq, String tableName, boolean ifdrop)
protected void	createDropTableSql(StringBuilder dropTableSql, String tableName)
private String	createKeyDefinition(List<FieldDefinition> keyDefinitionList) the keyDefinitionList tableSql.
protected void	createTableBody(StringBuilder createTableSql, RepositoryDefinition repositoryDefinition)
protected void	createTableEnd(StringBuilder createTableSql, RepositoryDefinition repositoryDefinition)
protected void	createTableHead(StringBuilder createTableSql, RepositoryDefinition repositoryDefinition)
String	getRandomlySql(String tableName, int fetchSize)
String	queryPage(int start, int end, String selectSql, String filterSql, String orderBySql, String tableName)

Methods inherited from class org.b3log.latke.repository.jdbc.AbstractJdbcDatabaseSolution

clearTable, createTable, getJdbcTypeMapping, registerType

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleJdbcDatabaseSolution

public OracleJdbcDatabaseSolution()

Public constructor.

Method Detail

queryPage

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

getRandomlySql

public String getRandomlySql(String tableName,
                             int fetchSize)

createDropTableSql

protected void createDropTableSql(StringBuilder dropTableSql,
                                  String tableName)

Specified by:

createDropTableSql in class AbstractJdbcDatabaseSolution

createTableHead

protected void createTableHead(StringBuilder createTableSql,
                               RepositoryDefinition repositoryDefinition)

Specified by:

createTableHead in class AbstractJdbcDatabaseSolution

createTableBody

protected void createTableBody(StringBuilder createTableSql,
                               RepositoryDefinition repositoryDefinition)

Specified by:

createTableBody in class AbstractJdbcDatabaseSolution

createKeyDefinition

private String createKeyDefinition(List<FieldDefinition> keyDefinitionList)

the keyDefinitionList tableSql.

Parameters:

keyDefinitionList - keyDefinitionList

Returns:

createKeyDefinitionsql

createTableEnd

protected void createTableEnd(StringBuilder createTableSql,
                              RepositoryDefinition repositoryDefinition)

Specified by:

createTableEnd in class AbstractJdbcDatabaseSolution

clearTableSql

public void clearTableSql(StringBuilder clearTableSq,
                          String tableName,
                          boolean ifdrop)

Specified by:

clearTableSql in class AbstractJdbcDatabaseSolution