com.healthmarketscience.jackcess.Table类的使用及代码示例

x33g5p2x  于2022-01-30 转载在 其他  
字(8.7k)|赞(0)|评价(0)|浏览(840)

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

Table介绍

[英]A single database table. A Table instance is retrieved from a Database instance. The Table instance provides access to the table metadata as well as the table data. There are basic data operations on the Table interface (i.e. #iterator #addRow, #updateRowand #deleteRow), but for advanced search and data manipulation a Cursor instance should be used. New Tables can be created using a TableBuilder. The com.healthmarketscience.jackcess.util.Joiner utility can be used to traverse table relationships (e.g. find rows in another table based on a foreign-key relationship).

A Table instance is not thread-safe (see Database for more thread-safety details).
[中]一个数据库表。从数据库实例检索表实例。表实例提供对表元数据和表数据的访问。表接口上有一些基本的数据操作（即#迭代器#addRow、#UpdateRow和#deleteRow），但对于高级搜索和数据操作，应该使用游标实例。可以使用TableBuilder创建新表。通讯。健康市场科学。杰克塞斯。util。Joiner实用程序可用于遍历表关系（例如，基于外键关系查找另一个表中的行）。
表实例不是线程安全的（有关线程安全的详细信息，请参阅数据库）。

代码示例

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

  1. public static final RowMetaInterface getLayout( Table table ) throws SQLException, KettleStepException {
  2.  RowMetaInterface row = new RowMeta();
  3.  List<Column> columns = table.getColumns();
  4.  for ( int i = 0; i < columns.size(); i++ ) {
  5.   Column column = columns.get( i );

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

  1. private Object[] getOneRow() throws KettleException {
  2.  try {
  3.   if ( meta.isFileField() ) {
  4.    while ( ( data.readrow == null || ( ( data.rw = data.t.getNextRow() ) == null ) ) ) {
  5.     if ( !openNextFile() ) {
  6.      return null;
  7.    while ( ( data.file == null || ( ( data.rw = data.t.getNextRow() ) == null ) ) ) {
  8.     if ( !openNextFile() ) {
  9.      return null;
  10.   if ( meta.isIncludeTablename() && !Utils.isEmpty( data.t.getName() ) ) {
  11.    r[rowIndex++] = data.t.getName();

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

  1. void addRowToTable( Object... row ) throws IOException {
  2.  table.addRow( row );
  3. }

代码示例来源：origin: apache/tika

  1. String tableName = table.getName();
  2. List<? extends Column> columns = table.getColumns();
  3. xhtml.startElement("table", "name", tableName);
  4. addHeaders(columns, xhtml);
  5. xhtml.startElement("tbody");
  6. Row r = table.getNextRow();
  7.   r = table.getNextRow();

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

  1. private void setDefaultValues(Table t) throws SQLException, IOException {
  2.   String tn = t.getName();
  3.   String ntn = escapeIdentifier(tn);
  4.   List<? extends Column> lc = t.getColumns();
  5.   List<String> arTrigger = new ArrayList<String>();
  6.   for (Column cl : lc) {
  7.     setDefaultValue(cl, ntn, arTrigger);
  8.   }
  9.   for (String trigger : arTrigger) {
  10.     exec(trigger, true);
  11.   }
  12. }

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

  1. public InsertCommand(Table _table, Object[] _newRow, String _execId) {
  2.   this.table = _table;
  3.   this.tableName = _table.getName();
  4.   this.newRow = _newRow;
  5.   this.execId = _execId;
  6. }

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

  1. public BlobAction(Table _table, Object[] newValues) throws SQLException {
  2.   this.table = _table;
  3.   if (!BlobKey.hasPrimaryKey(_table)) {
  4.     return;
  5.   }
  6.   Index pk = _table.getPrimaryKeyIndex();
  7.   HashSet<String> hsKey = new HashSet<String>();
  8.   for (Index.Column icl : pk.getColumns()) {
  9.     hsKey.add(icl.getName());
  10.   }
  11.   HashSet<String> hsBlob = new HashSet<String>();
  12.   int i = 0;
  13.   HashMap<String, Object> keyMap = new HashMap<String, Object>();
  14.   for (Column cl : _table.getColumns()) {
  15.     if (cl.getType().equals(DataType.OLE) && newValues[i] != null) {
  16.       containsBlob = true;
  17.       hsBlob.add(cl.getName());
  18.     }
  19.     if (hsKey.contains(cl.getName())) {
  20.       keyMap.put(cl.getName(), newValues[i]);
  21.     }
  22.     ++i;
  23.   }
  24.   for (String cln : hsBlob) {
  25.     keys.add(new BlobKey(keyMap, table.getName(), cln));
  26.   }
  27. }

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

  1. private void persist(Cursor cur) throws IOException, SQLException {
  2.   Object[] mr = this.modifiedRow;
  3.   if (table.getDatabase().getColumnOrder().equals(ColumnOrder.DISPLAY)) {
  4.     Object[] newRowReorded = new Object[this.modifiedRow.length];
  5.     int j = 0;
  6.     for (Column cli : table.getColumns()) {
  7.       newRowReorded[cli.getColumnIndex()] = this.modifiedRow[j];
  8.       j++;
  9.     }
  10.     mr = newRowReorded;
  11.   }
  12.   cur.updateCurrentRow(mr);
  13. }

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

  1. public void insertRow(Table _table, Object[] _row) throws IOException {
  2.   try {
  3.     _table.addRow(newRow);
  4.   } catch (ConstraintViolationException e) {
  5.     List<? extends Column> lc = _table.getColumns();
  6.     boolean retry = false;
  7.     for (Column cl : lc) {
  8.       if (cl.isAutoNumber()) {
  9.         retry = true;
  10.         break;
  11.       }
  12.     }
  13.     if (!retry) {
  14.       throw e;
  15.     }
  16.     Database db = _table.getDatabase();
  17.     File fl = db.getFile();
  18.     DBReferenceSingleton dbsin = DBReferenceSingleton.getInstance();
  19.     DBReference ref = dbsin.getReference(fl);
  20.     ref.reloadDbIO();
  21.     this.dbIO = ref.getDbIO();
  22.     _table = this.dbIO.getTable(this.tableName);
  23.     _table.addRow(newRow);
  24.   }
  25. }

代码示例来源：origin: AccelerationNet/access2csv

  1. static int export(Database db, String tableName, Writer csv, boolean withHeader, boolean applyQuotesToAll, String nullText) throws IOException{
  2.   Table table = db.getTable(tableName);
  3.   String[] buffer = new String[table.getColumnCount()];
  4.   CSVWriter writer = new CSVWriter(new BufferedWriter(csv), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.DEFAULT_QUOTE_CHARACTER);
  5.   int rows = 0;
  6.   try{
  7.     if (withHeader) {
  8.       int x = 0;
  9.       for(Column col : table.getColumns()){
  10.         buffer[x++] = col.getName();
  11.       }
  12.       writer.writeNext(buffer, applyQuotesToAll);
  13.     }
  14.     
  15.     for(Row row : table){
  16.       int i = 0;
  17.       for (Object object : row.values()) {
  18.         buffer[i++] = object == null ? nullText : object.toString();
  19.       }
  20.       writer.writeNext(buffer, applyQuotesToAll);
  21.       rows++;
  22.     }
  23.   }finally{
  24.     writer.close();
  25.   }
  26.   return rows;
  27. }

代码示例来源：origin: com.healthmarketscience.jackcess/jackcess

  1. private boolean matchesLinkedTable(Table table, String linkedTableName,
  2.                   String linkedDbName) {
  3.  return (table.getName().equalsIgnoreCase(linkedTableName) &&
  4.      (_linkedDbs != null) &&
  5.      (_linkedDbs.get(linkedDbName) == table.getDatabase()));
  6. }

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

  1. try {
  2.   int i = 0;
  3.   Iterator<Row> it = t.iterator();
  4.   if (i != t.getRowCount() && step != 1) {
  5.     Logger.logParametricWarning(Messages.ROW_COUNT, t.getName(), String.valueOf(t.getRowCount()),
  6.         String.valueOf(i));

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

  1. for (Column cli : t.getColumns()) {
  2.   ColumnImpl cl = (ColumnImpl) cli;
  3.   if (cli.getType().equals(DataType.COMPLEX_TYPE) && (newR[i] == null || "".equals(newR[i]))) {
  4.     if (type == Trigger.INSERT_BEFORE_ROW) {
  5.       if (t.isAllowAutoNumberInsert()) {
  6.         if (cl.getAutoNumberGenerator().getType().equals(DataType.LONG) && newR[i] != null) {
  7.           AutoNumberManager.bump(cl, (Integer) newR[i]);

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

  1. Table RESOURCES = Database.open(new File("TargetFile.mdb")).getTable("RESOURCES");
  2.  int pcount = RESOURCES.getRowCount();
  3.  String csvFilename = "C:\\STATS\\APEX\\report.csv";
  4.  CSVReader csvReader = new CSVReader(new FileReader(csvFilename));
  5.  List<String[]> content = csvReader.readAll();
  6.  Map<ValueKey, Integer> csvValuesCount = new HashMap<ValueKey, Integer>();
  7.  for (String[] rowcsv  : content) {
  8.    ValueKey key = new ValueKey(rowcsv[6], rowcsv[1]);
  9.    Integer count = csvValuesCount.get(key);
  10.    csvValuesCount.put(key,count == null ? 1: count + 1);
  11.  }
  12.  int count = 0;
  13.  // Taking 1st resource data
  14.  for (int i = 0; i < pcount; i++) {
  15.    Map<String, Object> row = RESOURCES.getNextRow();
  16.    TEAM = row.get("TEAM").toString();
  17.    MDMID = row.get("MDM ID").toString();
  18.    NAME = row.get("RESOURCE NAME").toString();
  19.    PGNAME = row.get("PG NAME").toString();
  20.    PGTARGET = row.get("PG TARGET").toString();
  21.    int PGTARGETI = Integer.parseInt(PGTARGET);
  22.    Integer countInteger = csvValuesCount.get(new ValueKey(MDMID, PGNAME));
  23.    count = countInteger == null ? 0: countInteger;
  24.  }

代码示例来源：origin: com.healthmarketscience.jackcess/jackcess

  1. int numColumns = table.getColumnCount();
  2.   table.addRows(rows);
  3.   rows.clear();
  4.  table.addRows(rows);
  5. return table.getName();

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

  1. mt.dropTable(t.getName());
  2. if (!HibernateSupport.isActive()) {
  3.   Cursor c = t.getDefaultCursor();
  4.   while (c.getNextRow() != null) {
  5.     c.deleteCurrentRow();
  6. Table cat = dbi.getSystemCatalog();
  7. Map<String, Object> row;
  8. Cursor catc = cat.getDefaultCursor();
  9. while ((row = catc.getNextRow()) != null) {
  10.   String name = (String) row.get("Name");
  11.     Map<String, Object> rowtsa = new HashMap<String, Object>();
  12.     rowtsa.put("ObjectId", id);
  13.     Cursor cur = tsa.getDefaultCursor();
  14.     if (cur.findNextRow(rowtsa)) {
  15.       cur.deleteCurrentRow();
  16.     Cursor srsc = srs.getDefaultCursor();
  17.     while ((row = srsc.getNextRow()) != null) {
  18.       String szObject = (String) row.get("szObject");

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

  1. public BlobKey(Table _table, String _columnName, Row _row) {
  2.   this.tableName = _table.getName();
  3.   this.columnName = _columnName;
  4.   if (hasPrimaryKey(_table)) {
  5.     List<? extends Index.Column> cl = _table.getPrimaryKeyIndex().getColumns();
  6.     HashMap<String, Object> keyMap = new HashMap<String, Object>();
  7.     for (Index.Column c : cl) {
  8.       keyMap.put(c.getName(), _row.get(c.getName()));
  9.     }
  10.     this.key = keyMap;
  11.   }
  12. }

代码示例来源：origin: com.healthmarketscience.jackcess/jackcess

  1. table.addRows(rows);
  2.   rows.clear();
  3.  table.addRows(rows);
  4. return table.getName();

代码示例来源：origin: ujmp/universal-java-matrix-package

  1. public long[] getSize() {
  2.   size[ROW] = table.getRowCount();
  3.   size[COLUMN] = table.getColumnCount();
  4.   return size;
  5. }

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

  1. @Override
  2. public int getValueCount() {
  3.   try {
  4.     return getTable().getRowCount();
  5.   } catch (KlabIOException e) {
  6.     // shouldn't happen
  7.   }
  8.   return 0;
  9. }

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

Table

相关文章

    查看更多

    热门标签

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

    最新文章

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