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

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

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

Database.getSystemTable介绍

[英]Returns a reference to any available table in this access database, including system tables.

Warning, this method is not designed for common use, only for the occassional time when access to a system table is necessary. Messing with system tables can strip the paint off your house and give your whole family a permanent, orange afro. You have been warned.
[中]返回对此access数据库中任何可用表(包括系统表)的引用。
警告,此方法不是为通用而设计的,仅适用于需要访问系统表的偶然时间。弄乱系统桌子会剥掉你家的油漆,给你全家一个永久的橙色非洲式发型。你已经被警告了。

代码示例

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

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

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

  1. private void createSystemTables() throws SQLException, IOException {
  2. if (sysSchema) {
  3. createSystemSchema();
  4. for (String tn : dbIO.getSystemTableNames()) {
  5. UcanaccessTable t = null;
  6. try {
  7. t = new UcanaccessTable(dbIO.getSystemTable(tn), tn);
  8. if (t != null) {
  9. createTable(t, true);
  10. loadTableData(t, true);
  11. exec("SET TABLE " + schema(SQLConverter.escapeIdentifier(t.getName()), true)
  12. + " READONLY TRUE ", false);
  13. exec("GRANT SELECT ON " + schema(SQLConverter.escapeIdentifier(t.getName()), true)
  14. + " TO PUBLIC ", false);
  15. }
  16. } catch (Exception ignore) {
  17. }
  18. }
  19. }
  20. }

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

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

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

  1. private boolean checkInside(Database db) throws IOException {
  2. Table t = db.getSystemTable("MSysObjects");
  3. Iterator<Row> it = t.iterator();
  4. while (it.hasNext()) {
  5. Row row = it.next();
  6. Object dobj = row.get("DateUpdate");
  7. Object tobj = row.get("Type");
  8. if (dobj == null || tobj == null) {
  9. continue;
  10. }
  11. Date dt = (Date) dobj;
  12. short type = (Short) tobj;
  13. if (lastModified < dt.getTime() && (type == 1 || type == 5 || type == 8)
  14. ) {
  15. return true;
  16. }
  17. }
  18. return false;
  19. }

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

  1. r.put("Name", tn);
  2. catc.updateCurrentRowFromMap(r);
  3. Table srs = db.getSystemTable("MSysRelationships");
  4. Cursor srsc = srs.getDefaultCursor();

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

  1. if (name != null && name.equalsIgnoreCase(tableName)) {
  2. Integer id = (Integer) row.get("Id");
  3. Table tsa = db.getSystemTable("MSysACEs");
  4. Map<String, Object> rowtsa = new HashMap<String, Object>();
  5. rowtsa.put("ObjectId", id);
  6. Table srs = db.getSystemTable("MSysRelationships");
  7. Cursor srsc = srs.getDefaultCursor();
  8. while ((row = srsc.getNextRow()) != null) {

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

  1. UcanaccessConnection conn = UcanaccessConnection.getCtxConnection();
  2. Database db = conn.getDbIO();
  3. Table tbl = db.getSystemTable("MSysRelationships");
  4. IndexCursor crsr = CursorBuilder.createCursor(tbl.getIndex("szRelationship"));
  5. Row r = crsr.findRowByEntry(relationshipName);
  6. r = crsr.findRowByEntry(relationshipName);
  7. tbl = db.getSystemTable("MSysObjects");
  8. crsr = CursorBuilder.createCursor(tbl.getIndex("ParentIdName"));
  9. Map<String, Object> rowPattern = new HashMap<String, Object>();
  10. Integer relationshipId = r.getInt("Id");
  11. tbl.deleteRow(r);
  12. tbl = db.getSystemTable("MSysACEs");
  13. crsr = CursorBuilder.createCursor(tbl.getIndex("ObjectId"));
  14. r = crsr.findRowByEntry(relationshipId);

相关文章