Types.INTEGER, Types.INTEGER, Types.INTEGER }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet(tr, null); String row1[] = { "0", "0", "0" }; tr.newrow(row1); String row2[] = { "INTEGER", "" + Types.INTEGER, "32", "0", "0", "2" }; tr.newrow(row2); String row3[] = { "DOUBLE", "" + Types.DOUBLE, "16", "0", "0", "10" }; tr.newrow(row3); String row4[] = { "FLOAT", "" + Types.FLOAT, "7", "0", "0", "10" }; tr.newrow(row4);
public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException { String cols[] = { "TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "COLUMN_NAME", "GRANTOR", "GRANTEE", "PRIVILEGE", "IS_GRANTABLE" }; int types[] = { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet((SQLite.TableResult) tr, null); return rs; }
row[13] = "" + java.sql.DatabaseMetaData.importedKeyNotDeferrable; out.newrow(row);
rs = new JDBCResultSet(new TableResultX(tr), this);
public ResultSet getVersionColumns(String catalog, String schema, String table) throws SQLException { String cols[] = { "SCOPE", "COLUMN_NAME", "DATA_TYPE", "TYPE_NAME", "COLUMN_SIZE", "BUFFER_LENGTH", "DECIMAL_DIGITS", "PSEUDO_COLUMN" }; int types[] = { Types.SMALLINT, Types.VARCHAR, Types.SMALLINT, Types.VARCHAR, Types.INTEGER, Types.INTEGER, Types.SMALLINT, Types.SMALLINT }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet((SQLite.TableResult) tr, null); return rs; }
row[13] = "" + java.sql.DatabaseMetaData.importedKeyNotDeferrable; out.newrow(row);
rs = new JDBCResultSet(new TableResultX(tr), this);
Types.VARCHAR }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet(tr, null); if (rs0 != null && rs0.tr != null && rs0.tr.nrows > 0) { row[11] = "0"; row[12] = null; tr.newrow(row);
public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException { String cols[] = { "TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "COLUMN_NAME", "GRANTOR", "GRANTEE", "PRIVILEGE", "IS_GRANTABLE" }; int types[] = { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet((SQLite.TableResult) tr, null); return rs; }
row[13] = "" + java.sql.DatabaseMetaData.importedKeyNotDeferrable; out.newrow(row);
rs = new JDBCResultSet(new TableResultX(tr), this);
Types.INTEGER, Types.INTEGER, Types.VARCHAR }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet((SQLite.TableResult) tr, null); if (rs0 != null && rs0.tr != null && rs0.tr.nrows > 0) { row[10] = (r0[col].charAt(0) == '0') ? "" + columnNullable : "" + columnNoNulls; tr.newrow(row);
public ResultSet getExportedKeys(String catalog, String schema, String table) throws SQLException { String cols[] = { "PKTABLE_CAT", "PKTABLE_SCHEM", "PKTABLE_NAME", "PKCOLUMN_NAME", "FKTABLE_CAT", "FKTABLE_SCHEM", "FKTABLE_NAME", "FKCOLUMN_NAME", "KEY_SEQ", "UPDATE_RULE", "DELETE_RULE", "FK_NAME", "PK_NAME", "DEFERRABILITY" }; int types[] = { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.SMALLINT, Types.SMALLINT, Types.SMALLINT, Types.VARCHAR, Types.VARCHAR, Types.SMALLINT }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet(tr, null); return rs; }
row[13] = "" + java.sql.DatabaseMetaData.importedKeyNotDeferrable; out.newrow(row);
rs = new JDBCResultSet(new TableResultX(tr), this);
Types.VARCHAR, Types.SMALLINT, Types.VARCHAR }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet((SQLite.TableResult) tr, null); if (rs0 != null && rs0.tr != null && rs0.tr.nrows > 0) { row[4] = Integer.toString(Integer.parseInt(r1[col]) + 1); row[5] = iname; tr.newrow(row); row[4] = Integer.toString(Integer.parseInt(r0[col]) + 1); row[5] = ""; tr.newrow(row);
Types.VARCHAR, Types.SMALLINT }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet(tr, null); if (rs0 != null && rs0.tr != null && rs0.tr.nrows > 0) {
row[13] = "" + java.sql.DatabaseMetaData.importedKeyNotDeferrable; out.newrow(row);
rs = new JDBCResultSet(new TableResultX(tr), this);
Types.SMALLINT, Types.SMALLINT }; TableResultX tr = new TableResultX(); tr.columns(cols); tr.sql_types(types); JDBCResultSet rs = new JDBCResultSet((SQLite.TableResult) tr, null); if (rs0 != null && rs0.tr != null && rs0.tr.nrows > 0 && row[6] = "0"; row[7] = "" + bestRowNotPseudo; tr.newrow(row); row[6] = "0"; row[7] = "" + bestRowPseudo; tr.newrow(row);