comeon
- 浏览: 61043 次
- 性别:
- 来自: 北京
-
文章分类
最新评论
-
uglypeak：
我试过了，添加了永久的licm，再db2licm -l查看，还 ...
DB2 Lisence 过期问题 -
zhameng：
兄弟，拜托加点注释行不？
Dorado 动态创建Dataset实例
Dorado 动态创建Dataset实例来自“dorado 5原理、特性与高级用法 V1.0.doc”.
package sample.skills.createDatasetTest;
import com.bstek.dorado.data.Dataset;
import com.bstek.dorado.data.DatasetListener;
import com.bstek.dorado.data.Field;
import com.bstek.dorado.data.ParameterSet;
import com.bstek.dorado.data.db.AutoDBField;
import com.bstek.dorado.data.db.AutoSqlDataset;
import com.bstek.dorado.data.db.BaseMatchRule;
import com.bstek.dorado.utils.collection.ObjectCollection;
import com.bstek.dorado.utils.variant.DataType;
import com.bstek.dorado.utils.variant.Variant;
import com.bstek.dorado.view.DefaultViewModel;
import com.bstek.dorado.view.EventHandler;
import com.bstek.dorado.view.ViewModel;
import com.bstek.dorado.view.control.Button;
import com.bstek.dorado.view.control.Control;
import com.bstek.dorado.view.control.DataPilot;
import com.bstek.dorado.view.control.PagePilot;
import com.bstek.dorado.view.control.autoform.AutoForm;
import com.bstek.dorado.view.control.autoform.CustomFormElement;
import com.bstek.dorado.view.control.autoform.FormGroup;
import com.bstek.dorado.view.control.command.Command;
import com.bstek.dorado.view.control.command.QueryCommand;
import com.bstek.dorado.view.control.command.UpdateCommand;
import com.bstek.dorado.view.control.dropdown.DatasetDropDown;
import com.bstek.dorado.view.control.dropdown.DropDown;
import com.bstek.dorado.view.control.dropdown.ListDropDown;
import com.bstek.dorado.view.control.table.DataTable;
import com.bstek.dorado.view.data.DatasetWrapper;
import com.bstek.dorado.view.data.FormDataset;
import com.bstek.dorado.view.data.ViewDataset;
import com.bstek.dorado.view.data.ViewField;
import com.bstek.dorado.view.data.validate.Validator;
import com.bstek.dorado.view.data.validate.impl.RequiredValidator;
public class Sample_4_1_All_ViewModel extends DefaultViewModel {
public void init(int state) throws Exception {
this.createDataset("Form", "datasetForm");
this.createDataset("Wrapper", "datasetEmployee");
this.createDataset("Wrapper", "datasetDept");
super.init(state);
if (state == ViewModel.STATE_VIEW) {
this.createControl("ListDropDown", "dropdownSex");
this.createControl("DatasetDropDown", "dropdownDept");
this.createControl("QueryCommand", "commandQuery");
this.createControl("Button", "buttonQuery");
this.createControl("AutoForm", "formForm");
this.createControl("PagePilot", "pagepilotEmployee");
this.createControl("DataPilot", "datapilotEmployee");
this.createControl("DataTable", "tableEmployee");
this.createControl("UpdateCommand", "commandUpdate");
this.createControl("Button", "buttonSave");
EventHandler event = new EventHandler("onDatasetsPrepared");
StringBuffer script = new StringBuffer();
script.append("var record = datasetForm.getCurrent();");
script.append("record.setValue(\"EMPLOYEE_ID\",\"ANLIN\");");
event.setScript(script.toString());
this.addEventHandler(event);
}
}
protected void initDataset(ViewDataset dataset) throws Exception {
super.initDataset(dataset);
if (dataset instanceof FormDataset) {
if ("datasetForm".equals(dataset.getId())) {
if (this.getState() == ViewModel.STATE_VIEW) {
dataset.setAutoLoadData(false);
dataset.setInsertOnEmpty(true);
}
Field fieldEMPLOYEE_ID = dataset.addField("EMPLOYEE_ID");
fieldEMPLOYEE_ID.setLabel("员工编号");
Field fieldEMPLOYEE_NAME = dataset.addField("EMPLOYEE_NAME");
fieldEMPLOYEE_NAME.setLabel("员工姓名");
Field fieldDEPT_ID = dataset.addField("DEPT_ID");
fieldDEPT_ID.setLabel("部门");
if (this.getState() == ViewModel.STATE_VIEW) {
((ViewField) fieldDEPT_ID).setDropDown("dropdownDept");
}
Field fieldSEX = dataset.addField("SEX");
fieldSEX.setLabel("性别");
}
} else if (dataset instanceof DatasetWrapper) {
if ("datasetEmployee".equals(dataset.getId())) {
dataset.setPageSize(10);
DatasetListener datasetListener = new CreateDSHand_datasetEmployeeListener();
dataset.addDatasetListener(datasetListener);
Variant v = new Variant(DataType.STRING);
dataset.parameters().setVariant("EMPLOYEE_ID", v);
DatasetWrapper datasetEmployeeDW = (DatasetWrapper) dataset;
datasetEmployeeDW.setWrappedType("AutoSql");
AutoSqlDataset datasetEmployee = (AutoSqlDataset) ((DatasetWrapper) dataset)
.getWrappedDataset();
datasetEmployee.setOriginTable("EMPLOYEE");
datasetEmployee.setKeyFields("EMPLOYEE_ID");
datasetEmployee.addDummyField("select");
AutoDBField field = (AutoDBField) datasetEmployee
.addField("EMPLOYEE_ID");
field.setTable("EMPLOYEE");
field.setOriginField("EMPLOYEE_ID");
field.setLabel("员工编号");
if (field instanceof ViewField) {
Validator validator = new RequiredValidator();
((ViewField) field).addValidator(validator);
}
field = (AutoDBField) datasetEmployee.addField("DEPT_ID");
field.setTable("EMPLOYEE");
field.setOriginField("DEPT_ID");
field.setLabel("部门");
field = (AutoDBField) datasetEmployee.addField("EMPLOYEE_NAME");
field.setTable("EMPLOYEE");
field.setOriginField("EMPLOYEE_NAME");
field.setLabel("员工姓名");
field = (AutoDBField) datasetEmployee.addField("SEX");
field.setTable("EMPLOYEE");
field.setOriginField("SEX");
field.setLabel("性别");
if (field instanceof ViewField) {
((ViewField) field).setDropDown("dropdownSex");
}
field = (AutoDBField) datasetEmployee.addField("BIRTHDAY");
field.setTable("EMPLOYEE");
field.setOriginField("BIRTHDAY");
field.setLabel("出生日期");
field.setDataType(DataType.DATETIME);
field = (AutoDBField) datasetEmployee.addField("MARRIED");
field.setTable("EMPLOYEE");
field.setOriginField("MARRIED");
field.setDataType(DataType.BOOLEAN);
field = (AutoDBField) datasetEmployee.addField("SALARY");
field.setTable("EMPLOYEE");
field.setOriginField("SALARY");
field.setDataType(DataType.DOUBLE);
field = (AutoDBField) datasetEmployee.addField("DEGREE");
field.setTable("EMPLOYEE");
field.setOriginField("DEGREE");
field = (AutoDBField) datasetEmployee.addField("EMAIL");
field.setTable("EMPLOYEE");
field.setOriginField("EMAIL");
field = (AutoDBField) datasetEmployee.addField("WEB");
field.setTable("EMPLOYEE");
field.setOriginField("WEB");
field = (AutoDBField) datasetEmployee.addField("CMNT");
field.setTable("EMPLOYEE");
field.setOriginField("CMNT");
BaseMatchRule baseMatchRule = datasetEmployee.addBaseMatchRule(
"EMPLOYEE_ID", "=", ":EMPLOYEE_ID");
baseMatchRule.setEscapeEnabled(true);
baseMatchRule.setLevel(1);
baseMatchRule.setTable("EMPLOYEE");
baseMatchRule = datasetEmployee.addBaseMatchRule(
"EMPLOYEE_NAME", "like", ":EMPLOYEE_NAME");
baseMatchRule.setEscapeEnabled(true);
baseMatchRule.setLevel(1);
baseMatchRule.setTable("EMPLOYEE");
baseMatchRule = datasetEmployee.addBaseMatchRule("DEPT_ID",
"=", ":DEPT_ID");
baseMatchRule.setEscapeEnabled(true);
baseMatchRule.setLevel(1);
baseMatchRule.setTable("EMPLOYEE");
baseMatchRule = datasetEmployee.addBaseMatchRule("SEX", "=",
":SEX");
baseMatchRule.setEscapeEnabled(true);
baseMatchRule.setLevel(1);
baseMatchRule.setTable("EMPLOYEE");
baseMatchRule.setDataType(DataType.BOOLEAN);
} else if ("datasetDept".equals(dataset.getId())) {
DatasetWrapper datasetDeptDW = (DatasetWrapper) dataset;
datasetDeptDW.setWrappedType("AutoSql");
AutoSqlDataset datasetDept = (AutoSqlDataset) ((DatasetWrapper) dataset)
.getWrappedDataset();
datasetDept.setOriginTable("DEPT");
AutoDBField field = (AutoDBField) datasetDept
.addField("DEPT_ID");
field.setTable("DEPT");
field.setOriginField("DEPT_ID");
field.setLabel("部门");
field = (AutoDBField) datasetDept.addField("BRANCH_ID");
field.setTable("DEPT");
field.setOriginField("BRANCH_ID");
field = (AutoDBField) datasetDept.addField("DEPT_NAME");
field.setTable("DEPT");
field.setOriginField("DEPT_NAME");
}
}
}
protected void initControl(Control control) throws Exception {
System.out.println(5);
super.initControl(control);
if (control instanceof DataTable) {
if ("tableEmployee".equals(control.getId())) {
DataTable tableEmployee = (DataTable) control;
DatasetWrapper datasetEmployeeDW = (DatasetWrapper) this
.getDataset("datasetEmployee");
Dataset datasetEmployee = datasetEmployeeDW.getWrappedDataset();
tableEmployee.setDataset(datasetEmployee.getId());
tableEmployee.setHeight("100%");
tableEmployee.setShowFilterBar(true);
tableEmployee.setShowHScrollBar(false);
tableEmployee.setWidth("100%");
Field selectField = datasetEmployee.getField("select");
tableEmployee.addColumnByField(selectField);
Field EMPLOYEE_IDField = datasetEmployee
.getField("EMPLOYEE_ID");
tableEmployee.addColumnByField(EMPLOYEE_IDField);
Field DEPT_IDField = datasetEmployee.getField("DEPT_ID");
tableEmployee.addColumnByField(DEPT_IDField);
Field EMPLOYEE_NAMEField = datasetEmployee
.getField("EMPLOYEE_NAME");
tableEmployee.addColumnByField(EMPLOYEE_NAMEField);
Field SEXField = datasetEmployee.getField("SEX");
tableEmployee.addColumnByField(SEXField);
Field BIRTHDAYField = datasetEmployee.getField("BIRTHDAY");
tableEmployee.addColumnByField(BIRTHDAYField);
}
} else if (control instanceof AutoForm) {
if ("formForm".equals(control.getId())) {
AutoForm formForm = (AutoForm) control;
formForm.setDataset("datasetForm");
formForm.generateDefaultElements();
ObjectCollection groups = formForm.getGroups();
if (groups.size() > 0) {
FormGroup groupDefault = (FormGroup) groups.get(0);
groupDefault.setTitle("员工查询");
CustomFormElement customFormElement = (CustomFormElement) groupDefault
.addElement("Custom", "buttonQuery");
customFormElement.setControlId("buttonQuery");
customFormElement.setColSpan(2);
customFormElement.setShowLabel(false);
customFormElement.setControlAlign("right");
}
}
} else if (control instanceof Command) {
if (control instanceof QueryCommand) {
if ("commandQuery".equals(control.getId())) {
QueryCommand commandQuery = (QueryCommand) control;
commandQuery.setConditionDataset("datasetForm");
commandQuery.setQueryDataset("datasetEmployee");
EventHandler event = new EventHandler("beforeExecute");
StringBuffer script = new StringBuffer();
script.append("var record = datasetForm.getCurrent();");
script.append("if(record){");
script.append(" var EMPLOYEE_NAME = record.getValue(\"EMPLOYEE_NAME\");");
script.append(" if(EMPLOYEE_NAME){");
script.append(" EMPLOYEE_NAME = \"%\" + EMPLOYEE_NAME + \"%\";");
script.append(" command.parameters().setValue(\"EMPLOYEE_NAME\",EMPLOYEE_NAME);");
script.append(" }else{");
script.append(" command.parameters().removeParameter(\"EMPLOYEE_NAME\");");
script.append(" }");
script.append("}");
event.setScript(script.toString());
commandQuery.addEventHandler(event);
}
} else if (control instanceof UpdateCommand) {
if ("commandUpdate".equals(control.getId())) {
UpdateCommand commandUpdate = (UpdateCommand) control;
commandUpdate.addDatasetInfo("datasetEmployee");
}
}
} else if (control instanceof Button) {
if ("buttonQuery".equals(control.getId())) {
Button buttonQuery = (Button) control;
buttonQuery.setValue("查询");
buttonQuery.setWidth("80");
buttonQuery.setCommand("commandQuery");
} else if ("buttonSave".equals(control.getId())) {
Button buttonSave = (Button) control;
buttonSave.setValue("保存");
buttonSave.setWidth("80");
buttonSave.setCommand("commandUpdate");
}
} else if (control instanceof PagePilot) {
if ("pagepilotEmployee".equals(control.getId())) {
PagePilot pagepilotEmployee = (PagePilot) control;
pagepilotEmployee.setDataset("datasetEmployee");
}
} else if (control instanceof DropDown) {
if (control instanceof ListDropDown) {
if ("dropdownSex".equals(control.getId())) {
ListDropDown dropdownSex = (ListDropDown) control;
dropdownSex.setMapValue(true);
dropdownSex.addItem(null, "<空>");
dropdownSex.addItem("true", "男");
dropdownSex.addItem("false", "女");
}
} else if (control instanceof DatasetDropDown) {
if ("dropdownDept".equals(control.getId())) {
DatasetDropDown dropdownDept = (DatasetDropDown) control;
dropdownDept.setDataset("datasetDept");
dropdownDept.setStartWithEmptyRecord(true);
dropdownDept.setMapValue(true);
dropdownDept.setLabelField("DEPT_NAME");
dropdownDept.setValueField("DEPT_ID");
}
}
} else if (control instanceof DataPilot) {
if ("datapilotEmployee".equals(control.getId())) {
DataPilot datapilotEmployee = (DataPilot) control;
datapilotEmployee.setDataset("datasetEmployee");
}
}
}
protected void initDatasets() throws Exception {
super.initDatasets();
}
protected void initControls() throws Exception {
super.initControls();
}
protected void doLoadData(ViewDataset dataset) throws Exception {
super.doLoadData(dataset);
}
protected void doLoadData() throws Exception {
super.doLoadData();
}
protected void doUpdateData(ParameterSet parameters,
ParameterSet outParameters) throws Exception {
super.doUpdateData(parameters, outParameters);
}
}
分享到：
发表评论
-
java 非阻塞的栈
2015-04-18 13:30 672本例中的非阻塞算法中能确保线程的安全性。 本例是摘自《JAVA ... -
javadoc时候乱码-编码 GBK 的不可映射字符
2013-10-11 12:20 0在eclipse中导出工程的doc时，有时会出现GBK的不 ... -
run nginx in windows
2010-04-09 16:05 1822内容来自：http://nginx.org/en/docs/w ... -
JBPM 下载地址
2010-04-02 13:50 1506jbpm-jpdl-suite-3.2.3.zip 85.1 ... -
marmot framework 高级查询应用体验
2010-03-16 11:28 1422url:marmot/query/query-box.jsp ... -
axis && sap web service SOAPFaultBuilder error
2009-08-12 10:12 2481ERROR INFO: The above snippet o ... -
jprofiler 5.1.2 注册码
2009-02-18 22:53 5738jprofiler 5.1.2 SN: L-FLN#9218 ...
相关推荐
dorado5的Dataset说明,word文档
平时工作中整理的 都是一些比较常用的 Dorado软件dataset字段EL判断表达式 例如：只能输入数字，不能大于xx，电子邮件验证，车牌号码等。 拿来分享，请尊重劳动成果。
dorado 7 前端页面js动态创建控件.
Dataset在运行时会有Server端和Client端两种实例。 Dataset不可以直接显示，一般须通过数据控件来展示其中的数据。 Control： 各种可视化的控件。 包含数据控件和非数据控件。 其中非数据控件一般与数据操作...
dorado5的 Dataset说明,PDF文档
3. 创建dorado工程 17 3.1. 创建工程 17 3.2. 配置数据源 19 3.2.1. 配置datasource.xml 19 3.2.2. copy hsql.jar 22 3.2.3. 连接测试 23 3.2.4. 修改setting.xml文件 23 4. 制作登录界面 25 4.1. 概述 25 4.2. 视图...
Dorado提供了Dataset以及数据感知组件，协助程序员快速的开发各种数据库应用系统。dorado的组件不但让大部分的dorado程序员可以立即开始开发数据库应用系统，也提供了不直接使用数据库作为数据来源的标准企业应用...
资源:eclipse-4.3_for_dorado7_ide.zip 之前公司Dorado7开发环境（含插件开箱即用）压缩包珍藏版，支持dorado9开发。
8.1 动态创建和初始化组件 149 8.2 Dorado组件如何与标准DHTML事件结合 151 9 数据库编程 153 9.1 DBStatement 153 9.2 使用自定义Connection 159 9.3 事务管理 161 9.4 主键处理 164 9.5 方言自定义 170 10 EL...
内含Dorado7插件,Eclipse+dorado7插件合集下载地址，百度网盘永久有效地址。
Dorado Client Api.chm dorado 客户端 手册
中，试着了解其他实例的实现办法，本手册提供一些相关实例的原理以及开发的概要说明， 希望能对你有所帮助。另外其中某些概念或则操作方式描述不够细致的地方请结合BSTEK 公司提供的其他相关文档参考理解。
此资源为dorado7前端框架研发工具，适用于国企，银行等老项目后期维护使用
dorado5最新版本dorado5最新版本
dorado client-api ,dorado client-api
dorado 5 组件详解 v1.1.doc
Dorado Marmot使用简介
基于dorado可以快速创建Rich Internet Application与AJAX应用，使B/S架构应用系统兼美C/S架构应用的界面风格操作习惯等优势。dorado 填补了J2EE架构中表述业务交互的架构空白，以标准化自动化的作业方式，低成本、...
dorado用户指南
dorado7实战 standard lesson 初级中级 示例代码 Dorado7实战-企业通讯录（初级） Dorado7实战-企业通讯录（中级）