void createTable( String tableName, RowMetaInterface rowMeta ) throws IOException { List<Column> columns = AccessOutputMeta.getColumns( rowMeta ); db.createTable( tableName, columns ); table = db.getTable( tableName ); }
Table table = db.getTable( realTablename ); if ( table == null ) { throw new KettleException( BaseMessages.getString(
logBasic( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Log.DbOpened", targetFilename ) ); if ( db.getTable( tablename ) != null ) { logBasic( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Log.TableExists", tablename ) );
t = d.getSystemTable( realTableName ); } else { t = d.getTable( realTableName );
data.table = data.db.getTable( realTablename ); if ( data.table == null ) { if ( meta.isTableCreated() ) {
data.t = data.d.getSystemTable( data.tableName ); } else { data.t = data.d.getTable( data.tableName );
String dbFileSpec = "C:/Users/Public/example.accdb"; try (Database db = DatabaseBuilder.open(new File(dbFileSpec))) { Table tbl = db.getTable("XXXX_XA_Data_1"); HashMap rowData = new HashMap(); rowData.put("Today's Future Variation Margin", 1); tbl.addRowFromMap(rowData); }
ArrayList<Integer> partNumbers = new ArrayList<Integer>(); partNumbers.add(999); partNumbers.add(777); partNumbers.add(1234); // set up Database database = new Database(getConnection()); Table<Inventory> inventoryTable = database.getTable(Inventory.class); // select operation for list "...WHERE PARTNUMBER IN (?, ?, ?)..." for (Inventory inventory: inventoryTable. selectAllWhere("partNumberIn", partNumbers)) { System.out.println(inventory.getPartNumber()); }
private com.healthmarketscience.jackcess.Table getTable() throws KlabIOException { if (_table == null) { try { _table = getDb().getTable(_name); } catch (IOException e) { throw new KlabIOException(e); } } return _table; }
Database db = DatabaseBuilder.open(new File( "C:/Users/Gord/Desktop/Database1.accdb")); Table table = db.getTable("People"); Map<String, Object> criteria = new HashMap<String, Object>(); criteria.put("FirstName", "Jimmy"); criteria.put("LastName", "Hoffa"); Row row = CursorBuilder.findRow(table, criteria); if (row == null) { System.out.println("No row found that matches all criteria."); } else { System.out.println(String.format("Row found: ID=%d.", row.get("ID"))); }
@SuppressWarnings("unchecked") private List<com.healthmarketscience.jackcess.Column> getColumns(String tableName) throws IOException { return (List<com.healthmarketscience.jackcess.Column>) jackcessDatabase.getTable(tableName).getColumns(); }
Database db = DatabaseBuilder.open(new File( "C:/Users/Gord/Desktop/Database1.accdb")); Table tbl = db.getTable("MyTable"); Cursor crsr = new CursorBuilder(tbl) .setIndex(tbl.getIndex("alias")) .setStartEntry("B0") .setEndEntry("B0") .toCursor(); List<Row> rowList = new ArrayList<Row>(); for (Row r : crsr.newIterable()) { rowList.add(r); }
private void loadTablesData() throws SQLException, IOException { for (String tn : this.loadingOrder) { if (!this.unresolvedTables.contains(tn)) { UcanaccessTable t = new UcanaccessTable(dbIO.getTable(tn), tn); this.loadTableData(t, false); conn.commit(); } } }
String dbFile = "C:/Users/Public/test/DB.mdb"; try (Database db = DatabaseBuilder.open(new File(dbFile))) { Table table = db.getTable("Table1"); Cursor cursor = CursorBuilder.createCursor(table); int testNum = 1; for (Row row : cursor.newIterable().addMatchPattern("testnum", testNum)) { row.put("active", true); table.updateRow(row); } } catch (Exception e) { e.printStackTrace(System.out); }
private void createTriggers() throws IOException, SQLException { for (String tn : this.loadingOrder) { if (!this.unresolvedTables.contains(tn) && !this.readOnlyTables.contains(tn)) { UcanaccessTable t = new UcanaccessTable(dbIO.getTable(tn), tn); createSyncrTriggers(t); } } createCalculatedFieldsTriggers(); }
@Override protected Number executeCountQuery(Table table, List<FilterItem> whereItems, boolean functionApproximationAllowed) { try { com.healthmarketscience.jackcess.Table mdbTable = getDatabase().getTable(table.getName()); return mdbTable.getRowCount(); } catch (Exception e) { throw new MetaModelException(e); } }
public OleBlob getOleBlob(Database db) throws UcanaccessSQLException { try { Table t = db.getTable(tableName); Cursor c = CursorBuilder.createPrimaryKeyCursor(t); return c.findFirstRow(key) ? c.getCurrentRow().getBlob(columnName) : null; } catch (IOException e) { throw new UcanaccessSQLException(e); } }
private void loadTableIndexesUK(String tn) throws IOException, SQLException { Table t = dbIO.getTable(tn); UcanaccessTable table = new UcanaccessTable(t, tn); if (t != null) { for (Index idx : table.getIndexes()) { if (!idx.isForeignKey() && (idx.isPrimaryKey() || idx.isUnique())) { loadIndex(idx, tn); } } } }
private void loadTableIndexesNotUK(String tn) throws IOException, SQLException { Table t = dbIO.getTable(tn); UcanaccessTable table = new UcanaccessTable(t, tn); if (!skipIndexes && t != null) { for (Index idx : table.getIndexes()) { if (!idx.isForeignKey() && !idx.isPrimaryKey() && !idx.isUnique()) { loadIndex(idx, tn); } } } }
private void readTableData(Table table) throws IOException { com.healthmarketscience.jackcess.Table sourceTable = jackcessDatabase.getTable(table.getName()); for (com.healthmarketscience.jackcess.Row sourceRow : sourceTable) { Row row = new Row(table); for (Column column : table.getColumns()) { row.add(column, sourceRow.get(column.getName())); } table.addRow(row); } }