@Override public PreparedStatement createPreparedStatement(Connection conn) throws SQLException { StringBuilder sb = new StringBuilder(); sb.append("DELETE FROM ").append(columnsTableName); sb.append(" WHERE table_name=?"); String sql = sb.toString(); log.debug(sql); PreparedStatement ps = conn.prepareStatement(sql); sb = new StringBuilder(); int col = 1; safeSetString(sb, ps, col++, table.getTableName()); log.debug("values: " + sb.toString()); return ps; } }
@Override public PreparedStatement createPreparedStatement(Connection conn) throws SQLException { StringBuilder sb = new StringBuilder(); sb.append("DELETE FROM ").append(tablesTableName); sb.append(" WHERE table_name=?"); String sql = sb.toString(); log.debug(sql); PreparedStatement ps = conn.prepareStatement(sql); sb = new StringBuilder(); int col = 1; safeSetString(sb, ps, col++, table.getTableName()); log.debug("values: " + sb.toString()); return ps; } }
safeSetString(sb, ps, col++, schema.description); safeSetString(sb, ps, col++, schema.utype); safeSetInteger(sb, ps, col++, schema.schema_index); safeSetString(sb, ps, col++, schema.getSchemaName());
safeSetString(sb, ps, col++, table.tableType.getValue()); safeSetString(sb, ps, col++, table.description); safeSetString(sb, ps, col++, table.utype); safeSetInteger(sb, ps, col++, table.tableIndex); safeSetString(sb, ps, col++, table.getSchemaName()); safeSetString(sb, ps, col++, table.getTableName());
safeSetString(sb, ps, col++, column.description); safeSetString(sb, ps, col++, column.utype); safeSetString(sb, ps, col++, column.ucd); safeSetString(sb, ps, col++, column.unit); safeSetString(sb, ps, col++, column.getDatatype().getDatatype()); safeSetString(sb, ps, col++, column.getDatatype().arraysize); safeSetString(sb, ps, col++, column.getDatatype().xtype); safeSetBoolean(sb, ps, col++, column.principal); safeSetBoolean(sb, ps, col++, column.indexed); safeSetBoolean(sb, ps, col++, column.std); safeSetString(sb, ps, col++, column.id); safeSetInteger(sb, ps, col++, column.column_index); safeSetString(sb, ps, col++, column.getTableName()); safeSetString(sb, ps, col++, column.getColumnName()); log.debug("values: " + sb.toString());