core文件夹里的solrconfig.xml
<requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">
<lst name="defaults">
<str name="config">DIHconfig.xml</str>
</lst>
</requestHandler>
同文件夹下创建一个DIHconfig.xml
官方示例
<dataConfig>
<dataSource driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:./example-DIH/hsqldb/ex"
user="sa" password="secret"/>
<document>
<entity name="item" query="select * from item"
deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
<field column="NAME" name="name" />
<entity name="feature"
query="select DESCRIPTION from FEATURE where ITEM_ID='${item.ID}'"
deltaQuery="select ITEM_ID from FEATURE where last_modified > '${dataimporter.last_index_time}'"
parentDeltaQuery="select ID from item where ID=${feature.ITEM_ID}">
<field name="features" column="DESCRIPTION" />
</entity>
<entity name="item_category"
query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'"
deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified > '${dataimporter.last_index_time}'"
parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
<entity name="category"
query="select DESCRIPTION from category where ID = '${item_category.CATEGORY_ID}'"
deltaQuery="select ID from category where last_modified > '${dataimporter.last_index_time}'"
parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}">
<field column="description" name="cat" />
</entity>
</entity>
</entity>
</document>
</dataConfig>
自用
<dataConfig>
<dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/shop?characterEncoding=utf-8"
user="root" password="root"/>
<document>
<entity name="item" query="select * from tb_item">
<field name="id" column="id" />
<field name="item_title" column="title"/>
<field name="item_sell_point" column="sell_point"/>
<field name="item_price" column="price"/>
<field name="item_image" column="image"/>
<entity name = "category" query="select name from tb_item_cat where id = '${item.cid}'" >
<field name="item_category_name" column="name" />
</entity>
</entity>
</document>
</dataConfig>
从D:\JAVA\code\solr-8.3.0\dist 里拷贝jar包到 D:\JAVA\code\solr-8.3.0\server\solr\new_core\lib
mysql-connector-java-5.1.32.jar
solr-dataimporthandler-8.3.0.jar
solr-dataimporthandler-extras-8.3.0.jar
重启
评论区