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>