栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

SpringBoot+Mybatis+Mysql+Vue+ElementUi实现一个《流浪猫狗领养救助管理系统》毕业设计(超详细教程)

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

SpringBoot+Mybatis+Mysql+Vue+ElementUi实现一个《流浪猫狗领养救助管理系统》毕业设计(超详细教程)

哈喽,大家好!我是阿瞒,今天给大家带来的一个《流浪猫狗领养救助管理系统》,制作时间花费了....嗯....大概两周的时间吧,如果喜欢可以点赞、收藏、关注三连,也可以评论私信啥的哦,我看见了就会第一时间回复的。

话不多说咱们直接开整吧,冲啊!!!冲啊!!!冲啊!!!

开发技术及开发工具

开发工具采用Idea【前后端代码的编写】、Navicat Premium 15【Mysql数据库的连接】

前端采用Vue、ElementUI

后端采用SpringBoot、Mybatis

数据库采用Mysql

记得以上的技术所需要的环境都得装好哟,这里就不跟大家说怎么去装了,百度就ok了

然后这个毕业设计是没有进行前后端分离的哦

系统结构图

内置功能

1.登录功能

2.系统管理:用户管理、角色管理、菜单管理、个人信息管理

3.救助站管理:救助站信息

4.领养管理:待领养信息、领养信息

5.养宠攻略管理:攻略信息

6.交流消息管理:消息信息
7.捐赠支出管理:捐赠支出信息

PS:角色一开始分为管理员与普通用户,大家可以根据自己的喜好来添加角色和角色的权限

系统演示图

先上一个处理跨域请求的类吧,否则前端请求不到后端接口地址哦,因为是不同域、不同端口的,这里我的项目是单体的所以其实这个跨域问题也不用解决,贴出来让大家注意一下,以后做前后端分离的系统的话就要处理这些东西了

package com.user.config;

import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.CorsRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;


@Configuration
public class CorsConfig implements WebMvcConfigurer {

    @Override
    public void addCorsMappings(CorsRegistry registry) {
        registry.addMapping("
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
public class User implements Serializable {

    private static final long serialVersionUID = 1L;

    
    private String userid;

    
    private String fullname;

    
    private String password;

    
    private String username;

    
    private String identity;

    
    private String sex;

    
    private String age;

    
    private String area;

    
    private String address;

    
    private String phone;

    
    private String backup;

    
    private String backup2;

    
    private String backup3;

    
    private Role role;

    
    private String roleName;
}

3.救助站管理:救助站信息

 救助站的Controller展现层

CONTROLLER层
  • 控制层,实现对Get和Post的相应
  • 用于前后端交互,service层和前端通过Controller层进行数据交互

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.controller;


import com.user.model.Station;
import com.user.service.IStationService;
import com.user.utils.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;


@RestController
@RequestMapping("/station")
public class StationController {
    @Autowired
    IStationService iStationService;
    //查询所有救助站信息
    @GetMapping("/list")
    public Result getStationAll(){
        return new Result(true,iStationService.getStationAll());
    }
    //根据编号查询救助站信息
    @GetMapping("/getStationOne/{staId}")
    public Result getStationOne(@PathVariable String staId){
        return new Result(true,iStationService.getStationOne(staId));
    }
    //删除救助站
    @DeleteMapping("{staId}")
    public Result delStation(@PathVariable String staId){
        String[] sta = staId.split(",");
        for (String id : sta){
            iStationService.delStation(id);
        }
        return new Result(true);
    }
    //新增救助站
    @PostMapping("/addStation")
    public Result addStation(@RequestBody Station station){
        boolean flag = iStationService.addStation(station);
        return new Result(flag, flag ? "添加成功^_^" : "添加失败-_-!");
    }
    //根据救助站名称、容量、地区、地址模糊查询
    @PostMapping("/selectStationByCriteria")
    public Result selectStationByCriteria(@RequestBody Station station){
        return new Result(true,iStationService.selectStationByCriteria(station));
    }
    //修改救助站
    @PostMapping("/udpateStation")
    public Result updateStationById(@RequestBody Station station){
        boolean flag = iStationService.updateStationById(station);
        return new Result(flag, flag ? "修改成功^_^" : "修改失败-_-!");
    }
}

救助站功能的Service接口层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service;

import com.user.model.Role;
import com.user.model.Station;
import com.user.model.User;
import com.user.utils.Result;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface IStationService {
    //查询所有救助站信息
    List getStationAll();
    //根据编号查询救助站信息
    Station getStationOne(String staId);
    //根据id删除救助站
    Boolean delStation(String staId);
    //新增救助站
    Boolean addStation(Station station);
    //模糊查询救助站
    List selectStationByCriteria(Station station);
    //根据编号修改救助站
    Boolean updateStationById(Station station);
}

救助站功能的Service接口的Impl实现层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service.impl;

import com.user.dao.StationDao;
import com.user.model.Menu;
import com.user.model.Station;
import com.user.service.IStationService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Arrays;
import java.util.List;

@Service
public class StationServiceImpl implements IStationService {
    @Autowired
    StationDao stationDao;

    //查询所有救助站信息
    @Override
    public List getStationAll() {
        List station = stationDao.getStationAll();
        return station;
    }
    //根据编号查询救助站信息
    @Override
    public Station getStationOne(String staId) {
        return stationDao.getStationOne(staId);
    }
    //根据id删除救助站
    @Override
    public Boolean delStation(String staId) {
        return stationDao.delStation(staId)>0;
    }
    //新增救助站
    @Override
    public Boolean addStation(Station station) {
        return stationDao.addStation(station)>0;
    }
    //模糊查询救助站
    @Override
    public List selectStationByCriteria(Station station) {
        //名称
        //容量
        //地区
        //地址
        List sta = stationDao.selectStationByCriteria(station);
        return sta;
    }
    //根据编号修改救助站
    @Override
    public Boolean updateStationById(Station station) {
        return stationDao.updateStationById(station)>0;
    }
}

 救助站功能的Dao数据持久化层

DAO层
  • 数据持久层,用于存放sql语句,在SpringBoot中用注解来为每一个方法注入sql语句
  • 又称为mapper层

这一层请注意,我用的是mybatis的注解sql,并没有在mapper的xml里使用sql语句哦

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.dao;

import com.user.model.Menu;
import com.user.model.Role;
import com.user.model.Station;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface StationDao {
    //查询所有救助站信息
    @Select("select * from station")
    List getStationAll();
    //根据编号查询救助站信息
    @Select("select * from station where sta_id = #{staId}")
    Station getStationOne(String staId);

    //根据id删除救助站
    @Delete("delete from station where sta_id = #{staId}")
    Integer delStation(String staId);

    //新增救助站
    @Insert("insert into `station`(sta_name,capacity,set_time,area,address,phone)n" +
            "values" +
            "(#{staName},#{capacity},#{setTime},#{area},#{address},#{phone})")
    Integer addStation(Station station);
    //模糊查询救助站
    @Select({""})
    List selectStationByCriteria(Station station);
    //根据编号修改救助站
    @Update("    update stationn" +
            "    set sta_name = #{staName},n" +
            "      capacity = #{capacity},n" +
            "      set_time = #{setTime},n" +
            "      area = #{area},n" +
            "      address = #{address},n" +
            "      phone = #{phone},n" +
            "      backup = #{backup},n" +
            "      backup2 = #{backup2},n" +
            "      backup3 = #{backup3}n" +
            "    where sta_id = #{staId}")
    Integer updateStationById(Station station);
}

 救助站功能的Model实体层

MODEL层
  • model层,又称:数据访问层
  • 一张表对应一个实体类

这一层的类,我用的是mybatis-plus的maven插件自动生成数据库对应的字段以及表的实体类

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.sql.Date;
import java.time.LocalDateTime;


@Data
public class Station implements Serializable {

    private static final long serialVersionUID = 1L;

    
    @TableId(value = "sta_id", type = IdType.AUTO)
    private Integer staId;

    
    private String staName;

    
    private String capacity;

    
    @JsonFormat(pattern = "yyyy-MM-dd hh:mm:ss")
    private Date setTime;

    
    private String area;

    
    private String address;

    
    private String phone;

    
    private String backup;

    
    private String backup2;

    
    private String backup3;


}
4.领养管理:待领养信息、领养信息

   领养管理的Controller展现层

CONTROLLER层
  • 控制层,实现对Get和Post的相应
  • 用于前后端交互,service层和前端通过Controller层进行数据交互

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.controller;


import com.user.model.Adopt;
import com.user.service.IAdoptService;
import com.user.utils.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;


@RestController
@RequestMapping("/adopt")
public class AdoptController {
    @Autowired
    IAdoptService iAdoptService;
    //查询所有宠物领养信息信息
    @GetMapping("/list")
    public Result getAdoptAll(){
        return new Result(true,iAdoptService.getAdoptAll());
    }
    //根据编号查询宠物领养信息信息
    @GetMapping("/getAdoptOne/{adId}")
    public Result getAdoptOne(@PathVariable String adId){
        return new Result(true,iAdoptService.getAdoptOne(adId));
    }
    //删除宠物领养信息
    @DeleteMapping("{adId}")
    public Result delAdopt(@PathVariable String adId){
        String[] sta = adId.split(",");
        for (String id : sta){
            iAdoptService.delAdopt(id);
        }
        return new Result(true);
    }
    //根据宠物领养信息模糊查询
    @PostMapping("/selectAdoptByCriteria")
    public Result selectAdoptByCriteria(@RequestBody Adopt adopt){
        System.out.println(adopt.getAn().getAnName());
        System.out.println(adopt.getUser().getUsername());
        return new Result(true,iAdoptService.selectAdoptByCriteria(adopt));
    }
    //修改宠物领养信息
    @PutMapping
    public Result updateAdoptById(@RequestBody Adopt adopt){
        boolean flag = iAdoptService.updateAdoptById(adopt);
        return new Result(flag, flag ? "修改成功^_^" : "修改失败-_-!");
    }
}

领养管理功能的Service接口层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service;

import com.user.model.Adopt;

import java.util.List;

public interface IAdoptService {
    //查询所有宠物领养信息信息
    List getAdoptAll();
    //根据编号查询宠物领养信息信息
    Adopt getAdoptOne(String anId);
    //根据id删除宠物领养信息
    Boolean delAdopt(String anId);
    //模糊查询宠物领养信息
    List selectAdoptByCriteria(Adopt Adopt);
    //根据编号修改宠物领养信息
    Boolean updateAdoptById(Adopt Adopt);
}

 领养管理功能的Service接口的Impl实现层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service.impl;

import com.user.dao.AdoptDao;
import com.user.dao.AnimalDao;
import com.user.model.Adopt;
import com.user.model.Animal;
import com.user.service.IAdoptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class AodptServiceImpl implements IAdoptService {
    @Autowired
    AdoptDao adoptDao;
    @Autowired
    AnimalDao animalDao;

    //查询所有动物信息
    @Override
    public List getAdoptAll() {
        List ado = adoptDao.getAdoptAll();
        return ado;
    }
    //根据编号查询动物信息
    @Override
    public Adopt getAdoptOne(String adId) {
        return adoptDao.getAdoptOne(adId);
    }
    //根据id删除动物
    @Override
    public Boolean delAdopt(String adId) {
        return adoptDao.delAdopt(adId)>0;
    }
    //模糊查询动物
    @Override
    public List selectAdoptByCriteria(Adopt adopt) {
        List sta = adoptDao.selectAdoptByCriteria(adopt);
        return sta;
    }
    //根据编号修改动物领养信息
    @Override
    public Boolean updateAdoptById(Adopt adopt) {
        //如果当前状态为驳回或者为待领养那么修改宠物的状态
        if ("0".equals(adopt.getAdoptStatus())){
            Animal a = new Animal();
            a.setAnId(Integer.valueOf(adopt.getAnId()));
            a.setState("1");
            animalDao.updateAnimalStateById(a);
        }
        return adoptDao.updateAdoptById(adopt)>0;
    }
}

 领养管理功能的Dao数据持久化层

DAO层
  • 数据持久层,用于存放sql语句,在SpringBoot中用注解来为每一个方法注入sql语句
  • 又称为mapper层

这一层请注意,我用的是mybatis的注解sql,并没有在mapper的xml里使用sql语句哦

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.dao;

import com.user.model.Adopt;
import com.user.model.Animal;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface AdoptDao {
    //查询所有领养宠物信息
    @Select("select * from adopt")
    List getAdoptAll();
    //根据编号查询领养宠物信息
    @Select("select a.ad_id,a.remarks,a.adopt_time,a.adopt_status,n" +
            "adopt_status as adoptStatus,a.an_id,n" +
            "b.an_id as banId,an_name as anName,n" +
            "c.userid as cuserId,fullnamen" +
            "from adopt as a n" +
            "INNER JOIN animal as b on a.an_id = b.an_id n" +
            "INNER JOIN `user` as c on a.userid = c.useridn" +
            "where ad_id = #{adId}")
    @ResultMap(value = "adoptMap")
    Adopt getAdoptOne(String adId);

    //根据id删除领养宠物
    @Delete("delete from adopt where ad_id = #{adId}")
    Integer delAdopt(String adId);

    //模糊查询领养宠物
    @Select({""})
    @Results(id="adoptMap",value={
            @Result(id=true,column = "ad_id",property = "adId"),
            @Result(column = "remarks",property = "remarks"),
            @Result(column = "adopt_time",property = "adoptTime"),
            @Result(column = "adoptStatus",property = "adoptStatus"),
            @Result(column = "banId",property = "anId"),
            @Result(column = "cuserId",property = "userid"),
            @Result(column = "anName",property = "backup"),
            //宠物信息
            @Result(column = "banId",property = "an.anId"),
            @Result(column = "anName",property = "an.anName"),
            //用户信息
            @Result(column = "cuserId",property = "user.userid"),
            @Result(column = "fullname",property = "user.username")
    })
    List selectAdoptByCriteria(Adopt Adopt);

    //新增宠物领养信息
    @Insert("insert into `adopt`(userid,an_id,adopt_time,remarks,adopt_status)n" +
            "valuesn" +
            "(#{userid},#{anId},#{adoptTime},#{remarks},'2')")
    Integer addAdopt(Adopt Adopt);

    //根据编号修改领养宠物
    @Update("    update adoptn" +
            "    set userid = #{userid},n" +
            "      an_id = #{anId},n" +
            "      adopt_time = #{adoptTime},n" +
            "      remarks = #{remarks},n" +
            "      adopt_status = #{adoptStatus},n" +
            "      backup = #{backup},n" +
            "      backup2 = #{backup2},n" +
            "      backup3 = #{backup3}n" +
            "    where ad_id = #{adId}")
    Integer updateAdoptById(Adopt Adopt);
}

  领养管理功能的Model实体层

MODEL层
  • model层,又称:数据访问层
  • 一张表对应一个实体类

这一层的类,我用的是mybatis-plus的maven插件自动生成数据库对应的字段以及表的实体类

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Date;


@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
public class Adopt implements Serializable {

    private static final long serialVersionUID = 1L;

    
    @TableId(value = "ad_id", type = IdType.AUTO)
    private Integer adId;

    
    private String userid;

    
    private String anId;

    
    @JsonFormat(pattern = "yyyy-MM-dd hh:mm:ss")
    private Date adoptTime;

    
    private String remarks;

    
    private String adoptStatus;

    
    private String backup;

    
    private String backup2;

    
    private String backup3;


    
    private Animal an;

    
    private User user;
}
5.养宠攻略管理:攻略信息

 养宠攻略管理的Controller展现层

CONTROLLER层
  • 控制层,实现对Get和Post的相应
  • 用于前后端交互,service层和前端通过Controller层进行数据交互

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.controller;


import com.user.model.Strategy;
import com.user.service.IStrategyService;
import com.user.utils.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;


@RestController
@RequestMapping("/strategy")
public class StrategyController {
    @Autowired
    IStrategyService iStrategyService;
    //查询所有攻略信息
    @GetMapping("/list")
    public Result getStrategyAll(){
        return new Result(true,iStrategyService.getStrategyAll());
    }
    //根据编号查询攻略信息
    @GetMapping("/getStrategyOne/{strId}")
    public Result getStrategyOne(@PathVariable String strId){
        return new Result(true,iStrategyService.getStrategyOne(strId));
    }
    //删除攻略
    @DeleteMapping("{strId}")
    public Result delStrategy(@PathVariable String strId){
        String[] sta = strId.split(",");
        for (String id : sta){
            iStrategyService.delStrategy(id);
        }
        return new Result(true);
    }
    //新增攻略
    @PostMapping("/addStrategy")
    public Result addStrategy(@RequestBody Strategy strategy){
        boolean flag = iStrategyService.addStrategy(strategy);
        return new Result(flag, flag ? "添加成功^_^" : "添加失败-_-!");
    }
    //根据攻略模糊查询
    @PostMapping("/selectStrategyByCriteria")
    public Result selectStrategyByCriteria(@RequestBody Strategy strategy){
        return new Result(true,iStrategyService.selectStrategyByCriteria(strategy));
    }
    //修改攻略
    @PutMapping
    public Result updateStrategyById(@RequestBody Strategy strategy){
        boolean flag = iStrategyService.updateStrategyById(strategy);
        return new Result(flag, flag ? "修改成功^_^" : "修改失败-_-!");
    }
}

养宠攻略管理功能的Service接口层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service;

import com.user.model.Strategy;

import java.util.List;

public interface IStrategyService {
    //查询所有攻略信息
    List getStrategyAll();
    //根据编号查询攻略信息
    Strategy getStrategyOne(String str_id);
    //根据id删除攻略
    Boolean delStrategy(String str_id);
    //新增攻略
    Boolean addStrategy(Strategy strategy);
    //模糊查询攻略
    List selectStrategyByCriteria(Strategy strategy);
    //根据编号修改攻略
    Boolean updateStrategyById(Strategy strategy);
}

养宠攻略管理功能的Service接口的Impl实现层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service.impl;

import com.user.dao.StrategyDao;
import com.user.model.Strategy;
import com.user.service.IStrategyService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.List;

@Service
public class StrategyServiceImpl implements IStrategyService {
    @Autowired
    StrategyDao strategyDao;

    //查询所有攻略信息
    @Override
    public List getStrategyAll() {
        List strategy = strategyDao.getStrategyAll();
        return strategy;
    }
    //根据编号查询攻略信息
    @Override
    public Strategy getStrategyOne(String strId) {
        return strategyDao.getStrategyOne(strId);
    }
    //根据id删除攻略
    @Override
    public Boolean delStrategy(String strId) {
        return strategyDao.delStrategy(strId)>0;
    }
    //新增攻略
    @Override
    public Boolean addStrategy(Strategy strategy) {
        strategy.setCreateTime(new Date());
        return strategyDao.addStrategy(strategy)>0;
    }
    //模糊查询攻略
    @Override
    public List selectStrategyByCriteria(Strategy strategy) {
        List sta = strategyDao.selectStrategyByCriteria(strategy);
        return sta;
    }
    //根据编号修改攻略
    @Override
    public Boolean updateStrategyById(Strategy strategy) {
        return strategyDao.updateStrategyById(strategy)>0;
    }
}

养宠攻略管理功能的Dao数据持久化层

DAO层
  • 数据持久层,用于存放sql语句,在SpringBoot中用注解来为每一个方法注入sql语句
  • 又称为mapper层

这一层请注意,我用的是mybatis的注解sql,并没有在mapper的xml里使用sql语句哦

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.dao;

import com.user.model.Strategy;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface StrategyDao {
    //查询所有攻略信息
    @Select("select * from strategy")
    List getStrategyAll();
    //根据编号查询攻略信息
    @Select("select str_id,title,content,createTime,b.userid as buserid,usernamen" +
            "from `strategy` as an" +
            "inner join `user` as b on a.userid = b.useridn" +
            " where str_id = #{strId}")
    @ResultMap(value = "strategyMap")
    Strategy getStrategyOne(String strId);

    //根据id删除攻略
    @Delete("delete from strategy where str_id = #{strId}")
    Integer delStrategy(String strId);

    //新增攻略
    @Insert("    insert into strategy (str_id, userid, createTime, n" +
            "      title, content, backup, n" +
            "      backup2, backup3)n" +
            "    values (#{strId}, #{userid}, #{createTime}, n" +
            "      #{title}, #{content}, #{backup}, n" +
            "      #{backup2}, #{backup3})")
    Integer addStrategy(Strategy strategy);
    //模糊查询攻略
    @Select({""})
    @Results(id="strategyMap",value={
            @Result(id=true,column = "str_id",property = "strId"),
            @Result(column = "title",property = "title"),
            @Result(column = "content",property = "content"),
            @Result(column = "createTime",property = "createTime"),
            //用户信息
            @Result(column = "buserid",property = "user.userid"),
            @Result(column = "fullname",property = "user.username")
    })
    List selectStrategyByCriteria(Strategy strategy);
    //根据编号修改攻略
    @Update(" update strategyn" +
            "    set userid = #{userid},n" +
            "      createTime = #{createTime},n" +
            "      title = #{title},n" +
            "      content = #{content},n" +
            "      backup = #{backup},n" +
            "      backup2 = #{backup2},n" +
            "      backup3 = #{backup3}n" +
            "    where str_id = #{strId}")
    Integer updateStrategyById(Strategy strategy);
}

养宠攻略管理功能的Model实体层

MODEL层
  • model层,又称:数据访问层
  • 一张表对应一个实体类

这一层的类,我用的是mybatis-plus的maven插件自动生成数据库对应的字段以及表的实体类

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Date;


@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
public class Strategy implements Serializable {

    private static final long serialVersionUID = 1L;

    
    @TableId(value = "str_id", type = IdType.AUTO)
    private Integer strId;

    
    private String userid;

    
    @JsonFormat(pattern = "yyyy-MM-dd hh:mm:ss")
    private Date createTime;

    
    private String title;

    
    private String content;

    
    private String backup;

    
    private String backup2;

    
    private String backup3;

    //用户信息
    private User user;

}

6.交流消息管理:消息信息

交流消息管理的Controller展现层

CONTROLLER层
  • 控制层,实现对Get和Post的相应
  • 用于前后端交互,service层和前端通过Controller层进行数据交互

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.controller;


import com.user.model.Information;
import com.user.service.IInformationService;
import com.user.utils.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;


@RestController
@RequestMapping("/information")
public class InformationController {
    @Autowired
    IInformationService iInformationService;
    //查询所有消息信息
    @GetMapping("/list")
    public Result getInformationAll(){
        return new Result(true,iInformationService.getInformationAll());
    }
    //根据编号查询消息信息
    @GetMapping("/getInformationOne/{inId}")
    public Result getInformationOne(@PathVariable String inId){
        return new Result(true,iInformationService.getInformationOne(inId));
    }
    //删除消息
    @DeleteMapping("{inId}")
    public Result delInformation(@PathVariable String inId){
        String[] sta = inId.split(",");
        for (String id : sta){
            iInformationService.delInformation(id);
        }
        return new Result(true);
    }
    //新增消息
    @PostMapping
    public Result addInformation(@RequestBody Information information){
        boolean flag = iInformationService.addInformation(information);
        return new Result(flag, flag ? "添加成功^_^" : "添加失败-_-!");
    }
    //根据消息模糊查询
    @PostMapping("/selectInformationByCriteria")
    public Result selectInformationByCriteria(@RequestBody Information information){
        return new Result(true,iInformationService.selectInformationByCriteria(information));
    }
    //修改消息信息
    @PutMapping
    public Result updateInformationById(@RequestBody Information information){
        boolean flag = iInformationService.updateInformationById(information);
        return new Result(flag, flag ? "修改成功^_^" : "修改失败-_-!");
    }
}

交流消息管理功能的Service接口层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service;

import com.user.model.Information;

import java.util.List;

public interface IInformationService {
    //查询所有消息信息
    List getInformationAll();
    //根据编号查询消息信息
    Information getInformationOne(String in_id);
    //根据id删除消息
    Boolean delInformation(String in_id);
    //新增消息
    Boolean addInformation(Information information);
    //模糊查询消息
    List selectInformationByCriteria(Information information);
    //根据编号修改消息
    Boolean updateInformationById(Information information);
}

交流消息管理功能的Service接口的Impl实现层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service.impl;

import com.user.dao.InformationDao;
import com.user.dao.RoleDao;
import com.user.model.Information;
import com.user.model.Role;
import com.user.service.IInformationService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@Service
public class InformationServiceImpl implements IInformationService {
    @Autowired
    InformationDao informationDao;
    @Autowired
    RoleDao roleDao;

    //查询所有消息信息
    @Override
    public List getInformationAll() {
        List information = informationDao.getInformationAll();
        return information;
    }
    //根据编号查询消息信息
    @Override
    public Information getInformationOne(String inId) {
        return informationDao.getInformationOne(inId);
    }
    //根据id删除消息
    @Override
    public Boolean delInformation(String inId) {
        return informationDao.delInformation(inId)>0;
    }
    //新增消息
    @Override
    public Boolean addInformation(Information information) {
        information.setCreateTime(new Date());
        return informationDao.addInformation(information)>0;
    }
    //模糊查询消息
    @Override
    public List selectInformationByCriteria(Information information) {
        //根据用户编号查询用户角色信息
        Role r = roleDao.r(information.getBackup());
        List sta = new ArrayList();
        //判断此用户不是管理员(查询接收者固定为当前用户)
        if (!"1".equals(r.getRoleid())){
            //其它用户
            System.out.println("当前用户的编号"+information.getBackup());
            System.out.println("发送人编号"+information.getPublishUserid());
            System.out.println("接收人编号"+information.getAddresseeUserid());
            if(null == information.getAddresseeUserid() || "".equals(information.getAddresseeUserid()) && null == information.getContent() || "".equals(information.getContent()) ){
                information.setBackup2("都为空");
            }
            sta=informationDao.selectInformationById(information);
        }else{
            //管理员
            sta = informationDao.selectInformationByCriteria(information);
        }
        return sta;
    }

    //根据编号修改消息
    @Override
    public Boolean updateInformationById(Information information) {
        return informationDao.updateInformationById(information)>0;
    }
}

交流消息管理功能的Dao数据持久化层

DAO层
  • 数据持久层,用于存放sql语句,在SpringBoot中用注解来为每一个方法注入sql语句
  • 又称为mapper层

这一层请注意,我用的是mybatis的注解sql,并没有在mapper的xml里使用sql语句哦

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.dao;

import com.user.model.Information;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface InformationDao {
    //查询所有消息信息
    @Select("select * from information")
    List getInformationAll();
    //根据编号查询消息信息
    @Select("select a.fullname as publishUser,a.userid as publishUserId," +
            "b.fullname as addresseeUser,b.userid as addresseeUserId,i.*n" +
            "from information as in" +
            "inner join `user` as a on a.userid=i.publish_useridn" +
            "inner join `user` as b on b.userid=i.addressee_useridn" +
            " where in_id = #{inId}")
    @ResultMap(value = "informationMap")
    Information getInformationOne(String inId);

    //根据id删除消息
    @Delete("delete from information where in_id = #{inId}")
    Integer delInformation(String inId);

    //新增消息
    @Insert("    insert into information (in_id, publish_userid, addressee_userid, n" +
            "      create_time, content, backup, n" +
            "      backup2, backup3)n" +
            "    values (#{inId}, #{publishUserid}, #{addresseeUserid}, n" +
            "      #{createTime}, #{content}, #{backup}, n" +
            "      #{backup2}, #{backup3})")
    Integer addInformation(Information information);
    //模糊查询消息
    @Select({""})
    @Results(id="informationMap",value={
            @Result(id=true,column = "in_id",property = "inId"),
            @Result(column = "create_time",property = "createTime"),
            @Result(column = "content",property = "content"),
            //发送者信息
            @Result(column = "publishUserId",property = "user.userid"),
            @Result(column = "publishUser",property = "user.username"),
            //接收者信息
            @Result(column = "addresseeUserId",property = "user2.userid"),
            @Result(column = "addresseeUser",property = "user2.username")
    })
    List selectInformationByCriteria(Information information);

    //模糊查询消息
    @Select({""})
    @Results(id="informationMapById",value={
            @Result(id=true,column = "in_id",property = "inId"),
            @Result(column = "create_time",property = "createTime"),
            @Result(column = "content",property = "content"),
            //发送者信息
            @Result(column = "publishUserId",property = "user.userid"),
            @Result(column = "publishUser",property = "user.username"),
            //接收者信息
            @Result(column = "addresseeUserId",property = "user2.userid"),
            @Result(column = "addresseeUser",property = "user2.username")
    })
    List selectInformationById(Information information);


    //根据编号修改消息
    @Update("    update informationn" +
            "    set publish_userid = #{publishUserid},n" +
            "      addressee_userid = #{addresseeUserid},n" +
            "      create_time = #{createTime},n" +
            "      content = #{content},n" +
            "      backup = #{backup},n" +
            "      backup2 = #{backup2},n" +
            "      backup3 = #{backup3}n" +
            "    where in_id = #{inId}")
    Integer updateInformationById(Information information);
}

交流消息管理功能的Model实体层

MODEL层
  • model层,又称:数据访问层
  • 一张表对应一个实体类

这一层的类,我用的是mybatis-plus的maven插件自动生成数据库对应的字段以及表的实体类

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Date;


@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
public class Information implements Serializable {

    private static final long serialVersionUID = 1L;

    
    @TableId(value = "in_id", type = IdType.AUTO)
    private Integer inId;

    
    private String publishUserid;

    
    private String addresseeUserid;

    
    @JsonFormat(pattern = "yyyy-MM-dd hh:mm:ss")
    private Date createTime;

    
    private String content;

    
    private String backup;

    
    private String backup2;

    
    private String backup3;


    
    private User user;


    
    private User user2;

}

7.捐赠支出管理:捐赠支出信息

捐赠支出管理的Controller展现层

CONTROLLER层
  • 控制层,实现对Get和Post的相应
  • 用于前后端交互,service层和前端通过Controller层进行数据交互

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.controller;


import com.user.model.Donate;
import com.user.service.IDonateService;
import com.user.utils.Result;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;


@RestController
@RequestMapping("/donate")
public class DonateController {
    @Autowired
    IDonateService iDonateService;
    //查询所有捐赠支出信息
    @GetMapping("/list")
    public Result getDonateAll(){
        return new Result(true,iDonateService.getDonateAll());
    }
    //根据编号查询捐赠支出信息
    @GetMapping("/getDonateOne/{doId}")
    public Result getDonateOne(@PathVariable String doId){
        return new Result(true,iDonateService.getDonateOne(doId));
    }
    //删除捐赠支出
    @DeleteMapping("{doId}")
    public Result delDonate(@PathVariable String doId){
        String[] sta = doId.split(",");
        for (String id : sta){
            iDonateService.delDonate(id);
        }
        return new Result(true);
    }
    //新增捐赠支出
    @PostMapping("/addDonate")
    public Result addDonate(@RequestBody Donate Donate){
        boolean flag = iDonateService.addDonate(Donate);
        return new Result(flag, flag ? "添加成功^_^" : "添加失败-_-!");
    }
    //根据捐赠支出模糊查询
    @PostMapping("/selectDonateByCriteria")
    public Result selectDonateByCriteria(@RequestBody Donate donate){
        return new Result(true,iDonateService.selectDonateByCriteria(donate));
    }
    //修改捐赠支出
    @PutMapping
    public Result updateDonateById(@RequestBody Donate donate){
        boolean flag = iDonateService.updateDonateById(donate);
        return new Result(flag, flag ? "修改成功^_^" : "修改失败-_-!");
    }
}

捐赠支出管理功能的Service接口层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service;

import com.user.model.Donate;
import com.user.model.Strategy;

import java.util.List;

public interface IDonateService {
    //查询所有捐赠/支出信息
    List getDonateAll();
    //根据编号查询捐赠/支出信息
    Donate getDonateOne(String doId);
    //根据id删除捐赠/支出
    Boolean delDonate(String doId);
    //新增捐赠/支出
    Boolean addDonate(Donate donate);
    //模糊查询捐赠/支出
    List selectDonateByCriteria(Donate donate);
    //根据编号修改捐赠/支出
    Boolean updateDonateById(Donate donate);
}

捐赠支出管理功能的Service接口的Impl实现层

SERVICE层
  • 业务逻辑层,用于完成功能设计
  • 一般用于调用dao层的接口,实现业务功能

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.service.impl;

import com.user.dao.DonateDao;
import com.user.model.Donate;
import com.user.service.IDonateService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Date;
import java.util.List;

@Service
public class DonateServiceImpl implements IDonateService {
    @Autowired
    DonateDao donateDao;

    //查询所有捐赠/支出信息
    @Override
    public List getDonateAll() {
        List Donate = donateDao.getDonateAll();
        return Donate;
    }
    //根据编号查询捐赠/支出信息
    @Override
    public Donate getDonateOne(String doId) {
        return donateDao.getDonateOne(doId);
    }
    //根据id删除捐赠/支出
    @Override
    public Boolean delDonate(String doId) {
        return donateDao.delDonate(doId)>0;
    }
    //新增捐赠/支出
    @Override
    public Boolean addDonate(Donate donate) {
        donate.setCreateTime(new Date());
        donate.setAdminId("1");
        return donateDao.addDonate(donate)>0;
    }
    //模糊查询捐赠/支出
    @Override
    public List selectDonateByCriteria(Donate donate) {
        List sta = donateDao.selectDonateByCriteria(donate);
        return sta;
    }

    //根据编号修改捐赠/支出
    @Override
    public Boolean updateDonateById(Donate donate) {
        return donateDao.updateDonateById(donate)>0;
    }
}

捐赠支出管理功能的Dao数据持久化层

DAO层
  • 数据持久层,用于存放sql语句,在SpringBoot中用注解来为每一个方法注入sql语句
  • 又称为mapper层

这一层请注意,我用的是mybatis的注解sql,并没有在mapper的xml里使用sql语句哦

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.dao;

import com.user.model.Donate;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DonateDao {
    //查询所有捐赠/支出信息
    @Select("select * from donate")
    List getDonateAll();
    //根据编号查询捐赠/支出信息
    @Select("select do_id,personName,`specific`,create_time,admin_id,n" +
            "case behavior when '0' then '捐赠' else '支出' end as behavior,n" +
            "b.sta_id as staId,sta_name,n" +
            "c.userid as cuserId,usernamen" +
            "from donate as a n" +
            "INNER JOIN station as b on a.sta_id = b.sta_idn" +
            "INNER JOIN `user` as c on a.admin_id = c.useridn" +
            " where do_id = #{doId}")
    @ResultMap(value = "DonateMap")
    Donate getDonateOne(String doId);

    //根据id删除捐赠/支出
    @Delete("delete from donate where do_id = #{doId}")
    Integer delDonate(String doId);

    //新增捐赠/支出
    @Insert("insert into donate (sta_id, personName, n" +
            "      behavior, `specific`, create_time, n" +
            "      admin_id, backup, backup2, n" +
            "      backup3)n" +
            "    values ( #{staId}, #{personName}, n" +
            "      #{behavior}, #{specific}, #{createTime}, n" +
            "      #{adminId}, #{backup}, #{backup2}, n" +
            "      #{backup3})")
    Integer addDonate(Donate donate);
    //模糊查询捐赠/支出
    @Select({""})
    @Results(id="DonateMap",value={
            @Result(id=true,column = "do_id",property = "doId"),
            @Result(column = "personName",property = "personName"),
            @Result(column = "specific",property = "specific"),
            @Result(column = "behavior",property = "behavior"),
            @Result(column = "create_time",property = "createTime"),
            @Result(column = "admin_id",property = "adminId"),
            //救助站信息
            @Result(column = "a.sta_id",property = "sta.staId"),
            @Result(column = "sta_name",property = "sta.staName"),
            //用户信息
            @Result(column = "cuserId",property = "user.userid"),
            @Result(column = "fullname",property = "user.fullname")
    })
    List selectDonateByCriteria(Donate donate);
    //根据编号修改捐赠/支出
    @Update(" update donaten" +
            "    set sta_id = #{staId},n" +
            "      personName = #{personName},n" +
            "      behavior = #{behavior},n" +
            "      `specific` = #{specific},n" +
            "      create_time = #{createTime},n" +
            "      admin_id = #{adminId},n" +
            "      backup = #{backup},n" +
            "      backup2 = #{backup2},n" +
            "      backup3 = #{backup3}n" +
            "    where do_id = #{doId}")
    Integer updateDonateById(Donate donate);
}

捐赠支出管理功能的Model实体层

MODEL层
  • model层,又称:数据访问层
  • 一张表对应一个实体类

这一层的类,我用的是mybatis-plus的maven插件自动生成数据库对应的字段以及表的实体类

(以下只是部分代码,详情请去文尾下载完整版)

package com.user.model;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Date;


@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
public class Donate implements Serializable {

    private static final long serialVersionUID = 1L;

    
    @TableId(value = "do_id", type = IdType.AUTO)
    private Integer doId;

    
    private String staId;

    
    @TableField("personName")
    private String personName;

    
    private String behavior;

    
    private String specific;

    
    @JsonFormat(pattern = "yyyy-MM-dd hh:mm:ss")
    private Date createTime;

    
    private String adminId;

    
    private String backup;

    
    private String backup2;

    
    private String backup3;

    
    private Station sta;

    
    private User user;
}

啊,对了还有数据库的sql文件也放在了项目resouce文件夹下了

 数据库表详解

adopt:领养记录表
animal:宠物表
donate:救助站捐赠信息表
information:消息记录表
menu:菜单表
menurole:菜单角色中间表
role:角色表
station:救助站表
strategy:养宠攻略表
user:用户表
userrole:用户角色表

源码+项目部署

 源码地址:

百度云盘链接:https://pan.baidu.com/s/1sdAK_EfqaXJbHS6NTFZaxA 
提取码:zdg3

嗯嗯嗯......终于到了激动人心的时候了,我来帮你搞定一切,帝王般的服务你值得拥有,免费的哟,记得备注下:曹家的小仙女 / 小哥哥,微信:NIKE2022888

最后附上

一寸光阴一寸金,寸金难买寸光阴。请珍惜现在美好的青春,咱们一起努力奋斗,创造美好未来

拜托拜托!!!拜托拜托!!!拜托拜托!!!

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/944494.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号