SSM框架下一个简单的模糊查询（超级详细)

小鱼儿 2021-09-22 13:40 482阅读 0赞

**引言:模糊查询作为后台常用的一种查询方式，我们可以根据相应的 关键字对其检索,从而获得所需要的记录,本次模糊查询我们通过名字的任何一个字段进行匹配查询。**

另外声明，源码就是以下的部分，直接复制就可以使用了。此外，想要模糊查询，最好学会分页查询，分页查询我用了两种方法，一种是利用的pageHelper，另一种没用到插件.

**需要源码的，或者demo，在我的资源下载，需要远程帮忙的可以加我QQ1728608455**

**![20190926145403701.png][]**关注我的微信公众号，送IT视频资料，和本项目的源码，希望额能帮到你；

[https://blog.csdn.net/liqz666/article/details/81868619][https_blog.csdn.net_liqz666_article_details_81868619]

[https://blog.csdn.net/liqz666/article/details/81532292][https_blog.csdn.net_liqz666_article_details_81532292]

看看这些，对你模糊查询是一个很好的铺垫，希望能帮到大家了。

--------------------

![70][]

--------------------

**1****、数据表设计**

DROP TABLE IF EXISTS \`user\`;  
CREATE TABLE \`user\`  (  
  \`id\` int(11) NOT NULL AUTO\_INCREMENT,  
  \`username\` varchar(45) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL,  
  \`password\` varchar(45) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL,  
  \`role\` varchar(45) CHARACTER SET utf8 COLLATE utf8\_general\_ci NOT NULL,  
  \`createtime\` date NOT NULL,  
  PRIMARY KEY (\`id\`) USING BTREE  
) ENGINE = InnoDB AUTO\_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8\_general\_ci ROW\_FORMAT = Dynamic;

--------------------

**2、数据表里增添几条记录：**

INSERT INTO \`user\` VALUES (11, '李庆照', '12344', '学生', '2018-09-11');  
INSERT INTO \`user\` VALUES (12, 'al', '121221', '学生', '2018-08-11');  
INSERT INTO \`user\` VALUES (13, '韩小虎', '12344', '学生', '2018-09-10');  
INSERT INTO \`user\` VALUES (14, '狄云辉', '12345', '学生', '2018-09-01');  
INSERT INTO \`user\` VALUES (15, '王鹏', '124434', '学生', '2018-09-09');  
INSERT INTO \`user\` VALUES (16, '魏鹏', '12344', '学生', '2018-09-14');  
INSERT INTO \`user\` VALUES (17, '吕老师', '123456', '老师', '2018-09-10');  
INSERT INTO \`user\` VALUES (18, '李庆照', '123456', '管理员', '2018-09-09');  
INSERT INTO \`user\` VALUES (19, '吕老师', '12344', '学生', '2018-09-11');  
INSERT INTO \`user\` VALUES (21, '甘志伟', '12344', '学生', '2018-09-11');  
INSERT INTO \`user\` VALUES (32, '夏平平', '123456', '学生', '2018-09-11');  
INSERT INTO \`user\` VALUES (38, '', '', '学生', '2018-09-11');  
INSERT INTO \`user\` VALUES (39, '', '', '学生', '2018-09-11');  
INSERT INTO \`user\` VALUES (40, 'admin', '123456', '学生', '2018-09-11');

SET FOREIGN\_KEY\_CHECKS = 1;

--------------------

**3、创建接口**

List<User> findByName(@Param("username")String username);//根据username字段里的任意一个值进行模糊查询整条记录

--------------------

**4**、**在mybatis 里编写sql语句**

<select id="findByName" resultType="com.lysoc.jmi.teaching.model.User"  
        parameterType="com.lysoc.jmi.teaching.model.User">  
        SELECT \* FROM user  
        <where>  
            <if test="username != null and username != ''">  
                AND username LIKE CONCAT(CONCAT('%',\#\{username\},'%'))  
            </if>  
        </where>  
        ORDER BY id  
    </select>

--------------------

**5、业务逻辑层代码实现**

@Service  
@Transactional  
public class UserService \{  
    @Autowired  
    UserMapper userMapper;//注入mapper文件  
     //模糊根据登陆账号查询  
     public List<User> findByName(String username)\{  
         return userMapper.findByName(username);  
     \}

--------------------

**6、编写User类的实体类**

package com.lysoc.jmi.teaching.model;

import java.util.Date;

public class User \{  
    private Integer id;

private String username;

private String password;

private String role;

private Date createtime;  
    public Integer getId() \{  
        return id;  
    \}

public void setId(Integer id) \{  
        this.id = id;  
    \}

public String getUsername() \{  
        return username;  
    \}

public void setUsername(String username) \{  
        this.username = username == null ? null : username.trim();  
    \}

public String getPassword() \{  
        return password;  
    \}

public void setPassword(String password) \{  
        this.password = password == null ? null : password.trim();  
    \}

public String getRole() \{  
        return role;  
    \}

public void setRole(String role) \{  
        this.role = role == null ? null : role.trim();  
    \}

public Date getCreatetime() \{  
        return createtime;  
    \}

public void setCreatetime(Date createtime) \{  
        this.createtime = createtime;  
    \}  
\}

--------------------

**7、首先要查询出所有的记录**

@Controller  
public class UserController \{  
        @Autowired  
        private UserService userService;  
          
     @RequestMapping("/findByName")  
    public String findByName(  
            @RequestParam(defaultValue="1") Integer currentPage,  
            HttpServletRequest request,Map<String,Object> map) \{  
        String username=request.getParameter("search");  
        System.out.println(username);  
        PageHelper.startPage(currentPage,8);  
        List<User> list=userService.findByName(username);  
        PageInfo<User> pageInfo=new PageInfo<User>(list,8);  
        map.put("pageInfo", pageInfo);  
        return "userinfo";  
    \}

**\}**

--------------------

**8、在userinfo.jsp里进行打印显示。**

<body>

<div class="tools">  
    <ul class="toolbar">  
        <li><a href="senduserTo"><button type="button" class="layui-btn layui-btn-sm" id="getAll"><i class="layui-icon">&\#xe608;</i> 添加</button></a></li>  
        <li ><a><button type="button" class="layui-btn layui-btn-sm" οnclick="return deleteAll()" ><i class="layui-icon">&\#xe640;</i>批量删除</button></a></li>  
    </ul>  
    <ul class="searchform">  
          
        <li> <form action="$\{path\}/findByName" method="post">  
<input type="text" name="search" placeholder="根据登陆账号查询" style="    border: 1px solid \#E6E6E6;;height:28px;width:120px;">  
<button class="layui-btn layui-btn-sm"><i class="layui-icon">&\#xe615;</i> 搜索</button>  
</form></li>  
        <%--    <li><a href="$\{path\}/findByName"><button class="layui-btn layui-btn-small"><i class="layui-icon">&\#xe615;</i> 搜索</button></a></li>  
        <li><fr<input name="search" type="text" class="scinput" placeholder="请根据登录账号查询"  /></li> --%>  
    </ul>  
          
</div>

<table class="tablelist">  
    <tr><th><input type="checkbox" name="selectall" id="selectall" οnclick="checkAll()" id="selectall"/></th>  
    <th>登陆账号</th><th>登陆密码</th><th>角色</th><th>创建日期</th><th>操作</th>  
    <c:forEach items="$\{pageInfo.list\}" var="user">  
    <tr>  
        <td><input type="checkbox" name="id" value="$\{user.id\}"/></td>  
        <td>$\{user.username\}</td>  
        <td>$\{user.password\}</td>  
        <td>$\{user.role\}  </td>  
    <%--     <td>$\{user.createtime\}</td> --%>  
        <td><fmt:formatDate value="$\{user.createtime\}" pattern="yyyy年-MM月-dd日" /></td>  
        <td><a href="updateUserTo?id=$\{user.id\}"><button class="layui-btn-mini layui-btn">更改</button></a>  
        <a href="deleteById?id=$\{user.id\}" class="tablelink"><button class="layui-btn-danger layui-btn-mini layui-btn">删除</button></a></td>      
    </tr>  
    </c:forEach>  
      
</table>

<div class="clear"></div>  
      <div class="pagin">  
 <div class="message">共<i class="blue">$\{pageInfo.total \}</i>条记录，当前显示第&nbsp;<i class="blue">$\{pageInfo.pageNum \}&nbsp;</i>页  
   
 总<i class="  
 blue">$\{pageInfo.pages \}</i>页  
 </div>  
 <ul class="paginList">  
       <li class="paginItem"><a href="$\{pageContext.request.contextPath\}/UserPage?currentPage=1">首页</a></li>  
                    <c:if test="$\{pageInfo.hasPreviousPage \}">  
                        <li  class="paginItem"><a href="$\{pageContext.request.contextPath\}/UserPage?currentPage=$\{pageInfo.pageNum-1\}"  
                            > <span>&laquo;</span>  
                        </a></li>  
                    </c:if>  
       <c:forEach items="$\{pageInfo.navigatepageNums \}" var="page\_Num">  
                        <c:if test="$\{page\_Num == pageInfo.pageNum \}">  
                            <li class="paginItem"><a href="\#">$\{page\_Num \}</a></li>  
                        </c:if>  
                        <c:if test="$\{page\_Num != pageInfo.pageNum \}">  
                            <li class="paginItem"><a href="$\{pageContext.request.contextPath\}/UserPage?currentPage=$\{page\_Num \}">$\{page\_Num \}</a></li>  
                        </c:if>

</c:forEach>  
        <c:if test="$\{pageInfo.hasNextPage \}">  
        <li class="paginItem"><a href="$\{pageContext.request.contextPath\}/UserPage?currentPage=$\{pageInfo.pageNum+1 \}"> <span>&raquo;</span></a></li>  
        </c:if>  
        <li class="paginItem"><a href="$\{pageContext.request.contextPath\}/UserPage?currentPage=$\{pageInfo.pages\}">末页</a></li>  
        </ul>  
  </div>  
  <body>

--------------------

**9、效果图**

![70 1][]

--------------------

![70 2][]

--------------------

**根据名字的任何一个字段进行查询 ，希望能帮到大家，模糊查询成功**，需要视频资源的可以加我QQ1728608455

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpcXo2NjY_size_16_color_FFFFFF_t_70][]

[20190926145403701.png]: /images/20210920/580024bf445345c0a648df17e770e461.png
[https_blog.csdn.net_liqz666_article_details_81868619]: https://blog.csdn.net/liqz666/article/details/81868619
[https_blog.csdn.net_liqz666_article_details_81532292]: https://blog.csdn.net/liqz666/article/details/81532292
[70]: /images/20210920/c8fb4eacba7f403c930d89992eab962f.png
[70 1]: /images/20210920/93a48750e30d479e8b058f340f75b831.png
[70 2]: /images/20210920/0c2a2138b4ee444a945b9bd8e7d9790e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpcXo2NjY_size_16_color_FFFFFF_t_70]: /images/20210920/61c80c795b4549899247d2342c948f4d.png