ssm公廉租房维保系统源码和论文ssm704
开发工具：idea 数据库mysql5.7+
数据库链接工具：navcat,小海豚等
环境： jdk8 tomcat8.5
开发技术 ssm vue vue.js
摘 要
本毕业设计的内容是设计并且实现一个基于java技术的公廉租房维保系统。它是在Windows下，以MYSQL为数据库开发平台，java技术和Tomcat网络信息服务作为应用服务器。公廉租房维保系统的功能已基本实现，主要实现首页、个人中心、业主管理、维修单位管理、房屋信息管理、维修申报单管理、维修完成管理、房屋维护管理等功能的操作系统。
论文主要从系统的分析与设计、数据库设计和系统的详细设计等几个方面来进行论述，系统分析与设计部分主要论述了系统的功能分析、系统的设计思路，数据库设计主要论述了数据库的设计，系统的详细设计部分主要论述了几个主要模块的详细设计过程。
关键字:公廉租房维保；java技术；MYSQL；Tomcat
演示视频:
ssm公廉租房维保系统源码和论文
Abstract
The content of this graduation project is to design and implement a public rental housing maintenance system based on java technology. It is under Windows, with MYSQL as the database development platform, Java technology and Tomcat network information service as the application server. Public rental house maintenance system functions have been basically realized, mainly realize home page, personal center, owner management, maintenance unit management, housing information management, maintenance declaration management, maintenance management, housing maintenance management and other functions of the operating system.
Thesis mainly from the system analysis and design, database design and system detailed design and so on several aspects to this paper, system analysis and design part mainly discussed the system function analysis, system design, database design, this paper mainly discusses the database design, system detailed design part mainly discusses the several main modules of the detailed design process.
Key words: public low-rent house maintenance; Java technology; MYSQL;
package com.controller;
import java.text.SimpleDateFormat;
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 java.io.IOException;
import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
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.WeixiudanweiEntity;
import com.entity.view.WeixiudanweiView;
import com.service.WeixiudanweiService;
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.InputStream;
import org.springframework.web.multipart.MultipartFile;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
/**
* 维修单位
* 后端接口
* @author
* @email
* @date 2022-04-01 12:20:42
*/
@RestController
@RequestMapping("/weixiudanwei")
public class WeixiudanweiController {
@Autowired
private WeixiudanweiService weixiudanweiService;
@Autowired
private TokenService tokenService;
/**
* 登录
*/
@IgnoreAuth
@RequestMapping(value = "/login")
public R login(String username, String password, String captcha, HttpServletRequest request) {
WeixiudanweiEntity user = weixiudanweiService.selectOne(new EntityWrapper<WeixiudanweiEntity>().eq("weixiugonghao", username));
if(user==null || !user.getMima().equals(password)) {
return R.error("账号或密码不正确");
}
String token = tokenService.generateToken(user.getId(), username,"weixiudanwei", "维修单位" );
return R.ok().put("token", token);
}
/**
* 注册
*/
@IgnoreAuth
@RequestMapping("/register")
public R register(@RequestBody WeixiudanweiEntity weixiudanwei){
//ValidatorUtils.validateEntity(weixiudanwei);
WeixiudanweiEntity user = weixiudanweiService.selectOne(new EntityWrapper<WeixiudanweiEntity>().eq("weixiugonghao", weixiudanwei.getWeixiugonghao()));
if(user!=null) {
return R.error("注册用户已存在");
}
Long uId = new Date().getTime();
weixiudanwei.setId(uId);
weixiudanweiService.insert(weixiudanwei);
return R.ok();
}
/**
* 退出
*/
@RequestMapping("/logout")
public R logout(HttpServletRequest request) {
request.getSession().invalidate();
return R.ok("退出成功");
}
/**
* 获取用户的session用户信息
*/
@RequestMapping("/session")
public R getCurrUser(HttpServletRequest request){
Long id = (Long)request.getSession().getAttribute("userId");
WeixiudanweiEntity user = weixiudanweiService.selectById(id);
return R.ok().put("data", user);
}
/**
* 密码重置
*/
@IgnoreAuth
@RequestMapping(value = "/resetPass")
public R resetPass(String username, HttpServletRequest request){
WeixiudanweiEntity user = weixiudanweiService.selectOne(new EntityWrapper<WeixiudanweiEntity>().eq("weixiugonghao", username));
if(user==null) {
return R.error("账号不存在");
}
user.setMima("123456");
weixiudanweiService.updateById(user);
return R.ok("密码已重置为：123456");
}
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,WeixiudanweiEntity weixiudanwei,
HttpServletRequest request){
EntityWrapper<WeixiudanweiEntity> ew = new EntityWrapper<WeixiudanweiEntity>();
PageUtils page = weixiudanweiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, weixiudanwei), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,WeixiudanweiEntity weixiudanwei,
HttpServletRequest request){
EntityWrapper<WeixiudanweiEntity> ew = new EntityWrapper<WeixiudanweiEntity>();
PageUtils page = weixiudanweiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, weixiudanwei), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( WeixiudanweiEntity weixiudanwei){
EntityWrapper<WeixiudanweiEntity> ew = new EntityWrapper<WeixiudanweiEntity>();
ew.allEq(MPUtil.allEQMapPre( weixiudanwei, "weixiudanwei"));
return R.ok().put("data", weixiudanweiService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(WeixiudanweiEntity weixiudanwei){
EntityWrapper< WeixiudanweiEntity> ew = new EntityWrapper< WeixiudanweiEntity>();
ew.allEq(MPUtil.allEQMapPre( weixiudanwei, "weixiudanwei"));
WeixiudanweiView weixiudanweiView = weixiudanweiService.selectView(ew);
return R.ok("查询维修单位成功").put("data", weixiudanweiView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
WeixiudanweiEntity weixiudanwei = weixiudanweiService.selectById(id);
return R.ok().put("data", weixiudanwei);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
WeixiudanweiEntity weixiudanwei = weixiudanweiService.selectById(id);
return R.ok().put("data", weixiudanwei);
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody WeixiudanweiEntity weixiudanwei, HttpServletRequest request){
weixiudanwei.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(weixiudanwei);
WeixiudanweiEntity user = weixiudanweiService.selectOne(new EntityWrapper<WeixiudanweiEntity>().eq("weixiugonghao", weixiudanwei.getWeixiugonghao()));
if(user!=null) {
return R.error("用户已存在");
}
weixiudanwei.setId(new Date().getTime());
weixiudanweiService.insert(weixiudanwei);
return R.ok();
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody WeixiudanweiEntity weixiudanwei, HttpServletRequest request){
weixiudanwei.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(weixiudanwei);
WeixiudanweiEntity user = weixiudanweiService.selectOne(new EntityWrapper<WeixiudanweiEntity>().eq("weixiugonghao", weixiudanwei.getWeixiugonghao()));
if(user!=null) {
return R.error("用户已存在");
}
weixiudanwei.setId(new Date().getTime());
weixiudanweiService.insert(weixiudanwei);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
public R update(@RequestBody WeixiudanweiEntity weixiudanwei, HttpServletRequest request){
//ValidatorUtils.validateEntity(weixiudanwei);
weixiudanweiService.updateById(weixiudanwei);//全部更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
weixiudanweiService.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<WeixiudanweiEntity> wrapper = new EntityWrapper<WeixiudanweiEntity>();
if(map.get("remindstart")!=null) {
wrapper.ge(columnName, map.get("remindstart"));
}
if(map.get("remindend")!=null) {
wrapper.le(columnName, map.get("remindend"));
}
int count = weixiudanweiService.selectCount(wrapper);
return R.ok().put("count", count);
}
@RequestMapping("/importExcel")
public R importExcel(@RequestParam("file") MultipartFile file){
try {
//获取输入流
InputStream inputStream = file.getInputStream();
//创建读取工作簿
Workbook workbook = WorkbookFactory.create(inputStream);
//获取工作表
Sheet sheet = workbook.getSheetAt(0);
//获取总行
int rows=sheet.getPhysicalNumberOfRows();
if(rows>1){
//获取单元格
for (int i = 1; i < rows; i++) {
Row row = sheet.getRow(i);
WeixiudanweiEntity weixiudanweiEntity =new WeixiudanweiEntity();
weixiudanweiEntity.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
String weixiugonghao = CommonUtil.getCellValue(row.getCell(0));
weixiudanweiEntity.setWeixiugonghao(weixiugonghao);
String mima = CommonUtil.getCellValue(row.getCell(1));
weixiudanweiEntity.setMima(mima);
String shifuxingming = CommonUtil.getCellValue(row.getCell(2));
weixiudanweiEntity.setShifuxingming(shifuxingming);
String xingbie = CommonUtil.getCellValue(row.getCell(3));
weixiudanweiEntity.setXingbie(xingbie);
String nianling = CommonUtil.getCellValue(row.getCell(4));
weixiudanweiEntity.setNianling(nianling);
String shifushouji = CommonUtil.getCellValue(row.getCell(5));
weixiudanweiEntity.setShifushouji(shifushouji);
//想数据库中添加新对象
weixiudanweiService.insert(weixiudanweiEntity);//方法
}
}
inputStream.close();
} catch (InvalidFormatException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return R.ok("导入成功");
}
}
package com.controller;
import java.text.SimpleDateFormat;
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 java.io.IOException;
import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
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.YezhuEntity;
import com.entity.view.YezhuView;
import com.service.YezhuService;
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.InputStream;
import org.springframework.web.multipart.MultipartFile;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
/**
* 业主
* 后端接口
* @author
* @email
* @date 2022-04-01 12:20:42
*/
@RestController
@RequestMapping("/yezhu")
public class YezhuController {
@Autowired
private YezhuService yezhuService;
@Autowired
private TokenService tokenService;
/**
* 登录
*/
@IgnoreAuth
@RequestMapping(value = "/login")
public R login(String username, String password, String captcha, HttpServletRequest request) {
YezhuEntity user = yezhuService.selectOne(new EntityWrapper<YezhuEntity>().eq("yezhuhao", username));
if(user==null || !user.getMima().equals(password)) {
return R.error("账号或密码不正确");
}
String token = tokenService.generateToken(user.getId(), username,"yezhu", "业主" );
return R.ok().put("token", token);
}
/**
* 注册
*/
@IgnoreAuth
@RequestMapping("/register")
public R register(@RequestBody YezhuEntity yezhu){
//ValidatorUtils.validateEntity(yezhu);
YezhuEntity user = yezhuService.selectOne(new EntityWrapper<YezhuEntity>().eq("yezhuhao", yezhu.getYezhuhao()));
if(user!=null) {
return R.error("注册用户已存在");
}
Long uId = new Date().getTime();
yezhu.setId(uId);
yezhuService.insert(yezhu);
return R.ok();
}
/**
* 退出
*/
@RequestMapping("/logout")
public R logout(HttpServletRequest request) {
request.getSession().invalidate();
return R.ok("退出成功");
}
/**
* 获取用户的session用户信息
*/
@RequestMapping("/session")
public R getCurrUser(HttpServletRequest request){
Long id = (Long)request.getSession().getAttribute("userId");
YezhuEntity user = yezhuService.selectById(id);
return R.ok().put("data", user);
}
/**
* 密码重置
*/
@IgnoreAuth
@RequestMapping(value = "/resetPass")
public R resetPass(String username, HttpServletRequest request){
YezhuEntity user = yezhuService.selectOne(new EntityWrapper<YezhuEntity>().eq("yezhuhao", username));
if(user==null) {
return R.error("账号不存在");
}
user.setMima("123456");
yezhuService.updateById(user);
return R.ok("密码已重置为：123456");
}
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,YezhuEntity yezhu,
HttpServletRequest request){
EntityWrapper<YezhuEntity> ew = new EntityWrapper<YezhuEntity>();
PageUtils page = yezhuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, yezhu), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,YezhuEntity yezhu,
HttpServletRequest request){
EntityWrapper<YezhuEntity> ew = new EntityWrapper<YezhuEntity>();
PageUtils page = yezhuService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, yezhu), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( YezhuEntity yezhu){
EntityWrapper<YezhuEntity> ew = new EntityWrapper<YezhuEntity>();
ew.allEq(MPUtil.allEQMapPre( yezhu, "yezhu"));
return R.ok().put("data", yezhuService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(YezhuEntity yezhu){
EntityWrapper< YezhuEntity> ew = new EntityWrapper< YezhuEntity>();
ew.allEq(MPUtil.allEQMapPre( yezhu, "yezhu"));
YezhuView yezhuView = yezhuService.selectView(ew);
return R.ok("查询业主成功").put("data", yezhuView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
YezhuEntity yezhu = yezhuService.selectById(id);
return R.ok().put("data", yezhu);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
YezhuEntity yezhu = yezhuService.selectById(id);
return R.ok().put("data", yezhu);
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody YezhuEntity yezhu, HttpServletRequest request){
yezhu.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(yezhu);
YezhuEntity user = yezhuService.selectOne(new EntityWrapper<YezhuEntity>().eq("yezhuhao", yezhu.getYezhuhao()));
if(user!=null) {
return R.error("用户已存在");
}
yezhu.setId(new Date().getTime());
yezhuService.insert(yezhu);
return R.ok();
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody YezhuEntity yezhu, HttpServletRequest request){
yezhu.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(yezhu);
YezhuEntity user = yezhuService.selectOne(new EntityWrapper<YezhuEntity>().eq("yezhuhao", yezhu.getYezhuhao()));
if(user!=null) {
return R.error("用户已存在");
}
yezhu.setId(new Date().getTime());
yezhuService.insert(yezhu);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
public R update(@RequestBody YezhuEntity yezhu, HttpServletRequest request){
//ValidatorUtils.validateEntity(yezhu);
yezhuService.updateById(yezhu);//全部更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
yezhuService.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<YezhuEntity> wrapper = new EntityWrapper<YezhuEntity>();
if(map.get("remindstart")!=null) {
wrapper.ge(columnName, map.get("remindstart"));
}
if(map.get("remindend")!=null) {
wrapper.le(columnName, map.get("remindend"));
}
int count = yezhuService.selectCount(wrapper);
return R.ok().put("count", count);
}
@RequestMapping("/importExcel")
public R importExcel(@RequestParam("file") MultipartFile file){
try {
//获取输入流
InputStream inputStream = file.getInputStream();
//创建读取工作簿
Workbook workbook = WorkbookFactory.create(inputStream);
//获取工作表
Sheet sheet = workbook.getSheetAt(0);
//获取总行
int rows=sheet.getPhysicalNumberOfRows();
if(rows>1){
//获取单元格
for (int i = 1; i < rows; i++) {
Row row = sheet.getRow(i);
YezhuEntity yezhuEntity =new YezhuEntity();
yezhuEntity.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
String yezhuhao = CommonUtil.getCellValue(row.getCell(0));
yezhuEntity.setYezhuhao(yezhuhao);
String mima = CommonUtil.getCellValue(row.getCell(1));
yezhuEntity.setMima(mima);
String yezhuxingming = CommonUtil.getCellValue(row.getCell(2));
yezhuEntity.setYezhuxingming(yezhuxingming);
String xingbie = CommonUtil.getCellValue(row.getCell(3));
yezhuEntity.setXingbie(xingbie);
String yezhushouji = CommonUtil.getCellValue(row.getCell(4));
yezhuEntity.setYezhushouji(yezhushouji);
String shenfenzheng = CommonUtil.getCellValue(row.getCell(5));
yezhuEntity.setShenfenzheng(shenfenzheng);
String loufanghao = CommonUtil.getCellValue(row.getCell(6));
yezhuEntity.setLoufanghao(loufanghao);
String chepaihao = CommonUtil.getCellValue(row.getCell(7));
yezhuEntity.setChepaihao(chepaihao);
//想数据库中添加新对象
yezhuService.insert(yezhuEntity);//方法
}
}
inputStream.close();
} catch (InvalidFormatException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
return R.ok("导入成功");
}
}
扫一扫
1287
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
