solr+tomcat+mysql 数据导入到solr

养成习惯，每日写笔记，做功课！

先说说感受哈，这玩意儿说难不难，百度一大把 ，说简单不简单，配置文件的修改，不多说，看下文：

具体步骤：

1、下载solr  点击打开链接 

2、解压后打开目录找到/example/webapps/下的solr.war放入你tomcat中的webapps下：

3、接着在此/webapps/solr/WEB-INF/lib目录下加入如下jar：

mysql-connector-java-5.1.13-bin.jar

solr-dataimporthandler-4.5.0.jar

solr-dataimporthandler-extras-4.5.0.jar

4、开始配置xml文件：

     （1） solrconfig.xml  添加如下：

 <requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">  
    <lst name="defaults">  
        <str name="config"><span style="color:#FF0000;">data-config.xml</span></str><!--此处的data-config.xml 主要是用配置数据库连接信息 可以和  solrconfig.xml放在同一目录 -->  
    </lst>  

     （2）data-config.xml，此文件需要手动新建，命名跟上面的配置名一致即可

       

<?xml version="1.0" encoding="UTF-8" ?>  
<dataConfig>  
    <dataSource driver="com.mysql.jdbc.Driver"    
                url="jdbc:mysql://127.0.0.1:3306/test"     
                user="root"     
                password="root"    />
    <document>  
        <entity name="business_info" pk="id"  
                query="select id,business_name,business_type from business_info"  
                deltaImportQuery="select id,business_name,business_type from business_info where id='${dataimporter.delta.ID}'"  
                deltaQuery="select id,business_name,business_type from business_info where  to_char(updatetime,'yyyy-mm-dd hh24:mi:ss')> '${dataimporter.last_index_time}'">  
            <field column="id" name="id"/>  
            <field column="business_name" name="business_name"/>  
            <field column="business_type" name="business_type"/>  
        </entity>  
    </document>  
</dataConfig> 

       （3）schema.xml主要添加数据库生成的索引字段：

<field name="id" type="string" indexed="true" stored="true" multiValued="false" /> 

<field name="business_name"      type="string"    indexed="true"  stored="true"  multiValued="false" />  
<field name="business_type"      type="string"    indexed="true"  stored="true"  multiValued="false" />  
<field name="updatetime"      type="string"    indexed="true"  stored="true"  multiValued="false" /> 

配置完成，接着去新建数据库：

create table `test`.`business_info`(  
        `ID` INT not null auto_increment,  
       `business_name` CHAR(255),  
       `business_type` CHAR(50),  
       `updatetime` DATETIME not null,  
        primary key (`ID`)  
    );  
    create unique index `PRIMARY` on `test`.`business_info`(`ID`);  
insert into business_info(business_name,business_type,updatetime) values('cup','Inter-i5','2013-09-07 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup','Inter-i3','2013-09-06 09:06:00');  
insert into business_info(business_name,business_type,updatetime) values('cup','Inter-i7','2013-09-06 09:06:00');  
insert into business_info(business_name,business_type,updatetime) values('cup1','Inter-i5','2013-09-05 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup1','Inter-i3','2013-09-07 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup1','Inter-i7','2013-09-06 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup2','Inter-i5','2013-09-05 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup2','Inter-i3','2013-09-07 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup2','Inter-i7','2013-09-06 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup3','Inter-i5','2013-09-05 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup3','Inter-i3','2013-09-07 09:08:00');  
insert into business_info(business_name,business_type,updatetime) values('cup3','Inter-i7','2013-09-06 09:08:00');  

最后重启服务，导入数据

如上图，依次点击后：

出现如上图表示ok了