关于solr配置多表连接导入数据并实现

1.先写好mysql语句先
此时是用的是内连接 代码如下

select u.id,u.username,s.real_name,c.college_name,d.apartment_name,dd.build,dd.number,dd.is_filled,ss.one,ss.two,ss.three,ss.four from uuser u
join sstudent s on s.stu_id = u.id 
join college c on c.college_id = s.stu_college_id
join dormitory_no dd on dd.dor_id = s.stu_dormitory_id
join dormitory d on dd.apartment_id= d.apartment_id
join specific_bed_number ss on ss.dor_id = dd.dor_id;

结果

2.不错 写好了就知道自己想要什么 那就配置solr文件 分别配:
data-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<dataConfig>

    <dataSource type="JdbcDataSource"
                driver="com.mysql.jdbc.Driver"
                url="jdbc:mysql://localhost:3306/dor_manager"
                user="root"
                password="root"
                batchSize="-1"/>
    <document>
        <!-- query中写SQL语句 -->
        <entity name="uuser" query="select u.id,u.username,s.real_name,c.college_name,
            d.apartment_name,dd.build,dd.number,dd.is_filled,ss.one,ss.two,ss.three,ss.four
            from uuser u
            join sstudent s on s.stu_id = u.id
            join college c on c.college_id = s.stu_college_id
            join dormitory_no dd on dd.dor_id = s.stu_dormitory_id
            join dormitory d on dd.apartment_id= d.apartment_id
            join specific_bed_number ss on ss.dor_id = dd.dor_id  ">
            <!-- column对应数据库中的列名，name为对应的域名（在scheme中没有的话需要配置，即设置业务系统域）,
            这是一个映射关系 -->
            <field column="id" name="id"/>
            <field column="username" name="username"/>
            <field column="real_name" name="realName"/>
            <field column="college_name" name="collegeName"/>
            <field column="apartment_name" name="apartmentName"/>
            <field column="build" name="build"/>
            <field column="number" name="number"/>
            <field column="is_filled" name="isFilled"/>
            <field column="one" name="one"/>
            <field column="two" name="two"/>
            <field column="three" name="three"/>
            <field column="four" name="four"/>

        </entity>

    </document>

</dataConfig>

再配置schema.xml 只要在最后配置就好

再附上对应文件的路径

最后启动服务器，然后进入
http://localhost:8080/solr/

然后直接查询即可，得到数据