/** * Create a column from a DatabaseMetaData.getColumns row. * * @param contents the database contents * @param rs the result set * @return the column */ public static DbColumn getColumn(DbContents contents, ResultSet rs) throws SQLException { return new DbColumn(contents, rs, false); }
/** * Read the column for this table from the database meta data. * * @param meta the database meta data */ public void readColumns(DatabaseMetaData meta) throws SQLException { ResultSet rs = meta.getColumns(null, schema.name, name, null); ArrayList<DbColumn> list = New.arrayList(); while (rs.next()) { DbColumn column = DbColumn.getColumn(schema.getContents(), rs); list.add(column); } rs.close(); columns = list.toArray(new DbColumn[0]); }
private static int addColumns(boolean mainSchema, DbTableOrView table, StringBuilder buff, int treeIndex, boolean showColumnTypes, StringBuilder columnsBuffer) { DbColumn[] columns = table.getColumns(); for (int i = 0; columns != null && i < columns.length; i++) { DbColumn column = columns[i]; if (columnsBuffer.length() > 0) { columnsBuffer.append(' '); } columnsBuffer.append(column.getName()); String col = escapeIdentifier(column.getName()); String level = mainSchema ? ", 1, 1" : ", 2, 2"; buff.append("setNode(").append(treeIndex).append(level) .append(", 'column', '") .append(PageParser.escapeJavaScript(column.getName())) .append("', 'javascript:ins(\\'").append(col).append("\\')');\n"); treeIndex++; if (mainSchema && showColumnTypes) { buff.append("setNode(").append(treeIndex) .append(", 2, 2, 'type', '") .append(PageParser.escapeJavaScript(column.getDataType())) .append("', null);\n"); treeIndex++; } } return treeIndex; }
/** * Read the column for this table from the database meta data. * * @param meta the database meta data */ void readParameters(DatabaseMetaData meta) throws SQLException { ResultSet rs = meta.getProcedureColumns(null, schema.name, name, null); ArrayList<DbColumn> list = New.arrayList(); while (rs.next()) { DbColumn column = DbColumn.getProcedureColumn(schema.getContents(), rs); if (column.getPosition() > 0) { // Not the return type list.add(column); } } rs.close(); parameters = new DbColumn[list.size()]; // Store the parameter in the good position [1-n] for (int i = 0; i < parameters.length; i++) { DbColumn column = list.get(i); if (column.getPosition() > 0 && column.getPosition() <= parameters.length) { parameters[column.getPosition() - 1] = column; } } }
for (DbColumn column : last.getColumns()) { String compare = up; String name = StringUtils.toUpperEnglish(column.getName()); if (column.getQuotedName().length() > name.length()) { name = column.getQuotedName(); compare = query; column.getDataType().contains(columnType))) { String b = s.substring(name.length()); if (best == null || b.length() < best.length()) { } else if (s.length() == 0 || name.startsWith(compare)) { if (s.length() < name.length()) { sentence.add(column.getName(), column.getName().substring(s.length()), Sentence.CONTEXT); .getName()); if (columnType == null || column.getDataType().contains(columnType)) { if (up.startsWith(name)) { String b = s.substring(name.length()); sentence.add(column.getName(), column.getName().substring(s.length()), Sentence.CONTEXT);
if (parameter.getPosition() > 1) { rl = new RuleList(rl, comma, false); String parameterType = parameter.getDataType();
for (DbColumn column : last.getColumns()) { String compare = up; String name = StringUtils.toUpperEnglish(column.getName()); if (column.getQuotedName().length() > name.length()) { name = column.getQuotedName(); compare = query; column.getDataType().contains(columnType))) { String b = s.substring(name.length()); if (best == null || b.length() < best.length()) { } else if (s.length() == 0 || name.startsWith(compare)) { if (s.length() < name.length()) { sentence.add(column.getName(), column.getName().substring(s.length()), Sentence.CONTEXT); .getName()); if (columnType == null || column.getDataType().contains(columnType)) { if (up.startsWith(name)) { String b = s.substring(name.length()); sentence.add(column.getName(), column.getName().substring(s.length()), Sentence.CONTEXT);
/** * Read the column for this table from the database meta data. * * @param meta the database meta data */ void readParameters(DatabaseMetaData meta) throws SQLException { ResultSet rs = meta.getProcedureColumns(null, schema.name, name, null); ArrayList<DbColumn> list = New.arrayList(); while (rs.next()) { DbColumn column = DbColumn.getProcedureColumn(schema.getContents(), rs); if (column.getPosition() > 0) { // Not the return type list.add(column); } } rs.close(); parameters = new DbColumn[list.size()]; // Store the parameter in the good position [1-n] for (int i = 0; i < parameters.length; i++) { DbColumn column = list.get(i); if (column.getPosition() > 0 && column.getPosition() <= parameters.length) { parameters[column.getPosition() - 1] = column; } } }
if (parameter.getPosition() > 1) { rl = new RuleList(rl, comma, false); String parameterType = parameter.getDataType();
for (DbColumn column : last.getColumns()) { String compare = up; String name = StringUtils.toUpperEnglish(column.getName()); if (column.getQuotedName().length() > name.length()) { name = column.getQuotedName(); compare = query; column.getDataType().contains(columnType))) { String b = s.substring(name.length()); if (best == null || b.length() < best.length()) { } else if (s.length() == 0 || name.startsWith(compare)) { if (s.length() < name.length()) { sentence.add(column.getName(), column.getName().substring(s.length()), Sentence.CONTEXT); .getName()); if (columnType == null || column.getDataType().contains(columnType)) { if (up.startsWith(name)) { String b = s.substring(name.length()); sentence.add(column.getName(), column.getName().substring(s.length()), Sentence.CONTEXT);
/** * Read the column for this table from the database meta data. * * @param meta the database meta data */ void readParameters(DatabaseMetaData meta) throws SQLException { ResultSet rs = meta.getProcedureColumns(null, schema.name, name, null); ArrayList<DbColumn> list = New.arrayList(); while (rs.next()) { DbColumn column = DbColumn.getProcedureColumn(schema.getContents(), rs); if (column.getPosition() > 0) { // Not the return type list.add(column); } } rs.close(); parameters = new DbColumn[list.size()]; // Store the parameter in the good position [1-n] for (int i = 0; i < parameters.length; i++) { DbColumn column = list.get(i); if (column.getPosition() > 0 && column.getPosition() <= parameters.length) { parameters[column.getPosition() - 1] = column; } } }
private static int addColumns(boolean mainSchema, DbTableOrView table, StringBuilder buff, int treeIndex, boolean showColumnTypes, StringBuilder columnsBuffer) { DbColumn[] columns = table.getColumns(); for (int i = 0; columns != null && i < columns.length; i++) { DbColumn column = columns[i]; if (columnsBuffer.length() > 0) { columnsBuffer.append(' '); } columnsBuffer.append(column.getName()); String col = escapeIdentifier(column.getName()); String level = mainSchema ? ", 1, 1" : ", 2, 2"; buff.append("setNode(" + treeIndex + level + ", 'column', '" + PageParser.escapeJavaScript(column.getName()) + "', 'javascript:ins(\\'" + col + "\\')');\n"); treeIndex++; if (mainSchema && showColumnTypes) { buff.append("setNode(" + treeIndex + ", 2, 2, 'type', '" + PageParser.escapeJavaScript(column.getDataType()) + "', null);\n"); treeIndex++; } } return treeIndex; }
if (parameter.getPosition() > 1) { rl = new RuleList(rl, comma, false); String parameterType = parameter.getDataType();
/** * Create a column from a DatabaseMetaData.getProcedureColumns row. * * @param contents the database contents * @param rs the result set * @return the column */ public static DbColumn getProcedureColumn(DbContents contents, ResultSet rs) throws SQLException { return new DbColumn(contents, rs, true); }
/** * Read the column for this table from the database meta data. * * @param meta the database meta data */ public void readColumns(DatabaseMetaData meta) throws SQLException { ResultSet rs = meta.getColumns(null, schema.name, name, null); ArrayList<DbColumn> list = New.arrayList(); while (rs.next()) { DbColumn column = DbColumn.getColumn(schema.getContents(), rs); list.add(column); } rs.close(); columns = new DbColumn[list.size()]; list.toArray(columns); }
private static int addColumns(boolean mainSchema, DbTableOrView table, StringBuilder buff, int treeIndex, boolean showColumnTypes, StringBuilder columnsBuffer) { DbColumn[] columns = table.getColumns(); for (int i = 0; columns != null && i < columns.length; i++) { DbColumn column = columns[i]; if (columnsBuffer.length() > 0) { columnsBuffer.append(' '); } columnsBuffer.append(column.getName()); String col = escapeIdentifier(column.getName()); String level = mainSchema ? ", 1, 1" : ", 2, 2"; buff.append("setNode(" + treeIndex + level + ", 'column', '" + PageParser.escapeJavaScript(column.getName()) + "', 'javascript:ins(\\'" + col + "\\')');\n"); treeIndex++; if (mainSchema && showColumnTypes) { buff.append("setNode(" + treeIndex + ", 2, 2, 'type', '" + PageParser.escapeJavaScript(column.getDataType()) + "', null);\n"); treeIndex++; } } return treeIndex; }
/** * Create a column from a DatabaseMetaData.getColumns row. * * @param contents the database contents * @param rs the result set * @return the column */ public static DbColumn getColumn(DbContents contents, ResultSet rs) throws SQLException { return new DbColumn(contents, rs, false); }
/** * Read the column for this table from the database meta data. * * @param meta the database meta data */ public void readColumns(DatabaseMetaData meta) throws SQLException { ResultSet rs = meta.getColumns(null, schema.name, name, null); ArrayList<DbColumn> list = New.arrayList(); while (rs.next()) { DbColumn column = DbColumn.getColumn(schema.getContents(), rs); list.add(column); } rs.close(); columns = new DbColumn[list.size()]; list.toArray(columns); }
/** * Create a column from a DatabaseMetaData.getProcedureColumns row. * * @param contents the database contents * @param rs the result set * @return the column */ public static DbColumn getProcedureColumn(DbContents contents, ResultSet rs) throws SQLException { return new DbColumn(contents, rs, true); }
/** * Create a column from a DatabaseMetaData.getColumns row. * * @param contents the database contents * @param rs the result set * @return the column */ public static DbColumn getColumn(DbContents contents, ResultSet rs) throws SQLException { return new DbColumn(contents, rs, false); }