📄 pdm2javav5.html
字号:
<html>
<title>从PowerDesigner数据库文件转成java资源文件 V5</title>
<style> <!-- 样式 -->
body{margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px;}
td,body {font-size: 12px;}
input {height:16px; background-color:#FFFFFF; border:1px #999999 solid; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px;}
select {font-size:12px;}
</style>
<body onLoad="initXmlConfigDoc();" onunload="if(xmlFileChanged && confirm('是否保存已经更新的XML配置文件？')) saveXML();">
<table width=100% height=20px border=0 cellpadding=1 cellspacing=1> <!-- 顶部按钮及控件 -->
<tr><td>
<a name="htmlTop"/><span id=loadFile>选择PowerDesign数据库文件:<input
type=file id="fileInput" style="width:300px" onChange="loadXMLToSelect(this.value)" ></span><span id=fileOperate style="display:none">
</span><span id=targetSelect>
</span>
</td>
<td align=right>
<span id=targetButton></span>
</td></tr>
</table>
<table width=100% height=60% border=0 cellpadding=1 cellspacing=1 id=globalVariable style="display:none"><!-- 设置全局变量 -->
<tr><td>
<table width=500 height=200 border=0 align=center bgcolor=#000000 cellpadding=1 cellspacing=1>
<tr height=20px bgcolor=#EEEEEE><td><b>设置全局变量</b></td></tr>
<tr bgcolor=#FFFFFF><td align=center><span id=globalVariableConfigArea></span></td></tr>
</table>
</td></tr>
</table>
<table width=100% height=60% border=0 cellpadding=1 cellspacing=1 id=sortTableConfigArea style="display:none"><!-- 设置全局变量 -->
<tr><td>
<table width=500 height=200 border=0 align=center bgcolor=#000000 cellpadding=1 cellspacing=1>
<tr height=20px bgcolor=#EEEEEE><td><b>设置表排序方式</b></td></tr>
<tr bgcolor=#FFFFFF><td align=center>
<table width="360" height="160" border="0" align="center">
<tr>
<td>排 序：</td>
<td><span id=tableSortOnArea></span></td>
</tr>
<tr>
<td>显 示：</td>
<td><span id=tableShowArea></span></td>
</tr>
<tr>
<td colspan="2" align="center"><input type=button value=" 设 置 " onclick="generateSelect()"></td>
</tr>
</table>
</td></tr>
</table>
</td></tr>
</table>
<table width=100% height=95% border=0 cellpadding=1 cellspacing=1 id=generateResource style="display:none"> <!-- 资源文件-生成 -->
<tr height=20px><td colspan=2 align=right><span id=loadJavaResourceArea></span>
<input type=button onClick="combineResource();document.getElementById('combinedResourceArea').style.display='';document.getElementById('generateResource').style.display='none';" value="合并资源文件">
<input type="button" onclick="generateJRCWindow()" value="新增资源项">
</td></tr>
<tr height=20px><td width=50%>
原中文Java资源：
</td><td width=50%>转出中文的：
</td></tr>
<tr height=50%><td width=50%>
<textarea style="width:100%;height:100%" id="jrChsSource" ></textarea>
</td><td width=50%>
<textarea style="width:100%;height:100%" id="jrChsGenerated" ></textarea>
</td></tr>
<tr height=20px><td width=50%>
原英文Java资源：
</td><td width=50%>
转出英文的：
</td></tr>
<tr height=50%><td width=50%>
<textarea style="width:100%;height:100%" id="jrEngSource" ></textarea>
</td><td width=50%>
<textarea style="width:100%;height:100%" id="jrEngGenerated" ></textarea>
</td></tr>
</table>
<table width=100% height=95% border=0 cellpadding=1 cellspacing=1 id=combinedResourceArea style="display:none"> <!-- 资源文件-合并 -->
<tr height=20px><td>
<table width=100% border=0 cellpadding=0 cellspacing=0>
<tr>
<td>合并后的中文Java资源：</td>
<td align=right><span id=saveJavaResourceArea style="display:none"></span>
<input type=button onClick="document.getElementById('combinedResourceArea').style.display='none';document.getElementById('generateResource').style.display=''; " value=" 返回 ">
</td>
</tr>
</table>
</td></tr>
<tr height=50%><td>
<textarea style="width:100%;height:100%" id="jrChsCombined" ></textarea>
</td></tr>
<tr height=20px><td>
合并后的英文Java资源：
</td></tr>
<tr height=50%><td>
<textarea style="width:100%;height:100%" id="jrEngCombined" ></textarea>
</td></tr>
</table>
<table width=100% height=95% border=0 cellpadding=1 cellspacing=1 id=generateTableDesc style="display:none"> <!-- HTML表结构 -->
<tr height=20px><td align=right colspan=2><input type=button value="使用HTML表格显示" onClick="elementDisplay('generateTableDescHTML')"></td></tr>
<tr><td width=50% valign=top>
<textarea style="width:100%;height:100%" id="pdTableSource" ></textarea>
</td><td width=50% valign=top>
<textarea style="width:100%;height:100%" id="javaNameSource" ></textarea>
</td></tr>
</table>
<table width=100% height=95% border=0 cellpadding=1 cellspacing=1 id=generateTableDescHTML style="display:none"> <!-- 纯文本表结构 -->
<tr height=20px><td align=right colspan=2><input type=button value="纯文本显示" onClick="elementDisplay('generateTableDesc')"></td></tr>
<tr><td width=50% valign=top>
<span id=pdTableSourceSpan></span>
</td><td width=50% valign=top>
<span id=javaNameSourceSpan></span>
</td></tr>
</table>
<table width=100% height=95% border=0 cellpadding=1 cellspacing=1 id=generateBeans style="display:none"> <!-- Java Bean -->
<tr height=20px><td align=right>
<span id=globalJavaSrcPathArea></span>
<input type=button onClick="saveJavaFile()" value="保存文件">
</td></tr>
<tr><td width=100%>
<textarea style="width:100%;height:100%" id="javaBeanSource" ></textarea>
</td></tr>
</table>
<table width=100% height=95% border=0 cellpadding=1 cellspacing=1 id=pdFieldUpperTable style="display:none"> <!-- 大写的PD文件内容 -->
<tr><td width=100%>
<textarea style="width:100%;height:100%" id="pdFieldUpperArea" ></textarea>
</td></tr>
</table>
<table width=100% height=95% border=0 cellpadding=1 cellspacing=1 id=generateJspSource style="display:none"> <!-- 配置生成JSP -->
<tr height=20px><td>
<table width=100% height=100% border=0 >
<tr>
<td>
页面类型：
<select name="jspType" id="jspType" onChange="selectJspTypeChanged();">
<option value="query40%_list60%">查询列表页面</option>
<option value="edit">编辑页面</option>
<option value="view">察看页面</option>
</select>
</td>
<td align=right>
<span id=saveJsp style="display:none"><span id=globalJavaWebPathArea></span>
<span id=jspFileNameArea></span>
<input type=button onclick="saveJSPFile()" value="保存文件">
<input type=button onClick="selectJspTypeChanged();" value="返回配置页面">
</span>
</td>
</tr>
</table>
</td></tr>
<tr><td width=100%>
<table width=100% height=100% border=0 cellpadding=0 cellspacing=0 >
<tr><td valign=top width=200px nowrap id=fieldSelectArea>
<span id=queryField style="display:none">选择查询的字段：<br></span>
<span id=listField style="display:none">选择列表的字段：<br></span>
<span id=viewField style="display:none">选择页面的字段：<br></span>
<span id=editField style="display:none">选择页面的字段：<br></span>
</td><td width=100% valign=top>
<span id=jspSourceArea style="display:none">
<textarea style="width:100%;height:100%;" id="jspSource" ></textarea>
</span>
<span id=jspConfigArea style="display:none">
<table width=100% border=0 id=generateJspButtonArea style="display:none" cellpadding=0 cellspacing=0>
<tr><td align=right>
<table width=100% border=0 cellpadding=0 cellspacing=0>
<tr><td align=left><span id=jspPageCommonSet>
</span></td><td width=50px align=right valign=top nowrap>
<input type=button onClick="generateJspContent()" value="生成代码">
</td></tr>
</table>
</td></tr>
</table>
<span id=queryFieldConfig style="display:none">
</span>
<span id=listFieldConfig style="display:none">
</span>
<span id=editFieldConfig style="display:none">
</span>
<span id=viewFieldConfig style="display:none">
</span>
</span>
</td></tr>
</table>
</td></tr>
</table>
<!-- //Declare Global Variable -->
<script>
<!--//
var xmldoc;
var tables;
var fso = new ActiveXObject("Scripting.FileSystemObject");
var xmlConfigdoc;
var XMLConfigFile = "D:\\GKN\\src\\db\\XMLConfigFile.xml";
var pdmXMLFile;
var xmlFileChanged = false;
//定义通用的表及表内字段的属性
var tableName = "";
var tableJavaName;
var fieldNameChs;
var fieldName;
var fieldJavaName;
var fieldType;
var fieldJavaType;
var fieldMandatory;
var fieldPrimaryKey;
var fieldIdentity;
var primaryKeyIndex;
var curJspTypes;
var jspTypeArray = new Array("query","list","edit","view");
//select name from code_table where code_type='enumType'order by id
//select code from code_table where code_type='enumType'order by id
//select code_type_name from code_type order by id
//select code_type from code_type order by id
//定义转码选择数组
var convertName = new Array("产品类型","文档类型","责任类型","是否类型","流程状态","角色","部门","供应商代码","产品代码","缺陷代码","设备代码","客户代码","登陆名","部门代码");
var convertCode = new Array("proType","docType","dutyType","yesOrNo","processStatus","ROLE","DEPARTMENT","VENDNO","PRONO","TROUBLENO","EQUIPNO","CUSTNO","LOGINNAME","DEPARTMENTNO");
//定义是否必选项
var isMandatoryName = new Array("可填","必填");
var isMandatoryCode = new Array("false","true");
//定义是否为隐藏输入项
var isHiddenName = new Array("显示","隐藏");
var isHiddenCode = new Array("show","hidden");
//定义短文本的显示类型
var shortCharViewTypeName = new Array("文本","转码");
var shortCharViewTypeCode = new Array("show_text","show_convert");
//定义短文本转码的显示类型
var convertViewTypeName = new Array("下拉列表","弹出列表","多选组","单选组");
var convertViewTypeCode = new Array("show_convert_select","show_convert_popup","show_convert_checkbox","show_convert_radio");
//定义弹出列表显示类型
var popupTypeName = new Array("代码","名称");
var popupTypeCode = new Array("show_convert_popup_code","show_convert_popup_name");
//定义长文本的显示类型
var longCharViewTypeName = new Array("多行文本","单行文本");
var longCharViewTypeCode = new Array("show_multirowtext","show_text");
//定义日期的显示类型
var dateEditTypeName = new Array("日期选择","文本");
var dateEditTypeCode = new Array("show_dateselect","show_text");
//定义按文本显示的类型
var textViewTypeName = new Array("文本");
var textViewTypeCode = new Array("show_text");
//定义按日期显示的类型
var dateViewTypeName = new Array("日期","文本");
var dateViewTypeCode = new Array("show_dateselect","show_text");
//日期详细类型
var dateDetailTypeName = new Array("日期","日期时间");
var dateDetailTypeCode = new Array("show_dateselect_onlydate","show_dateselect_withtime");
//定义列表列排序类型
var canSortColumnName = new Array("不可排序","可以排序");
var canSortColumnCode = new Array("flase","true");
//定义表排序类型
var tableSortOnName = new Array("表名称","表代码");
var tableSortOnCode = new Array("name","code");
//定义表显示类型
var tableShowName = new Array("表名称:表代码","表代码:表名称");
var tableShowCode = new Array("name_code","code_name");
var numberOrDateConditionName = new Array(" == "," > "," < "," >= "," <= ");
var numberOrDateConditionCode = new Array("_equal","_gt","_lt","_ge","_le");
var charConditionName = new Array("like").concat(numberOrDateConditionName);
var charConditionCode = new Array("_like").concat(numberOrDateConditionCode);
//-->
</script>
<!-- //Generate JSP - Common -->
<script>
<!--//
function setContentWidthUsePx(){
var docWidth = document.body.scrollWidth;
var docHeight = document.body.offsetHeight;
var jspArea = document.getElementById('jspSource');
var beanArea = document.getElementById('javaBeanSource');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -