时间戳

首页 > 技术文章 > ssm实战城镇道路管理系统

ssm实战城镇道路管理系统

code200 2021-05-16 19:47 原文

项目介绍

本系统使用Spring+SpringMVC+MyBatis架构，数据库使用MySQL,前端页面使用jsp设计的道路管理系统,主要有道路分类管理,添加道路管理,巡查记录管理,评价管理等模块。

开发环境

  1. jdk 8
  2. intellij idea
  3. tomcat 8.5.40
  4. mysql 5.7

所用技术

  1. Spring+SpringMVC+MyBatis
  2. layui
  3. jsp

项目截图

  • 分类管理
    在这里插入图片描述

  • 添加道路
    在这里插入图片描述

  • 添加评价
    在这里插入图片描述

  • 巡查记录
    在这里插入图片描述

  • 系统介绍
    在这里插入图片描述

框架配置

  1. db.properties
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost/urbanRoad?useUnicode=true&characterEncoding=utf-8&useSSL=false
jdbc.username=root
jdbc.password=root123
  1. applicationContext-mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd
       http://www.springframework.org/schema/aop
       http://www.springframework.org/schema/aop/spring-aop.xsd">

    <!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 -->
    <context:component-scan base-package="com.lrfalse.controller"/>

    <mvc:interceptors>
        <mvc:interceptor>
            <!-- 需要拦截的url路径 :/order/**  这个是订单系统的url格式 -->
            <mvc:mapping path="/**" />
            <mvc:exclude-mapping path="/login"/>
            <mvc:exclude-mapping path="/*.js"/>
            <mvc:exclude-mapping path="/register"/>
            <mvc:exclude-mapping path="/logout"/>
            <bean class="com.lrfalse.interceptor.LoginInterceptor"></bean>
        </mvc:interceptor>
    </mvc:interceptors>
    <!-- 支持aop的注解 -->
    <aop:aspectj-autoproxy/>

    <!-- 启动SpringMVC的注解功能 -->
    <mvc:annotation-driven/>

    <!--静态资源放行-->
    <mvc:default-servlet-handler/>

    <!-- 定义跳转的文件的前后缀 ，视图解析器配置-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

    <!-- 配置文件上传解析器 -->
    <bean id="multipartResolver"
          class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
        <!-- 默认编码 -->
        <property name="defaultEncoding" value="utf-8"/>
        <!-- 文件大小最大值 -->
        <property name="maxUploadSize" value="10485760000"/>
    </bean>
</beans>
  1. applicationContext-service.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
    <import resource="classpath*:applicationContext-mapper.xml"/>
    <!--扫描的包-->
    <context:component-scan base-package="com.lrfalse.service"/>
</beans>
  1. applicationContext-mapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
    <!-- Jdbc配置文件 -->
    <context:property-placeholder location="classpath:db.properties" />
    <!-- 数据源dataSource -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <!--maxActive: 最大连接数量 -->
        <property name="maxActive" value="150" />
        <!--minIdle: 最小空闲连接 -->
        <property name="minIdle" value="5" />
        <!--maxIdle: 最大空闲连接 -->
        <property name="maxIdle" value="20" />
        <!--initialSize: 初始化连接 -->
        <property name="initialSize" value="30" />
        <!--maxWait: 超时等待时间以毫秒为单位 1000等于60秒 -->
        <property name="maxWait" value="1000" />
        <!-- 在空闲连接回收器线程运行期间休眠的时间值,以毫秒为单位. -->
        <property name="timeBetweenEvictionRunsMillis" value="10000" />
        <!-- 在每次空闲连接回收器线程(如果有)运行时检查的连接数量 -->
        <property name="numTestsPerEvictionRun" value="10" />
        <!-- 1000 * 60 * 30 连接在池中保持空闲而不被空闲连接回收器线程 -->
        <property name="minEvictableIdleTimeMillis" value="10000" />
        <property name="validationQuery" value="SELECT NOW() FROM DUAL" />
    </bean>
    <!--Mybatis核心对象-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 注入数据源 -->
        <property name="dataSource" ref="dataSource" />
        <!-- 配置mybatis (mapper)映射器路径 -->
        <property name="mapperLocations" value="classpath*:mapper/*Mapper.xml" />
        <!--引用mybatis的核心配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
        <!-- 配置mybatis 类型别名 -->
        <property name="typeAliasesPackage">
            <value>
                com.lrfalse.entity
                com.lrfalse.query
            </value>
        </property>
        <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageHelper">
                    <property name="properties">
                        <value>
                            dialect=mysql
                            reasonable=true
                        </value>
                    </property>
                </bean>
            </array>
        </property>
    </bean>
    <!--注入映射器，一劳永逸的做法-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.lrfalse.mapper"></property>
    </bean>
    <!--事务管理-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--以注解的方式进行事务管理-->
    <tx:annotation-driven transaction-manager="transactionManager"/>
</beans>

业务代码

  1. 道路信息保存
@RequestMapping("/save")
@ResponseBody
public AjaxResult save(RoadReq roadReq){
    try {
        Road road=new Road();	//主道路信息
        BeanUtil.copyProperties(roadReq,road);

        Roadway roadway=new Roadway();
        BeanUtil.copyProperties(roadReq,roadway);//车行道对象
        roadway.setId(roadReq.getRoadwayId());

        Separator separator=new Separator();
        BeanUtil.copyProperties(roadReq,separator);//分隔带
        separator.setId(roadReq.getSeparatorId());

        Sidewalk sidewalk=new Sidewalk();
        BeanUtil.copyProperties(roadReq,sidewalk);//人行道
        sidewalk.setId(roadReq.getSidewalkId());

        AncillaryFacilities ancillaryFacilities=new AncillaryFacilities();
        BeanUtil.copyProperties(roadReq,ancillaryFacilities);//附属设施对象
        ancillaryFacilities.setId(roadReq.getAncillaryFacilitiesId());

        if(road.getId()!=null){
            roadService.update(road);
            iAncillaryFacilitiesService.update(ancillaryFacilities);
            iRoadwayService.update(roadway);
            iSeparatorService.update(separator);
            iSidewalkService.update(sidewalk);
            return new AjaxResult("修改成功!");
        }else{
            roadService.add(road);
            iAncillaryFacilitiesService.add(ancillaryFacilities);
            iRoadwayService.add(roadway);
            iSeparatorService.add(separator);
            iSidewalkService.add(sidewalk);
            return new AjaxResult("保存成功!");
        }
    } catch (Exception e) {
        e.printStackTrace();
        return new AjaxResult("保存失败:"+e.getMessage(),-10002);
    }
}

//前端jsp代码

<div class="layui-row" id="zq_formpopbox" style="position: absolute;
    top: 0; left: 0; bottom: 0; right: 0;">
    <fieldset class="layui-elem-field layui-field-title" style="margin-top: 50px;color: #007DDB">
        <legend>街道基础信息</legend>
    </fieldset>
    <form class="layui-form layui-form-pane" action="">
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">道路名称</label>
                <div class="layui-input-block">
                    <input type="text" name="roadName" id="roadName" lay-verify="required" placeholder="请输入道路名称"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">道路编号</label>
                <div class="layui-input-block">
                    <input type="text" name="roadNum" id="roadNum" lay-verify="required" placeholder="请输入道路编号"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">道路走向</label>
                <div class="layui-input-block">
                    <input type="text" name="roadTo" id="roadTo" lay-verify="required" placeholder="请输入道路走向"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">起点</label>
                <div class="layui-input-block">
                    <input type="text" name="origin" id="origin" lay-verify="required" placeholder="请输入起点"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">终点</label>
                <div class="layui-input-block">
                    <input type="text" name="destination" id="destination" lay-verify="required" placeholder="请输入终点"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">设计单位</label>
                <div class="layui-input-block">
                    <input type="text" name="architect" id="architect" lay-verify="required" placeholder="请输入设计单位"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">施工单位</label>
                <div class="layui-input-block">
                    <input type="text" name="constructionOrganization" id="constructionOrganization"
                           lay-verify="required" placeholder="请输入施工单位" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">道路等级</label>
                <div class="layui-input-block">
                    <input type="text" name="roadGrade" id="roadGrade" lay-verify="required" placeholder="请输入道路等级"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">路面等级</label>
                <div class="layui-input-block">
                    <input type="text" name="roadLevel" id="roadLevel" lay-verify="required" placeholder="请输入路面等级"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">设计时速</label>
                <div class="layui-input-block">
                    <input type="text" name="designSpeed" id="designSpeed" lay-verify="required" placeholder="请输入设计时速"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">宽度范围</label>
                <div class="layui-input-block">
                    <input type="text" name="coverThickness" id="coverThickness" lay-verify="required"
                           placeholder="请输入路幅宽度范围" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">道路长度</label>
                <div class="layui-input-block">
                    <input type="text" name="lengthRoad" id="lengthRoad" lay-verify="required" placeholder="请输入道路长度"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">道路面积</label>
                <div class="layui-input-block">
                    <input type="text" name="areaRoad" id="areaRoad" lay-verify="required" placeholder="请输入道路面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">AADT</label>
                <div class="layui-input-block">
                    <input type="text" name="aadt" id="aadt" lay-verify="required" placeholder="请输入AADT"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">交通量等级</label>
                <div class="layui-input-block">
                    <input type="text" name="trafficLevel" id="trafficLevel" lay-verify="required"
                           placeholder="请输入交通量等级" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">所属乡镇</label>
                <div class="layui-input-block">
                    <input type="text" name="belongsTownship" id="belongsTownship" lay-verify="required"
                           placeholder="请输入所属乡镇" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">管理分类</label>
                <div class="layui-input-block">
                    <input type="text" name="manageCategories" id="manageCategories" lay-verify="required"
                           placeholder="请输入管理分类" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">管理单位</label>
                <div class="layui-input-block">
                    <input type="text" name="manageUnit" id="manageUnit" lay-verify="required" placeholder="请输入管理单位"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">养护单位</label>
                <div class="layui-input-block">
                    <input type="text" name="maintenanceUnit" id="maintenanceUnit" lay-verify="required"
                           placeholder="请输入养护单位" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">建造年月</label>
                <div class="layui-input-block">
                    <input type="text" name="builtYears" id="builtYears" lay-verify="required" placeholder="请输入建造年月"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>


        <fieldset class="layui-elem-field layui-field-title" style="margin-top: 50px;color: #007DDB">
            <legend>车行道</legend>
        </fieldset>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">路面类型</label>
                <div class="layui-input-block">
                    <input type="text" name="pavementType" id="pavementType" lay-verify="required" placeholder="请输入路面类型"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">路面厚度</label>
                <div class="layui-input-block">
                    <input type="text" name="pavementThickness" id="pavementThickness" lay-verify="required"
                           placeholder="请输入路面厚度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">基层类型</label>
                <div class="layui-input-block">
                    <input type="text" name="substratumType" id="substratumType" lay-verify="required"
                           placeholder="请输入基层类型" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">基层厚度</label>
                <div class="layui-input-block">
                    <input type="text" name="substratumThickness" id="substratumThickness" lay-verify="required"
                           placeholder="请输入基层厚度" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" >车道数</label>
                <div class="layui-input-block">
                    <input type="text" name="lanesCount" id="lanesCount" lay-verify="required" placeholder="请输入车道数"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">通行方向</label>
                <div class="layui-input-block">
                    <input type="text" name="directionTraffic" id="directionTraffic" lay-verify="required"
                           placeholder="请输入通行方向" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">车道宽度<br>范围</label>
                <div class="layui-input-block">
                    <input type="text" name="laneWidthRange" id="laneWidthRange" lay-verify="required"
                           placeholder="请输入车道宽度范围" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">车行道面积</label>
                <div class="layui-input-block">
                    <input type="text" name="roadArea" id="roadArea" lay-verify="required" placeholder="请输入车行道面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>

        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">侧石类型</label>
                <div class="layui-input-block">
                    <input type="text" name="inclinedStoneType" id="inclinedStoneType" lay-verify="required"
                           placeholder="请输入侧石类型" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">侧石长度</label>
                <div class="layui-input-block">
                    <input type="text" name="inclinedStoneLength" id="inclinedStoneLength" lay-verify="required"
                           placeholder="请输入侧石长度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">平石类型</label>
                <div class="layui-input-block">
                    <input type="text" name="flatStoneStoneType" id="flatStoneStoneType" lay-verify="required"
                           placeholder="请输入平石类型" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">平石长度</label>
                <div class="layui-input-block">
                    <input type="text" name="flatStoneStoneLength" id="flatStoneStoneLength" lay-verify="required"
                           placeholder="请输入平石长度" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>

        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">公交车<br>专用车道</label>
                <div class="layui-input-block">
                    <input type="text" name="busLane" id="busLane" lay-verify="required" placeholder="请输入公交车专用车道"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 10%">左侧非机动<br>车道宽度<br>范围</label>
                <div class="layui-input-block">
                    <input type="text" name="lLaneWidthRange" id="lLaneWidthRange" lay-verify="required"
                           placeholder="请输入左侧非机动车道宽度范围" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height:10%">右侧非机动<br>车道宽度<br>范围</label>
                <div class="layui-input-block">
                    <input type="text" name="rLaneWidthRange" id="rLaneWidthRange" lay-verify="required"
                           placeholder="请输入右侧非机动车道宽度范围" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>

        <fieldset class="layui-elem-field layui-field-title" style="margin-top: 50px;color: #007DDB">
            <legend>人行道</legend>
        </fieldset>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧<br>铺面类型</label>
                <div class="layui-input-block">
                    <input type="text" name="lSurfacingType" id="lSurfacingType" lay-verify="required"
                           placeholder="请输入左侧铺面类型" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">左侧长度</label>
                <div class="layui-input-block">
                    <input type="text" name="lSidewalkLength" id="lSidewalkLength" lay-verify="required"
                           placeholder="请输入左侧长度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">宽度范围</label>
                <div class="layui-input-block">
                    <input type="text" name="lWidthRange" id="lWidthRange" lay-verify="required" placeholder="请输入宽度范围"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧<br>直线面积</label>
                <div class="layui-input-block">
                    <input type="text" name="lLineArea" id="lLineArea" lay-verify="required" placeholder="请输入左侧直线面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧交叉<br>口面积</label>
                <div class="layui-input-block">
                    <input type="text" name="lIntersectionArea" id="lIntersectionArea" lay-verify="required"
                           placeholder="请输入左侧交叉口面积" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧盲道<br>长度</label>
                <div class="layui-input-block">
                    <input type="text" name="lBlindRoadLength" id="lBlindRoadLength" lay-verify="required"
                           placeholder="请输入左侧盲道长度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧<br>无障碍<br>通道面积</label>
                <div class="layui-input-block">
                    <input type="text" name="lDreeAccessArea" id="lDreeAccessArea" lay-verify="required"
                           placeholder="请输入左侧无障碍通道面积" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧绿化<br>面积</label>
                <div class="layui-input-block">
                    <input type="text" name="lGreenArea" id="lGreenArea" lay-verify="required" placeholder="请输入左侧绿化面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧<br>侧石类型</label>
                <div class="layui-input-block">
                    <input type="text" name="lSideType" id="lSideType" lay-verify="required" placeholder="请输入左侧侧石类型"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧<br>平石类型</label>
                <div class="layui-input-block">
                    <input type="text" name="lFlatStoneType" id="lFlatStoneType" lay-verify="required"
                           placeholder="请输入左侧平石类型" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>铺面类型</label>
                <div class="layui-input-block">
                    <input type="text" name="rSurfacingType" id="rSurfacingType" lay-verify="required"
                           placeholder="请输入右侧铺面类型" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">右侧长度</label>
                <div class="layui-input-block">
                    <input type="text" name="rSidewalkLength" id="rSidewalkLength" lay-verify="required"
                           placeholder="请输入右侧长度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>宽度范围</label>
                <div class="layui-input-block">
                    <input type="text" name="rWidthRange" id="rWidthRange" lay-verify="required" placeholder="请输入右侧宽度范围"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>直线面积</label>
                <div class="layui-input-block">
                    <input type="text" name="rLineArea" id="rLineArea" lay-verify="required" placeholder="请输入右侧直线面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>交叉口<br>面积</label>
                <div class="layui-input-block">
                    <input type="text" name="rIntersectionArea" id="rIntersectionArea" lay-verify="required"
                           placeholder="请输入右侧交叉口面积" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>盲道长度</label>
                <div class="layui-input-block">
                    <input type="text" name="rBlindRoadLength" id="rBlindRoadLength" lay-verify="required"
                           placeholder="请输入右侧盲道长度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>无障碍<br>通道面积</label>
                <div class="layui-input-block">
                    <input type="text" name="rDreeAccessArea" id="rDreeAccessArea" lay-verify="required"
                           placeholder="请输入右侧无障碍通道面积" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>绿化面积</label>
                <div class="layui-input-block">
                    <input type="text" name="rGreenArea" id="rGreenArea" lay-verify="required" placeholder="请输入右侧绿化面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>侧石类型</label>
                <div class="layui-input-block">
                    <input type="text" name="rSideType" id="rSideType" lay-verify="required" placeholder="请输入右侧侧石类型"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br>平石类型</label>
                <div class="layui-input-block">
                    <input type="text" name="rFlatStoneType" id="rFlatStoneType" lay-verify="required"
                           placeholder="请输入右侧平石类型" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>

        <fieldset class="layui-elem-field layui-field-title" style="margin-top: 50px;color: #007DDB">
            <legend>分隔带</legend>
        </fieldset>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧人行<br/>护栏长度</label>
                <div class="layui-input-block">
                    <input type="text" name="lSidewalkFenceLength" id="lSidewalkFenceLength" lay-verify="required"
                           placeholder="请输入左侧人行护栏长度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧人行<br/>护栏高度</label>
                <div class="layui-input-block">
                    <input type="text" name="lSidewalkFenceHeight" id="lSidewalkFenceHeight" lay-verify="required"
                           placeholder="请输入左侧人行护栏高度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧人行<br/>护栏类型</label>
                <div class="layui-input-block">
                    <input type="text" name="lSidewalkFenceType" id="lSidewalkFenceType" lay-verify="required"
                           placeholder="请输入左侧人行护栏类型" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">左侧长度</label>
                <div class="layui-input-block">
                    <input type="text" name="lLength" id="lLength" lay-verify="required" placeholder="请输入左侧长度"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">左侧<br/>宽度范围</label>
                <div class="layui-input-block">
                    <input type="text" name="lWidthScope" id="lWidthScope" lay-verify="required" placeholder="请输入左侧宽度范围"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">左侧面积</label>
                <div class="layui-input-block">
                    <input type="text" name="lArea" id="lArea" lay-verify="required" placeholder="请输入左侧面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">左侧类型</label>
                <div class="layui-input-block">
                    <input type="text" name="lType" id="lType" lay-verify="required" placeholder="请输入左侧类型"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">中央<br/>护栏高度</label>
                <div class="layui-input-block">
                    <input type="text" name="cFenceHeight" id="cFenceHeight" lay-verify="required"
                           placeholder="请输入中央护栏高度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">中央<br/>护栏面积</label>
                <div class="layui-input-block">
                    <input type="text" name="cFenceType" id="cFenceType" lay-verify="required" placeholder="请输入中央护栏面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">中央长度</label>
                <div class="layui-input-block">
                    <input type="text" name="cLength" id="cLength" lay-verify="required" placeholder="请输入中央长度"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">中央<br/>宽度范围</label>
                <div class="layui-input-block">
                    <input type="text" name="cWidthScope" id="cWidthScope" lay-verify="required" placeholder="请输入中央宽度范围"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">中央面积</label>
                <div class="layui-input-block">
                    <input type="text" name="cArea" id="cArea" lay-verify="required" placeholder="请输入中央面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">中央类型</label>
                <div class="layui-input-block">
                    <input type="text" name="cType" id="cType" lay-verify="required" placeholder="请输入中央类型"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧人行<br/>护栏长度</label>
                <div class="layui-input-block">
                    <input type="text" name="rSidewalkFenceLength" id="rSidewalkFenceLength" lay-verify="required"
                           placeholder="请输入右侧人行护栏长度" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧人行<br/>护栏高度</label>
                <div class="layui-input-block">
                    <input type="text" name="rSidewalkFenceHeight" id="rSidewalkFenceHeight" lay-verify="required"
                           placeholder="请输入右侧人行护栏高度" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧人行<br/>护栏类型</label>
                <div class="layui-input-block">
                    <input type="text" name="rSidewalkFenceType" id="rSidewalkFenceType" lay-verify="required"
                           placeholder="请输入右侧人行护栏类型" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">分隔带<br/>右侧长度</label>
                <div class="layui-input-block">
                    <input type="text" name="rLength" id="rLength" lay-verify="required" placeholder="请输入右侧长度"
                           autocomplete="off" class="layui-input">
                </div>
            </div>

            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧面积</label>
                <div class="layui-input-block">
                    <input type="text" name="rArea" id="rArea" lay-verify="required" placeholder="请输入右侧面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">右侧类型</label>
                <div class="layui-input-block">
                    <input type="text" name="rType" id="rType" lay-verify="required" placeholder="请输入右侧类型"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label" style="height: 7%">右侧<br/>宽度范围</label>
                <div class="layui-input-block">
                    <input type="text" name="rWidthScope" id="rWidthScope" lay-verify="required" placeholder="请输入右侧宽度范围"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>

        <fieldset class="layui-elem-field layui-field-title" style="margin-top: 50px;color: #007DDB">
            <legend>附属设施</legend>
        </fieldset>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">检查井数量</label>
                <div class="layui-input-block">
                    <input type="text" name="numberCount" id="numberCount" lay-verify="required" placeholder="请输入检查井数量"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">雨水口数量</label>
                <div class="layui-input-block">
                    <input type="text" name="gullyCount" id="gullyCount" lay-verify="required" placeholder="请输入雨水口数量"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">路名牌数量</label>
                <div class="layui-input-block">
                    <input type="text" name="platesCount" id="platesCount" lay-verify="required" placeholder="请输入路名牌数量"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">标志牌数量</label>
                <div class="layui-input-block">
                    <input type="text" name="denoterCount" id="denoterCount" lay-verify="required"
                           placeholder="请输入标志牌数量" autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">树池面积</label>
                <div class="layui-input-block">
                    <input type="text" name="poolArea" id="poolArea" lay-verify="required" placeholder="请输入树池面积"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">其他</label>
                <div class="layui-input-block">
                    <input type="text" name="other" id="other" lay-verify="required" placeholder="请输入其他"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>

        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label"></label>
                <div class="layui-input-block">
                    <input type="text"    placeholder=""
                           autocomplete="off" class="layui-input"readonly="readonly">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label"></label>
                <div class="layui-input-block">
                    <input type="text"    placeholder=""
                           autocomplete="off" class="layui-input" readonly="readonly">
                </div>
            </div>
        </div>

        <fieldset class="layui-elem-field layui-field-title" style="margin-top: 50px;color: #007DDB">
            <legend>制表信息</legend>
        </fieldset>

        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">审核人</label>
                <div class="layui-input-block">
                    <input type="text" name="auditor" id="auditor" lay-verify="required" placeholder="请输入审核人"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">制表人</label>
                <div class="layui-input-block">
                    <input type="text" name="lister" id="lister" lay-verify="required" placeholder="请输入制表人"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-col-md3">
            <div class="layui-form-item">
                <label class="layui-form-label">制表日期</label>
                <div class="layui-input-block">
                    <input type="text" name="tabulationDate" id="tabulationDate" lay-verify="required" placeholder="请输入制表日期"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
        </div>
        <div class="layui-form-item">
            <div class="layui-input-block">
                <button class="layui-btn layui-btn-radius layui-btn-normal" lay-submit="" lay-filter="zq_submit">
                    确认
                </button>
            </div>
        </div>
    </form>
</div>

1.1 首页代码-service层

@Service
public class ProductServiceImpl implements ProductService {
	@Autowired
	ProductMapper productMapper;
	//商品列表
	public List<Product> getProductList(){
		return productMapper.selectAll();
	}
}

1.2 首页代码-dao层-Mapper

//继承MyMapper类，获取超类的增删改查方法
public interface ProductMapper extends MyMapper<Product> {
}

1.3 首页代码-jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"  pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
    <meta charset="utf-8"/>
    <title>java</title>
    <link rel="stylesheet" href="/css/style.css"/>
</head>
<body>
<div class="n-support">请使用Chrome、Safari等webkit内核的浏览器！</div>
<div class="n-head">
    <div class="g-doc f-cb">
        <c:if test="${not empty user}">
            <div class="user">
                买家你好，<span class="name">${user.nickName}</span>！<a href="logout">[退出]</a>
            </div>

        </c:if>
        <c:if test="${ empty user}">
            请<a href="login">[登录]</a>
        </c:if>
            <ul class="nav">
                <li><a href="index">首页</a></li>
                <c:if test="${not empty user}">
                    <c:if test="${user.userType==0}">
                        <li><a href="account">账务</a></li>
                       <li><a href="shopCart">购物车</a></li>
                    </c:if>
                    <c:if test="${user.userType==1}">
                       <li><a href="publish">发布</a></li>
                    </c:if>
                </c:if>
            </ul>

    </div>
</div>
<div class="g-doc">
    <div class="m-tab m-tab-fw m-tab-simple f-cb">
        <div class="tab">
            <ul>
                <li class="z-sel"><a href="index">所有内容</a></li>
                <c:if test="${ user.userType!=1}">
                    <li><a href="isNoBuy">未购买的内容</a></li>
                </c:if>
            </ul>
        </div>
    </div>
    <div class="n-plist">
        <ul class="f-cb" id="plist">
            <c:forEach items="${productList}" var="product" varStatus="st">
                <li id="p-1">
                    <a href="details?pid=${product.id}" class="link">
                        <div class="img"><img src="${product.image}" alt=""></div>
                        <h3>${product.title}</h3>
                        <div class="price"><span class="v-unit">¥</span><span class="v-value">${product.price}</span></div>
                        <c:if test="${ not empty user}">
                            <c:if test="${ user.userType==0 and product.isSell==1}">
                                <span class="had"><b>已购买</b></span>
                            </c:if>
                            <c:if test="${ user.userType==1 and product.isSell==1}">
                                <span class="had"><b>已售出${product.buyNum}</b></span>
                            </c:if>
                        </c:if>
                    </a>
                    <c:if test="${ user.userType==1 and product.isSell==0}">
                        <span class="u-btn u-btn-normal u-btn-xs del" data-del="5">删除</span>
                    </c:if>
                </li>
            </c:forEach>
        </ul>
    </div>
</div>
<script type="text/javascript" src="/js/global.js"></script>
<script type="text/javascript" src="/js/pageIndex.js"></script>
</body>
</html>

2 购物车列表-controller

@RequestMapping(value = {"shopCart"})
public ModelAndView shopCart(ModelAndView mav, HttpServletRequest request){
    Person person=(Person) request.getSession().getAttribute("user");
    ShopCart shopCart3=new ShopCart();
    shopCart3.setUid(person.getId()+"");
    List<ShopCart> shopCarts=shopCartService.getShopCartList(shopCart3);
    mav.addObject("shopCarts",shopCarts);
    mav.setViewName("shopCart");
    return mav;
}

2.1 购物车列表-jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"  pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
    <meta charset="utf-8"/>
    <title>java</title>
    <link rel="stylesheet" href="/css/style.css"/>
</head>
<body>
<div class="n-head">
    <div class="g-doc f-cb">
        <c:if test="${not empty user}">
            <div class="user">
                买家你好，<span class="name">${user.nickName}</span>！<a href="logout">[退出]</a>
            </div>

        </c:if>
        <c:if test="${ empty user}">
            请<a href="login">[登录]</a>
        </c:if>
        <ul class="nav">
            <li><a href="index">首页</a></li>
            <c:if test="${not empty user}">
                <c:if test="${user.userType==0}">
                    <li><a href="account">账务</a></li>
                    <li><a href="shopCart">购物车</a></li>
                </c:if>
                <c:if test="${user.userType==1}">
                   <li><a href="publish">发布</a></li>
                </c:if>
            </c:if>
        </ul>

    </div>
</div>
<div class="g-doc">
    <div class="m-tab m-tab-fw m-tab-simple f-cb" id="settleAccount">
        <h2>已添加到购物车的内容</h2>
    </div>
    <table class="m-table m-table-row n-table g-b3">
        <colgroup><col class="img"/><col/><col class="time"/><col class="price"/></colgroup>
        <thead>
        <tr><th>内容图片</th><th>内容名称</th><th>购买时间</th><th>数量</th><th>购买价格</th></tr>
        </thead>
        <tbody>
            <c:forEach items="${shopCarts}" var="cart">
                <tr>
                    <td><a href="details?pid=${cart.pid}"><img src="${cart.image}" alt=""></a></td>
                    <td><h4><a href="details?pid=${cart.pid}">${cart.title}</a></h4></td>
                    <td><span class="v-time">${cart.time}</span></td>
                    <td><span class="v-num">${cart.num}</span></td>
                    <td><span class="v-unit">¥</span><span class="value">${cart.price}</span></td>
                </tr>
            </c:forEach>
        </tbody>
        <tfoot>
        <tr>
            <td><button class="u-btn u-btn-primary" onclick="goout();">退出</button></td>
            <td><button class="u-btn u-btn-primary" onclick="buy();">购买</button></td>
        </tr>
        </tfoot>
    </table>
</div>
<script type="text/javascript" src="/js/global.js"></script>
<script type="text/javascript" src="/js/pageShow.js"></script>
<script type="text/javascript"  src="/js/jquery-3.3.1.js" ></script>

<script type="text/javascript"  >
    function goout() {
        window.history.go(-1);
    }
    function buy(){
        if(confirm("确定购买吗？")){
            $.ajax({
                type:"post",
                url:"saveTrx",
                data:{pid:$("#pid").val()},
                dataType:"json",//返回的
                success:function(data) {
                    if(data==0) {
                        window.location.href="account";
                    } else {
                        alert('用户密码错误，请重新登录');
                    }
                },
                error:function(msg) {
                    alert(msg);
                }
            });
        }
    }
</script>
</body>
</html>
  1. 日常巡查
@RequestMapping("/save")
@ResponseBody
public AjaxResult save(RoutineInspections routineInspections){
    try {
        if(routineInspections.getId()!=null){
            routineInspectionsService.update(routineInspections);
            return new AjaxResult("修改成功!");
        }else{
            routineInspectionsService.add(routineInspections);
            return new AjaxResult("保存成功!");
        }

    } catch (Exception e) {
        e.printStackTrace();
        return new AjaxResult("保存失败:"+e.getMessage(),-10002);
    }
}

//前端jsp代码

<div class="layui-row" id="zq_formpopbox" style="position: absolute;
    top: 0; left: 0; bottom: 0; right: 0;">
    <div class="layui-col-md11">
        <form id="zq_form" class="layui-form" action="" style="margin-top: 20px;align:center;">
            <div class="layui-form-item">
                <label class="layui-form-label">巡查道路</label>
                <div class="layui-input-block">
                    <select name="roadId" id="roadId" lay-verify="required" lay-filter="patentType">
                        <option value="">请选择具体巡查道路</option>
                        <c:forEach items="${roadList}" var="road">
                            <option value="${road.id}"  >${road.roadName}</option>
                        </c:forEach>
                    </select>
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">路面外观状况</label>
                <div class="layui-input-block">
                    <input type="text" name="roadLooks" id="roadLooks" lay-verify="required" placeholder="请输入路面外观状况"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">结构变化状况</label>
                <div class="layui-input-block">
                    <input type="text" name="structureDesc" id="structureDesc" lay-verify="required"
                           placeholder="请输入结构变化状况" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">道路施工作业状况</label>
                <div class="layui-input-block">
                    <input type="text" name="roadConstructionDesc" id="roadConstructionDesc" lay-verify="required"
                           placeholder="请输入道路施工作业状况" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">附属设施状况</label>
                <div class="layui-input-block">
                    <input type="text" name="ancillaryFacilitiesDesc" id="ancillaryFacilitiesDesc" lay-verify="required"
                           placeholder="请输入附属设施状况" autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <label class="layui-form-label">巡查日期</label>
                <div class="layui-input-block">
                    <input type="text" name="createTime" id="createTime" lay-verify="required" placeholder="请输入巡查日期"
                           autocomplete="off" class="layui-input">
                </div>
            </div>
            <div class="layui-form-item">
                <div class="layui-input-block">
                    <button class="layui-btn layui-btn-radius layui-btn-normal" lay-submit="" lay-filter="zq_submit">
                        确认
                    </button>
                </div>
            </div>
        </form>
    </div>
</div>

推荐阅读