java使用cache数据库(二)

1.右键打开studio

2.出现以下界面

3.Tools>import local>选择你导入的xml文件就可以了

4.右下角右键打开 打开 ManageMent Portal

5.默认用户是 '_system' 密码是你安装时设置的密码

6.

注:至于xml来自哪里,我给一个模范的xml供大家参考

<?xml version="1.0" encoding="UTF-8"?>
<Export generator="Cache" version="25" zv="Cache for Windows (x86-64) 2016.2 (Build 736U)" ts="2019-07-12 15:49:43">
<Class name="User.DHCPEPEMVIEW">
<Description>
xxxxxx接口视图</Description>
<SqlTableName>DHC_PE_PEMVIEW</SqlTableName>
<Super>%Persistent</Super>
<TimeChanged>65206,54507.811521</TimeChanged>
<TimeCreated>65206,54077.589485</TimeCreated>

<Property name="ExamNo">
<Description>
Exam_No    申请单号    varchar    20    即:检查申请号    1107210001008</Description>
<Type>%String</Type>
<SqlFieldName>Exam_No</SqlFieldName>
</Property>

<Property name="CISID">
<Description>
CISID    体检号    varchar    15    体检号,也就是条码号。    1107210001</Description>
<Type>%String</Type>
<SqlFieldName>CISID</SqlFieldName>
</Property>

<Property name="PatientName">
<Description>
PatientName    姓名    varchar    20        王军</Description>
<Type>%String</Type>
<SqlFieldName>PatientName</SqlFieldName>
</Property>

<Property name="Sex">
<Description>
Sex    性别    varchar    2    男或女    男</Description>
<Type>%String</Type>
<SqlFieldName>Sex</SqlFieldName>
</Property>

<Property name="BirthDay">
<Description>
BirthDay    出生日期    datetime    8        1976-02-23</Description>
<Type>%String</Type>
<SqlFieldName>BirthDay</SqlFieldName>
</Property>

<Property name="ReqDate">
<Description>
ReqDate    申请时间    datetime    8        2014-01-13</Description>
<Type>%String</Type>
<SqlFieldName>ReqDate</SqlFieldName>
</Property>

<Property name="ReqDoct">
<Description>
ReqDoct    申请医师    varchar    20    申请医师姓名    李医生</Description>
<Type>%String</Type>
<SqlFieldName>ReqDoct</SqlFieldName>
</Property>

<Property name="StudyType">
<Description>
StudyType    设备类型    varchar    6    体检系统检查类型,比如XD是心电,给心理体检指定一个类型,比如:PSY    PSY</Description>
<Type>%String</Type>
<SqlFieldName>StudyType</SqlFieldName>
</Property>

<Property name="PacsItemCode">
<Description>
Pacs_Item_Code    申请项目关联代码    Varchar    10    体检系统收费项目与心电测评项目关联代码    1001</Description>
<Type>%String</Type>
<SqlFieldName>Pacs_Item_Code</SqlFieldName>
</Property>

<Property name="ItemCode">
<Description>
Item_Code    体检收费项目代码    varchar    10    体检系统收费项目代码,与检查号构成一条记录的唯一标识    9001</Description>
<Type>%String</Type>
<SqlFieldName>Item_Code</SqlFieldName>
</Property>

<Property name="ItemName">
<Description>
Item_Name    体检收费项目名称    varchar    40    肝胆胰脾肾超声检查    </Description>
<Type>%String</Type>
<SqlFieldName>Item_Name</SqlFieldName>
</Property>

<Property name="ReqDept">
<Description>
ReqDept    申请科室    varchar    20     申请科室    体检中心</Description>
<Type>%String</Type>
<SqlFieldName>ReqDept</SqlFieldName>
</Property>

<Property name="GroupName">
<Description>
GroupName    单位名称    varchar    100     </Description>
<Type>%String</Type>
<SqlFieldName>GroupName</SqlFieldName>
</Property>

<Property name="GroupCode">
<Description>
GroupCode    单位代码    varchar    20 </Description>
<Type>%String</Type>
<SqlFieldName>GroupCode</SqlFieldName>
</Property>

<Property name="PACSCheckID">
<Description>
PACS_CheckID    varchar    20    
心电测评报告号,也是心电测评报告记录的唯一标识,心电测评系统对于体检申请的项目有合并生成报告的情况,则此表中合并的几条记录的PACS_CheckID相同。
(如:心电测评将两条申请项目结果合并成一份报告,则在结果里写两条记录,PACS_CheckID相同,报告内容和结果也相同,其他体检信息参照视图数据)</Description>
<Type>%String</Type>
<SqlFieldName>PACS_CheckID</SqlFieldName>
</Property>

<Property name="ClinicDiagnose">
<Description>
ClinicDiagnose    text    16    检查结论</Description>
<Type>%String</Type>
<SqlFieldName>ClinicDiagnose</SqlFieldName>
</Property>

<Property name="ClinicSymptom">
<Description>
ClinicSymptom    text    16    检查描述</Description>
<Type>%String</Type>
<SqlFieldName>ClinicSymptom</SqlFieldName>
</Property>

<Property name="IMGStrings">
<Description>
IMGStrings    varchar    1000    报告图片路径字符串(一个测评项目有多页,每页一个文件),以^隔开。如:20120512/1.jpg^20120512/1.jpg</Description>
<Type>%String</Type>
<SqlFieldName>IMGStrings</SqlFieldName>
</Property>

<Property name="CheckDoc">
<Description>
Check_Doc    Varchar    10    检查医生姓名</Description>
<Type>%String</Type>
<SqlFieldName>Check_Doc</SqlFieldName>
</Property>

<Property name="CheckDate">
<Description>
Check_Date    datetime    8    检查时间</Description>
<Type>%String</Type>
<SqlFieldName>Check_Date</SqlFieldName>
</Property>

<Property name="ReportDoc">
<Description>
Report_Doc    Varchar    10    报告医生</Description>
<Type>%String</Type>
<SqlFieldName>Report_Doc</SqlFieldName>
</Property>

<Property name="ReportDate">
<Description>
Report_Date    datetime    8    报告时间</Description>
<Type>%String</Type>
<SqlFieldName>Report_Date</SqlFieldName>
</Property>

<Property name="AuditDoc">
<Description>
Audit_Doc    varchar    10    审核医师</Description>
<Type>%String</Type>
<SqlFieldName>Audit_Doc</SqlFieldName>
</Property>

<Property name="AuditDate">
<Description>
Audit_Date    datetime    8    审核时间</Description>
<Type>%String</Type>
<SqlFieldName>Audit_Date</SqlFieldName>
</Property>

<Property name="TransToCisDate">
<Description>
TransToCis_Date    datetime    8    回传日期时间(由体检系统填写)</Description>
<Type>%String</Type>
<SqlFieldName>TransToCis_Date</SqlFieldName>
</Property>

<Storage name="Default">
<Type>%Library.CacheStorage</Type>
<DataLocation>^User.DHCPEPEMVIEWD</DataLocation>
<DefaultData>DHCPEPEMVIEWDefaultData</DefaultData>
<IdLocation>^User.DHCPEPEMVIEWD</IdLocation>
<IndexLocation>^User.DHCPEPEMVIEWI</IndexLocation>
<StreamLocation>^User.DHCPEPEMVIEWS</StreamLocation>
<Data name="DHCPEPEMVIEWDefaultData">
<Value name="1">
<Value>%%CLASSNAME</Value>
</Value>
<Value name="2">
<Value>ExamNo</Value>
</Value>
<Value name="3">
<Value>CISID</Value>
</Value>
<Value name="4">
<Value>Name</Value>
</Value>
<Value name="5">
<Value>Sex</Value>
</Value>
<Value name="6">
<Value>BirthDay</Value>
</Value>
<Value name="7">
<Value>ReqDate</Value>
</Value>
<Value name="8">
<Value>ReqDoct</Value>
</Value>
<Value name="9">
<Value>StudyType</Value>
</Value>
<Value name="10">
<Value>PacsItemCode</Value>
</Value>
<Value name="11">
<Value>ItemCode</Value>
</Value>
<Value name="12">
<Value>ItemName</Value>
</Value>
<Value name="13">
<Value>ReqDept</Value>
</Value>
<Value name="14">
<Value>PACSCheckID</Value>
</Value>
<Value name="15">
<Value>ClinicDiagnose</Value>
</Value>
<Value name="16">
<Value>ClinicSymptom</Value>
</Value>
<Value name="17">
<Value>IMGStrings</Value>
</Value>
<Value name="18">
<Value>CheckDoc</Value>
</Value>
<Value name="19">
<Value>CheckDate</Value>
</Value>
<Value name="20">
<Value>ReportDoc</Value>
</Value>
<Value name="21">
<Value>ReportDate</Value>
</Value>
<Value name="22">
<Value>AuditDoc</Value>
</Value>
<Value name="23">
<Value>AuditDate</Value>
</Value>
<Value name="24">
<Value>TransToCisDate</Value>
</Value>
<Value name="25">
<Value>GroupName</Value>
</Value>
<Value name="26">
<Value>GroupCode</Value>
</Value>
</Data>
</Storage>
</Class>
</Export>

 

 

 

posted @ 2019-09-10 08:55  叶知秋qw  阅读(199)  评论(0)    收藏  举报