7.1 ssm 暑期实习

于 2020-07-17 11:13:17 发布
阅读量109 收藏
点赞数
文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45213939/article/details/107403973
版权

ssm修改及定向查询简易实现
前言
暑期项目实习第七课， ssm修改及定向查询简易实现

UserController

   @RequestMapping("/findById.do")
    public String findById(int id, Model model){
        User user = userService.findById(id);
        model.addAttribute("user",user);
        return "../modify";
    }

    @RequestMapping("/update.do")
    public String update(User user){
        boolean del = userService.update(user);
        if(del){
            return "redirect:findAll.do";
        }else {
            return "../failure";
        }
    }

UserService

User findById(Integer id);

boolean update(User user);

List<User> searchByName(String name);

UserServiceImpl
 @Override
    public User findById(Integer id){
        User user = userDao.findUserById(id);
        return user;
    }

    @Override
    public boolean update(User user){
        int upd = userDao.update(user);
        if(upd > 0){
            return true;
        }
        else return false;
    }

    @Override
    public List<User> searchByName(String name){
        return userDao.searchByName(name);
    }

UserDao

 int update(User user);

    User findUserById(Integer id);

    List<User> searchByName(String name);

UserMapper

<select id="findUserById" parameterType="Integer" resultType="User">
    select * from user where id=#{id}
</select>

<update id="update" parameterType="User">
    update user set name=#{name},password=#{password} where id=#{id}
</update>

<select id="searchByName" parameterType="String" resultType="User">
    select * from user where name like concat('%',#{name},'%')
</select>

JSP
modify

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>修改</title>
</head>
<body>
<div>
    <form action="/user/update.do">
        <input name="id" value="${user.id}" type="hidden">
        <div>
            <label for="name">用户名：</label>
            <input name="name" type="text" id="name" value="${user.name}">
        </div>
        <div>
            <label for="password">密码</label>
            <input name="password" type="text" id="password" value="${user.password}">
        </div>
        <div>
            <input type="submit" value="提交">
        </div>
        <a href="javasceipt:window.history.go(-1)">返回</a>
    </form>
</div>
</body>
</html>

main

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>列表</title>
</head>
<body>
<div>
    <form action="/user/findAll.do">
        <input id="name" type="search" name="name" value="${name}">
        <button onclick="form.submit()">搜索</button>
    </form>
    <TABLE>
        <THEAD>
        <TR>
            <th>ID</th>
            <th>用户名</th>
            <th>密码</th>
            <th>操作</th>
        </TR>
        </THEAD>

        <tbody>
        <c:forEach items="${userList}" var="user">
            <tr>
                <td>${user.id}</td>
                <td>${user.name}</td>
                <td>${user.password}</td>
                <td>
                    <a href="${pageContext.request.contextPath}/user/delete.do?id=${user.id}">删除</a>
                    <a href="${pageContext.request.contextPath}/user/findById.do?id=${user.id}">修改</a>
                </td>
            </tr>
        </c:forEach>
        </tbody>
    </TABLE>
</div>
</body>
</html>

UserController

  @RequestMapping("/findById.do")
    public String findById(int id, Model model){
        User user = userService.findById(id);
        model.addAttribute("user",user);
        return "../modify";
    }

    @RequestMapping("/update.do")
    public String update(User user){
        boolean del = userService.update(user);
        if(del){
            return "redirect:findAll.do";
        }else {
            return "../failure";
        }
    }

UserService

User findById(Integer id);

boolean update(User user);

List<User> searchByName(String name);

UserServiceImpl

@Override
    public User findById(Integer id){
        User user = userDao.findUserById(id);
        return user;
    }

    @Override
    public boolean update(User user){
        int upd = userDao.update(user);
        if(upd > 0){
            return true;
        }
        else return false;
    }

    @Override
    public List<User> searchByName(String name){
        return userDao.searchByName(name);
    }

UserDao

 int update(User user);

    User findUserById(Integer id);

    List<User> searchByName(String name);

UserMapper

<select id="findUserById" parameterType="Integer" resultType="User">
        select * from user where id=#{id}
    </select>

    <update id="update" parameterType="User">
        update user set name=#{name},password=#{password} where id=#{id}
    </update>

    <select id="searchByName" parameterType="String" resultType="User">
        select * from user where name like concat('%',#{name},'%')
    </select>

JSP
modify

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>修改</title>
</head>
<body>
<div>
    <form action="/user/update.do">
        <input name="id" value="${user.id}" type="hidden">
        <div>
            <label for="name">用户名：</label>
            <input name="name" type="text" id="name" value="${user.name}">
        </div>
        <div>
            <label for="password">密码</label>
            <input name="password" type="text" id="password" value="${user.password}">
        </div>
        <div>
            <input type="submit" value="提交">
        </div>
        <a href="javasceipt:window.history.go(-1)">返回</a>
    </form>
</div>
</body>
</html>

main

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>列表</title>
</head>
<body>
<div>
    <form action="/user/findAll.do">
        <input id="name" type="search" name="name" value="${name}">
        <button onclick="form.submit()">搜索</button>
    </form>
    <TABLE>
        <THEAD>
        <TR>
            <th>ID</th>
            <th>用户名</th>
            <th>密码</th>
            <th>操作</th>
        </TR>
        </THEAD>

        <tbody>
        <c:forEach items="${userList}" var="user">
            <tr>
                <td>${user.id}</td>
                <td>${user.name}</td>
                <td>${user.password}</td>
                <td>
                    <a href="${pageContext.request.contextPath}/user/delete.do?id=${user.id}">删除</a>
                    <a href="${pageContext.request.contextPath}/user/findById.do?id=${user.id}">修改</a>
                </td>
            </tr>
        </c:forEach>
        </tbody>
    </TABLE>
</div>
</body>
</html>
東木桑
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值