Spring Boot + MyBatis 电商项目 -04- 使用 Spring MVC 读取用户信息、筛选字段

谁借莪１个温暖的怀抱￠ 2022-03-30 13:10 178阅读 0赞

### Spring Boot + MyBatis 电商项目 -04- 使用 Spring MVC 读取用户信息、筛选字段 ###

**前几篇文章：**

（如果不是新手，建议至少看完第 3 篇，因为整个项目是基于第三篇创建的很多文件进行的）

*  [Spring Boot + MyBatis 电商项目 - 01- 开题 + 创建项目][Spring Boot _ MyBatis _ - 01- _ _]
 *  [Spring Boot + MyBatis 电商项目 - 02- 引入 Spring Boot 依赖包][Spring Boot _ MyBatis _ - 02- _ Spring Boot]
 *  [Spring Boot + MyBatis 电商项目 - 03- MySQL 连接、DRUID、MyBatis-generator 配置及测试][Spring Boot _ MyBatis _ - 03- MySQL _DRUID_MyBatis-generator]

**本篇功能：**  
（1）基于上一篇的内容，完成获取两个表全部信息，和只显示部分字段  
（2）在使用 Spring MVC 时，如何在隐藏数据库中的部分字段，也就是 User 的部分属性？  
（3）本篇思想是通过下面这种方式转换数据对象：

BeanUtils.copyProperties(userModel,userVO);

将含有全部属性的 userModel，转换为含有部分属性的 userVO

![在这里插入图片描述][20190108234729800.gif]

### 一、先在数据库插入几条数据 ###

上一次，只有一条，我们可以连接了，多插入几条：  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMTQ3ODYz_size_16_color_FFFFFF_t_70][]

### 二、构建项目，配置文件源码 ###

（1）先构建项目结构，创建目录，创建类，接口以及配置文件，内容下面会有

**老规矩，先看一下，整个的项目结构：**

熟悉 Spring 的话，应该会知道，这里找两个包，controller 和 service 我们手动创建项目结构。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMTQ3ODYz_size_16_color_FFFFFF_t_70 1][]

**（2）pom.xml 文件（第 2 篇介绍过，可以在对照一下）：**

<dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.11</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>com.jayway.jsonpath</groupId>
                <artifactId>json-path</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.13</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.3</version>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.7</version>
            </dependency>
    
        </dependencies>

（3）application.properties 文件：

#自定义端口
    server.port=8090
    
    mybatis.mapper-locations=classpath:mapping/*.xml spring.datasource.name=miaosha spring.datasource.url=jdbc:mysql://127.0.0.1:3306/miaosha?serverTimezone=UTC spring.datasource.username=root spring.datasource.password=xiaopengwei # 使用 druid 数据源 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

（3）generatorConfig.xml 文件（自动生成 DO，DAO，Mapping.xml 文件，不想用自动生成工具也可以，下面会贴出源代码，但是最好学会如何生成，因为每个项目，都是根据相应的数据库字段生成的，还是非常方便的）：

**使用步骤：** [mybatis-generator 详细配置及使用，爬坑记录][mybatis-generator]

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
    
        
        
        
        <context id="default" targetRuntime="MyBatis3">
    
    
            
            
            
            <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                            connectionURL="jdbc:mysql://127.0.0.1:3306/miaosha?serverTimezone=UTC"
                            userId="root"
                            password="xiaopengwei">
            </jdbcConnection>
    
            
            
            
            <javaModelGenerator targetPackage="com.miaoshapro.dataobject"
                                targetProject=".\src\main\java">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="constructorBased" value="true" />
                
                <property name="trimStrings" value="true" />
                
                <property name="immutable" value="false" />
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapping"
                             targetProject=".\src\main\resources">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER"
                                 targetPackage="com.miaoshapro.dao" targetProject=".\src\main\java">
                
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
    
            
            <table tableName="user_info" domainObjectName="UserDO"
                   enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
            enableSelectByExample="false">
            </table>
            <table tableName="user_pwd" domainObjectName="UserPwdDO"
                   enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false">
            </table>
        </context>
    </generatorConfiguration>

### 三、src/main/java 下文件源代码 ###

（1）Controller/UserController.java 文件：

package com.miaoshapro.controller;
    
    import com.miaoshapro.controller.viewobject.UserVO;
    import com.miaoshapro.service.UserService;
    import com.miaoshapro.service.model.UserModel;
    import org.springframework.beans.BeanUtils;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestParam;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    @Controller("user")
    @RequestMapping("/user")
    public class UserController { 
    
        @Autowired
        private UserService userService;
    
        //关联查询，获取用户信息表和密码表全部信息
        @RequestMapping("/getall")
        @ResponseBody
        public UserModel getUser(@RequestParam(name = "id")Integer id){ 
            //调用 service 服务获取对应 id 的用户对象并返回给前端
            UserModel userModel = userService.getUserById(id);
    
            //将核心领域模型用户对象转化为可供 UI 使用的 viewobject
            return userModel;
        }
    
        //通过转换成只含有部分属性的 userModel
        @RequestMapping("/get")
        @ResponseBody
        public UserVO getUserVo(@RequestParam(name = "id")Integer id){ 
            //调用 service 服务获取对应 id 的用户对象并返回给前端
            UserModel userModel = userService.getUserById(id);
    
            //将核心领域模型用户对象转化为可供 UI 使用的 viewobject
            return convertFormModel(userModel);
        }
    
    
        //userModel 拥有数据库中的所有字段，但是前端显示不能显示所有字段
        //所以在 controller/viewobject 中新建了一个 UserVO 模型，只存放部分字段对应的属性
        private UserVO convertFormModel(UserModel userModel){ 
            if (userModel == null){ 
                return null;
            }
            UserVO userVO = new UserVO();
    
            //转换的方法
            BeanUtils.copyProperties(userModel,userVO);
            return userVO;
    
        }
    
    }

（2）controller/viewobject/UserVO.java 文件：

package com.miaoshapro.controller.viewobject;
    
    public class UserVO { 
    
        private Integer id;
        private String uname;
        private Byte gender;
        private Integer age;
        private String phone;
    
        public Integer getId() { 
            return id;
        }
    
        public void setId(Integer id) { 
            this.id = id;
        }
    
        public String getUname() { 
            return uname;
        }
    
        public void setUname(String uname) { 
            this.uname = uname;
        }
    
        public Byte getGender() { 
            return gender;
        }
    
        public void setGender(Byte gender) { 
            this.gender = gender;
        }
    
        public Integer getAge() { 
            return age;
        }
    
        public void setAge(Integer age) { 
            this.age = age;
        }
    
        public String getPhone() { 
            return phone;
        }
    
        public void setPhone(String phone) { 
            this.phone = phone;
        }
    }

（3）service/UserService.java 文件：

package com.miaoshapro.service;
    
    import com.miaoshapro.service.model.UserModel;
    
    public interface UserService { 
    
        //通过用户 id 获取用户对象的方法
        UserModel getUserById(Integer id);
    
    
    }

（4）service/impl/UserServiceImpl.java 文件：

package com.miaoshapro.service.impl;
    
    import com.miaoshapro.dao.UserDOMapper;
    import com.miaoshapro.dao.UserPwdDOMapper;
    import com.miaoshapro.dataobject.UserDO;
    import com.miaoshapro.dataobject.UserPwdDO;
    import com.miaoshapro.service.UserService;
    import com.miaoshapro.service.model.UserModel;
    import org.springframework.beans.BeanUtils;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    
    @Service
    public class UserServiceImpl implements UserService { 
    
        @Autowired
        private UserDOMapper userDOMapper;
    
        @Autowired
        private UserPwdDOMapper userPwdDOMapper;
    
        @Override
        public UserModel getUserById(Integer id) { 
    
            //通过 userDOMapper 获取到对应的用户 dataObject
            UserDO userDO = userDOMapper.selectByPrimaryKey(id);
            if (userDO == null){ 
                return null;
            }
            //通过用户 id 获取密码信息
            UserPwdDO userPwdDO = this.userPwdDOMapper.selectByUserId(userDO.getId());
            return convertFromDataObject(userDO,userPwdDO);
    
        }
    
        //
        private UserModel convertFromDataObject(UserDO userDO, UserPwdDO userPwdDO){ 
    
            if (userDO == null){ 
                return null;
            }
            UserModel userModel = new UserModel();
            BeanUtils.copyProperties(userDO,userModel);
    
            if (userPwdDO != null){ 
                userModel.setEncrptPassword(userPwdDO.getUpwd());
            }
            return userModel;
        }
    
    }

（5）service/model/UserModel.java 文件：

package com.miaoshapro.service.model;
    
    public class UserModel { 
    
        private Integer id;
        private String uname;
        private Byte gender;
        private Integer age;
        private String phone;
        private String registerMode;
        private String thirdPartyId;
    
        private String encrptPassword;
    
        public Integer getId() { 
            return id;
        }
    
        public void setId(Integer id) { 
            this.id = id;
        }
    
        public String getUname() { 
            return uname;
        }
    
        public void setUname(String uname) { 
            this.uname = uname;
        }
    
        public Byte getGender() { 
            return gender;
        }
    
        public void setGender(Byte gender) { 
            this.gender = gender;
        }
    
        public Integer getAge() { 
            return age;
        }
    
        public void setAge(Integer age) { 
            this.age = age;
        }
    
        public String getPhone() { 
            return phone;
        }
    
        public void setPhone(String phone) { 
            this.phone = phone;
        }
    
        public String getRegisterMode() { 
            return registerMode;
        }
    
        public void setRegisterMode(String registerMode) { 
            this.registerMode = registerMode;
        }
    
        public String getThirdPartyId() { 
            return thirdPartyId;
        }
    
        public void setThirdPartyId(String thirdPartyId) { 
            this.thirdPartyId = thirdPartyId;
        }
    
        public String getEncrptPassword() { 
            return encrptPassword;
        }
    
        public void setEncrptPassword(String encrptPassword) { 
            this.encrptPassword = encrptPassword;
        }
    }

### 四、mybatis-generator 自动生成的文件源代码 ###

*  打包免费下载：[https://pan.baidu.com/s/1hbjyJHxfu\_45tNF5ghs0YQ][https_pan.baidu.com_s_1hbjyJHxfu_45tNF5ghs0YQ]

### 更多文章链接 ###

*  [Spring Boot + MyBatis 电商项目][Spring Boot _ MyBatis]

### 支持博主 ###

我正在参加 CSDN 2018 年博客之星评选，希望大家能支持我，  
我是【No. 001】号 肖朋伟 ，感谢大家宝贵的一票 ^\_^/  
投票地址：[https://bss.csdn.net/m/topic/blog\_star2018/index][https_bss.csdn.net_m_topic_blog_star2018_index]

[Spring Boot _ MyBatis _ - 01- _ _]: https://blog.csdn.net/qq_40147863/article/details/85870950
[Spring Boot _ MyBatis _ - 02- _ Spring Boot]: https://blog.csdn.net/qq_40147863/article/details/85878056
[Spring Boot _ MyBatis _ - 03- MySQL _DRUID_MyBatis-generator]: https://blog.csdn.net/qq_40147863/article/details/85880247
[20190108234729800.gif]: /images/20220330/f2dcbf17ed8843c29ad5b215421c3171.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMTQ3ODYz_size_16_color_FFFFFF_t_70]: /images/20220330/b85f6b1f7e8c464ab098f04b72688188.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMTQ3ODYz_size_16_color_FFFFFF_t_70 1]: /images/20220330/39091963615c43eea7eb4c4b7e5d84c1.png
[mybatis-generator]: https://blog.csdn.net/qq_40147863/article/details/85886166
[https_pan.baidu.com_s_1hbjyJHxfu_45tNF5ghs0YQ]: https://pan.baidu.com/s/1hbjyJHxfu_45tNF5ghs0YQ
[Spring Boot _ MyBatis]: https://blog.csdn.net/qq_40147863/article/category/8587227
[https_bss.csdn.net_m_topic_blog_star2018_index]: https://bss.csdn.net/m/topic/blog_star2018/index