springBoot后端五层基础写法

最新推荐文章于 2024-05-03 13:13:36 发布
最新推荐文章于 2024-05-03 13:13:36 发布
阅读量431 收藏 5
点赞数 6
文章标签： spring boot 后端 java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2301_77572947/article/details/136376839
版权

实体层

package com.slwvote.system.domain.community;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.slwvote.common.core.domain.BaseEntity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
import java.math.BigDecimal;
import java.util.List;
/**
 * 楼栋表
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
@TableName("cu_building")
public class Building extends BaseEntity {
    /**
     * 楼栋ID
     */
    @JsonFormat(shape = JsonFormat.Shape.STRING)
    @TableId(value = "building_id")
    private Long buildingId;

    /**
     * 楼栋编码
     */
    private String buildingCode;

    /**
     * 楼栋名称
     */
    private String buildingName;

    /**
     * 楼层数
     */
    private Long floorNumber;

    /**
     * 户数
     */
    private Long households;

    /**
     * 是否有电梯(0:否 1:是)
     */
    private String elevator;

    /**
     * 占地面积
     */
    private BigDecimal buildingSpace;

    /**
     * 备注
     */
    private String remark;

    /**
     * 是否删除(0:否 1:是)
     */
    private String delFlag;

    /**
     * 小区ID
     */
    private Long residenceId;

    /**
     * 所属小区
     */
    private Residence residence;

    /**
     * 单元列表
     */
    private List<Unit> units;
}

Mapper层

package com.slwvote.system.mapper.community;

import com.baomidou.mybatisplus.core.conditions.Wrapper;

import com.baomidou.mybatisplus.core.toolkit.Constants;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.slwvote.common.core.mapper.BaseMapperPlus;

import com.slwvote.system.domain.community.Building;

import com.slwvote.system.domain.community.Residence;

import org.apache.ibatis.annotations.Mapper;

import org.apache.ibatis.annotations.Param;

import java.util.List;

/**

 * 楼栋表 数据层

 */

@Mapper

public interface BuildingMapper extends BaseMapperPlus<BuildingMapper, Building, Building> {

    /**

     *楼栋分页查询

     *

     * @param page

     * @param wrapper

     * @return

     */

    Page<Building> selectBuildingPageList(@Param("page") Page<Building> page,@Param(Constants.WRAPPER) Wrapper<Object> wrapper);

    /**

     * 楼栋列表查询

     *

     * @param buildingName

     * @Param buildingCode

     * @return null没查到 List<Building>查到了

     */

    List<Building> selectList1(@Param("buildingCode")String buildingCode,@Param("buildingName")String buildingName);

    /**

     * 楼栋ID查询

     *

     * @param id

     * @return null没查到 Building查到了

     */

    Building selectById1(Long id);

    /**

     * 添加楼栋信息

     *

     * @param building

     * @return 0失败 >0成功

     */

    int insert1(Building building);

    /**

     * 批量删除楼栋信息

     *

     * @param id

     * @return 0失败 >0成功

     */

    int deleteById1(Long id);

    /**

     * 修改楼栋信息

     *

     * @param building

     * @return 0失败 >0成功

     */

    int updateById1(Building building);

    /**

     * 通过小区ID查询楼栋信息

     *

     * @param id

     * @return 0没查到 >0查到了

     */

    int selectBuildingByResidenceId(Long id);

}

xml层

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper

        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.slwvote.system.mapper.community.BuildingMapper">

    <resultMap id="BuildingResult" type="com.slwvote.system.domain.community.Building">

        <id property="buildingId" column="building_id"/>

        <result property="buildingCode" column="building_code"/>

        <result property="buildingName" column="building_name"/>

        <result property="floorNumber" column="floor_number"/>

        <result property="households" column="households"/>

        <result property="elevator" column="elevator"/>

        <result property="buildingSpace" column="building_space"/>

        <result property="remark" column="remark"/>

        <result property="delFlag" column="del_flag"/>

        <result property="createBy" column="create_by"/>

        <result property="createTime" column="create_time"/>

        <result property="updateBy" column="update_by"/>

        <result property="updateTime" column="update_time"/>

    </resultMap>

    <resultMap id="ResidenceBuildingUnit" type="com.slwvote.system.domain.community.Building">

        <id property="buildingId" column="building_id"/>

        <result property="buildingCode" column="building_code"/>

        <result property="buildingName" column="building_name"/>

        <result property="floorNumber" column="floor_number"/>

        <result property="households" column="households"/>

        <result property="elevator" column="elevator"/>

        <result property="buildingSpace" column="building_space"/>

        <result property="remark" column="remark"/>

        <result property="delFlag" column="del_flag"/>

        <result property="createBy" column="create_by"/>

        <result property="createTime" column="create_time"/>

        <result property="updateBy" column="update_by"/>

        <result property="updateTime" column="update_time"/>

        <association property="residence" javaType="com.slwvote.system.domain.community.Residence">

            <id property="residenceId" column="residence_id"/>

            <result property="residenceCode" column="residence_code"/>

            <result property="residenceName" column="residence_name"/>

            <result property="residenceLocation" column="residence_location"/>

            <result property="residenceAddress" column="residence_address"/>

            <result property="buildingType" column="building_type"/>

            <result property="buildingSpace" column="building_space"/>

            <result property="buildingNumber" column="building_number"/>

            <result property="households" column="households"/>

            <result property="parkingSpace" column="parking_space"/>

            <result property="supportingFacility" column="supporting_facility"/>

            <result property="remark" column="remark"/>

            <result property="delFlag" column="del_flag"/>

            <result property="createBy" column="create_by"/>

            <result property="createTime" column="create_time"/>

            <result property="updateBy" column="update_by"/>

            <result property="updateTime" column="update_time"/>

        </association>

        <collection property="units" ofType="com.slwvote.system.domain.community.Unit">

            <id property="unitId" column="unit_id"/>

            <result property="unitCode" column="unit_code"/>

            <result property="unitName" column="unit_name"/>

            <result property="floorNumber" column="floor_number"/>

            <result property="households" column="households"/>

            <result property="remark" column="remark"/>

            <result property="delFlag" column="del_flag"/>

            <result property="createBy" column="create_by"/>

            <result property="createTime" column="create_time"/>

            <result property="updateBy" column="update_by"/>

            <result property="updateTime" column="update_time"/>

        </collection>

    </resultMap>

    <select id="selectBuildingPageList" resultMap="ResidenceBuildingUnit">

        select  b.building_id,

                b.building_code,

                b.building_name,

                b.floor_number,

                b.households,

                b.elevator,

                b.building_space,

                b.remark,

                b.del_flag,

                b.create_by,

                b.create_time,

                b.update_by,

                b.update_time,

                b.residence_id,

                r.residence_id,

                r.residence_code,

                r.residence_name,

                r.residence_location,

                r.residence_address,

                r.building_type,

                r.building_space,

                r.building_number,

                r.households,

                r.parking_space,

                r.elevator,

                r.supporting_facility,

                r.del_flag,

                r.create_by,

                r.create_time,

                r.update_by,

                r.update_time,

                r.remark,

                u.unit_id,

                u.unit_code,

                u.unit_name,

                u.floor_number,

                u.households,

                u.del_flag,

                u.create_by,

                u.create_time,

                u.update_by,

                u.update_time,

                u.remark,

                u.building_id

        from cu_building b

        left join cu_residence r on b.residence_id = r.residence_id

        left join cu_unit u on u.building_id = b.building_id

        ${ew.getCustomSqlSegment}

    </select>

    <select id="selectList1" resultMap="BuildingResult">

        select * from cu_building

        where del_flag = 0

        <if test=" buildingCode!=null and buildingCode.trim()!='' ">

            and building_code like '%${buildingCode}%'

        </if>

        <if test=" buildingName!=null and buildingName.trim()!='' ">

            and building_name like '%${buildingName}%'

        </if>

        order by create_time desc

    </select>

    <select id="selectById1" resultMap="BuildingResult">

        select * from cu_building where building_id = #{id} and del_flag = 0

    </select>

    <insert id="insert1">

        insert into cu_building(

        <if test=" buildingId!=null and buildingId.trim()!='' ">building_id,</if>

        <if test=" buildingCode!=null and buildingCode.trim()!='' ">building_code,</if>

        <if test=" buildingName!=null and buildingName.trim()!='' ">building_name,</if>

        <if test=" floorNumber!=null and floorNumber.trim()!='' ">floor_number,</if>

        <if test=" households!=null and households.trim()!='' ">households,</if>

        <if test=" elevator!=null and elevator.trim()!='' ">elevator,</if>

        <if test=" buildingSpace!=null and buildingSpace.trim()!='' ">building_space,</if>

        <if test=" remark!=null and remark.trim()!='' ">remark</if>

        ) values(

        <if test=" buildingId!=null and buildingId.trim()!='' ">#{buildingId},</if>

        <if test=" buildingCode!=null and buildingCode.trim()!='' ">#{buildingCode},</if>

        <if test=" buildingName!=null and buildingName.trim()!='' ">#{buildingName},</if>

        <if test=" floorNumber!=null and floorNumber.trim()!='' ">#{floorNumber},</if>

        <if test=" households!=null and households.trim()!='' ">#{households},</if>

        <if test=" elevator!=null and elevator.trim()!='' ">#{elevator},</if>

        <if test=" buildingSpace!=null and buildingSpace.trim()!='' ">#{buildingSpace},</if>

        <if test=" remark!=null and remark.trim()!='' ">#{remark}</if>

        )

    </insert>

    <delete id="deleteById1">

        delete from cu_building where building_id = #{id}

    </delete>

    <update id="updateById1">

        update cu_building

        <set>

            <if test=" buildingCode!=null and buildingCode.trim()!='' ">

                building_code = #{buildingCode},

            </if>

            <if test=" buildingName!=null and buildingName.trim()!='' ">

                building_name = #{buildingName},

            </if>

            <if test=" floorNumber!=null and floorNumber.trim()!='' ">

                floor_number = #{floorNumber},

            </if>

            <if test=" households!=null and households.trim()!='' ">

                households = #{households},

            </if>

            <if test=" elevator!=null and elevator.trim()!='' ">

                elevator = #{elevator},

            </if>

            <if test=" buildingSpace!=null and buildingSpace.trim()!='' ">

                building_space = #{buildingSpace},

            </if>

            <if test=" remark!=null and remark.trim()!='' ">

                remark = #{remark}

            </if>

        </set>

        where building_id = #{id}

    </update>

    <select id="selectBuildingByResidenceId" resultType="java.lang.Integer">

        select count(*) from cu_building where residence_id = #{id}

</select>

</mapper>

service层

package com.slwvote.system.service.community;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.slwvote.common.core.domain.PageQuery;

import com.slwvote.system.domain.community.Building;

import java.util.List;

/**

 * 楼栋表 业务层

 */

public interface BuildingService {

    /**

     * 楼栋分页查询

     *

     * @param pageQuery

     * @param building

     * @return

     */

    Page<Building> selectBuildingPageList(PageQuery pageQuery,Building building);

    /**

     * 楼栋列表查询

     *

     * @param buildingName

     * @Param buildingCode

     * @return

     */

    List<Building> selectBuildingList(String buildingCode,String buildingName);

    /**

     * 楼栋ID查询

     *

     * @param id

     * @return

     */

    Building selectBuildingById(Long id);

    /**

     * 添加楼栋信息

     *

     * @param building

     * @return

     */

    boolean  insertBuilding(Building building);

    /**

     * 按ID删除楼栋信息

     *

     * @param ids

     * @return

     */

    boolean deleteBuildingByIds(Long[] ids);

    /**

     * 修改楼栋信息

     *

     * @param building

     * @return

     */

    boolean  updateBuilding(Building building);

}

serviceImpl层

package com.slwvote.system.service.community.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.slwvote.common.constant.Constants;

import com.slwvote.common.core.domain.PageQuery;

import com.slwvote.system.domain.community.Building;

import com.slwvote.system.mapper.community.BuildingMapper;

import com.slwvote.system.mapper.community.UnitMapper;

import com.slwvote.system.service.community.BuildingService;

import lombok.RequiredArgsConstructor;

import org.springframework.stereotype.Service;

import java.util.List;

/**

 * 楼栋表 业务层实现

 */

@RequiredArgsConstructor

@Service

public class BuildingServiceImpl implements BuildingService {

    private final BuildingMapper buildingMapper;

    private final UnitMapper unitMapper;

    /**

     * 楼栋分页查询

     *

     * @param pageQuery

     * @param building

     * @return

     */

    @Override

    public Page<Building> selectBuildingPageList(PageQuery pageQuery, Building building) {

        Page<Building> page = buildingMapper.selectBuildingPageList(pageQuery.build(),new QueryWrapper<>()

                .eq(building.getBuildingCode()!=null,"building_code",building.getBuildingCode())

                .eq(building.getBuildingName()!=null,"building_name",building.getBuildingName())

                .eq("del_flag", Constants.DEL_EXIST));

        return page;

    }

    /**

     * 楼栋列表查询

     *

     * @param buildingName

     * @Param buildingCode

     * @return 0失败 List成功

     */

    @Override

    public List<Building> selectBuildingList(String buildingCode,String buildingName) {

        return buildingMapper.selectList1(buildingCode,buildingName);

    }

    /**

     * 楼栋ID查询

     *

     * @param id

     * @return 0失败 Building成功

     */

    @Override

    public Building selectBuildingById(Long id) {

        return buildingMapper.selectById1(id);

    }

    /**

     * 添加楼栋信息

     *

     * @param building

     * @return true成功 false失败

     */

    @Override

    public boolean  insertBuilding(Building building) {

        return buildingMapper.insert1(building);

    }

    /**

     * 批量删除楼栋信息

     *

     * @param ids

     * @return true成功 false失败

     */

    @Override

    public boolean deleteBuildingByIds(Long[] ids) {

        //如果ID列表不为空，循环ID

        if(ids != null && ids.length >0 ){

            for(Long id : ids){

                //查询从表有没有数据

                Integer i = unitMapper.selectUnitByBuildingId(id);

                //没有数据直接删除主表

                if (i == null || i == 0) {

                    buildingMapper.deleteById1(id);

                    return true;

                }

            }

        }

        //有数据返回 error

        return false;

    }

    /**

     * 修改楼栋信息

     *

     * @param building

     * @return true成功 false失败

     */

    @Override

    public boolean updateBuilding(Building building) {

        return buildingMapper.updateById1(building);

    }

}

controller层

package com.slwvote.web.controller.community;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.slwvote.common.core.controller.BaseController;

import com.slwvote.common.core.domain.PageQuery;

import com.slwvote.common.core.domain.R;

import com.slwvote.common.core.domain.page.TableDataInfo;

import com.slwvote.system.domain.community.Building;

import com.slwvote.system.service.community.BuildingService;

import lombok.RequiredArgsConstructor;

import org.springframework.web.bind.annotation.*;

import java.util.List;

/**

 * 楼栋表 控制层

 */

@RequiredArgsConstructor

@RestController

@RequestMapping("/community/building")

public class BuildingController extends BaseController {

    private final BuildingService buildingService;

    /**

     * 楼栋分页查询

     *

     * @param pageQuery

     * @param building

     * @return

     */

    @GetMapping("/pageList")

    public TableDataInfo<Building> pageList(PageQuery pageQuery,Building building){

        Page<Building> page = buildingService.selectBuildingPageList(pageQuery,building);

        return TableDataInfo.build(page);

    }

    /**

     * 楼栋列表查询

     *

     * @param buildingName

     * @Param buildingCode

     * @return

     */

    @GetMapping("/list")

    public R<List<Building>> list(String buildingCode,String buildingName){

        return R.ok(buildingService.selectBuildingList(buildingName,buildingCode));

    }

    /**

     * 楼栋ID查询

     *

     * @param id

     * @return

     */

    @GetMapping("/getInfo")

    public R<Building> getInfo(Long id){

        return R.ok(buildingService.selectBuildingById(id));

    }

    /**

     * 添加楼栋信息

     *

     * @param building

     * @return

     */

    @PostMapping("add")

    public R add(Building building){

        return buildingService.insertBuilding(building) ? R.ok() : R.fail();

    }

    /**

     * 修改楼栋信息

     *

     * @param building

     * @return

     */

    @PostMapping("edit")

    public R edit(Building building){

        return buildingService.updateBuilding(building) ? R.ok() : R.fail();

    }

    /**

     * 按ID删除楼栋信息

     *

     * @param ids

     * @return

     */

    @DeleteMapping("/remove")

    public R remove(Long[] ids){

       return buildingService.deleteBuildingByIds(ids) ? R.ok() : R.fail();

    }

}

2301_77572947
关注
  • 6
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
java的层级说明（参考）
Jerry的博客
12-23 3655
我个人的理解是：涉及请求、参数、序列化之类的逻辑可以放在controller。而具体到数据的操作逻辑，也就是增删改查的操作都应该完整封装到service中。一方面是对于事务的要求，比如一个请求过来，后台需要多步增删改查，一般都要求放到一个service方法中也就是同一段事务里。另一方面也是为了提供统一的接口，有的业务除了本地的controller还会需要服务间通信，比如rest api或者rpc什么的，最后他们都应该从同一个service拿到一致的基础数据，然后由各自的controller按各自的需求加工后
个人博客后端使用springboot和mybaits
01-29
标题 "个人博客后端使用springboot和mybaits" 暗示了这个项目采用的是一个基于Spring Boot和MyBatis的Java后端框架来构建个人博客系统。Spring Boot简化了Spring应用程序的初始设置和配置，而MyBatis则是一个优秀的...
springboot中对各个层的理解
weixin_44001753的博客
10-31 7762
springboot的entity，dao，controller，service层的理解。 1 Dao层：持久层，主要是和数据库进行交互 dao层首先胡创建dao接口，接着就可以在配置文件中定义该接口的实现类；接着就可以在模块中调用dao的接口进行数据业务的处理，而不用关注此接口的具体实现是哪一个类，dao层的数据源和数据库实在配置文件中进行配置的。 2 Entity层：实体层，数据库在项目中的类...
多级留言/评论的功能实现——SpringBoot3后端篇
最新发布
道阻且长 心态要好
05-03 2273
想要实现类似bilibili的评论区那样，在药材、方剂、文章详情页都实现多级留言/评论功能，但是不以递进的方式来展现层级关系
告别混乱代码：SpringBoot 后端接口规范
Java后端技术
06-30 389
往期热门文章： 1、项目终于用上了Spring状态机，非常优雅！ 2、自从用了这款 IDEA 神器，领导都夸我代码写得好！ 3、MyBatis的二级缓存，慎用！ 4、8种专坑同事的 SQL 写法，性能降低100倍，不来看看？ 5、最近火起的 Bean Searcher 与 MyBatis Plus 到底有啥区别？一、前言一个后端接口大致分为四个部分组成：接口地址（url）、接口请求方式（get、...
Android-RecyclerView基础写法简单实现
05-08
本篇文章将详细讲解Android RecyclerView的基础写法及其简单实现。 首先，我们需要在项目的build.gradle文件中添加RecyclerView的依赖库。在app模块的build.gradle文件中，找到dependencies块，添加以下代码： ```...
javascript函数以及基础写法100多条实用整理
10-27
100多个很有用的JavaScript函数以及基础写法汇总,在项目开发中经常会使用到，本文整理了一些，希望对你们有帮助
SpringBoot AOP切面类三种写法（源代码）
01-27
写法一： @Before("execution(* com.bjpowernode.springboot07.javabean.Man.eat(..))") 一、AOP开发 1.1 概述 1.2使用方法 1.3创建项目并添加maven依赖 1.4 创建Javabean测试类 1.5 创建切面 1.6 测试类 1.7 测试...
js的写法基础分析
10-28
js的写法基础分析，学习js的朋友可以参考下。
springboot分页查询的两种方法.md
02-14
SpringBoot分页查询的两种写法，一种是手动实现，另一种是使用框架实现
Kotlin中单利常用的五种写法
08-27
在Kotlin中，实现单例有多种方式，下面将详细介绍五种常见的Kotlin单例写法。 1. **加载类时创建单例（静态对象）** 这是最简单的实现方式，利用Kotlin的`object`关键字，当类被加载时，单例对象也随之创建。这种...
简单了解SpringBoot过滤器及使用方式
08-19
SpringBoot 过滤器简介及使用方式 SpringsBoot 过滤器是基于 Servlet 容器的函数回调，可以对几乎所有请求进行过滤。Filter 的生命周期由 Servlet 容器管理。在 SpringBoot 中，过滤器可以用来实现许多功能，如...
springboot+vue实现websocket配置过程解析
08-19
SpringBoot+Vue 实现 WebSocket 配置过程解析 标题: SpringBoot+Vue 实现 WebSocket 配置过程解析 描述: 本文主要介绍了 SpringBoot+Vue 实现 WebSocket 配置过程解析，通过示例代码进行详细的介绍，对大家的学习...
第二章 PHP入门基础之php代码写法
10-28
配置好php运行环境以后，下面就需要介绍如何写php，他有个解析块的写法，类似asp
博客内容:网页显示次数后端写法对应案例
12-04
前端vue+页面bootStrap页面样式后端:mysql+myBaits-plus内容涉及到sql高级语句查询前端vue+页面bootStrap页面样式后端:mysql+myBaits-plus内容涉及到sql高级语句查询前端vue+页面bootStrap页面样式后端:mysql+...
100多个很有用的javascript函数以及基础写法集合
07-29
JavaScript 函数和基础写法大集合 JavaScript 是一种广泛应用于 Web 开发的编程语言，下面总结了 100 多个有用的 JavaScript 函数和基础写法。 输出语句 document.write("") 是 JavaScript 中最基本的输出语句，...
springboot_properties配置项
09-08
springboot_properties配置项
SpringBoot 自定义拦截器 的 源代码
01-27
另一种写法 四、最后application运行 我们对拦截器并不陌生，无论是 Struts 2 还是 Spring MVC 中都提供了拦截器功能，它可以根据 URL 对请求进行拦截，主要应用于登陆校验、权限验证、乱码解决、性能监控和异常处理...
springboot的service层写法
03-07
SpringBoot 的 Service 层写法可以采用注解的方式，使用 @Service 标注类，然后在类中定义业务逻辑方法，使用 @Autowired 注解注入 DAO 层对象，实现数据访问和业务逻辑的分离。同时，可以使用 @Transactional 注解实现事务管理。具体实现可以参考 SpringBoot 官方文档和相关教程。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值