當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

（四）DIH导入结构化数据

發布時間：2024/8/1 编程问答 34 豆豆

生活随笔收集整理的這篇文章主要介紹了（四）DIH导入结构化数据小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

（四）DIH導入結構化數據

　　目前大多數的應用程序將數據存儲在關系數據庫（如oracle、sql server 、mysql等）、xml文件中。對這樣的數據進行搜索是很常見的應用。所謂的DataImportHandler提供一種可配置的方式向solr導入數據，即可以一次全部導入，也可以增量導入。還可以聲明式提供可配置的任務調度，讓數據定時的從關系型數據庫更新數據到solr服務器。

?一、環境

　　1、windows 72、jdk1.83、tomcat84、solr7.1.05、mysql5.5
　　6、IK分詞器(支持solr7的最優版本，ik低版本不支持solr7)

二、配置ik分詞器

　　solr7.1中進行IK中文分詞器的配置和solr低版本中最大不同點在于IK 分詞器中jar包的引用。

　　一般的IK分詞jar包都是不能用的（如：IKAnalyzer2012FF_u1.jar這種就不能用），因為IK分詞中傳統的jar不支持solr7.1這個高版本的，所以就會發送運行錯誤的界面。

　　下面的這個錯誤是血淋漓的教訓。

??? solr7.1下IK中文分詞器的安裝配置。

　　1、下載支持solr7.1的IK版本

　　下載solr7.1專用的IK 分詞器的jar包和相應的配置文件。

　　2、拷貝jar文件到solr項目下的WEB-INF\lib目錄

　　解壓上一個步驟所得到的壓縮包，將ik-analyzer-solr5-5.x.jar這個jar包放入solr項目下的WEB-INF\lib目錄中去，將IKAnalyzer.cfg.xml，ext.dic（擴展詞庫文件），stopword.dic（停止詞文件）放在solr項目下的WEB-INF\classes目錄中去。

　　3、修改IKAnalyzer.cfg.xml配置

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> <properties> <comment>IK Analyzer 擴展配置</comment> <entry key="ext_dict">ext.dic;</entry> <entry key="ext_stopwords">stopword.dic;</entry> </properties>

　　4、修改managed-schema配置文件(以前solr版本是schema.xml)

將項目下D:/solr_home\core1\conf下的managed-schema配置文件中</schema>上面加入如下配置信息：

<fieldType name="text_ik" class="solr.TextField"><analyzer type="index" isMaxWordLength="false" class="org.wltea.analyzer.lucene.IKAnalyzer"/> <analyzer type="query" isMaxWordLength="true" class="org.wltea.analyzer.lucene.IKAnalyzer"/></fieldType> <field name="name_ik" type="text_ik" indexed="true" stored="true"/>

　　5、測試ik分詞器

　　啟動tomcat，訪問http://localhost:8080/solr/index.html，進行如下測試，看一下能否能正常分詞

　　6、配置停止器

　　意思就是把不需要的字和詞進行收錄（有些字和詞的組合毫無意義），放到solr項目下的WEB-INF\classes目錄下的stopword.dic中去

　　stopword.dic內容

我是中國人是中 a an and are as at be but by for if in into is it no not of on or such that the their then there these they this to was will with

　　測試結果

　　通過測試發現，好像少了"我是中國人"，我希望讓他作為一個詞，就需要用到擴展詞

　　7、添加擴展詞

　　意思就是把需要的詞進行收錄，放到solr項目下的WEB-INF\classes目錄下的ext.dic中去

　　ext.dic內容

我是中國人

　　測試結果

三、配置數據源

（1）添加依賴包

　　1、將D:\solr-7.1.0\dist目錄下的solr-dataimporthandler-7.1.0.jar和solr-dataimporthandler-extras-7.1.0.jar復制到已經部署到tomcat上的solr項目的WEB-INF/lib目錄下

　　2、將mysql驅動mysql-connector-java-5.1.7-bin.jar復制到已經部署到tomcat上的solr項目的WEB-INF/lib目錄下

（2）solrconfig.xml中配置DataImportHandler并指定config的位置

?　　可以模仿D:\solr-7.1.0\example\example-DIH\solr\db\conf下的solrconfig.xml配置

　　參照此配置，我的配置如下：

<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler"><lst name="defaults">
　　　　 <str name="config">./data-config.xml</str></lst></requestHandler>

　　mysql中準備數據，創建mysql的數據庫solrdata，創建表products，添加幾條的數據

CREATE TABLE `products` (`pid` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品編號',`name` varchar(255) DEFAULT NULL COMMENT '商品名稱',`catalog` int(11) DEFAULT NULL COMMENT '商品分類ID',`catalog_name` varchar(50) DEFAULT NULL COMMENT '商品分類名稱',`price` double DEFAULT NULL COMMENT '價格',`number` int(11) DEFAULT NULL COMMENT '數量',`description` longtext COMMENT '商品描述',`picture` varchar(255) DEFAULT NULL COMMENT '圖片名稱',`release_time` datetime DEFAULT NULL COMMENT '上架時間',PRIMARY KEY (`pid`) ) ENGINE=InnoDB AUTO_INCREMENT=6126 DEFAULT CHARSET=utf8;

（3）添加數據（這里只提供十條數據，更多數據自己改改）

INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('1', '花兒朵朵彩色金屬門后掛 8鉤免釘門背掛鉤2066', '17', '幽默雜貨', '18.9', '10000', ' \r\n<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>這是以金屬為主材的一款切割型產品，因為創意，因為實用，所以讓金屬不于冰冷，而如此這般成為了焦點。這是一組關于大小花朵的粉紅色掛鉤，專用于門后懸掛收納衣褲、圍巾、鑰匙等零碎雜亂的隨手物品，更易查找，更好收納。不占空間，無須鉆孔，不傷家具。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6>金屬</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6>40*22*4.5CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>白盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>534</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>粉 </TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>24個</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032613045379.png border=0> </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032613053404.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032613042041.png border=0></TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032613055774.png border=0> </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2014032613103438.png', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('2', '幸福一家人彩色金屬門后掛 8鉤免釘門背掛鉤2088', '17', '幽默雜貨', '18.9', '10000', '<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>這是以金屬為主材的一款切割型產品，因為創意，因為實用，所以讓金屬不于冰冷，而如此這般成為了焦點。看這一家其樂融融的場面可真是讓人感動。專用于門后懸掛收納衣褲、圍巾、鑰匙等零碎雜亂的隨手物品，更易查找，更好收納。不占空間，無須鉆孔，不傷家具。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6>金屬</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6>40*22*6.5CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>白盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>\r\n534\r\n </TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6>8勾</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>粉色</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>24</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　適合厚度3.5-4.2cm的門</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n  </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612392370.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612392368.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612392303.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612392342.png border=0> </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612410281.png border=0>  </TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612413603.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612413600.png border=0> </TD></TR>\r\n<TR>\r\n<TD height=131> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2014032612461139.png', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('3', '神偷奶爸電影同款 慘叫發泄公仔 發聲小黃人', '17', '幽默雜貨', '10', '10000', ' \r\n<DIV align=left>\r\n<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 align=left border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>眼睛：單只或雙只，頭發：刺頭、塌塌的小中分、沖天一小撮，身型：黃色膠囊狀，身高：94--120cm，105cm為標準型，性格：吵鬧、易滿足、愛享受、聽主人話、樂于助人，屬性：呆蠢、賤萌的技術宅，喜歡：大笑、玩耍，討厭：被嘲笑。這就是神偷奶爸里的小黃人。現在的它由搪膠制作而成，形象可愛，柔軟舒適，一擠一捏就會發出尖叫的聲音，想要發泄它就是對象，讓你在這壓力和緊張中得以釋放和排解。它也是個可愛精靈的玩物。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6>搪膠</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6><SPAN style=DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 12px/18px Tahoma, Arial, 宋體, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(51,51,51); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; webkit-text-stroke-width: 0px>9.2*11.5cm</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>尼龍網袋</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>16</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6><SPAN style=DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 12px/18px Tahoma, Arial, 宋體, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(51,51,51); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; webkit-text-stroke-width: 0px></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>黃色</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6><SPAN style=DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 12px/18px Tahoma, Arial, 宋體, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(51,51,51); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; webkit-text-stroke-width: 0px>60個</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n  </TD></TR>\r\n<TR>\r\n<TD height=131>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417084459.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417200618.png border=0>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  \r\n  </TD></TR></TR>\r\n<TR>\r\n<TD height=131>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417250754.png border=0>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417250758.png border=0>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417200616.png border=0>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417271233.png border=0></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417250772.png border=0>  </TD></TR></TBODY></TABLE>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0></TD></TR></TBODY></TABLE></DIV>\r\n ', '2014032417271233.png', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('4', '神偷奶爸電影同款  發泄公仔 暴眼小黃人', '17', '幽默雜貨', '13', '10000', ' \r\n<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>這是神偷奶爸電影同款的小黃人，是兩個主人公格魯和納瓦利歐博士用變種DNA、脂肪酸和香蕉泥組成的膠囊狀生物，短胳膊短腿，穿著藍色背帶裝，屬于那呆蠢、賤萌的技術宅。線下的它，由搪膠制成，軟軟的、鼓鼓的，一擠一壓就會讓兩個大眼球蹦出來、轉起來。任憑主人如何百般糟蹋、萬種蹂虐，仍然保持原狀，如果你的心情快樂了、情緒穩定了，這就是它想要達到的。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6><SPAN style=DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 12px/18px Tahoma, Arial, 宋體, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(51,51,51); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; webkit-text-stroke-width: 0px>搪膠</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6><SPAN style=DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 12px/18px Tahoma, Arial, 宋體, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(51,51,51); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; webkit-text-stroke-width: 0px>12*7cm</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6> PVC圓筒盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>16</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6><SPAN style=DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 12px/18px Tahoma, Arial, 宋體, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(51,51,51); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; webkit-text-stroke-width: 0px>78*50*50cm</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>黃色</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>48個</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n  </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416471308.png border=0>  </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416420720.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416423004.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416430705.png border=0>  </TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416444759.png border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416455242.png border=0></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416474771.png border=0>  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2014032416533215.png', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('5', '有趣浪漫魔力無痕掛鉤 環保廚房衛生間衣鉤無痕掛鉤', '17', '幽默雜貨', '3', '10000', '<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>用于一切無凹凸的光滑硬質隔聲門，如瓷磚、冰箱、玻璃、不銹鋼、油漆木板，搭配輔助膜也可用于木飾紋、仿古磚、磨砂面等帶細紋紋理的表面使用。無須添膠，可任意重復移位使用。可防水，防潮、防塵。長期可承重高達3公斤，且粘貼越久越牢固。是家庭廚房，浴室，臥室，居家生活的好幫手哦。不留膠痕，可重復移位使用并特有防水功能。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6><SPAN style=DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 12px/18px Tahoma, Arial, 宋體, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(51,51,51); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; webkit-text-stroke-width: 0px>樹脂</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6>7*7*2CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>吸塑彩卡</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>20</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>多種顏色圖案隨機發送</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>300個</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　 </TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n <A href=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913134115.jpg target=_blank><IMG height=2941 src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913134115.jpg width=750 border=0> </A> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913082622.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913082631.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913082670.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913082772.jpg border=0>  </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n</TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2014031913145400_S.jpg', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('6', 'zakka雜貨 情侶小鹿樹脂擺件家居裝飾品一對', '17', '幽默雜貨', '15', '10000', '<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>這是一對，青梅竹馬的一對，一藍一黃，夸張但形象，可愛但時尚，甜蜜而溫馨，這正是它們需要傳達給我們的深情厚意。或背靠背，或頭挨頭，或是面對面，其實愛有很多種表達方式，是雙方接受的就行。這既是擺設也是錢罐。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6>樹脂</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6>10*6*15CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>彩盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>71g（單個重量）</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>如圖</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>60對</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517190190.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517190278.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517190225.jpg border=0> </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180164.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180295.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180236.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180287.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180232.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180227.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180222.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516582807.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516582874.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516582984.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516582912.jpg border=0>  </TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n</TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<A href=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516471604.jpg target=_blank><IMG height=700 src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516471604.jpg width=700 border=0> </A>  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2014031517190225.jpg', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('7', '魔幻星座音樂水晶球內雕音樂盒七彩漸變音樂球', '17', '幽默雜貨', '70', '10000', '<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6>水晶+塑料+電子元件</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>彩盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>如圖</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>24個</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n<A href=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610151185.jpg target=_blank><IMG height=700 src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610151185.jpg width=700 border=0> </A></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121308.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121330.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121351.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121378.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121397.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121305.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121313.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121363.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140651.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140738.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140748.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140768.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140781.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140794.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140709.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143620.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143782.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143772.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143786.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143743.jpg border=0> <A href=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610152742.jpg target=_blank><IMG height=700 src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610152742.jpg width=700 border=0> </A> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143795.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143728.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n</TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2014030610151185.jpg', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('8', '家天下情侶款仿真縫紉機音樂盒八音盒 創意禮品', '17', '幽默雜貨', '25', '10000', '<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>外觀、造型逼真形象，臺式主機、皮帶輪、針腳甚至還有花布等配件一應俱全；除了尺寸外，其它和真的縫紉機看起來沒什么兩樣。轉動背面一側的發條，上足鏈，然后打開縫紉機抽屜音樂隨即啟動，清脆悅耳的音樂就會響起！一個可愛的小女孩坐在縫紉機上面，一個可愛的小男孩在一邊推動縫紉機運轉，此時縫紉機隨音樂的旋律開始工作，一幅縫紉工人操作的場景躍然眼前，皮帶輪在轉動，連針腳也會上下活動。既是音樂盒，也是精美禮物，更是可愛裝飾。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6>塑料+金屬</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6>\r\n18.2*8.8*18.3CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>英文版彩盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>256克</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6>18.3x10x19cm</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>逼真咖啡色木紋</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>48個</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n<A href=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216363484.jpg target=_blank><IMG height=626 src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216363484.jpg width=700 border=0> </A> </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354003.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354063.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354084.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354043.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354012.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354038.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354083.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354090.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216360165.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216360119.jpg border=0> </TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345777.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345757.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345772.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345706.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345711.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345712.jpg border=0></TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <A href=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216340921.jpg target=_blank><IMG height=599 src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216340921.jpg width=700 border=0> </A></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<A href=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216335945.jpg target=_blank><IMG height=541 src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216335945.jpg width=700 border=0> </A>  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2013120216363484_S.jpg', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('9', '家天下嘻哈動物魔術貼掛鉤繞帶無痕掛鉤2個裝RB205', '17', '幽默雜貨', '5.5', '10000', '<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>一版兩個，多種動物造型，無論是顏色還是造型都是可愛之選。可拆可取，方便簡單實用。無論是居家還是旅行或是小車，用于懸掛收納包袋、毛巾、雜物等最適合。掛鉤可360度旋轉，魔術貼粘合，松緊輕松調節，適合于圓柱管狀物。小掛鉤，大作用。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6>塑料</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6>5*9CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>PVC+彩卡</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>45克</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6>兩個裝</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>如圖</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>240個</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n<A href=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909444459.jpg target=_blank><IMG height=700 src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909444459.jpg width=700 border=0> </A></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441295.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441286.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441289.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441254.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441241.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441273.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <A href=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909414762.jpg target=_blank><IMG height=603 src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909414762.jpg width=700 border=0> </A></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2013112909444459_S.jpg', '2015-01-14 18:59:33'); INSERT INTO `solrdata`.`products` (`pid`, `name`, `catalog`, `catalog_name`, `price`, `number`, `description`, `picture`, `release_time`) VALUES ('10', '創意卡通動物鐵藝門后掛鉤掛物ZT3103', '17', '幽默雜貨', '5', '10000', '<TABLE id=table2 cellSpacing=5 cellPadding=5 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 colSpan=4 height=30>規·格·參·數</TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品概述</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>門后掛鉤，定制專用，可愛而卡通的各種動物形狀裝飾，且以炫麗果彩色澤呈現，適合懸掛在厚度為3.8CM以內的門柜面。居家辦公均可，收納各種衣物、包袋等，實用方便。馬、兔、青蛙、河馬等動物造型，堅實厚固金屬，表面經噴漆工藝耐用也防銹。圓滑掛鉤經圓滑處理不傷衣物更貼心。</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品材質</TD>\r\n<TD width=255 bgColor=#f6f6f6>金屬</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品尺寸</TD>\r\n<TD width=249 bgColor=#f6f6f6>長 21.2CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6>商品品牌</TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29>商品包裝</TD>\r\n<TD width=249 bgColor=#f6f6f6>彩盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>商品重量</TD>\r\n<TD width=255 bgColor=#f6f6f6>160克</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>商品規格</TD>\r\n<TD width=249 bgColor=#f6f6f6>適合厚度3.8cm以內的門柜面</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>顏色款式</TD>\r\n<TD width=255 bgColor=#f6f6f6>綠色青蛙/黃色兔子/藍色牛/玫紅馬</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6>裝箱數量</TD>\r\n<TD width=249 bgColor=#f6f6f6>120個</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29>溫馨提醒</TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3>　</TD></TR>\r\n<TR>\r\n<TD colSpan=4 height=313>\r\n<TABLE id=table3 height=345 cellSpacing=0 cellPadding=0 width=700 border=0>\r\n<TBODY>\r\n<TR>\r\n<TD height=131>\r\n <A href=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010220971.jpg target=_blank><IMG height=700 src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010220971.jpg width=700 border=0> </A></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010213335.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010213320.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010213317.jpg border=0> <IMG src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010213325.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564950.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n  </TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n <A href=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010210096.jpg target=_blank><IMG height=401 src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010210096.jpg width=700 border=0> </A></TD></TR>\r\n<TR>\r\n<TD height=131><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564955.jpg border=0></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<A href=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010204977.jpg target=_blank><IMG height=427 src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010204977.jpg width=700 border=0> </A>  </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><IMG src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0>', '2013112010220971_S.jpg', '2015-01-14 18:59:33');

（4）在managed-schema文件中配置field域

<field name="product_name" type="text_ik" indexed="true" stored="true"/><field name="product_catalog_name" type="string" indexed="true" stored="true"/><field name="product_price" type="float" indexed="true" stored="true"/><field name="product_number" type="long" indexed="true" stored="true"/><field name="product_description" type="text_ik" indexed="true" stored="false"/><field name="product_picture" type="string" indexed="false" stored="true"/><field name="product_keywords" type="text_ik" indexed="true" stored="false" multiValued="true" /><copyField source="product_name" dest="product_keywords" /><copyField source="product_description" dest="product_keywords" />

（5）配置data-config.xml

　　在solrconfig.xml同級目錄創建data-config.xml（或者將D:\solr-7.1.0\example\example-DIH\solr\db\conf目錄下的db-data-config.xml文件拷貝到D:\solr_home\core1\conf目錄下，并將其更名為data-config.xml）

<?xml version="1.0" encoding="UTF-8" ?> <dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/solrdata" user="root" password="root"/> <document> <entity name="product" query="select pid,name,catalog,catalog_name,price,number,description,picture from products"> <field column="pid" name="id"/> <field column="name" name="product_name"/> <field column="catalog_name" name="product_catalog_name"/> <field column="price" name="product_price"/> <field column="number" name="product_number"/> <field column="description" name="product_description"/> <field column="picture" name="product_picture"/> </entity> </document> </dataConfig>

五、在solr管理頁面進行數據導入

六、查看導入的數據

　　簡單查看數據導入的條數

查看數據的內容

補充、solr自帶的中文分詞器配置

　　1、拷貝jar包

　　　　將D:\solr-7.1.0\contrib\analysis-extras\lucene-libs目錄下solr自帶的中文分詞器lucene-analyzers-smartcn-7.1.0.jar，復制到已經部署到tomcat上的solr項目的WEB-INF/lib目錄下

、

　　2、修改managed-shchema配置中文分詞器（新版本配置文件）

<fieldType name="solr_cnAnalyzer" class="solr.TextField" positionIncrementGap="100"><analyzer type="index"><tokenizer class="org.apache.lucene.analysis.cn.smart.HMMChineseTokenizerFactory"/></analyzer><analyzer type="query"><tokenizer class="org.apache.lucene.analysis.cn.smart.HMMChineseTokenizerFactory"/></analyzer></fieldType><field name="name_solr" type="solr_cnAnalyzer" indexed="true" stored="true"/>

?

轉載于:https://www.cnblogs.com/gaogaoyanjiu/p/7798187.html

總結

以上是生活随笔為你收集整理的（四）DIH导入结构化数据的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇： Uploadify-中文帮助手册
下一篇： android看本地视频播放器下载,An