/** * queryJsonObject. * * @param sql sql * @param paramList paramList * @param connection connection * @param tableName tableName * @param isDebug the specified debug flag * @return JSONObject only one record. * @throws SQLException SQLException * @throws JSONException JSONException * @throws RepositoryException repositoryException */ public static JSONObject queryJsonObject(final String sql, final List<Object> paramList, final Connection connection, final String tableName, final boolean isDebug) throws SQLException, JSONException, RepositoryException { return queryJson(sql, paramList, connection, true, tableName, isDebug); }
/** * Gets keys of the repository specified by the given repository name. * * @param repositoryName the given repository name * @return keys */ public static List<FieldDefinition> getKeys(final String repositoryName) { final List<RepositoryDefinition> repositoryDefs = getRepositoryDefinitions(); for (final RepositoryDefinition repositoryDefinition : repositoryDefs) { if (StringUtils.equals(repositoryName, repositoryDefinition.getName())) { return repositoryDefinition.getKeys(); } } return null; }
/** * Public constructor. * * @throws SQLException SQLException */ public JdbcTransaction() throws SQLException { connection = Connections.getConnection(); connection.setAutoCommit(false); isActive = true; }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder builder = new StringBuilder(definition.getName()).append(" bigint"); if (!definition.getNullable()) { builder.append(" not null"); } return builder.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" nvarchar(").append(definition.getLength()).append(')'); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override protected void createTableHead(final StringBuilder createTableSql, final RepositoryDefinition repositoryDefinition) { /* IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[tablename]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) CREATE TABLE [dbo].[tablename] ( columns specification ); */ createTableSql.append("IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[").append( repositoryDefinition.getName()).append("]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) "); }
@Override public boolean clearTable(final String tableName, final boolean ifdrop) throws SQLException { final Connection connection = Connections.getConnection(); try { final StringBuilder clearTableSql = new StringBuilder(); clearTableSql(clearTableSql, tableName, ifdrop); return JdbcUtil.executeSql(clearTableSql.toString(), connection, false); } catch (final SQLException e) { throw e; } finally { connection.close(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder builder = new StringBuilder(definition.getName()).append(" datetime"); if (!definition.getNullable()) { builder.append(" not null"); } return builder.toString(); } }
@Override protected void createTableHead(final StringBuilder createTableSql, final RepositoryDefinition repositoryDefinition) { createTableSql.append("CREATE TABLE IF NOT EXISTS ").append(repositoryDefinition.getName()).append("("); }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" char(1)"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override protected void createTableHead(final StringBuilder createTableSql, final RepositoryDefinition repositoryDefinition) { createTableSql.append("CREATE TABLE ").append(repositoryDefinition.getName()).append("("); }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" datetime"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override protected void createTableHead(final StringBuilder createTableSql, final RepositoryDefinition repositoryDefinition) { createTableSql.append("CREATE TABLE IF NOT EXISTS ").append(repositoryDefinition.getName()).append("("); }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" date"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" date"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" decimal(20,0)"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" boolean"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" double "); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" int"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); }
@Override public String toDataBaseSting(final FieldDefinition definition) { final StringBuilder sql = new StringBuilder(); sql.append(definition.getName()); sql.append(" datetime"); if (!definition.getNullable()) { sql.append(" not null"); } return sql.toString(); } }