xml 导入到Orcale数据库中
刚上班的下班求教
已从webservice 获得 xml样式的string
xml返回数据条目不定 可能两条可能,三条
现在如何把数据插入到orcale中
获取的string
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<Table>
<Column>
<RECORDID>$5B1353A8DE8629C84E2890F</RECORDID>
<ORDER_ID>$504F5643529E4D84B1C71F1</ORDER_ID>
<ORDERCODE>$20130924000000980</ORDERCODE>
<BUYERORGID>QJ20T0000201000015754422</BUYERORGID>
<BUYERNAME>解放军总医院</BUYERNAME>
<BUYEREASY>301医院</BUYEREASY>
<MEDICALNAME>烫疮油</MEDICALNAME>
<PRODUCTID>FR20T0000003000000124033</PRODUCTID>
<PRODUCTNAME>无</PRODUCTNAME>
<MEDICALMODE>油剂</MEDICALMODE>
<MEDICALSPEC>50ml×1瓶/瓶</MEDICALSPEC>
<METRICNAME>瓶</METRICNAME>
<FATORYID>FR20T0000004000000088552</FATORYID>
<FACTORYNAME>湖南邵阳华仁堂药业发展有限公司</FACTORYNAME>
<REQUESTQTY>1</REQUESTQTY>
<PRICE>62.91</PRICE>
<CREATEDATE>2013/9/24 18:16:21</CREATEDATE>
<DEGREE>1</DEGREE>
<ORDERREMARK>
</ORDERREMARK>
<REMARK>
</REMARK>
<WAREHOUSENAME>
</WAREHOUSENAME>
<COMPANY_ID>FR20T0000004000000066990</COMPANY_ID>
<DEPART_NAME>北京科园信海医药经营有限公司</DEPART_NAME>
<REPOSITORY_ID>0</ REPOSITORY_ID >
<BUYER_TYPE>0</BUYER_TYPE >
</Column>
<Column>
<RECORDID>$42E493211207A915CA4C3A5</RECORDID>
<ORDER_ID>$504F5643529E4D84B1C71F1</ORDER_ID>
<ORDERCODE>$20130924000000980</ORDERCODE>
<BUYERORGID>QJ20T0000201000015754422</BUYERORGID>
<BUYERNAME>解放军总医院</BUYERNAME>
<BUYEREASY>301医院</BUYEREASY>
<MEDICALNAME>烫疮油</MEDICALNAME>
<PRODUCTID>FR20T0000003000000124030</PRODUCTID>
<PRODUCTNAME>无</PRODUCTNAME>
<MEDICALMODE>油剂</MEDICALMODE>
<MEDICALSPEC>30ml×1瓶/瓶</MEDICALSPEC>
<METRICNAME>瓶</METRICNAME>
<FATORYID>FR20T0000004000000088552</FATORYID>
<FACTORYNAME>湖南邵阳华仁堂药业发展有限公司</FACTORYNAME>
<REQUESTQTY>3</REQUESTQTY>
<PRICE>45.80</PRICE>
<CREATEDATE>2013/9/24 18:16:21</CREATEDATE>
<DEGREE>1</DEGREE>
<ORDERREMARK>
</ORDERREMARK>
<REMARK>
</REMARK>
<WAREHOUSENAME>
</WAREHOUSENAME>
<COMPANY_ID>FR20T0000004000000066990</COMPANY_ID>
<DEPART_NAME>北京科园信海医药经营有限公司</DEPART_NAME>
<REPOSITORY_ID>0</ REPOSITORY_ID >
<BUYER_TYPE>0</BUYER_TYPE >
</Column>
<Column>
<RECORDID>$D4D5D0AFC99BAB998A913A2</RECORDID>
<ORDER_ID>$CA036FC81EA9AB5A980D301</ORDER_ID>
<ORDERCODE>$20130924000000950</ORDERCODE>
<BUYERORGID>FR20T0000005000000070123</BUYERORGID>
<BUYERNAME>解放军第302医院</BUYERNAME>
<BUYEREASY>302医院</BUYEREASY>
<MEDICALNAME>豨红通络口服液</MEDICALNAME>
<PRODUCTID>FR20T0000003000000132568</PRODUCTID>
<PRODUCTNAME>无</PRODUCTNAME>
<MEDICALMODE>合剂(含口服液)</MEDICALMODE>
<MEDICALSPEC>10ml×18/盒</MEDICALSPEC>
<METRICNAME>盒</METRICNAME>
<FATORYID>FR20T0000004000000077240</FATORYID>
<FACTORYNAME>通化卫京药业股份有限公司</FACTORYNAME>
<REQUESTQTY>5</REQUESTQTY>
<PRICE>138</PRICE>
<CREATEDATE>2013/9/24 14:54:06</CREATEDATE>
<DEGREE>1</DEGREE>
<ORDERREMARK>
</ORDERREMARK>
<REMARK>
</REMARK>
<WAREHOUSENAME>
</WAREHOUSENAME>
<COMPANY_ID>FR20T0000004000000066990</COMPANY_ID>
<DEPART_NAME>北京科园信海医药经营有限公司</DEPART_NAME>
<REPOSITORY_ID>0</ REPOSITORY_ID >
<BUYER_TYPE>0</BUYER_TYPE >
</Column>
<Column>
<RECORDID>$A816BBCD8AB46371D09F2B7</RECORDID>
<ORDER_ID>$423FAE5F20F1A74C6085A69</ORDER_ID>
<ORDERCODE>$20130924000000960</ORDERCODE>
<BUYERORGID>QJ20T0000201000015754422</BUYERORGID>
<BUYERNAME>解放军总医院</BUYERNAME>
<BUYEREASY>301医院</BUYEREASY>
<MEDICALNAME>烫疮油</MEDICALNAME>
<PRODUCTID>FR20T0000003000000124033</PRODUCTID>
<PRODUCTNAME>无</PRODUCTNAME>
<MEDICALMODE>油剂</MEDICALMODE>
<MEDICALSPEC>50ml×1瓶/瓶</MEDICALSPEC>
<METRICNAME>瓶</METRICNAME>
<FATORYID>FR20T0000004000000088552</FATORYID>
<FACTORYNAME>湖南邵阳华仁堂药业发展有限公司</FACTORYNAME>
<REQUESTQTY>3</REQUESTQTY>
<PRICE>62.91</PRICE>
<CREATEDATE>2013/9/24 16:05:27</CREATEDATE>
<DEGREE>1</DEGREE>
<ORDERREMARK>
</ORDERREMARK>
<REMARK>
</REMARK>
<WAREHOUSENAME>
</WAREHOUSENAME>
<COMPANY_ID>FR20T0000004000000066990</COMPANY_ID>
<DEPART_NAME>北京科园信海医药经营有限公司</DEPART_NAME>
<REPOSITORY_ID>0</ REPOSITORY_ID >
<BUYER_TYPE>0</BUYER_TYPE >
</Column>
</Table>
数据库表
字段名称 字段类型 字段说明
RECORDID CHAR(24) 订单明细ID,唯一主键(SQPTS)
ORDER_ID CHAR(24) 订单主表ID(SQPTS)
ORDERCODE VARCHAR2(50) 订单编码(SQPTS)
BUYERORGID VARCHAR2(50) 医院编码(ERP/SQPTS)
BUYERNAME VARCHAR2(100) 医院名称(SQPTS)
BUYEREASY VARCHAR2(100) 医院简称(SQPTS)
PRODUCTID VARCHAR2(50) 产品id(SQPTS)
PRODUCTNAME VARCHAR2(100) 商名称(SQPTS)
MEDICALMODE VARCHAR2(100) 药品剂型(SQPTS)
MEDICALSPEC VARCHAR2(150) 药品规格(SQPTS)
METRICNAME VARCHAR2(150) 药品单位(SQPTS)
MEDICALNAME VARCHAR2(150) 药品名称(SQPTS)
FATORYID CHAR(24) 生产企业编码(SQPTS)
FACTORYNAME VARCHAR2(150) 生产企业名称(SQPTS)
REQUESTQTY NUMBER(22,2) 订购数量(SQPTS)
PRICE NUMBER(22,3) 药品单价(SQPTS)
CREATEDATE DATE 医院发单时间(SQPTS)
ORDERREMARK VARCHAR2(1000) 主单备注(SQPTS)
REMARK VARCHAR2(1000) 明细备注(SQPTS)
WAREHOUSENAME VARCHAR2(100) 库房名称(SQPTS)
DEGREE CHAR(1) 紧急程度(SQPTS)
COMPANY_ID VARCHAR2(100) 供货商编码(SQPTS)
DEPART_NAME VARCHAR2(100) 供货商名称(SQPTS)
REPOSITORY_ID CHAR(24) 库房id(SQPTS)
BUTER_TYPE CHAR(1) 医院类别 1:二级以上医疗机构 0:社区医院