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

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

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

Table.getColumns介绍

暂无

代码示例

代码示例来源：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. List<Column> col = t.getColumns();
  2. int nr = col.size();
  3. for ( int i = 0; i < nr; i++ ) {

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

  1. @Override
  2. public List<? extends Column> getColumns() {
  3.   return wrapped.getColumns();
  4. }

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

  1. public static boolean isMultiValueColumn(Table typeObjTable) {
  2.  // if we found a single value of a "simple" type, then we are dealing with
  3.  // a multi-value column
  4.  List<? extends Column> typeCols = typeObjTable.getColumns();
  5.  return ((typeCols.size() == 1) &&
  6.      MULTI_VALUE_TYPES.contains(typeCols.get(0).getType()));
  7. }

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

  1. private boolean hasAppendOnly(Table t) {
  2.   for (Column c : t.getColumns()) {
  3.     if (c.isAppendOnly()) {
  4.       return true;
  5.     }
  6.   }
  7.   return false;
  8. }

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

  1. private void saveColumnsDefaults(String[] defaults, Boolean[] required, Table table) throws IOException {
  2.   List<? extends Column> cols = table.getColumns();
  3.   int j = 0;
  4.   if (defaults != null || required != null) {
  5.     for (Column cl : cols) {
  6.       saveColumnsDefaults(defaults, required, cl, j);
  7.       j++;
  8.     }
  9.   }
  10. }

代码示例来源：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: net.sf.ucanaccess/ucanaccess

  1. private Map<String, Object> escapeIdentifiers(Map<String, Object> map, Table t) {
  2.   List<? extends Column> colums = t.getColumns();
  3.   Map<String, Object> vl = new LinkedHashMap<String, Object>();
  4.   for (Column cl : colums) {
  5.     String key = cl.getName();
  6.     String keyu = key.toUpperCase();
  7.     String ekey = map.containsKey(keyu) ? keyu : SQLConverter.escapeIdentifier(key).toUpperCase();
  8.     if (!map.containsKey(ekey) && map.containsKey(ekey.substring(1, ekey.length() - 1))) {
  9.       ekey = ekey.substring(1, ekey.length() - 1);
  10.     }
  11.     vl.put(key, map.get(ekey));
  12.   }
  13.   return vl;
  14. }

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

  1. public static boolean isVersionHistoryColumn(Table typeObjTable) {
  2.   // version history data has these columns <value>(MEMO),
  3.   // <modified>(SHORT_DATE_TIME)
  4.   List<? extends Column> typeCols = typeObjTable.getColumns();
  5.   if(typeCols.size() < 2) {
  6.    return false;
  7.   }
  9.   int numMemo = 0;
  10.   int numDate = 0;
  11.   
  12.   for(Column col : typeCols) {
  13.    switch(col.getType()) {
  14.    case SHORT_DATE_TIME:
  15.     ++numDate;
  16.     break;
  17.    case MEMO:
  18.     ++numMemo;
  19.     break;
  20.    default:
  21.     // ignore
  22.    }
  23.   }
  25.   // be flexible, allow for extra columns...
  26.   return((numMemo >= 1) && (numDate >= 1));
  27.  }
  28. }

代码示例来源：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: apache/tika

  1. Table table = it.next();
  2. String tableName = table.getName();
  3. List<? extends Column> columns = table.getColumns();
  4. xhtml.startElement("table", "name", tableName);
  5. addHeaders(columns, xhtml);

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

  1. protected static void diffFlatColumns(Table typeObjTable, 
  2.                    Table flatTable,
  3.                    List<Column> typeCols,
  4.                    List<Column> otherCols)
  5. {
  6.  // each "flat"" table has the columns from the "type" table, plus some
  7.  // others.  separate the "flat" columns into these 2 buckets
  8.  for(Column col : flatTable.getColumns()) {
  9.   if(((TableImpl)typeObjTable).hasColumn(col.getName())) {
  10.    typeCols.add(col);
  11.   } else {
  12.    otherCols.add(col);
  13.   }  
  14.  } 
  15. }

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

  1. @Override
  2. public Collection<IColumn> getColumns() {
  3.   ArrayList<IColumn> ret = new ArrayList<IColumn>();
  4.   try {
  5.     for (com.healthmarketscience.jackcess.Column cc : getTable().getColumns()) {
  6.       ret.add(new Column(cc.getName()));
  7.     }
  8.   } catch (KlabIOException e) {
  9.     ret.clear();
  10.   }
  11.   return ret;
  12. }

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

  1. public UpdateCommand(Table _table, Map<String, Object> _map, Object[] _modifiedRow, String _execId) {
  2.   this.tableColumns = _table.getColumns();
  3.   this.indexSelector = new IndexSelector(_table);
  4.   this.rowPattern = _map;
  5.   this.modifiedRow = _modifiedRow;
  6.   this.execId = _execId;
  7.   checkBlob(_modifiedRow);
  8.   this.table = _table;
  9. }

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

  1. static void schema(File inputFile) throws IOException{
  2.   Database db = DatabaseBuilder.open(inputFile);
  3.   try{
  4.     for(String tableName : db.getTableNames()){
  5.       Table table = db.getTable(tableName);
  6.       System.out.println(String.format("CREATE TABLE %s (", tableName));
  7.       for(Column col : table.getColumns()){
  8.         System.out.println(String.format("  %s %s,", 
  9.             col.getName(), col.getType()));
  10.       }
  11.       System.out.println(")");
  12.     }
  13.   }finally{
  14.     db.close();
  15.   }
  16. }

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

  1. @Override
  2. public IColumn getColumn(String columnName) {
  3.   boolean ok = false;
  4.   try {
  5.     for (com.healthmarketscience.jackcess.Column cc : getTable().getColumns()) {
  6.       if (cc.getName().equals(columnName)) {
  7.         ok = true;
  8.         break;
  9.       }
  10.     }
  11.   } catch (KlabIOException e) {
  12.   }
  13.   return ok ? new Column(columnName) : null;
  14. }

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

  1. private static boolean hasAutoNumberColumn(Table t) {
  2.   List<? extends Column> lc = t.getColumns();
  3.   for (Column cl : lc) {
  4.     if (cl.isAutoNumber() || DataType.BOOLEAN.equals(cl.getType())) {
  5.       return true;
  6.     }
  7.   }
  8.   return false;
  9. }

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

  1. private String getExpression(Column cl) throws IOException {
  2.   PropertyMap map = cl.getProperties();
  3.   Property exprp = map.get(PropertyMap.EXPRESSION_PROP);
  4.   if (exprp != null) {
  5.     Table tl = cl.getTable();
  6.     String expr = SQLConverter.convertPowOperator((String) exprp.getValue());
  7.     for (Column cl1 : tl.getColumns()) {
  8.       expr = expr.replaceAll("\\[(?i)(" + Pattern.quote(cl1.getName()) + ")\\]", "newrow.$0");
  9.     }
  10.     return expr;
  11.   }
  12.   return null;
  13. }

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

  1. public JackcessDenseObjectMatrix2D(File file, String tablename) throws IOException {
  2.   super(0, 0);
  3.   database = DatabaseBuilder.open(file);
  4.   VerifyUtil.verifyNotNull(database, "database could not be opened");
  5.   table = database.getTable(tablename);
  6.   VerifyUtil.verifyNotNull(table, "table not found in database");
  7.   columns = table.getColumns();
  8.   cursor = CursorBuilder.createCursor(table);
  9.   for (int i = 0; i < columns.size(); i++) {
  10.     setColumnLabel(i, columns.get(i).getName());
  11.   }
  12.   setLabel(tablename);
  13. }

代码示例来源：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. }

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

Table

相关文章

    查看更多

    热门标签

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

    最新文章

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