7月15日总结

（1）用list查询数据库中所以记录，再table来盛放从数据库查询的结果。

HelloWorldController.java

    @RequestMapping(value = "/all", method = RequestMethod.POST)

    public String selectall(UserBean UserBean,Model model) {

    List<UserBean> result=helloWorldService.selectall(UserBean);

    model.addAttribute("list",result);

        return "all";

    }

HelloWorldService.java

public List<UserBean> selectall(UserBean ll){

List<UserBean> result=queryDao.executeForObjectList("User.selectall", ll);

//frm=queryDao.executeForObject("User.selectUser",frm, UserBean.class);

//frm.setUserID("test");

return result;

}

UserSqlMap.xml

<select id="selectall"

parameterClass="cn.training.controller.UserBean"

resultClass="cn.training.controller.UserBean">

SELECT

userId as userID,password

FROM

user

</select>

（2）删除一条查询的结果。

HelloWorldController.java

@RequestMapping(value = "/deleteid", method = RequestMethod.GET)

    public String delete(UserBean UserBean,Model model) {

     helloWorldService.deleteid(UserBean);

     //model.addAttribute("UserBean",result);

     List<UserBean> result1=helloWorldService.selectall(UserBean);

     model.addAttribute("list",result1);

        return "all";

    }

HelloWorldService.java

public int deleteid(UserBean oo){

return updateDao.execute("User.deleteid", oo);

//frm=queryDao.executeForObject("User.selectUser",frm, UserBean.class);

//frm.setUserID("test");

}

UserSqlMap.xml

<delete id="deleteid"

    parameterClass="cn.training.controller.UserBean">

DELETE FROM user WHERE userId=#userID#

</delete>

（3）table来盛放从数据库查询的结果

<h1>用户信息</h1>

        <c:forEach items="${list}" var="goodsInfo" varStatus="status">

<p>userid:${goodsInfo.userID}</p>

<p>password:${goodsInfo.password}</p>

<!--<div class="price" style="height: 35px;">

<span class="reducedfrom">password:${goodsInfo.password}</span>

</div>-->

  </c:forEach>

   <!--<c:forEach

    items="${list}" var="user" varStatus="s"  >

   <p class="title1">userid:${user.userID}</p>

   <p class="title2">password:${user.password}</p>

   </c:forEach>-->

（4）通过链接方式删除一条记录。

<h1>用户信息</h1>     

        <table>

             <tr>

             <td>userid</td>

             <td>username</td>

             </tr>

             <c:forEach items="${list}" var="goodsInfo" varStatus="status">

              <tr>

                <td><a href="deleteid?userID=${goodsInfo.userID}">${goodsInfo.userID}</a></td> 

                <td>${goodsInfo.password}</td>              

              </tr>

               </c:forEach>

       </table>

转载于:https://my.oschina.net/u/2413996/blog/479062