^1640741513537
@
sname
Columns
slabel
列
sdataSource
var:dataSource
seditCols
2
spaging
false
spageSize
50
sreadUrl
do?sc=xworker.web.app.view.extjs.server.DataObjectStore/@read
screateUrl
do?sc=xworker.web.app.view.extjs.server.DataObjectStore/@create
supdateUrl
do?sc=xworker.web.app.view.extjs.server.DataObjectStore/@update
sdestroyUrl
do?sc=xworker.web.app.view.extjs.server.DataObjectStore/@destroy
LstoreAutoDestroy
false
sstoreAutoLoad
false
LstoreAutoSave
true
LstoreBatch
true
LstorePruneModifiedRecords
false
LstoreRemoteSort
false
LstoreRestful
false
sstoreRoot
'rows'
sstoreSuccessProperty
'success'
sstoreTotalProperty
'totalCount'
sstoreMessageProperty
'msg'
sgridEditable
false
sformReadUrl
do?sc=xworker.web.app.view.extjs.server.DataObjectForm/@read
sformCreateUrl
do?sc=xworker.web.app.view.extjs.server.DataObjectForm/@create
sformUpdateUrl
do?sc=xworker.web.app.view.extjs.server.DataObjectForm/@update
sformDestroyUrl
do?sc=xworker.web.app.view.extjs.server.DataObjectForm/@delete
spaging_afterPageText
页 共
spaging_beforePageText
第
Lpaging_displayInfo
false
spaging_displayMsg
第{0}-第{1}条，共{2}条
spaging_emptyMsg
没有数据
spaging_firstText
首页
spaging_lastText
最后一页
spaging_nextText
下一页
Lpaging_prependButtons
false
spaging_prevText
上一页
spaging_refreshText
刷新
sgridColumnLocking
false
sgridLockText
'锁定'
sgridUnlockText
'解锁'
scolumnGroup
false
sgridCheckable
false
sgridRowNumber
false
sgridGrouping
false
sgridGroupTextTpl
'{text} ({[values.rs.length]} 条)'
sgridRowExpander
false
sautoGenerateId
false
sidGenerateType
action
sstoreSortDir
ASC
sdescriptors
xworker.dataObject.db.DbDataObject
sth_createIndex
false
sid
Columns
  @/@tableCat
  sname
  tableCat
  slabel
  表类别
  sfieldName
  TABLE_CAT
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  tableCat
  @/@tableSchem
  sname
  tableSchem
  slabel
  表模式
  sfieldName
  TABLE_SCHEM
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  tableSchem
  @/@talbeName
  sname
  talbeName
  slabel
  表名称
  sfieldName
  TABLE_NAME
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  talbeName
  @/@columnName
  sname
  columnName
  slabel
  列名称
  sfieldName
  COLUMN_NAME
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  columnName
  @/@dataType
  sname
  dataType
  slabel
  类型
  sfieldName
  DATA_TYPE
  stype
  int
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  dataType
  @/@typeName
  sname
  typeName
  slabel
  类型名称
  sfieldName
  TYPE_NAME
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  typeName
  @/@columnSize
  sname
  columnSize
  slabel
  列的大小
  sfieldName
  COLUMN_SIZE
  stype
  int
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  columnSize
  @/@decimalDigits
  sname
  decimalDigits
  slabel
  小数位数
  sfieldName
  DECIMAL_DIGITS
  stype
  int
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  decimalDigits
  @/@numPrecRadix
  sname
  numPrecRadix
  slabel
  基数
  sfieldName
  NUM_PREC_RADIX
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  numPrecRadix
  @/@nullable
  sname
  nullable
  slabel
  可为空
  sfieldName
  NULLABLE
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  nullable
  @/@remarks
  sname
  remarks
  slabel
  描述
  sfieldName
  REMARKS
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  remarks
  @/@columnDef
  sname
  columnDef
  slabel
  默认值
  sfieldName
  COLUMN_DEF
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  columnDef
  @/@charOctetLength
  sname
  charOctetLength
  slabel
  char 类型
  sfieldName
  CHAR_OCTET_LENGTH
  stype
  int
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  charOctetLength
  @/@ordinalPosition
  sname
  ordinalPosition
  slabel
  列的索
  sfieldName
  ORDINAL_POSITION
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  ordinalPosition
  @/@isNullable
  sname
  isNullable
  slabel
  是否为空
  sfieldName
  IS_NULLABLE
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  isNullable
  @/@scopeCatlog
  sname
  scopeCatlog
  slabel
  表的类别
  sfieldName
  SCOPE_CATLOG
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  scopeCatlog
  @/@scopeSchema
  sname
  scopeSchema
  slabel
  表的模式
  sfieldName
  SCOPE_SCHEMA
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  scopeSchema
  @/@scopeTable
  sname
  scopeTable
  slabel
  表名称
  sfieldName
  SCOPE_TABLE
  stype
  string
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  scopeTable
  @/@sourceDataType
  sname
  sourceDataType
  slabel
  源类型
  sfieldName
  SOURCE_DATA_TYPE
  stype
  short
  soptional
  true
  skey
  false
  sdataField
  true
  sviewField
  true
  sreadField
  true
  screateEditor
  true
  seditEditor
  true
  sviewEditor
  true
  sgridEditor
  true
  squeryEditor
  true
  sreadOnly
  false
  seditable
  true
  sshowLabel
  true
  slabelAlign
  right
  slabelVAlign
  baseline
  svalidateAllowBlank
  true
  LvalidateOnBlur
  true
  LallowDecimals
  true
  LallowNegative
  true
  sshowInTable
  true
  sgridFixed
  false
  sgridHidden
  false
  sgridHideable
  true
  sgridSortable
  false
  scolumnLocked
  false
  sgridGroupable
  true
  sgridMenuDisabled
  false
  sgridResizable
  true
  sdescriptors
  xworker.dataObject.db.DbDataObject/@attribute
  sth_createIndex
  false
  sid
  sourceDataType
  @/@actions
  sname
  actions
  sdescriptors
  xworker.dataObject.db.DbDataObject/@actions1
  sth_createIndex
  false
  sid
  actions
    @/@actions/@query
    sname
    query
    sisSynchronized
    false
    sthrowException
    true
    suseOtherAction
    false
    svarScope
    Global
    sdisableGlobalContext
    false
    Scode
#$@text#$@
import xworker.dataObject.DataObject;

def catalog = actionContext.get("catalog");
def schemaPattern = actionContext.get("schemaPattern");
def tableNamePattern = actionContext.get("tableNamePattern");
def columnNamePattern = actionContext.get("columnNamePattern");

def datas = [];
def metadata = con.getMetaData();
def rs = metadata.getColumns(catalog, schemaPattern, tableNamePattern, columnNamePattern);
try{    
    def thing = world.getThing("xworker.db.jdbc.metadata.Columns");
    while(rs.next()){
        def dataObject = new DataObject("xworker.db.jdbc.metadata.Columns");
        dataObject.setInited(false);
        for(attr in thing.get("attribute@")){
            dataObject.put(attr.name, rs.getString(attr.fieldName));
        }
        dataObject.setInited(true);
        datas.add(dataObject);
    }
}finally{
    rs.close();
}
return datas;
#$@text#$@
    sdescriptors
    xworker.lang.actions.Actions/@GroovyAction
    sth_createIndex
    false
    sid
    query
      @/@actions/@query/@contexts
      sname
      contexts
      slabel
      contexts
      sdescriptors
      xworker.lang.actions.Inout/@contexts
      sid
      contexts
        @/@actions/@query/@contexts/@dataSource
        sname
        dataSource
        sdisable
        false
        sonError
        ignore
        spreventError
        false
        sinherit
        true
        sdescriptors
        xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
        sid
        dataSource
      @/@actions/@query/@ins
      sisValidate
      false
      sname
      ins
      sdescriptors
      xworker.lang.actions.Inout/@ins
      sth_createIndex
      false
      sid
      ins
        @/@actions/@query/@ins/@catalog
        sname
        catalog
        stypeCheck
        false
        soptional
        true
        scheck
        false
        scheckLevel
        exception
        sdescriptors
        xworker.lang.actions.Inout/@ins/@param
        sth_createIndex
        false
        sid
        catalog
        @/@actions/@query/@ins/@schemaPattern
        sname
        schemaPattern
        stypeCheck
        false
        soptional
        true
        scheck
        false
        scheckLevel
        exception
        sdescriptors
        xworker.lang.actions.Inout/@ins/@param
        sth_createIndex
        false
        sid
        schemaPattern
        @/@actions/@query/@ins/@tableNamePattern
        sname
        tableNamePattern
        stypeCheck
        false
        soptional
        true
        scheck
        false
        scheckLevel
        exception
        sdescriptors
        xworker.lang.actions.Inout/@ins/@param
        sth_createIndex
        false
        sid
        tableNamePattern
        @/@actions/@query/@ins/@columnNamePattern
        sname
        columnNamePattern
        stypeCheck
        false
        soptional
        true
        scheck
        false
        scheckLevel
        exception
        sdescriptors
        xworker.lang.actions.Inout/@ins/@param
        sth_createIndex
        false
        sid
        columnNamePattern
