基于javaweb+mysql的ssm房屋销售管理系统(java+ssm+jsp+jquery+mysql)

基于javaweb+mysql的ssm房屋销售管理系统(java+ssm+jsp+jquery+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的SSM房屋销售管理系统(java+ssm+jsp+jquery+mysql)

项目介绍

本项目包含管理员与买家两种角色；

管理员角色包含以下功能：

管理员登录,房源信息管理,合同信息管理,账户管理,申请看房信息管理等功能。

买家角色包含以下功能：

用户登录,用户登陆,查看房源信息,查看销售信息,查看申请信息,绑定账户等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。

2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;

3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可

4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；

5.是否Maven项目: 否；查看源码目录中是否包含pom.xml；若包含，则为maven项目，否则为非maven项目

6.数据库：MySql 5.7、8.0等版本均可；

技术栈

1. 后端：Spring+springmvc+mybatis

2. 前端：JSP+css+javascript+jQuery

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应sql文件名称的数据库，并导入项目的sql文件；

2. 使用IDEA/Eclipse/MyEclipse导入项目，配置tomcat；

3. 将项目中db.properties配置文件中的数据库配置改为自己的配置;

4. 运行项目，在浏览器中输入地址：http://localhost:8080/text2/

用户账号/密码： user/123456

管理员账号/密码：admin/admin

request.setAttribute("sessce", "修改成功");

request.setAttribute("newhouse", house);

return "houseupdate";

/**

* 删除房源信息

*/

@RequestMapping("/delethouse")

public String delethouse(int houseid, HttpServletRequest request) {

if (houseid >= 0) {

int id = leaseinformationService.queryID(houseid).get(0).getId();

leaseinformationService.deleteByPrimaryKey(houseid);

leaseimgService.deleteByPrimaryKey(id);

leaseinformationService.updateByPrimaryKey(house);

request.setAttribute("sessce", "修改成功");

request.setAttribute("newhouse", house);

return "houseupdate";

/**

* 删除房源信息

*/

@RequestMapping("/delethouse")

public String delethouse(int houseid, HttpServletRequest request) {

if (houseid >= 0) {

int id = leaseinformationService.queryID(houseid).get(0).getId();

leaseinformationService.deleteByPrimaryKey(houseid);

leaseimgService.deleteByPrimaryKey(id);

*/

@RequestMapping("/adminrepairdone")

public String delrepair(Integer id) {

faultService.deleteByPrimaryKey(id);

return "redirect:/admin/Adminselectrepairdone.do";

/**

* 搜索报障

*/

@RequestMapping("/repairselect")

public String repairselect(QueryVo vo, @RequestParam(value = "pn", defaultValue = "1") Integer pn, Model model) {

ModelAndView mav = new ModelAndView("housedel");

System.out.println(checkoutapplicationService.updateState("已拒绝", id));

return mav;

/**

* 分页查找所有用户

*/

@RequestMapping("/pagingselectuser")

public String pagingselectuser(Model model, @RequestParam(value = "pn", defaultValue = "1") Integer pn,

@RequestParam(required = false, defaultValue = "6") Integer pageSize) {

PageHelper.startPage(pn, 10);

List<userlist> userlist = userlistService.selectAll();

*/

@RequestMapping("/houseapply")

public ModelAndView kanfansqing(@RequestParam int pn) {

ModelAndView mav = new ModelAndView("houseapply");

// 设置分页传输

PageHelper.startPage(pn, 10);

// 查询所有数据

List<checkoutapplication> list = checkoutapplicationService.selectCoaState();

// 使用PageInFo封装查询结果

PageInfo<checkoutapplication> pageInfo = new PageInfo<checkoutapplication>(list, 5);

// 放入转发参数

mav.addObject("cs", pageInfo);

return mav;

*/

@RequestMapping("/adminrentselect")

public String rentadd(String housecall, Model model) {

userlist userlist = userlistService.selectUserCallWith(housecall);

model.addAttribute("addrent", userlist);

return "rentadd";

/**

* 添加代缴租金

*/

@RequestMapping("/adminrentadd")

public String rentaddwait(rentcollection rentcollection) {

rentcollectionService.insert(rentcollection);

return "redirect:/admin/adminrentshou.do";

return mav;

/**

* 拒绝退房

*/

@RequestMapping("/refusemvc")

public ModelAndView refusemvc(@RequestParam int id) {

ModelAndView mav = new ModelAndView("housedel");

System.out.println(checkoutapplicationService.updateState("已拒绝", id));

return mav;

/**

* 分页查找所有用户

*/

@RequestMapping("/repairselect")

public String repairselect(QueryVo vo, @RequestParam(value = "pn", defaultValue = "1") Integer pn, Model model) {

// 引用PageHelper分页插件

PageHelper.startPage(pn, 10);

List<fault> faultdone = faultService.repairselect(vo);

for (fault temp : faultdone) {

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

String date = sdf.format(temp.getFdate());

temp.setFdatetemp(date);

* 添加日程

*/

@RequestMapping("/addmydailylife")

public String mydailylifeadd(mydailylife mydailylife) {

mydailylifeService.insert(mydailylife);

return "redirect:/admin/schedulelist.do";

/**

* 修改日程

*/

@RequestMapping("/updatemydailylife")

public String mydailylifeupdate1(Integer id, HttpServletRequest request) {

mydailylife mydailylife = mydailylifeService.selectByPrimaryKey(id);

public ModelAndView stopapplying(String call,String token,HttpServletRequest request,HttpSession session) {

ModelAndView mav = new ModelAndView("personacenter");

//令牌验证

if(!new Koken().kokenid(request, session)) {

return mav;

Warning news = checkoutapplicationService.updateCallState("已取消", call);

System.out.println(news.getWarningContent());

// 放入转发参数

mav.addObject("news", news);

return mav;

* 推荐房屋列表

*/

@RequestMapping("/recommendlist")

public String recommendlist(Model model, @RequestParam(value = "pn", defaultValue = "1") Integer pn,

@RequestParam(required = false, defaultValue = "6") Integer pageSize) {

PageHelper.startPage(pn, 10);

List<leaseinformation> leaseinformation = leaseinformationService.selectAllLeasable();

PageInfo<leaseinformation> p = new PageInfo<leaseinformation>(leaseinformation, 3);

model.addAttribute("p", p);

return "recommendhouse";

/**

request.setAttribute("mydailylife", mydailylife);

return "scheduleupdate";

@RequestMapping("/toupdate")

public String mydailylifeupdate2(mydailylife mydailylife) {

mydailylifeService.updateByPrimaryKey(mydailylife);

return "redirect:/admin/schedulelist.do";

/**

* 删除日程

*/

@RequestMapping("/delmydailylife")

request.setAttribute("mydailylife", mydailylife);

return "scheduleupdate";

@RequestMapping("/toupdate")

public String mydailylifeupdate2(mydailylife mydailylife) {

mydailylifeService.updateByPrimaryKey(mydailylife);

return "redirect:/admin/schedulelist.do";

/**

* 删除日程

*/

@RequestMapping("/delmydailylife")

break;

case "我的申请":

response.getWriter().print("/jsp/personalInformation/myapplication.jsp");

break;

case "代缴租金":

response.getWriter().print("/jsp/personalInformation/rentpayment.jsp");

break;

case "报障模块":

response.getWriter().print("/jsp/personalInformation/faultreportingmodule.jsp");

break;

case "其他操作":

response.getWriter().print("/jsp/personalInformation/otheroperations.jsp");

mav.addObject("cs", pageInfo);

return mav;

@RequestMapping("/delectcontract")

public ModelAndView delectcontract(@RequestParam int id) {

ModelAndView mav = new ModelAndView("rentinglist");

leaseinformationService.updacontract(id);

return mav;

/**

* 看房申请列表

*/

@RequestMapping("/houseapply")

public ModelAndView kanfansqing(@RequestParam int pn) {

ModelAndView mav = new ModelAndView("houseapply");

num += Float.parseFloat(temp.getRchousemoney());

return Msg.success().add("num", num);

/**

* 报障分页查询

*/

@RequestMapping("/repairList")

@ResponseBody

public Msg repairList(@RequestParam(value = "pn") Integer pn, String str, HttpSession session) {

// 使用PageInFo封装查询结果

userlist user = userlistService.selectUserCall((String) session.getAttribute("user"));

// 设置分页传输

PageHelper.startPage(pn, 8);

if (str.equals("我要报障")) {

*/

@RequestMapping("/pagingselecthouse")

public String pagingselecthouse(Model model, @RequestParam(value = "pn", defaultValue = "1") Integer pn,

@RequestParam(required = false, defaultValue = "6") Integer pageSize) {

PageHelper.startPage(pn, 10);

List<leaseinformation> leaseinformation = leaseinformationService.queryAll();

PageInfo<leaseinformation> p = new PageInfo<leaseinformation>(leaseinformation, 3);

model.addAttribute("p", p);

return "housinglist";

/**

* 获取修改房源信息

*/

fault.setFhouseid(housecall);

fault.setFhouseaddress(user.getLeaseinformation().getHouseaddress());

fault.setFprice(Double.parseDouble(user.getLeaseinformation().getHousemoney()));

SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");

Date t1 = sdf.parse(date);

fault.setFdate(t1);

fault.setFdatetemp(date);

fault.setFcontent(contentofthe);

fault.setFusername(user.getUsername());

fault.setFuserid(user.getUserid());

fault.setFuserphone(user.getUserphone());

fault.setFstate("未处理");