微信小程序实现lot开发08 项目主体业务前后端实现

主体业务：订座位，下单，时间过期之后自动回收座位，控制座位灯与插座，控制门禁。

微信小程序页面图片：

 实现逻辑主体在springboot后端代码：

直接挂代码：有不理解和需要帮助的评论区留言，我会及时回复。

实体层：

import lombok.Data;
 
@Data
public class Device {
    private String Id;
    private boolean State;
    private boolean Lock;
    private String Info;
    /*输出口号*/
    private int outSign;
    /*设备配置端口号*/
    private int hostPort;
    /*设备电源状态*/
    private boolean power;
    /*区号*/
    private char areaCode;
}
 
@Data
public class DeviceUsePrice {
 
    private String deviceId;
    private Integer receipt;
    private Integer deviceTime;
    private String  info;
}
 
@Data
public class Door {
    private int Id;
    private int outSign;
    private int serverPort;
}
 
@Data
public class FromInfo {
    private String info;
    private Date date;
}
 
@Data
public class User {
    private String Id;
    private String Name;
    private Integer Amount;
    private String Phone;
    private String password;
}
 
@Data
public class UserDevice {
    private String userId;
    private Integer useTime;
    private String deviceId;
    private Integer receipt;
    private String orderTime;
    private boolean orderState;
}

 mapper层

import com.hlc.entity.Device;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
 
import java.util.List;
 
@Mapper
public interface DeviceMapper {
 
    @Select("select * from getmsqlconnection.device where areaCode=#{areaCode}")
    List findDeviceByArea(@Param("areaCode") char areaCode);
 
    @Update("update getmsqlconnection.device set `State` = 0 , `Lock` = 1 where `Id`=#{Id}")
    boolean updateDeviceStateByDeviceId(@Param("Id") String Id);
 
    @Update("update getmsqlconnection.device set `State` = 1 , `Lock` = 0 where `Id`=#{Id}")
    boolean freeDeviceByDeviceId(@Param("Id") String Id);
 
    @Select("select `Lock` from getmsqlconnection.device where `Id`=#{Id}")
    boolean findDeviceLockByDeviceId(@Param("Id")String Id);
 
    @Select("select outSign from getmsqlconnection.device where Id=#{Id}")
    int findOutSignByDeviceId(@Param("Id")String Id);
 
    @Select("select hostPort from getmsqlconnection.device where Id=#{Id}")
    int findHostPortByDeviceId(@Param("Id")String Id);
 
    @Update("update getmsqlconnection.device set power = 1 where Id=#{Id}")
    boolean openDevicePowerByDeviceId(@Param("Id")String Id);
 
    @Update("update getmsqlconnection.device set power = 0 where Id=#{Id}")
    boolean downDevicePowerByDeviceId(@Param("Id")String Id);
 
    @Select("select power from getmsqlconnection.device where Id=#{Id}")
    boolean findDevicePowerByDeviceId(@Param("Id")String Id);
}
 
 
@Mapper
public interface DeviceUsePriceMapper {
    
    @Select("select * from getmsqlconnection.device_use_price where deviceId=#{deviceId}")
    List findDeviceUsePriceByDeviceId(@Param("deviceId")String deviceId);
 
}
 
@Mapper
public interface DoorMapper {
    @Select("select * from getmsqlconnection.door where Id=1 ")
    Door findDoor();
}
 
 
@Mapper
public interface FromInfoMapper {
 
    @Select("select date,info from getmsqlconnection.from_info")
    List findAllFromInfo();
 
}
 
@Mapper
public interface UserDeviceMapper {
 
    @Insert("insert into getmsqlconnection.user_device values (#{userDevice.userId},#{userDevice.useTime},#{userDevice.deviceId},#{userDevice.receipt},#{userDevice.orderTime},#{userDevice.orderState})")
    boolean InsertUserDevice(@Param("userDevice")UserDevice userDevice);
 
    @Select("select * from getmsqlconnection.user_device where userId=#{userId}")
    List findUserDeviceByUserId(@Param("userId")String userId);
 
    @Update("update getmsqlconnection.user_device set useTime = 0 where useTime!=0 and deviceId=#{deviceId}")
    boolean updateExOrder(@Param("deviceId")String deviceId);
//  用户使用时间在缓存过期时会被设置为0；所以当前不为0的使用时间就是用户可以使用设备的凭证
    @Select("select deviceId from getmsqlconnection.user_device where useTime != 0 and userId=#{userId}")
    String findDeviceIdByUserId(@Param("userId")String userId);
}
 
@Mapper
public interface UserMapper {
 
    //    登录
    @Select("select password from getmsqlconnection.user where Id=#{Id}")
    String login(@Param("Id") String Id,@Param("password") String password);
    //    注册
    @Insert("insert into getmsqlconnection.user values(#{user.Id},#{user.Name},#{user.Phone},#{user.Amount},#{user.password})")
    Boolean register(@Param("user") User user);
    //    修改密码
    @Update("update getmsqlconnection.user set password=#{password} where Id=#{Id}")
    Boolean updatePassword(@Param("Id") String Id,@Param("password") String password);
}

 Servcie层（无非是mapper层的注入语接口的重塑，便于解耦与业务的拓展）

controller层（嵌套工具组件）

deviceController

package com.hlc.controller;/*
    User: 黄林春
    Date: 2022/7/13
    Time: 周三
    Project_Name: springDemo712
    */
 
import com.hlc.common.R;
import com.hlc.entity.Device;
import com.hlc.service.DeviceService;
import com.hlc.service.UserDeviceService;
import com.hlc.utils.NetAndIoController;
import com.hlc.utils.NetFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
 
 
import java.util.List;
 
@RestController(value = "DeviceController")
public class DeviceController {
 
    @Autowired
    private DeviceService deviceService;
 
    /**
     * --------------------------------------------查询全部设备信息------------------------------------------------------/
     */
 
    @GetMapping("/findDeviceByArea")
    @ResponseBody
    public R