(四)DIH导入结构化数据

(四)DIH导入结构化数据

  目前大多数的应用程序将数据存储在关系数据库(如oracle、sql server 、mysql等)、xml文件中。对这样的数据进行搜索是很常见的应用。所谓的DataImportHandler提供一种可配置的方式向solr导入数据,即可以一次全部导入,也可以增量导入。还可以声明式提供可配置的任务调度,让数据定时的从关系型数据库更新数据到solr服务器。

 一、环境

  1、windows 7
  2、jdk1.8
  3、tomcat8
  4、solr7.1.0
  5、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>上面加入如下配置信息:

    <!--自定义数据类型 text_ik 支持Ik分词器-->
    <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>
    <!--自定义字段 name_ik (type与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', '花儿朵朵彩色金属门后挂&nbsp;8钩免钉门背挂钩2066', '17', '幽默杂货', '18.9', '10000', '<BR><BR>\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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT size=2>这是以金属为主材的一款切割型产品,因为创意,因为实用,所以让金属不于冰冷,而如此这般成为了焦点。这是一组关于大小花朵的粉红色挂钩,专用于门后悬挂收纳衣裤、围巾、钥匙等零碎杂乱的随手物品,更易查找,更好收纳。不占空间,无须钻孔,不伤家具。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2>金属</FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>40*22*4.5CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>白盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>534</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>粉 </TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>24个</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><BR><BR><BR><BR></P></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<P align=center><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032613045379.png border=0><BR><BR><BR><BR><BR></P></TD></TR>\r\n<TR>\r\n<TD height=131><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032613053404.png border=0><BR><BR><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<P align=center><BR><BR><BR><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032613042041.png border=0></P></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<P align=center><STRONG><FONT size=4><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032613055774.png border=0><BR><BR></FONT></STRONG></P></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<P align=center><BR></P></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', '幸福一家人彩色金属门后挂&nbsp;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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT size=2>这是以金属为主材的一款切割型产品,因为创意,因为实用,所以让金属不于冰冷,而如此这般成为了焦点。看这一家其乐融融的场面可真是让人感动。专用于门后悬挂收纳衣裤、围巾、钥匙等零碎杂乱的随手物品,更易查找,更好收纳。不占空间,无须钻孔,不伤家具。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2>金属</FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>40*22*6.5CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>白盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>\r\n<P>534</P>\r\n<P>&nbsp;</P></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>8勾</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>粉色</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>24</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><BR><BR><BR><BR>&nbsp;</P></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<P align=center><BR><BR>&nbsp;<IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612392370.png border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612392368.png border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612392303.png border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612392342.png border=0><BR><BR></P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612410281.png border=0><BR><BR><BR><BR><BR><BR><BR>&nbsp;</P></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<P align=center><STRONG><FONT size=4><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612413603.png border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032612413600.png border=0><BR><BR></FONT></STRONG></P></TD></TR>\r\n<TR>\r\n<TD height=131><BR><BR><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<P align=center><BR><BR><BR>&nbsp;</P></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', '神偷奶爸电影同款&nbsp;惨叫发泄公仔&nbsp;发声小黄人', '17', '幽默杂货', '10', '10000', '<P align=left><BR></P>\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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT style=BACKGROUND-COLOR: #ffffff size=2></FONT><FONT size=2>眼睛:单只或双只,头发:刺头、塌塌的小中分、冲天一小撮,身型:黄色胶囊状,身高:94--120cm,105cm为标准型,性格:吵闹、易满足、爱享受、听主人话、乐于助人,属性:呆蠢、贱萌的技术宅,喜欢:大笑、玩耍,讨厌:被嘲笑。这就是神偷奶爸里的小黄人。现在的它由搪胶制作而成,形象可爱,柔软舒适,一挤一捏就会发出尖叫的声音,想要发泄它就是对象,让你在这压力和紧张中得以释放和排解。它也是个可爱精灵的玩物。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2>搪胶</FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></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</SPAN></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>尼龙网袋</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>16</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></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></SPAN></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>黄色</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></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个</SPAN></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><BR><BR><BR><BR>&nbsp;</P></TD></TR>\r\n<TR>\r\n<TD height=131>\r\n<P><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417084459.png border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417200618.png border=0></P>\r\n<P><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564934.jpg border=0></P></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<P align=center><BR><BR><BR><BR><BR><BR>&nbsp;</P></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<P align=center><BR><BR><BR>&nbsp;</P>\r\n<P align=center><BR><BR>&nbsp;</P></TD></TR></TR>\r\n<TR>\r\n<TD height=131>\r\n<P><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417250754.png border=0></P>\r\n<P><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417250758.png border=0></P>\r\n<P><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417200616.png border=0></P>\r\n<P><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122410564910.jpg border=0></P></TD></TR>\r\n<TR>\r\n<TD height=100>\r\n<P align=center><STRONG><FONT size=4><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417271233.png border=0></FONT></STRONG></P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032417250772.png border=0><BR>&nbsp;</P></TD></TR></TBODY></TABLE>\r\n<P align=left><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201212/2012122915213662.jpg border=0></P></TD></TR></TBODY></TABLE></DIV>\r\n<P align=left>&nbsp;</P>', '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', '神偷奶爸电影同款&nbsp;&nbsp;发泄公仔&nbsp;暴眼小黄人', '17', '幽默杂货', '13', '10000', '<BR><BR><BR><BR><BR><BR>\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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT size=2>这是神偷奶爸电影同款的小黄人,是两个主人公格鲁和纳瓦利欧博士用变种DNA、脂肪酸和香蕉泥组成的胶囊状生物,短胳膊短腿,穿着蓝色背带装,属于那呆蠢、贱萌的技术宅。线下的它,由搪胶制成,软软的、鼓鼓的,一挤一压就会让两个大眼球蹦出来、转起来。任凭主人如何百般糟蹋、万种蹂虐,仍然保持原状,如果你的心情快乐了、情绪稳定了,这就是它想要达到的。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></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>搪胶</SPAN><FONT size=2></FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></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</SPAN></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>&nbsp;PVC圆筒盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>16</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></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</SPAN></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>黄色</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>48个</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><BR><BR><BR><BR><BR><BR>&nbsp;</P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416471308.png border=0><BR><BR>&nbsp;</P></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<P align=center><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416420720.png border=0><BR><BR><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416423004.png border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416430705.png border=0><BR><BR><BR><BR>&nbsp;</P></TD></TR></TR>\r\n<TR>\r\n<TD height=131><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416444759.png border=0><BR><BR><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<P align=center><STRONG><FONT size=4><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416455242.png border=0></FONT></STRONG></P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014032416474771.png border=0><BR><BR><BR><BR><BR>&nbsp;</P></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', '有趣浪漫魔力无痕挂钩&nbsp;环保厨房卫生间衣钩无痕挂钩', '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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT style=BACKGROUND-COLOR: #ffffff size=2>用于一切无凹凸的光滑硬质隔声门 ,如瓷砖、冰箱、玻璃、不锈钢、油漆木板,搭配辅助膜也可用于木饰纹、仿古砖、磨砂面等带细纹纹理的表面使用。无须添胶,可任意重复移位使用。可防水,防潮、防尘。长期可承重高达3公斤,且粘贴越久越牢固。是家庭厨房,浴室,卧室,居家生活的好帮手哦。不留胶痕,可重复移位使用并特有防水功能。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2><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>树脂</SPAN></FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6><FONT style=BACKGROUND-COLOR: #ffffff face=Tahoma color=#333333>7*7*2CM</FONT><FONT face=Tahoma color=#333333></FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6><FONT face=Tahoma color=#333333>吸塑彩卡</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>20</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6><STRONG><FONT face=Tahoma color=#333333></FONT></STRONG></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>多种颜色图案随机发送</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>300个</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><BR><BR><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>&nbsp;</A><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913082622.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913082631.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913082670.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031913082772.jpg border=0><BR><BR>&nbsp;</P></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<P align=center><BR><BR>&nbsp;</P></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<P align=center><BR><BR><BR><BR><BR>&nbsp;</P></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<P align=center><STRONG><FONT size=4></FONT></STRONG></P></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<P align=center><BR>&nbsp;</P></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杂货&nbsp;情侣小鹿树脂摆件家居装饰品一对', '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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT size=2>这是一对,青梅竹马的一对,一蓝一黄,夸张但形象,可爱但时尚,甜蜜而温馨,这正是它们需要传达给我们的深情厚意。或背靠背,或头挨头,或是面对面,其实爱有很多种表达方式,是双方接受的就行。这既是摆设也是钱罐。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2>树脂</FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>10*6*15CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>彩盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>71g(单个重量)</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>如图</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>60对</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517190190.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517190278.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517190225.jpg border=0>&nbsp;</P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180164.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180295.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180236.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180287.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180232.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180227.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031517180222.jpg border=0></P></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<P align=center><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516582807.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516582874.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516582984.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014031516582912.jpg border=0><BR><BR><BR><BR><BR><BR>&nbsp;</P></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<P align=center><STRONG><FONT size=4></FONT></STRONG></P></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<P align=center><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>&nbsp;</A><BR>&nbsp;</P></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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT size=2></FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2>水晶+塑料+电子元件</FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>彩盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>如图</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>24个</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><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>&nbsp;</A></P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121308.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121330.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121351.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121378.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121397.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121305.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121313.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610121363.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140651.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140738.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140748.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140768.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140781.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140794.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610140709.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143620.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143782.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143772.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143786.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143743.jpg border=0><BR><BR><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>&nbsp;</A><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143795.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201403/2014030610143728.jpg border=0></P></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<P align=center><BR><BR><BR><BR><BR>&nbsp;</P></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<P align=center><STRONG><FONT size=4></FONT></STRONG></P></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<P align=center><BR>&nbsp;</P></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', '家天下情侣款仿真缝纫机音乐盒八音盒&nbsp;创意礼品', '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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT style=BACKGROUND-COLOR: #ffffff size=2>外观、造型逼真形象,台式主机、皮带轮、针脚甚至还有花布等配件一应俱全;除了尺寸外,其它和真的缝纫机看起来没什么两样。转动背面一侧的发条,上足链,然后打开缝纫机抽屉音乐随即启动,清脆悦耳的音乐就会响起!一个可爱的小女孩坐在缝纫机上面,一个可爱的小男孩在一边推动缝纫机运转,此时缝纫机随音乐的旋律开始工作,一幅缝纫工人操作的场景跃然眼前,皮带轮在转动,连针脚也会上下活动。既是音乐盒,也是精美礼物,更是可爱装饰。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2>塑料+金属</FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>\r\n<P>18.2*8.8*18.3CM</P></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>英文版彩盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>256克</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>18.3x10x19cm</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>逼真咖啡色木纹</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>48个</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><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>&nbsp;</A>&nbsp;</P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354003.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354063.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354084.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354043.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354012.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354038.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354083.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216354090.jpg border=0><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216360165.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216360119.jpg border=0>&nbsp;</P></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<P align=center><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345777.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345757.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345772.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345706.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345711.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201312/2013120216345712.jpg border=0></P></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<P align=center><STRONG><FONT size=4>&nbsp;<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></FONT></STRONG></P></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<P align=center><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>&nbsp;</A><BR>&nbsp;</P></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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT size=2>一版两个,多种动物造型,无论是颜色还是造型都是可爱之选。可拆可取,方便简单实用。无论是居家还是旅行或是小车,用于悬挂收纳包袋、毛巾、杂物等最适合。挂钩可360度旋转,魔术贴粘合,松紧轻松调节,适合于圆柱管状物。小挂钩,大作用。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2>塑料</FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>5*9CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>PVC+彩卡</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>45克</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>两个装</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>如图</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>240个</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><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>&nbsp;</A></P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441295.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441286.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441289.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441254.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441241.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112909441273.jpg border=0></P></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<P align=center><BR><BR><BR><BR><BR>&nbsp;</P></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<P align=center><STRONG><FONT size=4>&nbsp;<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></FONT></STRONG></P></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<P align=center><BR>&nbsp;</P></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><FONT color=#808080 size=6>规·格·参·数</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT style=BACKGROUND-COLOR: #f6f6f6 face=宋体 size=2>商品概述</FONT></TD>\r\n<TD width=608 bgColor=#f6f6f6 colSpan=3><FONT size=2>门后挂钩,定制专用,可爱而卡通的各种动物形状装饰,且以炫丽果彩色泽呈现,适合悬挂在厚度为3.8CM以内的门柜面。居家办公均可,收纳各种衣物、包袋等,实用方便。马、兔、青蛙、河马等动物造型,坚实厚固金属,表面经喷漆工艺耐用也防锈。圆滑挂钩经圆滑处理不伤衣物更贴心。</FONT></TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品材质</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6><FONT size=2>金属</FONT></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品尺寸</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>长 21.2CM</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6><FONT size=2>商品品牌</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6></TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6 height=29><FONT size=2>商品包装</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>彩盒</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>商品重量</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>160克</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>商品规格</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>适合厚度3.8cm以内的门柜面</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>颜色款式</FONT></TD>\r\n<TD width=255 bgColor=#f6f6f6>绿色青蛙/黄色兔子/蓝色牛/玫红马</TD>\r\n<TD align=middle width=80 bgColor=#f6f6f6><FONT size=2>装箱数量</FONT></TD>\r\n<TD width=249 bgColor=#f6f6f6>120个</TD></TR>\r\n<TR>\r\n<TD align=middle bgColor=#f6f6f6 height=29><FONT size=2>温馨提醒</FONT></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<P align=center><BR><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>&nbsp;</A></P></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<P align=center><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010213335.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010213320.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010213317.jpg border=0><BR><BR><IMG   src=http://www.5252jia.com/Shop/UploadPhotos/201311/2013112010213325.jpg border=0></P></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<P align=center><BR><BR><BR><BR><BR>&nbsp;</P></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<P align=center><STRONG><FONT size=4>&nbsp;<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></FONT></STRONG></P></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<P align=center><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>&nbsp;</A><BR>&nbsp;</P></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"/>
    
    <!--关键词  定义复制域字段,将商品名称和商品描述都复制到 product_keywords这一个字段上-->
    <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>
    <!--自定义字段 name_solr(type与fieldType一致)网站查询的关键词字段-->
    <field name="name_solr" type="solr_cnAnalyzer" indexed="true" stored="true"/>

 

 

 

 

 

posted @ 2018-11-20 22:02  神码是浮云  阅读(654)  评论(0编辑  收藏  举报