springboot基于Android平台的校园论坛系统源码

APP需求分析

作为一款APP的校园论坛系统，面向的是大多数学者，软件的界面设计简洁清晰，用户可轻松掌握使用技巧。在调查之后，获得用户以下需求：

（1）用户注册登录后，可进入系统解锁更多功能，用户将信息加入到后台数据库。

（2）用户不仅可以查看广场、失物招领、二手闲置、跑腿代取、学习分享，而且还可以自行搜索二手闲置或者收藏等。

（3）管理员具有权限，对用户、失物招领、二手闲置、跑腿代取进行添加、修改、删除等[11]。

（4）可以点击信息详情页进行查看。

（5）管理员在系统管理发布系统简介、轮播图、校园头条等信息。

校园论坛系统设计的目的是为用户提供失物招领、二手闲置、跑腿代取、学习分享等方面的平台。

与PC端应用程序相比，校园论坛系统的设计主要面向于用户，旨在为管理员和用户提供一个APP的校园论坛系统。用户可以通过APP及时查看二手闲置、跑腿代取、学习分享等。

校园论坛系统是在安卓操作系统下的应用平台。为防止出现兼容性及稳定性问题，编辑器选择的是Hbuildex，安卓APP与后台服务端之间的数据存储主要通过MySQL。用户在使用应用时产生的数据通过 java等语言传递给数据库。通过此方式促进校园论坛系统信息流动和数据传输效率，提供一个内容丰富、功能多样、易于操作的APP校园论坛系统。

关键词：校园论坛系统；java语言；MySQL数据库

springboot基于Android平台的校园论坛系统源码和答辩PPT论文020

演示视频：

springboot基于Android平台的校园论坛系统源码和答辩PPT论文

Abstract

The purpose of designing the campus forum system is to provide users with a platform for lost and found, second-hand idle, errand pick-up, learning and sharing, and other aspects.

Compared to PC applications, the design of the campus forum system is mainly aimed at users, aiming to provide an APP campus forum system for administrators and users. Users can timely view second-hand idle, errand pick-up, learning sharing, and more through the app.

The campus forum system is an application platform under the Android operating system. To prevent compatibility and stability issues, the editor selects Hbuildex, and the data storage between the Android app and the backend server is mainly through MySQL. The data generated by users when using the application is transmitted to the database through languages such as Java. In this way, we can promote the information flow and data transmission efficiency of the campus forum system, and provide an APP campus forum system with rich content, diverse functions and easy operation.

Keywords: Campus forum system; Java language; MySQL database

package com.controller;

import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;

import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
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.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;

import com.entity.ErshouxianzhiEntity;
import com.entity.view.ErshouxianzhiView;

import com.service.ErshouxianzhiService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.IOException;
import com.service.StoreupService;
import com.entity.StoreupEntity;

/**
 * 二手闲置
 * 后端接口
 * @author 
 * @email 
 * @date 2023-04-03 17:44:37
 */
@RestController
@RequestMapping("/ershouxianzhi")
public class ErshouxianzhiController {
    @Autowired
    private ErshouxianzhiService ershouxianzhiService;

    @Autowired
    private StoreupService storeupService;

    


    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,ErshouxianzhiEntity ershouxianzhi,
		HttpServletRequest request){
		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("yonghu")) {
			ershouxianzhi.setZhanghao((String)request.getSession().getAttribute("username"));
		}
        EntityWrapper<ErshouxianzhiEntity> ew = new EntityWrapper<ErshouxianzhiEntity>();

		PageUtils page = ershouxianzhiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, ershouxianzhi), params), params));

        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
	@IgnoreAuth
    @RequestMapping("/list")
    public R list(@RequestParam Map<String, Object> params,ErshouxianzhiEntity ershouxianzhi, 
		HttpServletRequest request){
        EntityWrapper<ErshouxianzhiEntity> ew = new EntityWrapper<ErshouxianzhiEntity>();

		PageUtils page = ershouxianzhiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, ershouxianzhi), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/lists")
    public R list( ErshouxianzhiEntity ershouxianzhi){
       	EntityWrapper<ErshouxianzhiEntity> ew = new EntityWrapper<ErshouxianzhiEntity>();
      	ew.allEq(MPUtil.allEQMapPre( ershouxianzhi, "ershouxianzhi")); 
        return R.ok().put("data", ershouxianzhiService.selectListView(ew));
    }

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(ErshouxianzhiEntity ershouxianzhi){
        EntityWrapper< ErshouxianzhiEntity> ew = new EntityWrapper< ErshouxianzhiEntity>();
 		ew.allEq(MPUtil.allEQMapPre( ershouxianzhi, "ershouxianzhi")); 
		ErshouxianzhiView ershouxianzhiView =  ershouxianzhiService.selectView(ew);
		return R.ok("查询二手闲置成功").put("data", ershouxianzhiView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        ErshouxianzhiEntity ershouxianzhi = ershouxianzhiService.selectById(id);
		ershouxianzhi.setClicknum(ershouxianzhi.getClicknum()+1);
		ershouxianzhi.setClicktime(new Date());
		ershouxianzhiService.updateById(ershouxianzhi);
        return R.ok().put("data", ershouxianzhi);
    }

    /**
     * 前端详情
     */
	@IgnoreAuth
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        ErshouxianzhiEntity ershouxianzhi = ershouxianzhiService.selectById(id);
		ershouxianzhi.setClicknum(ershouxianzhi.getClicknum()+1);
		ershouxianzhi.setClicktime(new Date());
		ershouxianzhiService.updateById(ershouxianzhi);
        return R.ok().put("data", ershouxianzhi);
    }
    



    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody ErshouxianzhiEntity ershouxianzhi, HttpServletRequest request){
    	ershouxianzhi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(ershouxianzhi);
        ershouxianzhiService.insert(ershouxianzhi);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
	@IgnoreAuth
    @RequestMapping("/add")
    public R add(@RequestBody ErshouxianzhiEntity ershouxianzhi, HttpServletRequest request){
    	ershouxianzhi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(ershouxianzhi);
        ershouxianzhiService.insert(ershouxianzhi);
        return R.ok();
    }



    /**
     * 修改
     */
    @RequestMapping("/update")
    @Transactional
    public R update(@RequestBody ErshouxianzhiEntity ershouxianzhi, HttpServletRequest request){
        //ValidatorUtils.validateEntity(ershouxianzhi);
        ershouxianzhiService.updateById(ershouxianzhi);//全部更新
        return R.ok();
    }


    

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        ershouxianzhiService.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<String, Object> 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<ErshouxianzhiEntity> wrapper = new EntityWrapper<ErshouxianzhiEntity>();
		if(map.get("remindstart")!=null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")!=null) {
			wrapper.le(columnName, map.get("remindend"));
		}

		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("yonghu")) {
			wrapper.eq("zhanghao", (String)request.getSession().getAttribute("username"));
		}

		int count = ershouxianzhiService.selectCount(wrapper);
		return R.ok().put("count", count);
	}
	
	/**
     * 前端智能排序
     */
	@IgnoreAuth
    @RequestMapping("/autoSort")
    public R autoSort(@RequestParam Map<String, Object> params,ErshouxianzhiEntity ershouxianzhi, HttpServletRequest request,String pre){
        EntityWrapper<ErshouxianzhiEntity> ew = new EntityWrapper<ErshouxianzhiEntity>();
        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 = ershouxianzhiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, ershouxianzhi), params), params));
        return R.ok().put("data", page);
    }









}

package com.controller;


import java.util.Arrays;
import java.util.Calendar;
import java.util.Date;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
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.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.TokenEntity;
import com.entity.UsersEntity;
import com.service.TokenService;
import com.service.UsersService;
import com.utils.CommonUtil;
import com.utils.MPUtil;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.ValidatorUtils;

/**
 * 登录相关
 */
@RequestMapping("users")
@RestController
public class UsersController{
	
	@Autowired
	private UsersService userService;
	
	@Autowired
	private TokenService tokenService;

	/**
	 * 登录
	 */
	@IgnoreAuth
	@RequestMapping(value = "/login")
	public R login(String username, String password, String captcha, HttpServletRequest request) {
		UsersEntity user = userService.selectOne(new EntityWrapper<UsersEntity>().eq("username", username));
		if(user==null || !user.getPassword().equals(password)) {
			return R.error("账号或密码不正确");
		}
		String token = tokenService.generateToken(user.getId(),username, "users", user.getRole());
		return R.ok().put("token", token);
	}
	
	/**
	 * 注册
	 */
	@IgnoreAuth
	@PostMapping(value = "/register")
	public R register(@RequestBody UsersEntity user){
//    	ValidatorUtils.validateEntity(user);
    	if(userService.selectOne(new EntityWrapper<UsersEntity>().eq("username", user.getUsername())) !=null) {
    		return R.error("用户已存在");
    	}
        userService.insert(user);
        return R.ok();
    }

	/**
	 * 退出
	 */
	@GetMapping(value = "logout")
	public R logout(HttpServletRequest request) {
		request.getSession().invalidate();
		return R.ok("退出成功");
	}
	
	/**
     * 密码重置
     */
    @IgnoreAuth
	@RequestMapping(value = "/resetPass")
    public R resetPass(String username, HttpServletRequest request){
    	UsersEntity user = userService.selectOne(new EntityWrapper<UsersEntity>().eq("username", username));
    	if(user==null) {
    		return R.error("账号不存在");
    	}
    	user.setPassword("123456");
        userService.update(user,null);
        return R.ok("密码已重置为：123456");
    }
	
	/**
     * 列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,UsersEntity user){
        EntityWrapper<UsersEntity> ew = new EntityWrapper<UsersEntity>();
    	PageUtils page = userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/list")
    public R list( UsersEntity user){
       	EntityWrapper<UsersEntity> ew = new EntityWrapper<UsersEntity>();
      	ew.allEq(MPUtil.allEQMapPre( user, "user")); 
        return R.ok().put("data", userService.selectListView(ew));
    }

    /**
     * 信息
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") String id){
        UsersEntity user = userService.selectById(id);
        return R.ok().put("data", user);
    }
    
    /**
     * 获取用户的session用户信息
     */
    @RequestMapping("/session")
    public R getCurrUser(HttpServletRequest request){
    	Long id = (Long)request.getSession().getAttribute("userId");
        UsersEntity user = userService.selectById(id);
        return R.ok().put("data", user);
    }

    /**
     * 保存
     */
    @PostMapping("/save")
    public R save(@RequestBody UsersEntity user){
//    	ValidatorUtils.validateEntity(user);
    	if(userService.selectOne(new EntityWrapper<UsersEntity>().eq("username", user.getUsername())) !=null) {
    		return R.error("用户已存在");
    	}
        userService.insert(user);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody UsersEntity user){
//        ValidatorUtils.validateEntity(user);
    	UsersEntity u = userService.selectOne(new EntityWrapper<UsersEntity>().eq("username", user.getUsername()));
    	if(u!=null && u.getId()!=user.getId() && u.getUsername().equals(user.getUsername())) {
    		return R.error("用户名已存在。");
    	}
        userService.updateById(user);//全部更新
        return R.ok();
    }

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        userService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
}