基于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等版本均可;
技术栈
-
后端:Spring+springmvc+mybatis
-
前端:JSP+css+javascript+jQuery
使用说明
-
使用Navicat或者其它工具,在mysql中创建对应sql文件名称的数据库,并导入项目的sql文件;
-
使用IDEA/Eclipse/MyEclipse导入项目,配置tomcat;
-
将项目中db.properties配置文件中的数据库配置改为自己的配置;
-
运行项目,在浏览器中输入地址:http://localhost:8080/text2/
用户账号/密码: user/123456
管理员账号/密码:admin/admin
*/
@RequestMapping("/adminrentshou")
public String rentshou(@RequestParam(value = "pn", defaultValue = "1") Integer pn, Model model) {
// 引用PageHelper分页插件
PageHelper.startPage(pn, 10);
List<userlist> userlists = userlistService.rentSelectAll();
PageInfo<userlist> page = new PageInfo<userlist>(userlists, 3);
model.addAttribute("rent", page);
return "rentshou";
/**
* 获取收租信息
*/
* 注销
*/
@RequestMapping("/admincancel")
public String cancellation(HttpServletRequest request) {
HttpSession session = request.getSession();
session.removeAttribute("admin");
System.out.println("注销成功");
return "official";
@RequestMapping("/details")
public ModelAndView listCategory(@RequestParam int pn) {
ModelAndView mav = new ModelAndView("rentingdel");
@ResponseBody
public Msg rentpaymentList(@RequestParam(value = "pn") Integer pn, String state, HttpSession session) {
userlist user = userlistService.selectUserCall((String) session.getAttribute("user"));
// 设置分页传输
PageHelper.startPage(pn, 8);
List<rentcollection> list = rentcollectionService.queryPaidStateAll(state, user.getUsername());
// 使用PageInFo封装查询结果
PageInfo<rentcollection> pageInfo = new PageInfo<rentcollection>(list, 3);
return Msg.success().add("pageInfo", pageInfo);
/**
* 缴纳租金
session.setAttribute("headportraitimg", headportraitimg.getHeadportraitimgaddress());
// 上传文件
file.transferTo(f);
userlist user = userlistService.selectUserCall((String) session.getAttribute("user"));
//暂时储存需要修改的真实姓名
String rcusernametemp=user.getUsername();
//判断,如有真实姓名联表修改,则添加
if(user.getUsername()==null||"".equals(user.getUsername())) {
// 上传真实姓名,身份证,手机号
userlist userlist = new userlist();
userlist.setUsercall((String) session.getAttribute("user"));
userlist.setUsername(username);
userlist.setUserid(userid);
return Msg.success().add("pageInfo", pageInfo);
/**
* 申请状态记录分页查询
*/
@RequestMapping("/applicationAtatusList")
@ResponseBody
public Msg applicationAtatusList(@RequestParam(value = "pn") Integer pn, boolean flag, HttpSession session) {
List<checkoutapplication> list = null;
userlist user = userlistService.selectUserCall((String) session.getAttribute("user"));
// 设置分页传输
* 删除房源信息
*/
@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);
return "redirect:pagingselecthouse.do";
/*
request.setAttribute("sessce", "添加成功");
return "housingadd";
/**
* 分页展示房源信息
*/
@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);
PageInfo<leaseinformation> p = new PageInfo<leaseinformation>(leaseinformation, 3);
model.addAttribute("p", p);
return "recommendhouse";
/**
* 修改推荐信息
*/
@RequestMapping("/updaterecommend")
public String updatehouse(Integer houseid) {
leaseinformation house = leaseinformationService.queryID(houseid).get(0);
if (house.getHouserecommend().equals("未推荐")) {
house.setHouserecommend("已推荐");
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";
/**
* 代缴租金
if (usere==null) {
session.setAttribute("modifyerro",null);
System.out.println("可修改");
}else {
Warning news=new Warning(2, "修改失败!该姓名用户已注册");
mav.addObject("news", news);
return mav;
//令牌验证
if(!new Koken().kokenid(request, session)) {
return mav;
// 获取文件的名称
String fName = file.getOriginalFilename();
mav.addObject("news", news);
return mav;
/**
* 终止申请
*/
@RequestMapping("/stopapplying")
public ModelAndView stopapplying(String call,String token,HttpServletRequest request,HttpSession session) {
ModelAndView mav = new ModelAndView("personacenter");
//令牌验证
if(!new Koken().kokenid(request, session)) {
/**
* 删除退房记录
*/
@RequestMapping("/delecttzsq")
public ModelAndView delecttzsq(@RequestParam int id) {
ModelAndView mav = new ModelAndView("housedel");
checkoutapplicationService.deleteByPrimaryKey(id);
return mav;
/**
* 同意退房
*/
@RequestMapping("/checkoutmvc")
public ModelAndView checkoutmvc(@RequestParam int id,String housecall) {
house.setHouserecommend("已推荐");
} else {
house.setHouserecommend("未推荐");
leaseinformationService.updateByPrimaryKey(house);
return "redirect:recommendlist.do?";
/**
* 分页查询日程信息
*/
@RequestMapping("/schedulelist")
public String mydailylifelist(@RequestParam(value = "pn", defaultValue = "1") Integer pn, Model model) {
// 引用PageHelper分页插件
PageHelper.startPage(pn, 10);
List<mydailylife> mydailylifes = mydailylifeService.selectAll();
case "其他操作":
response.getWriter().print("/jsp/personalInformation/otheroperations.jsp");
break;
/**
* 我的租赁分页查询
*/
@RequestMapping("/myRentalList")
@ResponseBody
public Msg myRentalList(@RequestParam(value = "pn") Integer pn, HttpSession session) {
// 查询所有数据
userlist user = userlistService.selectUserCall((String) session.getAttribute("user"));
return "housingadd";
/**
* 分页展示房源信息
*/
@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";
/**
* 获取修改房源信息
*/
@RequestMapping("/getupdatehouse")
public String getupdatehouse(int houseid, HttpServletRequest request) {
List<leaseinformation> house = leaseinformationService.queryID(houseid);
request.setAttribute("uphouse", house);
return "houseupdate";
/**
* 修改房源信息
*/
@RequestMapping("/updatehouse")
@RequestMapping("/myRentalList")
@ResponseBody
public Msg myRentalList(@RequestParam(value = "pn") Integer pn, HttpSession session) {
// 查询所有数据
userlist user = userlistService.selectUserCall((String) session.getAttribute("user"));
// 设置分页传输
PageHelper.startPage(pn, 8);
List<userlist> leaseuser = userlistService.selectUserNameWith(user.getUsername());
// 使用PageInFo封装查询结果
PageInfo<userlist> pageInfo = new PageInfo<userlist>(leaseuser, 3);
return Msg.success().add("pageInfo", pageInfo);
/**
* 已退租赁记录分页查询
if (houseid >= 0) {
int id = leaseinformationService.queryID(houseid).get(0).getId();
leaseinformationService.deleteByPrimaryKey(houseid);
leaseimgService.deleteByPrimaryKey(id);
return "redirect:pagingselecthouse.do";
/*
* 推荐房屋列表
*/
@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();