springboot中搜索框怎么做啊

Question

<select id="findProductsList" resultMap="BaseResultMap">
    SELECT ID,PRODUCTID,CONTACTSNAME,PRODUCTNAME,SPECIFICATION,MEASURE,INSTALLTIME,WARRANTYTIME,QUANTITY
    FROM PRODUCTS
    <where>
      <if test="productid != null and productid != ''">
        AND productid LIKE #{productid}
      </if>
      <if test="contactsname != null and contactsname != ''">
        AND contactsname LIKE #{contactsname}
      </if>
      <if test="productname != null and productname != ''">
        AND productname LIKE #{productname}
      </if>
      <if test="specification != null and specification != ''">
        AND specification LIKE #{specification}
      </if>
      <if test="measure != null and measure != ''">
        AND measure LIKE #{measure}
      </if>
      <if test="installtime != null and installtime != ''">
        AND installtime LIKE #{contactsname}
      </if>
      <if test="warrantytime != null and warrantytime != ''">
        AND warrantytime LIKE #{warrantytime}
      </if>
      <if test="quantity != null and quantity != ''">
        OR quantity LIKE #{quantity}
      </if>
    </where>

web.controller层和html中应该怎么写

Answer 1

你的问题比较模糊 你写的sql是多条件查询 首先就是 写一个 input 框 具体写法可以去学习一下 你写完controller了 定义名字 然后去html里面去调接口传参 功能不难