查询时动态检索springmvc + mabatis

最新推荐文章于 2020-09-22 16:29:05 发布

wanlichang200

最新推荐文章于 2020-09-22 16:29:05 发布

阅读量891

点赞数

本文链接：https://blog.csdn.net/wanlichang200/article/details/51752814

版权

实现动态检索如

页面jsp

<form   action="<%=request.getContextPath() %>/admin/account/myuserbynameortele" method="post">
           <table >
         <tr>

           <th>用户姓名</th>
           <td>
            <input type="text" name="username" id="username" />
           </td>


           <th>联系电话</th>
           <td>
            <input type="text" name="usertele" id="usertele" />
           </td>

           <td>
            <button id="qryEmp" type="submit"
           iconCls="icon-search" class="easyui-linkbutton">查询</button>

           </td>

         </tr>
        </table>
      </form>

control

//检索根据用户姓名和联系电话

@RequestMapping(value = "/myuserbynameortele",method = RequestMethod.POST)
public String myuserbynameortele(Model model,String username,String usertele,HttpSession session) {

     Login lo =(Login)session.getAttribute("loginUser");

  String userID=lo.getUserID();

  System.out.println(usertele);
  System.out.println(username);
Pager<Accountinfo> acc = accountinfoService.listBynameortele(userID,username,usertele);

model.addAttribute("datas",acc);
  System.out.println("aaaaaaaaaaaaaaaa");
    return "account/myuser";

}

Iservice

/**
*根据指定联系电话或者真实姓名检索
* @param id
*/

public Pager<Accountinfo> listBynameortele(String userID,String username,String usertele);

service

/**
* 获取子用户分页列表集合信息
*/
@Override
public Pager<Accountinfo> findaccount(String userID) {
  //获取子用户总数
  int count=accountDao.countzi(userID);
  /*
  //获取用户分页列表集合信息
  List<accountinfo> list = accountDao.findzi(userID);*/
  //封装PageBounds对象
  PageBounds pageBounds = PageBoundsUtil.PageBoundsOrderExtend("ID.asc");

  List<Accountinfo> list = accountDao.findzi(pageBounds,userID);

  //封装用户分页的Pager对象
  Pager<Accountinfo> pages = new Pager<Accountinfo>(count,list);
  return pages;
}

dao

//根据电话和姓名查找
public List<Accountinfo> findbynameortele(PageBounds pagebounds,Accountinfo acc);

//根据电话和姓名查找个数
public int countbynameortele(Accountinfo acc);

xml

<select id="findbynameortele" parameterType="com.internet.cms.model.accountinfo.Accountinfo"    resultMap="accountinfo">
  select c.*
   from Wx_User_Info c where 1=1
  <if test="_parameter.userID!=null and _parameter.userID!=''">
  and c.User_main_id =#{userID}
  </if>

  <if test="_parameter.username!=null and _parameter.username!=''">
   and c.User_name =#{username}
  </if>
  <if test="_parameter.usertele!=null and _parameter.usertele!=''">
   and c.User_tele = #{usertele}
  </if>
</select>

   
<select id="countbynameortele" parameterType="com.internet.cms.model.accountinfo.Accountinfo" resultType="int">
select count(*)
  from Wx_User_Info c where 1=1
  <if test="_parameter.userID!=null and _parameter.userID!=''">
  and User_main_id =#{userID}
  </if>
  <if test="_parameter.username!=null and _parameter.username!=''">
   and User_name =#{username}
  </if>
  <if test="_parameter.usertele!=null and _parameter.usertele!=''">
   and User_tele = #{usertele}
  </if>
</select>