Java电商项目面试--收货地址模块

爱被打了一巴掌 2021-09-27 08:38 582阅读 0赞

> **收货地址模块技术要点：**  
> **1、同步获取自增主键  
> 2、数据绑定的对象绑定  
> 3、越权问题升级巩固**

**一、新增收货地址**  
Controller层：

//新建收货地址
    @RequestMapping("add.do")
    @ResponseBody
    public ServerResponse add(HttpSession session,Shipping shipping){
        User user = (User)session.getAttribute(Const.CURRENT_USER);
        if(user ==null)
            return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),ResponseCode.NEED_LOGIN.getDesc());
        return iShippingService.add(user.getId(),shipping);
    }

Service层：

//新建收货地址
    public ServerResponse add(Integer userId, Shipping shipping){
        shipping.setUserId(userId);
        int rowCount = shippingMapper.insert(shipping);
        if(rowCount > 0){
            Map result = Maps.newHashMap();
            result.put("shippingId",shipping.getId());
            return ServerResponse.createBySuccess("新建地址成功",result);
        }
        return ServerResponse.createByErrorMessage("新建地址失败");
    }

Mapper.xml：

<insert id="insert" parameterType="com.mmall.pojo.Shipping" useGeneratedKeys="true" keyProperty="id">
        insert into mmall_shipping (id, user_id, receiver_name,
        receiver_phone, receiver_mobile, receiver_province,
        receiver_city, receiver_district, receiver_address,
        receiver_zip, create_time, update_time
        )
        values (#{
       id,jdbcType=INTEGER}, #{
       userId,jdbcType=INTEGER}, #{
       receiverName,jdbcType=VARCHAR},
        #{
       receiverPhone,jdbcType=VARCHAR}, #{
       receiverMobile,jdbcType=VARCHAR}, #{
       receiverProvince,jdbcType=VARCHAR},
        #{
       receiverCity,jdbcType=VARCHAR}, #{
       receiverDistrict,jdbcType=VARCHAR}, #{
       receiverAddress,jdbcType=VARCHAR},
        #{
       receiverZip,jdbcType=VARCHAR}, now(), now()
        )
    </insert>

**同步获取自增主键**  
Mybatis 配置文件 useGeneratedKeys 参数只针对 insert 语句生效，默认为 false。当设置为 true 时，表示如果插入的表以自增列为主键，则允许 JDBC 支持自动生成主键，并可将自动生成的主键返回。

**二、删除收货地址**  
Controller层：

@RequestMapping("del.do")
    @ResponseBody
    public ServerResponse del(HttpSession session,Integer shippingId){
        User user = (User)session.getAttribute(Const.CURRENT_USER);
        if(user ==null){
            return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),ResponseCode.NEED_LOGIN.getDesc());
        }
        return iShippingService.del(user.getId(),shippingId);
    }

Service层：

public ServerResponse<String> del(Integer userId,Integer shippingId){
        int resultCount = shippingMapper.deleteByShippingIdUserId(userId,shippingId);
        if(resultCount > 0){
            return ServerResponse.createBySuccess("删除地址成功");
        }
        return ServerResponse.createByErrorMessage("删除地址失败");
    }

Mapper.xml：

<delete id="deleteByShippingIdUserId" parameterType="map">
        DELETE  FROM  mmall_shipping
        where id = #{shippingId}
        and user_id = #{userId}
    </delete>

**三、更新收货地址**  
Controller层：

@RequestMapping("update.do")
    @ResponseBody
    public ServerResponse update(HttpSession session,Shipping shipping){
        User user = (User)session.getAttribute(Const.CURRENT_USER);
        if(user ==null){
            return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),ResponseCode.NEED_LOGIN.getDesc());
        }
        return iShippingService.update(user.getId(),shipping);
    }

Service层：

public ServerResponse update(Integer userId, Shipping shipping){
        shipping.setUserId(userId);
        int rowCount = shippingMapper.updateByShipping(shipping);
        if(rowCount > 0){
            return ServerResponse.createBySuccess("更新地址成功");
        }
        return ServerResponse.createByErrorMessage("更新地址失败");
    }

Mapper.xml：

<update id="updateByShipping" parameterType="com.mmall.pojo.Shipping">
      update mmall_shipping
      set
        receiver_name = #{
       receiverName,jdbcType=VARCHAR},
        receiver_phone = #{
       receiverPhone,jdbcType=VARCHAR},
        receiver_mobile = #{
       receiverMobile,jdbcType=VARCHAR},
        receiver_province = #{
       receiverProvince,jdbcType=VARCHAR},
        receiver_city = #{
       receiverCity,jdbcType=VARCHAR},
        receiver_district = #{
       receiverDistrict,jdbcType=VARCHAR},
        receiver_address = #{
       receiverAddress,jdbcType=VARCHAR},
        receiver_zip = #{
       receiverZip,jdbcType=VARCHAR},
        create_time = #{
       createTime,jdbcType=TIMESTAMP},
        update_time = now()
      where id = #{
       id,jdbcType=INTEGER}
      and user_id = #{
       userId,jdbcType=INTEGER}
    </update>

**SpringMVC绑定对象**  
CSpringMVC会按请求参数名和POJO属性名进行自动匹配，自动为该对象填充属性值，支持级联属性。  
注意：pojo对象的属性名和表单中input的name属性一致  
表单：

处理器映射方法：

@RequestMapping(value={
       "/insertItem.action"})
    public String insertItem(Model model,Item item){
        return "itemList";
    }

注意：提交的表单不要有日期类型的数据，否则会报错400，如果需要提交日期类型的数据，需要自定义参数绑定的内容  
**SpringMVC时间处理**  
1. 在控制器中使用@InitBind注解

@Controller
    public class TestFileController {
    
        @InitBinder
        public void initBind(WebDataBinder binder){
            SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");  
            dateFormat.setLenient(false);  
            binder.registerCustomEditor(Date.class, new CustomDateEditor(dateFormat, true));   
        }
    
        @RequestMapping("/doAdd")
        public void doAdd(@ModelAttribute User user, HttpServletRequest request){
            System.out.println(user.getName());
            System.out.println(user.getBirthtime());
        }
    }

2. 在POJO中日期属性上添加@DateTimeFormat

public class User{
        private String name;
    
        @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm")
        private Date birthtime;
    
        // 属性的setter/getter方法略
    }

**SpringMVC乱码解决**  
post中文乱码：

<filter>
        <filter-name>CharacterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
      </filter>
      <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
        <url-pattern>*.action</url-pattern>
      </filter-mapping>

get中文乱码：

方法1:修改tomcat的server.xml 
    <Connector URIEncoding="utf-8" connectionTimeout="20000" port="8080" protocol="HTTP/1.1" redirectPort="8443"/>
    方式2:手动转码
    new String(request.getParameter("id").getBytes("iso8859-1"), "utf-8");

**四、查询收货地址列表**  
Controller层：

@RequestMapping("list.do")
    @ResponseBody
    public ServerResponse<PageInfo> list(@RequestParam(value = "pageNum",defaultValue = "1") int pageNum,
                                         @RequestParam(value = "pageSize",defaultValue = "10")int pageSize,
                                         HttpSession session){
        User user = (User)session.getAttribute(Const.CURRENT_USER);
        if(user ==null){
            return ServerResponse.createByErrorCodeMessage(ResponseCode.NEED_LOGIN.getCode(),ResponseCode.NEED_LOGIN.getDesc());
        }
        return iShippingService.list(user.getId(),pageNum,pageSize);
    }

Service层：

public ServerResponse<PageInfo> list(Integer userId,int pageNum,int pageSize){
        PageHelper.startPage(pageNum,pageSize);
        List<Shipping> shippingList = shippingMapper.selectByUserId(userId);
        PageInfo pageInfo = new PageInfo(shippingList);
        return ServerResponse.createBySuccess(pageInfo);
    }

Mapper.xml：

<select id="selectByUserId" resultMap="BaseResultMap" parameterType="map">
        SELECT
        <include refid="Base_Column_List"/>
        from mmall_shipping
        where user_id = #{userId}
    </select>

--------------------

**Java面试的完整博客目录如下：[Java笔试面试目录][Java]**

> **转载请标明出处，原文地址：[https://blog.csdn.net/weixin\_41835916][https_blog.csdn.net_weixin_41835916] 如果觉得本文对您有帮助，请点击顶支持一下，您的支持是我写作最大的动力，谢谢。  
> ![这里写图片描述][70]**

[Java]: https://blog.csdn.net/weixin_41835916/article/details/81413498
[https_blog.csdn.net_weixin_41835916]: https://blog.csdn.net/weixin_41835916
[70]: /images/20210923/a81a41af87cf491992f00ef840576c1e.png