导入数据失败,,,,,,,,,,,,,,,防火墙已关,solr已启动
网页访问

2.控制台错误提示
3.mapper中书写无误


target中有新加入的内容

4.sql语句无误

SELECT
item.id,
item.title,
item.sell_point,
item.price,
item.image,
cat.`name`,
idesc.item_desc
FROM
tb_item item
LEFT JOIN tb_item_cat cat ON item.cid = cat.id
LEFT JOIN tb_item_desc idesc ON item.id = idesc.item_id
5.pom文件中已经引入mapper

6.启动类中已经添加扫描

7.业务层代码 service
public interface SolrService {
Result importAll();
List<SolrDocument> selectByq(String q, Long page, Integer pageSize );
}
实现类 serviceImpl
/**
* 搜索服务 业务层
*/
@Service
public class SolrServiceImpl implements SolrService {
@Autowired
private SolrItemMapper solrItemMapper;
@Autowired
private SolrTemplate solrTemplate;
@Value("${spring.data.solr.core}")
private String bjsxt;
/**
*向索引库中导入数据
* @return
*/
@Override
public Result importAll() {
try {
//查询数据
List<SolrItem> list=this.solrItemMapper.getItemList();
//将数据添加到索引库
for (SolrItem item :
list) {
//创建SolrInputDocument
SolrInputDocument document=new SolrInputDocument();
document.setField("id",item.getId());
document.setField("item_title",item.getTitle());
document.setField("item_sell_point",item.getSell_point());
document.setField("item_price",item.getPrice());
document.setField("item_image",item.getImage());
document.setField("item_category_name",item.getName());
document.setField("item_desc",item.getItem_desc());
//写入数据库
this.solrTemplate.saveDocument(this.bjsxt,document);
}
this.solrTemplate.commit(this.bjsxt);
return Result.ok();
}catch (Exception e){
e.printStackTrace();
}
return Result.error("导入失败");
}
8.控制层
/**
* 搜索服务 Controller
*/
@RestController
@RequestMapping("/search")
public class SolrController {
@Autowired
private SolrService solrService;
/**
* 向 Solr 索引库中导入数据
*/
@RequestMapping("/importAll")
public Result importAll(){
return this.solrService.importAll();
}
9.config
/**
* SolrTemplate 配置类
*/
@Configuration
public class SolrConfig {
@Autowired
private SolrClient solrClient;
@Bean
public SolrTemplate getSolrTemplate(){
return new SolrTemplate(solrClient);
}
}
10.配置文件
