SpringMVC篇(三)——实现注册、修改和查询功能功能

左手的ㄟ右手 2023-03-01 11:59 14阅读 0赞

# 前言 #

在上一篇中我们已经实现了登录、删除的功能，本篇中将实现注册、修改和查询功能

# 项目编写 #

## 1、注册 ##

### dao ###

package com.zr0701.dao;
    
    import com.zr0701.bean.User;
    
    import java.util.List;
    
    public interface UserDao {
        
        User findUserByName(String name);
    
        List<User> findAll();
    
        int deleteById(Integer id);
    
        int add(User user);
    }
    
    }

### SQL语句 ###

<insert id="add" parameterType="Integer">
            insert into user (name,password) value (#{
        name},#{
        password})
        </insert>

### Service ###

boolean add(User user);

### Impl ###

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

### Controller ###

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

### 创建注册页面 ###

![在这里插入图片描述][20200725044056678.png]

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

## 2、修改 ##

### dao ###

### SQL语句 ###

<select id="findUserById" parameterType="Interger" 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>

### Service ###

User findById(Integer id);
    
        boolean update(User user);

### Impl ###

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

### Controller ###

@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 upd = userService.update(user);
            if (upd){
        
                return "redirect:findAll.do";
            }
            return "../failure";
        }

### 创建修改页面 ###

![在这里插入图片描述][2020072504443096.png]

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>修改</title>
    </head>
    <body>
    <div>
        <form action="/user/add.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="javascrip:window.history.go(-1)">返回</a>
        </form>
    </div>
    
    
    </body>
    </html>

### 在main.jsp中添加以下代码 ###

## 3、查询 ##

### dao ###

### SQL语句 ###

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

### Service ###

List<User> searchByName(String name);

### Impl ###

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

### Controller ###

修改findall方法

@RequestMapping("/findAll.do")//..../findAll.do?name=
        public ModelAndView findAll(@RequestParam(value = "name",defaultValue = "")String name){
        
            ModelAndView modelAndView = new ModelAndView();
            List<User> userList = userService.searchByName(name);
            System.out.println("userList中的内容为："+userList);
            modelAndView.addObject("userList",userList);
            modelAndView.setViewName("../main");
            System.out.println("modelAndView中的内容为："+modelAndView);
            return modelAndView;
        }

### 在main.jsp的div中添加以下代码 ###

[20200725044056678.png]: /images/20230208/6a5906f679d14f92ab0e9d1af60797ad.png
[2020072504443096.png]: /images/20230208/e9186daad6f84698813d3af557d91a56.png