一.简单的搜索功能
1：mapper.xml文件: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.google.crm.dao.SearchItemDao"> <select id="getItemList" resultType="SearchItem"> SELECT a.id, a.title, a.sell_point, a.price, a.image, b. NAME category_name, c.item_desc FROM tb_item a LEFT JOIN tb_item_cat b ON a.cid = b.id LEFT JOIN tb_item_desc c ON a.id = c.item_id WHERE a.`status` = 1 </select> </mapper> 2：model模型创建 SearchItem.java private String id; private String title; private String sell_point; private long price; private String image; private String category_name; private String item_desc; 3.dao接口: public interface SearchItemDao { List<SearchItem> getItemList(); } 4.service服务层：@Service public class SearchItemService { @Resource private SearchItemDao searchItemDao; public List<SearchItem> getItem(){ return this.searchItemDao.getItemList(); } } 5.controller控制层：public String getsearchitem(Model model) { List<SearchItem> searchItems = this.searchItemService.getItem(); if (searchItems != null) { model.addAttribute("searchItems", searchItems); return "searchItems"; } else { return "init"; } } 6.可视化层view: <table border="1"> <tr align="center"> <td>id</td> <td>标题</td> <td>买点</td> <td>价格</td> <td>图片</td> <td>分类</td> <%-- <td>描述</td>--%> </tr> <c:forEach var="s" items="${searchItems }"> <tr align="center"> <td>${s.id }</td> <td>${s.title }</td> <td>${s.sell_point }</td> <td>${s.price }</td> <td>${s.image }</td> <td>${s.category_name }</td> <%-- <td>${s.item_desc }</td>--%> </tr> </c:forEach> </table> 二.测试用例 把测试文档写到solr引擎上 http://localhost:8080/solr/#/ 127.0.0.1 http://127.0.0.1:8080/solr/#/ http://192.168.226.132:8000/solr/#/ 打通windows和ubuntu下的solr引擎 http://192.168.0.128:8080/solr/#/ 使用ifconfig命令时，只返回lo这一项 解决方法：安装无线网卡即可 1. sudo lshw -numeric -class network 2. sudo route -nv 3. sudo dhclient -v idea写测试文件转载于:https://www.cnblogs.com/llaq/p/9439668.html
