com.healthmarketscience.jackcess.Database.getTable()方法的使用及代码示例

x33g5p2x  于2022-01-18 转载在 其他  
字(6.4k)|赞(0)|评价(0)|浏览(261)

本文整理了Java中com.healthmarketscience.jackcess.Database.getTable()方法的一些代码示例，展示了Database.getTable()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Database.getTable()方法的具体详情如下：
包路径：com.healthmarketscience.jackcess.Database
类名称：Database
方法名：getTable

Database.getTable介绍

暂无

代码示例

代码示例来源：origin: pentaho/pentaho-kettle

  1. void createTable( String tableName, RowMetaInterface rowMeta ) throws IOException {
  2.  List<Column> columns = AccessOutputMeta.getColumns( rowMeta );
  3.  db.createTable( tableName, columns );
  4.  table = db.getTable( tableName );
  5. }

代码示例来源：origin: pentaho/pentaho-kettle

  1. Table table = db.getTable( realTablename );
  2. if ( table == null ) {
  3.  throw new KettleException( BaseMessages.getString(

代码示例来源：origin: pentaho/pentaho-kettle

  1. logBasic( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Log.DbOpened", targetFilename ) );
  2. if ( db.getTable( tablename ) != null ) {
  3.  logBasic( BaseMessages.getString( PKG, "JobEntryMSAccessBulkLoad.Log.TableExists", tablename ) );

代码示例来源：origin: pentaho/pentaho-kettle

  1. t = d.getSystemTable( realTableName );
  2. } else {
  3.  t = d.getTable( realTableName );

代码示例来源：origin: pentaho/pentaho-kettle

  1. data.table = data.db.getTable( realTablename );
  2. if ( data.table == null ) {
  3.  if ( meta.isTableCreated() ) {

代码示例来源：origin: pentaho/pentaho-kettle

  1. data.t = data.d.getSystemTable( data.tableName );
  2. } else {
  3.  data.t = data.d.getTable( data.tableName );

代码示例来源：origin: stackoverflow.com

  1. String dbFileSpec = "C:/Users/Public/example.accdb";
  2. try (Database db = DatabaseBuilder.open(new File(dbFileSpec))) {
  3.   Table tbl = db.getTable("XXXX_XA_Data_1");
  4.   HashMap rowData = new HashMap();
  5.   rowData.put("Today's Future Variation Margin", 1);
  6.   tbl.addRowFromMap(rowData);
  7. }

代码示例来源：origin: stackoverflow.com

  1. ArrayList<Integer> partNumbers = new ArrayList<Integer>();
  2. partNumbers.add(999);
  3. partNumbers.add(777);
  4. partNumbers.add(1234);
  6. // set up
  7. Database database = new Database(getConnection());
  8. Table<Inventory> inventoryTable = database.getTable(Inventory.class);
  10. // select operation for list "...WHERE PARTNUMBER IN (?, ?, ?)..."
  11. for (Inventory inventory: inventoryTable.
  12.   selectAllWhere("partNumberIn", partNumbers))    
  13. {
  14.   System.out.println(inventory.getPartNumber());
  15. }

代码示例来源：origin: org.integratedmodelling/klab-common

  1. private com.healthmarketscience.jackcess.Table getTable() throws KlabIOException {
  2.   if (_table == null) {
  3.     try {
  4.       _table = getDb().getTable(_name);
  5.     } catch (IOException e) {
  6.       throw new KlabIOException(e);
  7.     }
  8.   }
  9.   return _table;
  10. }

代码示例来源：origin: stackoverflow.com

  1. Database db = DatabaseBuilder.open(new File(
  2.     "C:/Users/Gord/Desktop/Database1.accdb"));
  3. Table table = db.getTable("People");
  4. Map<String, Object> criteria = new HashMap<String, Object>();
  5. criteria.put("FirstName", "Jimmy");
  6. criteria.put("LastName", "Hoffa");
  7. Row row = CursorBuilder.findRow(table, criteria);
  8. if (row == null) {
  9.   System.out.println("No row found that matches all criteria.");
  10. }
  11. else {
  12.   System.out.println(String.format("Row found: ID=%d.", row.get("ID")));
  13. }

代码示例来源：origin: io.github.codemumbler/mdb-oracle-converter

  1. @SuppressWarnings("unchecked")
  2. private List<com.healthmarketscience.jackcess.Column> getColumns(String tableName) throws IOException {
  3.  return (List<com.healthmarketscience.jackcess.Column>) jackcessDatabase.getTable(tableName).getColumns();
  4. }

代码示例来源：origin: stackoverflow.com

  1. Database db = DatabaseBuilder.open(new File(
  2.     "C:/Users/Gord/Desktop/Database1.accdb"));
  3. Table tbl = db.getTable("MyTable");
  4. Cursor crsr = new CursorBuilder(tbl)
  5.     .setIndex(tbl.getIndex("alias"))
  6.     .setStartEntry("B0")
  7.     .setEndEntry("B0")
  8.     .toCursor();
  9. List<Row> rowList = new ArrayList<Row>();
  10. for (Row r : crsr.newIterable()) {
  11.   rowList.add(r);
  12. }

代码示例来源：origin: net.sf.ucanaccess/ucanaccess

  1. private void loadTablesData() throws SQLException, IOException {
  2.   for (String tn : this.loadingOrder) {
  3.     if (!this.unresolvedTables.contains(tn)) {
  4.       UcanaccessTable t = new UcanaccessTable(dbIO.getTable(tn), tn);
  5.       this.loadTableData(t, false);
  6.       conn.commit();
  7.     }
  8.   }
  9. }

代码示例来源：origin: stackoverflow.com

  1. String dbFile = "C:/Users/Public/test/DB.mdb";
  2. try (Database db = DatabaseBuilder.open(new File(dbFile))) {
  3.   Table table = db.getTable("Table1");
  4.   Cursor cursor = CursorBuilder.createCursor(table);
  5.   int testNum = 1;
  6.   for (Row row : cursor.newIterable().addMatchPattern("testnum", testNum)) {
  7.     row.put("active", true);
  8.     table.updateRow(row);
  9.   }
  10. } catch (Exception e) {
  11.   e.printStackTrace(System.out);
  12. }

代码示例来源：origin: net.sf.ucanaccess/ucanaccess

  1. private void createTriggers() throws IOException, SQLException {
  2.   for (String tn : this.loadingOrder) {
  3.     if (!this.unresolvedTables.contains(tn) && !this.readOnlyTables.contains(tn)) {
  4.       UcanaccessTable t = new UcanaccessTable(dbIO.getTable(tn), tn);
  5.       createSyncrTriggers(t);
  6.     }
  7.   }
  8.   createCalculatedFieldsTriggers();
  9. }

代码示例来源：origin: org.eobjects.metamodel/MetaModel-access

  1. @Override
  2. protected Number executeCountQuery(Table table, List<FilterItem> whereItems, boolean functionApproximationAllowed) {
  3.   try {
  4.     com.healthmarketscience.jackcess.Table mdbTable = getDatabase().getTable(table.getName());
  5.     return mdbTable.getRowCount();
  6.   } catch (Exception e) {
  7.     throw new MetaModelException(e);
  8.   }
  9. }

代码示例来源：origin: net.sf.ucanaccess/ucanaccess

  1. public OleBlob getOleBlob(Database db) throws UcanaccessSQLException {
  2.   try {
  3.     Table t = db.getTable(tableName);
  4.     Cursor c = CursorBuilder.createPrimaryKeyCursor(t);
  5.     return c.findFirstRow(key) ? c.getCurrentRow().getBlob(columnName) : null;
  6.   } catch (IOException e) {
  7.     throw new UcanaccessSQLException(e);
  8.   }
  9. }

代码示例来源：origin: net.sf.ucanaccess/ucanaccess

  1. private void loadTableIndexesUK(String tn) throws IOException, SQLException {
  2.   Table t = dbIO.getTable(tn);
  3.   UcanaccessTable table = new UcanaccessTable(t, tn);
  4.   if (t != null) {
  5.     for (Index idx : table.getIndexes()) {
  6.       if (!idx.isForeignKey() && (idx.isPrimaryKey() || idx.isUnique())) {
  7.         loadIndex(idx, tn);
  8.       }
  9.     }
  10.   }
  11. }

代码示例来源：origin: net.sf.ucanaccess/ucanaccess

  1. private void loadTableIndexesNotUK(String tn) throws IOException, SQLException {
  2.   Table t = dbIO.getTable(tn);
  3.   UcanaccessTable table = new UcanaccessTable(t, tn);
  4.   if (!skipIndexes && t != null) {
  5.     for (Index idx : table.getIndexes()) {
  6.       if (!idx.isForeignKey() && !idx.isPrimaryKey() && !idx.isUnique()) {
  7.         loadIndex(idx, tn);
  8.       }
  9.     }
  10.   }
  11. }

代码示例来源：origin: io.github.codemumbler/mdb-oracle-converter

  1. private void readTableData(Table table) throws IOException {
  2.  com.healthmarketscience.jackcess.Table sourceTable = jackcessDatabase.getTable(table.getName());
  3.  for (com.healthmarketscience.jackcess.Row sourceRow : sourceTable) {
  4.   Row row = new Row(table);
  5.   for (Column column : table.getColumns()) {
  6.    row.add(column, sourceRow.get(column.getName()));
  7.   }
  8.   table.addRow(row);
  9.  }
  10. }

内容来源于网络，如有侵权，请联系作者删除！

Database

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com