使用MySQL作为SOLR的目录源

<lib dir="../../../dist/" regex="solr-dataimporthandler-.*\.jar" />
<!--需要增加依赖包，如果有数据库驱动，也需要增加到依赖路径中 -->

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

<?xml version="1.0" encoding="utf-8"?>    
<dataConfig>  
 <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"    
   url="jdbc:mysql://192.168.0.105:3306/test"    
   user="hive"    
   password="hive123"/>
   
   <document name="cms">  
      <entity name="books" pk="id" query="select id,cat,name,price,inStock,author,series_t,sequence_i,genre_s from index_test">
          <field column="id" name="id" />
		  <field column="cat" name="cat" />
		  <field column="name" name="name" />
		  <field column="price" name="price" />
		  <field column="inStock" name="inStock" />
		  <field column="author" name="author" />
		  <field column="series_t" name="series_t" />
		  <field column="sequence_i" name="sequence_i" />
		  <field column="genre_s" name="genre_s" />
      </entity>  
 </document>   
</dataConfig>