• Home
• org.xworker
• xworker_dataobject
• 1.4.1
• source code
• DbDataObject.xer.txt

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

xworker.dataObject.db.DbDataObject.xer.txt Maven / Gradle / Ivy

^1437966066998
@
sname
DbDataObject
slabel
DbDataObject
sdescriptors
xworker.lang.MetaDescriptor3
sextends
xworker.dataObject.DataObject
smany
true
seditCols
2
sinitialization
false
smodifier
public
sinheritDescription
false
sicon
icons/database_table.png
Sdescription
#$@text#$@
数据库数据对象，映射数据库中的表。

DDL

    现在通过Hibernate执行 DDL，在属性中可以看到相关字段，其中自动增长的标识字段使用generate=native，oralce会创建一个名为hibernate_sequence的序列，其他请参看hibenrate。
#$@text#$@
snotXmlAttribute
false
sid
DbDataObject
@/@actions
sname
actions
sid
actions
slabel
actions
sdescriptors
xworker.lang.MetaDescriptor3/@actions
@/@actions/@create
sname
doCreate
slabel
doCreate
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
create
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
ssaveReturn
false
sid
create
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sth_createIndex
false
@/@actions/@create/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@create/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@update
sname
doUpdate
slabel
doUpdate
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
update
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
ssaveReturn
false
sid
update
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sth_createIndex
false
@/@actions/@update/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@update/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@updateBatch
sname
updateBatch
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
updateBatch
sdisableGlobalContext
false
sdescription
批量更新，根据查询条件查找并更新符合条件的记录。
sid
updateBatch
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sth_createIndex
false
@/@actions/@updateBatch/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@updateBatch/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@updateBatch/@ins
sisValidate
false
sname
ins
sid
ins
slabel
ins
sdescriptors
xworker.lang.actions.Inout/@ins
@/@actions/@updateBatch/@ins/@theData
sname
theData
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
数据对象。
sid
theData
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@updateBatch/@ins/@conditionData
sname
conditionData
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
查询条件数据。
sdescriptors
xworker.lang.actions.Inout/@ins/@param
sth_createIndex
false
@/@actions/@updateBatch/@ins/@conditionConfig
sname
conditionConfig
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescriptors
xworker.lang.actions.Inout/@ins/@param
sth_createIndex
false
@/@actions/@delete
sname
doDelete
slabel
doDelete
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
delete
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
ssaveReturn
false
sid
delete
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sth_createIndex
false
@/@actions/@delete/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@delete/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@deleteBatch
sname
deleteBatch
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
deleteBatch
sdisableGlobalContext
false
sdescription
批量删除，根据查询条件查找并删除符合条件的记录。
sid
deleteBatch
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sth_createIndex
false
@/@actions/@deleteBatch/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@deleteBatch/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@deleteBatch/@ins
sisValidate
false
sname
ins
sid
ins
slabel
ins
sdescriptors
xworker.lang.actions.Inout/@ins
@/@actions/@deleteBatch/@ins/@theData
sname
theData
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
数据对象。
sid
theData
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@deleteBatch/@ins/@conditionData
sname
conditionData
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
查询条件数据。
sdescriptors
xworker.lang.actions.Inout/@ins/@param
sth_createIndex
false
@/@actions/@deleteBatch/@ins/@conditionConfig
sname
conditionConfig
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescriptors
xworker.lang.actions.Inout/@ins/@param
sth_createIndex
false
@/@actions/@load
sname
doLoad
slabel
doLoad
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Global
sdisableGlobalContext
false
Scode
#$@text#$@
import xworker.dataObject.DataObject;
import xworker.dataObject.DataObjectList;
import xworker.dataObject.utils.DbUtil;

def keyDatas = theData.getKeyAndDatas();
if(keyDatas == null || keyDatas.length == 0){
    log.warn("no keys data cannot load, dataObjectPath=" + theData.getMetadata().getDescriptor().metadata.path);
    throw new Exception("No keys, data cannot load");
}

//生成insert sql语句
def rattributes = theData.getMetadata().getAttributes();
def attributes = [];
for(int i=0; i查询参数

sid
datas
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@query/@ins/@condition
sname
condition
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
查询条件定义
sid
condition
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@iterator
sname
iterator
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
suseInnerJava
false
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
iterator
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
screateLocalVarScope
false
ssaveReturn
false
sdebugLog
false
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@iterator/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@iterator/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@iterator/@ins
sisValidate
false
sname
ins
sid
ins
slabel
ins
sdescriptors
xworker.lang.actions.Inout/@ins
@/@actions/@iterator/@ins/@datas
sname
action
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
查询参数
sid
datas
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@generateId
sname
generateSeqId
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Global
sdisableGlobalContext
false
Scode
#$@text#$@
def seqName = self.sequenceName;
if(seqName == null || seqName ==""){
    if(self.idGenerateType == "native"){
        //native是通过hibernate生成的
        seqName = "HIBERNATE_SEQUENCE";
    }
}
if(seqName == null || seqName ==""){
    throw new Exception("SequenceName is null");
}

int dotIndex = seqName.indexOf(".");
if(dotIndex != -1){
	//使用从表中读取Seq的方法
	String tableName = seqName.substring(0, dotIndex);
	String sName = seqName.substring(dotIndex + 1, seqName.length());
	
	def rs = null;
	def ps = null;
	try{
		ps = con.prepareStatement("select seq from " + tableName + " where name = ? for update");
		ps.setString(1, sName);
		rs = ps.executeQuery();
		if(rs.next()){
			int seq = rs.getInt("seq");
			
			rs.close();
			ps.close();
			
			ps = con.prepareStatement("update " + tableName + " set seq = seq +1 where name=?");
			ps.setString(1, sName);
			ps.execute();
			
			return seq +1;
		}else{
			rs.close();
			ps.close();
			
			ps = con.prepareStatement("insert into " + tableName + "(name, seq) values(?, 1)");
			ps.setString(1, sName);
			ps.execute();
			return 1;
		}
	}finally{
	    if(rs != null){
	        rs.close();
	    }
	    if(ps != null){
	        ps.close();
	    }
	}
}else{
    def driverName = con.getMetaData().getDriverName();
    if(driverName != null && driverName.indexOf("Oracle") != -1){
        //oracle数据库
        def sql = "select " + seqName + ".nextval as nextID from dual";
        def pst = con.prepareStatement(sql);
        def rs = null;
        try{
            rs = pst.executeQuery();
            if(rs.next()){
                return rs.getInt("nextID");
            }else{
                throw new Exception("cannot get seq from " + self.sequenceName);
            }
        }finally{
             if(rs != null){
                 rs.close();
             }
             if(pst != null){
                 pst.close();
             }
        }
    }else{
        log.warn("database driver " + driverName + " not supported sequence");
        //throw new Exception("database driver " + driverName + " not supported sequence");
    }
}
#$@text#$@
sinterpretationType
Action
screateLocalVarScope
false
ssaveReturn
false
sid
generateId
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
@/@actions/@generateId/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@generateId/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@generateNativeId
sname
generateNativeId
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Local
sdisableGlobalContext
false
Scode
#$@text#$@
String driverName = con.getMetaData().getDriverName();
if(driverName != null && driverName.indexOf("Oracle") != -1){
	return self.doAction("generateSeqId", actionContext);     
}else{
    return null;
}
#$@text#$@
sinterpretationType
Action
screateLocalVarScope
false
ssaveReturn
false
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@getCreateTableSql
sname
getCreateTableSql
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Global
sdisableGlobalContext
false
Scode
#$@text#$@
def sqlType = "oracle";
def tableName = self.tableName;
//数据库字段
def sql = "create table " + tableName;
for(attr in self.getChilds("attribute")){
    if(attr.getBoolean("dataField")){
        def columnName = attr.fieldName;
        def columnType = "";
        def type = attr.type;
        if(type == null || type == ""){
            type = "string";
        }
        def length = attr.length;
        def precision = attr.precision;
        def primaryKey = attr.key;
        switch(type){
            case "string":
                columnType = "
            case "byte":
            case "short":
            case "int":
            case "long":
            case "float":
            case "double":
            case "boolean":
            case "date":
            case "datetime":
            case "time":
            case "byte[]":
            case "stream":            
        }
        if(primaryKey == ""){
        }
    }
}
#$@text#$@
sid
getCreateTableSql
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
@/@actions/@getDropTableSql
sname
getDropTableSql
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Global
sdisableGlobalContext
false
sid
getDropTableSql
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
@/@actions/@getOracleSqlType
sname
getOracleSqlType
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Global
sdisableGlobalContext
false
Scode
#$@text#$@
def type = attribute.type;
if(type == null || type == ""){
    type = "string";
}
def length = attr.length;
def precision = attr.precision;
def primaryKey = attr.key;
#$@text#$@
sid
getOracleSqlType
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
@/@actions/@getOracleSqlType/@ins
sisValidate
false
sname
ins
sid
ins
slabel
ins
sdescriptors
xworker.lang.actions.Inout/@ins
@/@actions/@getOracleSqlType/@ins/@type
sname
type
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sid
type
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@getOracleSqlType/@ins/@length
sname
length
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sid
length
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@getOracleSqlType/@ins/@precision
sname
precision
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sid
precision
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@getOracleSqlType/@ins/@primaryKey
sname
primaryKey
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sid
primaryKey
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@getDerbySqlType
sname
getDerbySqlType
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Global
sdisableGlobalContext
false
Scode
#$@text#$@
switch(type){
    case "string":
        return "varchar(" + length + ")";
    case "byte":
    case "short":
    case "int":
    case "long":
    case "float":
    case "double":
    case "boolean":
    case "date":
    case "datetime":
    case "time":
    case "byte[]":
    case "stream":    
}
#$@text#$@
sid
getDerbySqlType
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
@/@actions/@getDerbySqlType/@ins
sisValidate
false
sname
ins
sid
ins
slabel
ins
sdescriptors
xworker.lang.actions.Inout/@ins
@/@actions/@getDerbySqlType/@ins/@type
sname
type
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sid
type
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@getDerbySqlType/@ins/@length
sname
length
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sid
length
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@getDerbySqlType/@ins/@precision
sname
precision
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sid
precision
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@getDerbySqlType/@ins/@primaryKey
sname
primaryKey
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sid
primaryKey
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@queryOracle
sname
queryOraclePage
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Global
sdisableGlobalContext
false
Scode
#$@text#$@
import xworker.dataObject.DataObject;
import xworker.dataObject.DataObjectList;
import xworker.dataObject.utils.DbUtil;

def pst = null;
def rs = null;
try{
    //查询总数
    def countSql = "select count(*) from (" + sql + ") ";
    pst = con.prepareStatement(countSql);
    
    //设置查询参数
    self.doAction("setStatementParams", actionContext, ["cds":cds, "pst":pst, "attributes":attributes, "index":1]);
    rs = pst.executeQuery();
    rs.next();
    pageInfo.totalCount = rs.getInt(1);
    rs.close();
    pst.close();
    
    //分页查询
    sql = "select * from (select t.*, rownum rowno from (" + sql + ") t ) where rowno between ? and ?";
    if(self.getBoolean("showSql")){
        log.info(sql);
    }
    pst = con.prepareStatement(sql);
    self.doAction("setStatementParams", actionContext, ["cds":cds, "pst":pst, "attributes":attributes, "index":1]);
    if(pageInfo != null && pageInfo.limit != 0){
        def index = cds.size() + 1;
        def start = pageInfo.start + 1;
        pst.setInt(index, start);
        pst.setInt(index + 1, start + pageInfo.limit - 1);
    }
    
    //执行sql
    rs = pst.executeQuery();
    def ds =[];
    attributes = self.get("attribute@"); //取查询数据对象实际的列
    while(rs.next()){
        //构造对象
        def data = new DataObject(self);
        data.setInited(false);
        
        //设置属性值
        for(int i=0; i= ? AND rownum <= ?";
    if(self.getBoolean("showSql")){
        log.info(sql);
    }
    pst = con.prepareStatement(sql);
    self.doAction("setStatementParams", actionContext, ["cds":cds, "pst":pst, "attributes":attributes, "index":1]);
    if(pageInfo != null && pageInfo.limit != 0){
        def index = cds.size() + 1;
        def start = pageInfo.start + 1;
        pst.setInt(index, start);
        pst.setInt(index + 1, start + pageInfo.limit - 1);
    }
    
    //执行sql
    rs = pst.executeQuery();
    def ds =[];
    attributes = self.get("attribute@"); //取查询数据对象实际的列
    while(rs.next()){
        //构造对象
        def data = new DataObject(self);
        data.setInited(false);
        
        //设置属性值
        for(int i=0; i返回属性是否可以映射，比如数据库数据对象、CSV数据对象和Excel等数据对象的属性适合表字段、CSV或Excel的列映射的。

如果不能映射，直接抛出有说明文字的异常。
映射用于快速编辑属性。
#$@text#$@
sid
isMappingAble
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
@/@actions/@isMappingAble/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@isMappingAble/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@getMappingFields
sname
getMappingFields
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Local
sdisableGlobalContext
false
Scode
#$@text#$@
import xworker.dataObject.DataObject;

import ognl.Ognl;

//获取全部的表
def datas = [];
def metadata = con.getMetaData();
def rs = metadata.getColumns(null, null, self.tableName, null);
getColumns(rs, datas);
if(datas.size() == 0){
    //转化为大写重新读一次，比如oracle数据库有时表名是小写读不出来，大写可以
    rs = metadata.getColumns(null, null, self.tableName.toUpperCase(), null);
    getColumns(rs, datas);
}
if(datas.size() == 0){
    //转化为小写重新读一次
    rs = metadata.getColumns(null, null, self.tableName.toLowerCase(), null);
    getColumns(rs, datas);
}

return datas;

def getColumns(rs, columns){
    try{    
        while(rs.next()){
            def data = [:];
            data.put("colName", rs.getString("COLUMN_NAME"));
            data.put("colTitle", rs.getString("REMARKS"));
           
            columns.add(data);
        }
    }finally{
        rs.close();
    }
}
#$@text#$@
sinterpretationType
Action
sid
getMappingFields
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
@/@actions/@getMappingFields/@contexts
sname
contexts
sid
contexts
slabel
contexts
sdescriptors
xworker.lang.actions.Inout/@contexts
@/@actions/@getMappingFields/@contexts/@dataSource
sname
dataSource
sconnectionName
con
stransaction
false
sdataSourcePath
self.dataSource
sconflicting
ignore
sdisable
false
sonError
ignore
spreventError
false
sinherit
true
sid
dataSource
sdescriptors
xworker.db.jdbc.DataSouceActionContext,xworker.lang.actions.Inout/@contexts/@context
@/@actions/@getMappingAttributeName
sname
getMappingAttributeName
sisSynchronized
false
sthrowException
true
suseOtherAction
false
svarScope
Local
sdisableGlobalContext
false
scode
return "fieldName";
sinterpretationType
Action
sid
getMappingAttributeName
sdescriptors
xworker.lang.actions.Actions/@GroovyAction
@/@actions/@getAttributeDescriptor
sname
getAttributeDescriptor
stype
string
svalue
xworker.dataObject.db.DbDataObject/@attribute
sinterpretationType
Self
svarScope
Local
sid
getAttributeDescriptor
sdescriptors
xworker.lang.actions.Actions/@ValueFactory
@/@actions/@setStatementParams
sname
setStatementParams
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
setStatementParams
sdisableGlobalContext
false
sid
setStatementParams
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sth_createIndex
false
@/@actions/@setStatementParams/@ins
sisValidate
false
sname
ins
sid
ins
slabel
ins
sdescriptors
xworker.lang.actions.Inout/@ins
@/@actions/@setStatementParams/@ins/@cds
sname
cds
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
查询条件列表
sid
cds
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@setStatementParams/@ins/@attributes
sname
attributes
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
属性列表
sid
attributes
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@setStatementParams/@ins/@pst
sname
pst
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
SQL Statement.
sid
pst
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@setStatementParams/@ins/@index
sname
index
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescription
起始序号。
sid
index
sdescriptors
xworker.lang.actions.Inout/@ins/@param
@/@actions/@mapping2ddl
sname
mapping2ddl
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
mapping2ddl
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
ssaveReturn
false
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sth_createIndex
false
sth_mark
false
@/@actions/@menu_hibernateDDL
sname
menu_hibernateDDL
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
menu_hibernateDDL
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
screateLocalVarScope
false
ssaveReturn
false
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@loadFromResult
sname
loadFromResultSet
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
suseInnerJava
false
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
loadFromResultSet
sdisableGlobalContext
false
sdescription
从java.sql.ResultSet中读取数据，返回List<DataObject>，如果没有数据返回空的List。
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
screateLocalVarScope
false
ssaveReturn
false
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@loadFromResult/@ins
sisValidate
false
sname
ins
sdescriptors
xworker.lang.actions.Inout/@ins
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@loadFromResult/@ins/@resultSet
sname
resultSet
stype
java.sql.ResultSet
stypeCheck
false
soptional
true
scheck
false
scheckLevel
exception
sdescriptors
xworker.lang.actions.Inout/@ins/@param
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@iteratorSqlServer2005Page
sname
iteratorSqlServer2005Page
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
suseInnerJava
false
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
iteratorSqlServer2005Page
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
screateLocalVarScope
false
ssaveReturn
false
sdebugLog
false
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@iteratorMysqlPage
sname
iteratorMysqlPage
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
suseInnerJava
false
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
iteratorMysqlPage
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
screateLocalVarScope
false
ssaveReturn
false
sdebugLog
false
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@iteratorDerbyPage
sname
iteratorDerbyPage
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
suseInnerJava
false
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
iteratorDerbyPage
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
screateLocalVarScope
false
ssaveReturn
false
sdebugLog
false
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@actions/@iteratorOraclePage
sname
iteratorOraclePage
sisSynchronized
false
sthrowException
true
suseOtherAction
false
suseOuterJava
true
suseInnerJava
false
souterClassName
xworker.dataObject.db.DbDataObject
smethodName
iteratorOraclePage
sdisableGlobalContext
false
sattributeTemplate
false
sinterpretationType
Action
svarScope
Global
screateLocalVarScope
false
ssaveReturn
false
sdebugLog
false
sdescriptors
xworker.lang.actions.Actions/@JavaAction
sinheritDescription
false
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@name
sname
name
sshowLabel
true
sgroup
DB
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
snotXmlAttribute
false
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@label
sname
label
sshowLabel
true
sgroup
DB
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
snotXmlAttribute
false
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@tableName
sname
tableName
slabel
表名
sinputtype
openWindow
ssize
40
scolspan
2
sgroup
DB
sinputattrs
xworker.dataObject.swt.SelectDBTableNameDialog/@shell
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
false
LallowDecimals
false
LallowNegative
false
sid
tableName
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
@/@dbConfigPath
sname
dataSource
slabel
数据源
sinputtype
openWindow
ssize
60
scolspan
2
sgroup
DB
sinputattrs
xworker.swt.xworker.attributeEditor.openWins.SelectThingOpenWindow/@shell|descriptor=xworker.db.jdbc.DataSource,returnType=path
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
false
LallowDecimals
false
LallowNegative
false
sid
dbConfigPath
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
@/@showSql
sname
showSql
sinputtype
truefalse
sgroup
DB
sdefault
false
sinheritDescription
false
sdescription
是否显示SQL语句。
LvalidateOnBlur
false
LallowDecimals
false
LallowNegative
false
sid
showSql
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
@/@querySqlForQueryOnly
sname
querySqlForQueryOnly
slabel
查询 SQL只为查询
sinputtype
truefalse
sgroup
DB
sreadOnly
false
sdefault
false
sinheritDescription
false
sdescription
查询SQL是否只是在查询中使用。
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
sth_createIndex
false
sth_mark
false
@/@querySql
sname
querySql
slabel
查询SQL
sinputtype
textarea
scolspan
2
sgroup
DB
sreadOnly
false
sinheritDescription
false
sdescription
如果表名不存在，可以吃用查询SQL（一般是子查询）作为查询的表。
svalidateAllowBlank
true
LvalidateOnBlur
false
LallowDecimals
false
LallowNegative
false
sid
querySql
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
@/@description
sname
description
sinputtype
html
sshowLabel
true
sgroup
DB
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
sth_createIndex
false
sth_mark
false
@/@attribute
sname
attribute
slabel
属性
sdescriptors
xworker.lang.MetaDescriptor3/@thing
sextends
xworker.dataObject.Attribute
smany
true
seditCols
2
sinitialization
false
smodifier
public
sinheritDescription
true
snotXmlAttribute
false
sid
attribute
@/@attribute/@name
sname
name
sgroup
Attribute
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
sid
name
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
@/@attribute/@label
sname
label
sgroup
Attribute
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
sid
label
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
@/@attribute/@fieldName
sname
fieldName
slabel
字段名
ssize
60
scolspan
2
sgroup
Attribute
sreadOnly
false
sinheritDescription
false
sdescription
对应数据库中的字段名，如果没有那么数据库的字段名默认为属性名。
svalidateAllowBlank
true
LvalidateOnBlur
false
LallowDecimals
false
LallowNegative
false
sid
fieldName
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
@/@attribute/@sql
sname
sql
sinputtype
textarea
sgroup
Attribute
sinputattrs
codeName= codeType= wrap=false fillBoth=true cols= rows=80
sreadOnly
false
sinheritDescription
false
sdescription
如果不为空一般在查询时使用该sql替代字段名。
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
sth_createIndex
false
sth_mark
false
@/@attribute/@index
sname
index
sshowLabel
true
ssize
40
sgroup
Hibernate-DDL
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
snotXmlAttribute
false
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@attribute/@unique-key
sname
unique-key
slabel
unique-key
sshowLabel
true
sgroup
Hibernate-DDL
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
false
LallowDecimals
false
LallowNegative
false
snotXmlAttribute
false
sid
unique-key
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
@/@attribute/@generator
sname
generator
sinputtype
select
sshowLabel
true
sgroup
Hibernate-DDL
sreadOnly
false
sinheritDescription
false
svalidateAllowBlank
true
LvalidateOnBlur
true
LallowDecimals
true
LallowNegative
true
snotXmlAttribute
false
sdescriptors
xworker.lang.MetaDescriptor3/@attribute
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@attribute/@generator/@native
sname
native
slabel
native
svalue
native
sid
native
sdescriptors
xworker.lang.MetaDescriptor3/@attribute/@value
@/@thing
sname
thing
slabel
事物
sdescriptors
xworker.lang.MetaDescriptor3/@thing
sextends
xworker.dataObject.RelationDataObject
sid
thing
@/@actions1
sname
actions
slabel
Actions
sdescriptors
xworker.lang.MetaDescriptor2/@thing
sextends
xworker.lang.actions.Actions
sid
actions1
@/@actions1/@name
sname
name
sid
name
sdescriptors
xworker.lang.MetaDescriptor2/@attribute
@/@sswtMenus
sname
sswtMenus
sid
sswtMenus
slabel
sswtMenus
sdescriptors
xworker.lang.MetaDescriptor3/@swtMenus
@/@sswtMenus/@menuDefine
sname
menuDefine
sid
menuDefine
slabel
menuDefine
sdescriptors
xworker.lang.MetaDescriptor3/@swtMenus/@menuDefine
@/@sswtMenus/@menuDefine/@dataObject
sname
dataObject
slabel
数据对象
sid
dataObject
sdescriptors
xworker.lang.ThingMenu/@menuDefine/@menu
@/@sswtMenus/@dataObject
sname
dataObject
stype
data
smenuType
dataObject
sid
dataObject
slabel
dataObject
sdescriptors
xworker.lang.MetaDescriptor3/@swtMenus/@menuSetting
@/@sswtMenus/@dataObject/@editData
sname
editData
slabel
编辑数据
surl
xworker.dataObject.DataObject/@actions/@menu_editData
sisSplit
false
sattachParam
true
sid
editData
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
@/@sswtMenus/@dataObject/@split1
sname
split1
sisSplit
true
sattachParam
true
sid
split1
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
@/@sswtMenus/@dataObject/@quickEditItem
sname
quickEditItem
slabel
映射属性
sshell
xworker.dataObject.swt.AttributeMappingEditor/@shell
sisSplit
false
sattachParam
true
sid
quickEditItem
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
@/@sswtMenus/@dataObject/@split2
sname
split2
sisSplit
true
sattachParam
true
sid
split2
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
@/@sswtMenus/@dataObject/@queryStaticMenu
sname
queryStaticMenu
slabel
添加属性
sisSplit
false
sattachParam
true
sid
queryStaticMenu
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
@/@sswtMenus/@dataObject/@queryStaticMenu/@importGrupAndAggrigate
sname
importAttribute
slabel
从数据对象导入属性
sshell
xworker.dataObject.swt.ImportAttributeDialog/@shell
sisSplit
false
sattachParam
true
sid
importGrupAndAggrigate
sdescriptors
xworker.lang.Menu/@menu
@/@sswtMenus/@dataObject/@split3
sname
split3
sisSplit
true
sattachParam
true
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
sth_createIndex
false
@/@sswtMenus/@dataObject/@SQL
sname
SQL
sisSplit
false
sattachParam
true
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
sth_createIndex
false
@/@sswtMenus/@dataObject/@SQL/@generateSimpleSql
sname
generateSimpleSql
slabel
生成简单SQL
sshell
xworker.dataObject.swt.GenerateSimpleSQLDialog
sisSplit
false
sattachParam
true
sdescriptors
xworker.lang.Menu/@menu
sth_createIndex
false
@/@sswtMenus/@dataObject/@split4
sname
split4
sisSplit
true
sattachParam
true
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
sth_createIndex
false
sth_mark
false
@/@sswtMenus/@dataObject/@Java
sname
Java
sisSplit
false
sattachParam
true
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
sth_createIndex
false
sth_mark
false
@/@sswtMenus/@dataObject/@Java/@toJavaModel
sname
toJavaModel
slabel
生成JavaModel
surl
xworker.dataObject.DataObject/@actions/@menu_toJavaModel
sisSplit
false
sattachParam
true
sdescriptors
xworker.lang.Menu/@menu
sth_createIndex
false
sth_mark
false
@/@sswtMenus/@dataObject/@split5
sname
split5
sisSplit
true
sattachParam
true
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@sswtMenus/@dataObject/@DDL
sname
DDL
sisSplit
false
sattachParam
true
sdescriptors
xworker.lang.ThingMenu/@menuSetting/@menu
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false
@/@sswtMenus/@dataObject/@DDL/@hibernateDDL
sname
hibernateDDL
slabel
使用Hibernate执行DDL
surl
xworker.dataObject.db.DbDataObject/@actions/@menu_hibernateDDL
sisSplit
false
sattachParam
true
sdescriptors
xworker.lang.Menu/@menu
sth_createIndex
false
sth_registMyChilds
false
sth_mark
false