idea中完成简单的搜索

一.简单的搜索功能

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