🍊作者:计算机编程-吉哥
🍊简介:专业从事JavaWeb程序开发,微信小程序开发,定制化项目、 源码、代码讲解、文档撰写、ppt制作。做自己喜欢的事,生活就是快乐的。
🍊心愿:点赞 👍 收藏 ⭐评论 📝
🍅 文末获取源码联系👇🏻 精彩专栏推荐订阅 👇🏻 不然下次找不到哟~
Java毕业设计项目~热门选题推荐《1000套》
目录
springboot、mybatisplus、vue、elementui、html、css、js、mysql、jdk1.8
13张
idea、navicat
管理员、用户


- CREATE TABLE `chat` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `userid` bigint(20) NOT NULL COMMENT '用户id',
- `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id',
- `ask` longtext COMMENT '提问',
- `reply` longtext COMMENT '回复',
- `isreply` int(11) DEFAULT NULL COMMENT '是否回复',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432604929 DEFAULT CHARSET=utf8 COMMENT='在线交流';
-
- CREATE TABLE `cheweifenlei` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `cheweileixing` varchar(200) DEFAULT NULL COMMENT '车位类型',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432531945 DEFAULT CHARSET=utf8 COMMENT='车位分类';
-
- CREATE TABLE `cheweixinxi` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `tingchechangmingcheng` varchar(200) DEFAULT NULL COMMENT '停车场名称',
- `quyu` varchar(200) DEFAULT NULL COMMENT '区域',
- `cheweibianhao` varchar(200) DEFAULT NULL COMMENT '车位编号',
- `cheweimingcheng` varchar(200) DEFAULT NULL COMMENT '车位名称',
- `cheweileixing` varchar(200) DEFAULT NULL COMMENT '车位类型',
- `cheweitupian` longtext COMMENT '车位图片',
- `cheweiweizhi` varchar(200) DEFAULT NULL COMMENT '车位位置',
- `cheweizhuangtai` varchar(200) DEFAULT NULL COMMENT '车位状态',
- `xiaoshidanjia` int(11) DEFAULT NULL COMMENT '小时单价',
- `cheweixiangqing` longtext COMMENT '车位详情',
- PRIMARY KEY (`id`),
- UNIQUE KEY `cheweibianhao` (`cheweibianhao`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432550071 DEFAULT CHARSET=utf8 COMMENT='车位信息';
-
- CREATE TABLE `chezijinchang` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `tingchechangmingcheng` varchar(200) DEFAULT NULL COMMENT '停车场名称',
- `quyu` varchar(200) DEFAULT NULL COMMENT '区域',
- `cheweibianhao` varchar(200) DEFAULT NULL COMMENT '车位编号',
- `cheweimingcheng` varchar(200) DEFAULT NULL COMMENT '车位名称',
- `cheweileixing` varchar(200) DEFAULT NULL COMMENT '车位类型',
- `cheweiweizhi` varchar(200) DEFAULT NULL COMMENT '车位位置',
- `xiaoshidanjia` int(11) DEFAULT NULL COMMENT '小时单价',
- `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
- `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
- `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
- `touxiang` longtext COMMENT '头像',
- `chepaihao` varchar(200) DEFAULT NULL COMMENT '车牌号',
- `jinchangshijian` datetime DEFAULT NULL COMMENT '进场时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432457333 DEFAULT CHARSET=utf8 COMMENT='车子进场';
-
- CREATE TABLE `chezilichang` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `tingchechangmingcheng` varchar(200) DEFAULT NULL COMMENT '停车场名称',
- `quyu` varchar(200) DEFAULT NULL COMMENT '区域',
- `cheweibianhao` varchar(200) DEFAULT NULL COMMENT '车位编号',
- `cheweimingcheng` varchar(200) DEFAULT NULL COMMENT '车位名称',
- `cheweileixing` varchar(200) DEFAULT NULL COMMENT '车位类型',
- `cheweiweizhi` varchar(200) DEFAULT NULL COMMENT '车位位置',
- `xiaoshidanjia` int(11) DEFAULT NULL COMMENT '小时单价',
- `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
- `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
- `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
- `touxiang` longtext COMMENT '头像',
- `chepaihao` varchar(200) DEFAULT NULL COMMENT '车牌号',
- `jinchangshijian` varchar(200) DEFAULT NULL COMMENT '进场时间',
- `lichangshijian` datetime DEFAULT NULL COMMENT '离场时间',
- `tingcheshizhang` float DEFAULT NULL COMMENT '停车时长',
- `tingchefeiyong` float DEFAULT NULL COMMENT '停车费用',
- `sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
- `shhf` longtext COMMENT '审核回复',
- `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432506595 DEFAULT CHARSET=utf8 COMMENT='车子离场';
-
- CREATE TABLE `config` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `name` varchar(100) NOT NULL COMMENT '配置参数名称',
- `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
-
- CREATE TABLE `forum` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
- `content` longtext NOT NULL COMMENT '帖子内容',
- `parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
- `userid` bigint(20) NOT NULL COMMENT '用户id',
- `username` varchar(200) DEFAULT NULL COMMENT '用户名',
- `avatarurl` longtext COMMENT '头像',
- `isdone` varchar(200) DEFAULT NULL COMMENT '状态',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432472314 DEFAULT CHARSET=utf8 COMMENT='论坛交流';
-
- CREATE TABLE `messages` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `userid` bigint(20) NOT NULL COMMENT '留言人id',
- `username` varchar(200) DEFAULT NULL COMMENT '用户名',
- `avatarurl` longtext COMMENT '头像',
- `content` longtext NOT NULL COMMENT '留言内容',
- `cpicture` longtext COMMENT '留言图片',
- `reply` longtext COMMENT '回复内容',
- `rpicture` longtext COMMENT '回复图片',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432481475 DEFAULT CHARSET=utf8 COMMENT='投诉建议';
-
- CREATE TABLE `news` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `title` varchar(200) NOT NULL COMMENT '标题',
- `introduction` longtext COMMENT '简介',
- `picture` longtext NOT NULL COMMENT '图片',
- `content` longtext NOT NULL COMMENT '内容',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432621597 DEFAULT CHARSET=utf8 COMMENT='系统公告';
-
- CREATE TABLE `token` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `userid` bigint(20) NOT NULL COMMENT '用户id',
- `username` varchar(100) NOT NULL COMMENT '用户名',
- `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
- `role` varchar(100) DEFAULT NULL COMMENT '角色',
- `token` varchar(200) NOT NULL COMMENT '密码',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
- `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token表';
-
- CREATE TABLE `users` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `username` varchar(100) NOT NULL COMMENT '用户名',
- `password` varchar(100) NOT NULL COMMENT '密码',
- `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
-
- CREATE TABLE `weiguichufa` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `weiguishixiang` varchar(200) DEFAULT NULL COMMENT '违规事项',
- `weiguibeizhu` varchar(200) DEFAULT NULL COMMENT '违规备注',
- `chufajine` int(11) DEFAULT NULL COMMENT '处罚金额',
- `chufashijian` datetime DEFAULT NULL COMMENT '处罚时间',
- `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
- `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
- `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
- `touxiang` longtext COMMENT '头像',
- `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432569013 DEFAULT CHARSET=utf8 COMMENT='违规处罚';
-
- CREATE TABLE `yonghu` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
- `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
- `xingming` varchar(200) NOT NULL COMMENT '姓名',
- `mima` varchar(200) NOT NULL COMMENT '密码',
- `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
- `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
- `touxiang` longtext COMMENT '头像',
- PRIMARY KEY (`id`),
- UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1678432425883 DEFAULT CHARSET=utf8 COMMENT='用户';
- package com.controller;
-
- /**
- * 车位信息
- * 后端接口
- * @author 计算机编程-吉哥
- */
- @RestController
- @RequestMapping("/cheweixinxi")
- public class CheweixinxiController {
-
- @Autowired
- private CheweixinxiService cheweixinxiService;
-
-
-
- /**
- * 后端列表
- */
- @RequestMapping("/page")
- public R page(@RequestParam Map
params,CheweixinxiEntity cheweixinxi, - HttpServletRequest request){
- EntityWrapper
ew = new EntityWrapper(); -
- PageUtils page = cheweixinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, cheweixinxi), params), params));
-
- return R.ok().put("data", page);
- }
-
- /**
- * 前端列表
- */
- @IgnoreAuth
- @RequestMapping("/list")
- public R list(@RequestParam Map
params,CheweixinxiEntity cheweixinxi, - HttpServletRequest request){
- EntityWrapper
ew = new EntityWrapper(); -
- PageUtils page = cheweixinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, cheweixinxi), params), params));
- return R.ok().put("data", page);
- }
-
- /**
- * 列表
- */
- @RequestMapping("/lists")
- public R list( CheweixinxiEntity cheweixinxi){
- EntityWrapper
ew = new EntityWrapper(); - ew.allEq(MPUtil.allEQMapPre( cheweixinxi, "cheweixinxi"));
- return R.ok().put("data", cheweixinxiService.selectListView(ew));
- }
-
- /**
- * 查询
- */
- @RequestMapping("/query")
- public R query(CheweixinxiEntity cheweixinxi){
- EntityWrapper< CheweixinxiEntity> ew = new EntityWrapper< CheweixinxiEntity>();
- ew.allEq(MPUtil.allEQMapPre( cheweixinxi, "cheweixinxi"));
- CheweixinxiView cheweixinxiView = cheweixinxiService.selectView(ew);
- return R.ok("查询车位信息成功").put("data", cheweixinxiView);
- }
-
- /**
- * 后端详情
- */
- @RequestMapping("/info/{id}")
- public R info(@PathVariable("id") Long id){
- CheweixinxiEntity cheweixinxi = cheweixinxiService.selectById(id);
- return R.ok().put("data", cheweixinxi);
- }
-
- /**
- * 前端详情
- */
- @IgnoreAuth
- @RequestMapping("/detail/{id}")
- public R detail(@PathVariable("id") Long id){
- CheweixinxiEntity cheweixinxi = cheweixinxiService.selectById(id);
- return R.ok().put("data", cheweixinxi);
- }
-
-
-
-
- /**
- * 后端保存
- */
- @RequestMapping("/save")
- public R save(@RequestBody CheweixinxiEntity cheweixinxi, HttpServletRequest request){
- cheweixinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
- //ValidatorUtils.validateEntity(cheweixinxi);
- cheweixinxiService.insert(cheweixinxi);
- return R.ok();
- }
-
- /**
- * 前端保存
- */
- @RequestMapping("/add")
- public R add(@RequestBody CheweixinxiEntity cheweixinxi, HttpServletRequest request){
- cheweixinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
- //ValidatorUtils.validateEntity(cheweixinxi);
- cheweixinxiService.insert(cheweixinxi);
- return R.ok();
- }
-
-
-
- /**
- * 修改
- */
- @RequestMapping("/update")
- @Transactional
- public R update(@RequestBody CheweixinxiEntity cheweixinxi, HttpServletRequest request){
- //ValidatorUtils.validateEntity(cheweixinxi);
- cheweixinxiService.updateById(cheweixinxi);//全部更新
- return R.ok();
- }
-
-
-
-
- /**
- * 删除
- */
- @RequestMapping("/delete")
- public R delete(@RequestBody Long[] ids){
- cheweixinxiService.deleteBatchIds(Arrays.asList(ids));
- return R.ok();
- }
-
- /**
- * 提醒接口
- */
- @RequestMapping("/remind/{columnName}/{type}")
- public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request,
- @PathVariable("type") String type,@RequestParam Map
map) { - map.put("column", columnName);
- map.put("type", type);
-
- if(type.equals("2")) {
- SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
- Calendar c = Calendar.getInstance();
- Date remindStartDate = null;
- Date remindEndDate = null;
- if(map.get("remindstart")!=null) {
- Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
- c.setTime(new Date());
- c.add(Calendar.DAY_OF_MONTH,remindStart);
- remindStartDate = c.getTime();
- map.put("remindstart", sdf.format(remindStartDate));
- }
- if(map.get("remindend")!=null) {
- Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
- c.setTime(new Date());
- c.add(Calendar.DAY_OF_MONTH,remindEnd);
- remindEndDate = c.getTime();
- map.put("remindend", sdf.format(remindEndDate));
- }
- }
-
- Wrapper
wrapper = new EntityWrapper(); - if(map.get("remindstart")!=null) {
- wrapper.ge(columnName, map.get("remindstart"));
- }
- if(map.get("remindend")!=null) {
- wrapper.le(columnName, map.get("remindend"));
- }
-
-
- int count = cheweixinxiService.selectCount(wrapper);
- return R.ok().put("count", count);
- }
-
-
- }
- package com.service;
-
- /**
- * 车位信息
- *
- * @author 计算机编程-吉哥
- */
- public interface CheweixinxiService extends IService
{ -
- PageUtils queryPage(Map
params) ; -
- List
selectListVO(Wrapper wrapper) ; -
- CheweixinxiVO selectVO(@Param("ew") Wrapper
wrapper) ; -
- List
selectListView(Wrapper wrapper) ; -
- CheweixinxiView selectView(@Param("ew") Wrapper
wrapper) ; -
- PageUtils queryPage(Map
params,Wrapper wrapper) ; -
-
- }
-
- package com.service.impl;
-
- @Service("cheweixinxiService")
- public class CheweixinxiServiceImpl extends ServiceImpl
implements CheweixinxiService { -
-
- @Override
- public PageUtils queryPage(Map
params) { - Page
page = this.selectPage( - new Query
(params).getPage(), - new EntityWrapper
() - );
- return new PageUtils(page);
- }
-
- @Override
- public PageUtils queryPage(Map
params, Wrapper wrapper) { - Page
page =new Query(params).getPage(); - page.setRecords(baseMapper.selectListView(page,wrapper));
- PageUtils pageUtil = new PageUtils(page);
- return pageUtil;
- }
-
- @Override
- public List
selectListVO(Wrapper wrapper) { - return baseMapper.selectListVO(wrapper);
- }
-
- @Override
- public CheweixinxiVO selectVO(Wrapper
wrapper) { - return baseMapper.selectVO(wrapper);
- }
-
- @Override
- public List
selectListView(Wrapper wrapper) { - return baseMapper.selectListView(wrapper);
- }
-
- @Override
- public CheweixinxiView selectView(Wrapper
wrapper) { - return baseMapper.selectView(wrapper);
- }
-
-
- }
- package com.dao;
-
- /**
- * 车位信息
- *
- * @author 计算机编程-吉哥
- */
- public interface CheweixinxiDao extends BaseMapper
{ -
- List
selectListVO(@Param("ew") Wrapper wrapper) ; -
- CheweixinxiVO selectVO(@Param("ew") Wrapper
wrapper) ; -
- List
selectListView(@Param("ew") Wrapper wrapper) ; -
- List
selectListView(Pagination page,@Param("ew") Wrapper wrapper) ; -
- CheweixinxiView selectView(@Param("ew") Wrapper
wrapper) ; -
-
- }

你可能还有感兴趣的项目👇🏻👇🏻👇🏻
更多项目推荐:计算机毕业设计项目
如果大家有任何疑虑,请在下方咨询或评论