开发平台为idea,maven管理工具,Mybatis操作数据库,根据市场数字化需要为农户打造小程序可远程查看农场的种植情况。项目是调试,讲解服务均可有偿获取,需要可在最下方QQ二维码处联系我。
Springboot+Vue+小程序,基于微信小程序的农场信息管理系统。数据库Mysql,17张表。
前台可以查阅接受保护的农产品。
后台对请求进行管理。
后台管理功能有。
1.农户管理
2.农产品展示
3.产品类型
4.农产品订单管理
5.预采摘登记管理
6.远程看护管理
7.蔬果类型管理
8.播种管理
9.施肥信息管理
10.浇水管理
11.轮播图管理,农业活动及活动分类管理。
12.个人信息管理。
部分数据库设计:
表名:nongchanpindingdan
功能:农产品订单
字段名称 | 类型 | 长度 | 字段说明 | 主键 | 默认值 |
id | bigint | 主键 | 主键 | ||
addtime | timestamp | 创建时间 | CURRENT_TIMESTAMP | ||
dingdanbianhao | varchar | 200 | 订单编号 | ||
chanpinmingcheng | varchar | 200 | 产品名称 | ||
chanpinleixing | varchar | 200 | 产品类型 | ||
chanpintupian | longtext | 4294967295 | 产品图片 | ||
chandi | varchar | 200 | 产地 | ||
guige | varchar | 200 | 规格 | ||
shuliang | int | 数量 | |||
jiage | int | 价格 | |||
zonge | double | 总额 | |||
goumaishijian | datetime | 购买时间 | |||
dingdanbeizhu | varchar | 200 | 订单备注 | ||
shouhuodizhi | varchar | 200 | 收货地址 | ||
youkexingming | varchar | 200 | 游客姓名 | ||
nonghuzhanghao | varchar | 200 | 农户账号 | ||
nonghuxingming | varchar | 200 | 农户姓名 |
表名:newstype
功能:农业活动分类
字段名称 | 类型 | 长度 | 字段说明 | 主键 | 默认值 |
id | bigint | 主键 | 主键 | ||
addtime | timestamp | 创建时间 | CURRENT_TIMESTAMP | ||
typename | varchar | 200 | 分类名称 |
表名:yucaizhaidengji
功能:预采摘登记
字段名称 | 类型 | 长度 | 字段说明 | 主键 | 默认值 |
id | bigint | 主键 | 主键 | ||
addtime | timestamp | 创建时间 | CURRENT_TIMESTAMP | ||
caizhaichanpin | varchar | 200 | 采摘产品 | ||
caizhaishijian | datetime | 采摘时间 | |||
caizhaididian | varchar | 200 | 采摘地点 | ||
caizhairenshu | int | 采摘人数 | |||
caizhaigongju | varchar | 200 | 采摘工具 | ||
caizhaitupian | longtext | 4294967295 | 采摘图片 | ||
nonghuzhanghao | varchar | 200 | 农户账号 | ||
nonghuxingming | varchar | 200 | 农户姓名 |
表名:news
功能:农业活动
字段名称 | 类型 | 长度 | 字段说明 | 主键 | 默认值 |
id | bigint | 主键 | 主键 | ||
addtime | timestamp | 创建时间 | CURRENT_TIMESTAMP | ||
title | varchar | 200 | 标题 | ||
introduction | longtext | 4294967295 | 简介 | ||
typename | varchar | 200 | 分类名称 | ||
name | varchar | 200 | 发布人 | ||
headportrait | longtext | 4294967295 | 头像 | ||
clicknum | int | 点击次数 | 0 | ||
clicktime | datetime | 最近点击时间 | |||
thumbsupnum | int | 赞 | 0 | ||
crazilynum | int | 踩 | 0 | ||
storeupnum | int | 收藏数 | 0 | ||
picture | longtext | 4294967295 | 图片 | ||
content | longtext | 4294967295 | 内容 |
代码示例:
1.农产品增删改查模块
package com.controller;import java.util.Arrays;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import javax.servlet.http.HttpServletRequest;import com.entity.NonghuEntity;
import com.service.NonghuService;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.ObjectUtils;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.annotation.IgnoreAuth;import com.entity.NongchanpinzhanshiEntity;
import com.entity.view.NongchanpinzhanshiView;import com.service.NongchanpinzhanshiService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MPUtil;/*** 农产品展示* 后端接口*/
@RestController
@RequestMapping("/nongchanpinzhanshi")
public class NongchanpinzhanshiController {@Autowiredprivate NonghuService nonghuService;@Autowiredprivate NongchanpinzhanshiService nongchanpinzhanshiService;/*** 后端列表*/@RequestMapping("/page")public R page(@RequestParam Map<String, Object> params, NongchanpinzhanshiEntity nongchanpinzhanshi,HttpServletRequest request) {String tableName = request.getSession().getAttribute("tableName").toString();if (tableName.equals("nonghu")) {nongchanpinzhanshi.setNonghuzhanghao((String) request.getSession().getAttribute("username"));}EntityWrapper<NongchanpinzhanshiEntity> ew = new EntityWrapper<>();PageUtils page = nongchanpinzhanshiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, nongchanpinzhanshi), params), params));return R.ok().put("data", page);}/*** 前端列表*/@RequestMapping("/list")public R list(@RequestParam Map<String, Object> params, NongchanpinzhanshiEntity nongchanpinzhanshi,HttpServletRequest request) {String tableName = request.getSession().getAttribute("tableName").toString();if (tableName.equals("nonghu")) {nongchanpinzhanshi.setNonghuzhanghao((String) request.getSession().getAttribute("username"));}EntityWrapper<NongchanpinzhanshiEntity> ew = new EntityWrapper<>();PageUtils page = nongchanpinzhanshiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, nongchanpinzhanshi), params), params));return R.ok().put("data", page);}/*** 列表*/@RequestMapping("/lists")public R list(NongchanpinzhanshiEntity nongchanpinzhanshi) {EntityWrapper<NongchanpinzhanshiEntity> ew = new EntityWrapper<>();ew.allEq(MPUtil.allEQMapPre(nongchanpinzhanshi, "nongchanpinzhanshi"));return R.ok().put("data", nongchanpinzhanshiService.selectListView(ew));}/*** 查询*/@RequestMapping("/query")public R query(NongchanpinzhanshiEntity nongchanpinzhanshi) {EntityWrapper<NongchanpinzhanshiEntity> ew = new EntityWrapper<>();ew.allEq(MPUtil.allEQMapPre(nongchanpinzhanshi, "nongchanpinzhanshi"));NongchanpinzhanshiView nongchanpinzhanshiView = nongchanpinzhanshiService.selectView(ew);return R.ok("查询农产品展示成功").put("data", nongchanpinzhanshiView);}/*** 后端详情*/@RequestMapping("/info/{id}")public R info(@PathVariable("id") Long id) {NongchanpinzhanshiEntity nongchanpinzhanshi = nongchanpinzhanshiService.selectById(id);nongchanpinzhanshi.setClicknum(nongchanpinzhanshi.getClicknum() + 1);nongchanpinzhanshi.setClicktime(new Date());nongchanpinzhanshiService.updateById(nongchanpinzhanshi);nongchanpinzhanshi = nongchanpinzhanshiService.selectView(new EntityWrapper<NongchanpinzhanshiEntity>().eq("id", id));return R.ok().put("data", nongchanpinzhanshi);}/*** 前端详情*/@IgnoreAuth@RequestMapping("/detail/{id}")public R detail(@PathVariable("id") Long id) {NongchanpinzhanshiEntity nongchanpinzhanshi = nongchanpinzhanshiService.selectById(id);nongchanpinzhanshi.setClicknum(nongchanpinzhanshi.getClicknum() + 1);nongchanpinzhanshi.setClicktime(new Date());nongchanpinzhanshiService.updateById(nongchanpinzhanshi);nongchanpinzhanshi = nongchanpinzhanshiService.selectView(new EntityWrapper<NongchanpinzhanshiEntity>().eq("id", id));return R.ok().put("data", nongchanpinzhanshi);}/*** 后端保存*/@RequestMapping("/save")public R save(@RequestBody NongchanpinzhanshiEntity nongchanpinzhanshi, HttpServletRequest request) {NonghuEntity nonghu = nonghuService.selectOne(new EntityWrapper<NonghuEntity>().eq("nonghuzhanghao", nongchanpinzhanshi.getNonghuzhanghao()).eq("nonghuxingming", nongchanpinzhanshi.getNonghuxingming()));if (ObjectUtils.isEmpty(nonghu)) {return R.error(404, "该账户不存在,请确认农户账号姓名");}nongchanpinzhanshiService.insert(nongchanpinzhanshi);return R.ok();}/*** 前端保存*/@RequestMapping("/add")public R add(@RequestBody NongchanpinzhanshiEntity nongchanpinzhanshi, HttpServletRequest request) {nongchanpinzhanshi.setUserid((Long) request.getSession().getAttribute("userId"));nongchanpinzhanshiService.insert(nongchanpinzhanshi);return R.ok();}/*** 修改*/@RequestMapping("/update")@Transactionalpublic R update(@RequestBody NongchanpinzhanshiEntity nongchanpinzhanshi, HttpServletRequest request) {nongchanpinzhanshiService.updateById(nongchanpinzhanshi);//全部更新return R.ok();}/*** 删除*/@RequestMapping("/delete")public R delete(@RequestBody Long[] ids) {nongchanpinzhanshiService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 前端智能排序*/@IgnoreAuth@RequestMapping("/autoSort")public R autoSort(@RequestParam Map<String, Object> params, NongchanpinzhanshiEntity nongchanpinzhanshi, HttpServletRequest request, String pre) {EntityWrapper<NongchanpinzhanshiEntity> ew = new EntityWrapper<NongchanpinzhanshiEntity>();Map<String, Object> newMap = new HashMap<String, Object>();Map<String, Object> param = new HashMap<String, Object>();Iterator<Map.Entry<String, Object>> it = param.entrySet().iterator();while (it.hasNext()) {Map.Entry<String, Object> entry = it.next();String key = entry.getKey();String newKey = entry.getKey();if (pre.endsWith(".")) {newMap.put(pre + newKey, entry.getValue());} else if (StringUtils.isEmpty(pre)) {newMap.put(newKey, entry.getValue());} else {newMap.put(pre + "." + newKey, entry.getValue());}}params.put("sort", "clicknum");params.put("order", "desc");PageUtils page = nongchanpinzhanshiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, nongchanpinzhanshi), params), params));return R.ok().put("data", page);}
}
2.农产品展示实体:
package com.entity.vo;import java.util.Date;
import org.springframework.format.annotation.DateTimeFormat;
import com.fasterxml.jackson.annotation.JsonFormat;
import java.io.Serializable;/*** 农产品展示*/
public class NongchanpinzhanshiVO implements Serializable {private static final long serialVersionUID = 1L;/*** 产品类型*/private String chanpinleixing;/*** 产地*/private String chandi;/*** 规格*/private String guige;/*** 数量*/private Integer shuliang;/*** 价格*/private Integer jiage;/*** 采摘日期*/@JsonFormat(locale = "zh", timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")@DateTimeFormatprivate Date caizhairiqi;/*** 保质期*/private String baozhiqi;/*** 产品描述*/private String chanpinmiaoshu;/*** 产品图片*/private String chanpintupian;/*** 农户账号*/private String nonghuzhanghao;/*** 农户姓名*/private String nonghuxingming;/*** 最近点击时间*/@JsonFormat(locale = "zh", timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")@DateTimeFormatprivate Date clicktime;/*** 点击次数*/private Integer clicknum;/*** 用户id*/private Long userid;/*** 设置:产品类型*/public void setChanpinleixing(String chanpinleixing) {this.chanpinleixing = chanpinleixing;}/*** 获取:产品类型*/public String getChanpinleixing() {return chanpinleixing;}/*** 设置:产地*/public void setChandi(String chandi) {this.chandi = chandi;}/*** 获取:产地*/public String getChandi() {return chandi;}/*** 设置:规格*/public void setGuige(String guige) {this.guige = guige;}/*** 获取:规格*/public String getGuige() {return guige;}/*** 设置:数量*/public void setShuliang(Integer shuliang) {this.shuliang = shuliang;}/*** 获取:数量*/public Integer getShuliang() {return shuliang;}/*** 设置:价格*/public void setJiage(Integer jiage) {this.jiage = jiage;}/*** 获取:价格*/public Integer getJiage() {return jiage;}/*** 设置:采摘日期*/public void setCaizhairiqi(Date caizhairiqi) {this.caizhairiqi = caizhairiqi;}/*** 获取:采摘日期*/public Date getCaizhairiqi() {return caizhairiqi;}/*** 设置:保质期*/public void setBaozhiqi(String baozhiqi) {this.baozhiqi = baozhiqi;}/*** 获取:保质期*/public String getBaozhiqi() {return baozhiqi;}/*** 设置:产品描述*/public void setChanpinmiaoshu(String chanpinmiaoshu) {this.chanpinmiaoshu = chanpinmiaoshu;}/*** 获取:产品描述*/public String getChanpinmiaoshu() {return chanpinmiaoshu;}/*** 设置:产品图片*/public void setChanpintupian(String chanpintupian) {this.chanpintupian = chanpintupian;}/*** 获取:产品图片*/public String getChanpintupian() {return chanpintupian;}/*** 设置:农户账号*/public void setNonghuzhanghao(String nonghuzhanghao) {this.nonghuzhanghao = nonghuzhanghao;}/*** 获取:农户账号*/public String getNonghuzhanghao() {return nonghuzhanghao;}/*** 设置:农户姓名*/public void setNonghuxingming(String nonghuxingming) {this.nonghuxingming = nonghuxingming;}/*** 获取:农户姓名*/public String getNonghuxingming() {return nonghuxingming;}/*** 设置:最近点击时间*/public void setClicktime(Date clicktime) {this.clicktime = clicktime;}/*** 获取:最近点击时间*/public Date getClicktime() {return clicktime;}/*** 设置:点击次数*/public void setClicknum(Integer clicknum) {this.clicknum = clicknum;}/*** 获取:点击次数*/public Integer getClicknum() {return clicknum;}/*** 设置:用户id*/public void setUserid(Long userid) {this.userid = userid;}/*** 获取:用户id*/public Long getUserid() {return userid;}
}