基于javaweb+mysql的ssm+maven房产中介管理系统(java+ssm+html+bootstrap+layui+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven房产中介管理系统(java+ssm+html+bootstrap+layui+mysql)
项目介绍
本项目为后台管理系统;
管理员角色包含以下功能: 管理员登录,用户管理,通知公告管理,卖家信息管理,买家信息管理,添加房屋,房屋管理,房屋搜索,修改个人信息,修改密码等功能。 管理员账号/密码:admin/admin
环境需要
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.数据库:MySql 5.7版本; 6.是否Maven项目: 是;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
技术栈
- 后端:Spring SpringMVC MyBatis 2. 前端:HTML+CSS+Javascript+jQuery+bootstrap+layui
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中db.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/ 登录 管理员账号/密码:admin/admin
//更新密码
int count = sysUserService.updatePassword(getUserId(), password, newPassword);
if (count == 0) {
return R.error("原密码不正确");
}
//退出
ShiroUtils.logout();
return R.ok();
}
@RequestMapping("/updateInfo")
public R updateInfo(@RequestBody SysUserEntity user) {
this.sysUserService.update(user);
return R.ok();
}
/**
* 用户信息
*/
@RequestMapping("/info/{userId}")
public R info(@PathVariable("userId") Long userId) {
SysUserEntity user = sysUserService.queryObject(userId);
//获取用户所属的角色列表
List<Long> roleIdList = sysUserRoleService.queryRoleIdList(userId);
user.setRoleIdList(roleIdList);
return R.ok().put("user", user);
}
/**
* 保存用户
*/
@RequestMapping("/save")
public R save(@RequestBody SysUserEntity user) {
user.setCreateUserId(getUserId());
sysUserService.save(user);
return R.ok();
}
/**
* 修改用户
*/
public static String[] suffixs = {"IMG", "PNG", "JPG", "JPEG", "GIF", "BPM"};
/**
* 上传文件
*/
@RequestMapping("/upload")
public R upload(@RequestParam("file") MultipartFile file, HttpServletRequest request) throws Exception {
if (file.isEmpty()) {
throw new RRException("上传文件不能为空");
}
String url = MultipartFileUtil.uploadFile("/cdn", file, request);
return R.ok().put("url", url);
}
/**
* 上传资讯内容的图片
*
* @param upload 图片
* @param response 响应
*/
@ResponseBody
@RequestMapping("ckEditorUpload")
public void uploadFile(MultipartFile upload, String CKEditorFuncNum, HttpServletRequest request, HttpServletResponse response) throws IOException {
response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
try {
String path = null;
if (upload != null && !upload.isEmpty()) {
String url = MultipartFileUtil.uploadFile("/cdn", upload, request);
path = url;
}
// 返回“图像”选项卡并显示图片
out.println("<script type=\"text/javascript\">");
out.println("window.parent.CKEDITOR.tools.callFunction(" + CKEditorFuncNum + ",'" + path + "','')");
out.println("</script>");
} catch (RuntimeException e) {
out.println("<script type=\"text/javascript\">");
out.println("window.parent.CKEDITOR.tools.callFunction(" + CKEditorFuncNum + ",'','" + e.getMessage() + "');");
out.println("</script>");
}
return R.ok().put("menuList", menuList);
}
/**
* 角色授权菜单
*/
@RequestMapping("/perms")
public R perms(){
//查询列表数据
List<SysMenuEntity> menuList = null;
//只有超级管理员,才能查看所有管理员列表
if(getUserId() == Constant.SUPER_ADMIN){
menuList = sysMenuService.queryList(new HashMap<String, Object>());
}else{
menuList = sysMenuService.queryUserList(getUserId());
}
return R.ok().put("menuList", menuList);
}
/**
* 菜单信息
*/
@RequestMapping("/info/{menuId}")
public R info(@PathVariable("menuId") Long menuId){
SysMenuEntity menu = sysMenuService.queryObject(menuId);
return R.ok().put("menu", menu);
}
/**
* 保存
*/
@RequestMapping("/save")
public R save(@RequestBody SysMenuEntity menu){
//数据校验
verifyForm(menu);
sysMenuService.save(menu);
return R.ok().put("list", list);
}
/**
* 角色信息
*/
@RequestMapping("/info/{roleId}")
public R info(@PathVariable("roleId") Long roleId){
SysRoleEntity role = sysRoleService.queryObject(roleId);
//查询角色对应的菜单
List<Long> menuIdList = sysRoleMenuService.queryMenuIdList(roleId);
role.setMenuIdList(menuIdList);
return R.ok().put("role", role);
}
/**
* 保存角色
*/
@RequestMapping("/save")
public R save(@RequestBody SysRoleEntity role){
role.setCreateUserId(getUserId());
sysRoleService.save(role);
return R.ok();
}
/**
* 修改角色
*/
@RequestMapping("/update")
public R update(@RequestBody SysRoleEntity role){
role.setCreateUserId(getUserId());
sysRoleService.update(role);
return R.ok();
}
/**
* 删除角色
*/
}
/**
* 信息
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
SalerEntity saler = salerService.queryObject(id);
return R.ok().put("saler", saler);
}
/**
* 保存
*/
@RequestMapping("/save")
public R save(@RequestBody SalerEntity saler){
salerService.save(saler);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
public R update(@RequestBody SalerEntity saler){
salerService.update(saler);
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
salerService.deleteBatch(ids);
return R.ok();
}
}
@RequestMapping("news")
public class NewsController extends AbstractController {
@Autowired
private NewsService newsService;
/**
* 列表
*/
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params){
//查询列表数据
Query query = new Query(params);
List<NewsEntity> newsList = newsService.queryList(query);
int total = newsService.queryTotal(query);
PageUtils pageUtil = new PageUtils(newsList, total, query.getLimit(), query.getPage());
return R.ok().put("page", pageUtil);
}
/**
* 列表
*/
@RequestMapping("/list2")
public R list2(@RequestParam Map<String, Object> params){
Query query = new Query(params);
List<NewsEntity> newsList = newsService.queryList(query);
return R.ok().put("list", newsList );
}
/**
* 信息
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
NewsEntity news = newsService.queryObject(id);
return R.ok().put("news", news);
}
/**
* 保存
*/
@RequestMapping("/save")
public R save(@RequestBody NewsEntity news){
if(parentType != Constant.MenuType.MENU.getValue()){
throw new RRException("上级菜单只能为菜单类型");
}
return ;
}
}
}
/**
* 登录相关
*
* @email admin@gmail.com
*/
@Controller
public class SysLoginController {
@Autowired
private Producer producer;
return R.ok().put("buyer", buyer);
}
/**
* 保存
*/
@RequestMapping("/save")
public R save(@RequestBody BuyerEntity buyer){
buyerService.save(buyer);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
public R update(@RequestBody BuyerEntity buyer){
buyerService.update(buyer);
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
buyerService.deleteBatch(ids);
return R.ok();
}
}
}
/**
* IP地址
*
* @email admin@gmail.com
*/
public class IPUtils {
private static Logger logger = LoggerFactory.getLogger(IPUtils.class);
/**
* 获取IP地址
*
* 使用Nginx等反向代理软件, 则不能通过request.getRemoteAddr()获取IP地址
* 如果使用了多级反向代理的话,X-Forwarded-For的值并不止一个,而是一串IP地址,X-Forwarded-For中第一个非unknown的有效IP字符串,则为真实IP地址
*/
public static String getIpAddr(HttpServletRequest request) {
String ip = null;
try {
ip = request.getHeader("x-forwarded-for");
if (StringUtils.isEmpty(ip) || "unknown".equalsIgnoreCase(ip)) {
ip = request.getHeader("Proxy-Client-IP");
}
if (StringUtils.isEmpty(ip) || ip.length() == 0 || "unknown".equalsIgnoreCase(ip)) {
ip = request.getHeader("WL-Proxy-Client-IP");
}
if (StringUtils.isEmpty(ip) || "unknown".equalsIgnoreCase(ip)) {
ip = request.getHeader("HTTP_CLIENT_IP");
}
if (StringUtils.isEmpty(ip) || "unknown".equalsIgnoreCase(ip)) {
ip = request.getHeader("HTTP_X_FORWARDED_FOR");
}
if (StringUtils.isEmpty(ip) || "unknown".equalsIgnoreCase(ip)) {
ip = request.getRemoteAddr();
}
} catch (Exception e) {
logger.error("IPUtils ERROR ", e);
}
// //使用代理,则获取第一个IP地址
// if(StringUtils.isEmpty(ip) && ip.length() > 15) {
// if(ip.indexOf(",") > 0) {
// ip = ip.substring(0, ip.indexOf(","));
/**
* 异常处理器
*
* @email admin@gmail.com
*/
@Component
public class RRExceptionHandler implements HandlerExceptionResolver {
private Logger logger = LoggerFactory.getLogger(getClass());
@Override
public ModelAndView resolveException(HttpServletRequest request,
HttpServletResponse response, Object handler, Exception ex) {
R r = new R();
try {
response.setContentType("application/json;charset=utf-8");
response.setCharacterEncoding("utf-8");
if (ex instanceof RRException) {
r.put("code", ((RRException) ex).getCode());
r.put("msg", ((RRException) ex).getMessage());
}else if(ex instanceof DuplicateKeyException){
r = R.error("该数据已存在,请重新输入");
}else if(ex instanceof AuthorizationException){
r = R.error("没有权限,请联系管理员授权");
}else{
r = R.error();
}
//记录异常日志
logger.error(ex.getMessage(), ex);
String json = JSON.toJSONString(r);
response.getWriter().print(json);
} catch (Exception e) {
logger.error("RRExceptionHandler 异常处理失败", e);
/**
* 异常处理器
*
* @email admin@gmail.com
*/
@Component
public class RRExceptionHandler implements HandlerExceptionResolver {
private Logger logger = LoggerFactory.getLogger(getClass());
@Override
public ModelAndView resolveException(HttpServletRequest request,
HttpServletResponse response, Object handler, Exception ex) {
R r = new R();
try {
response.setContentType("application/json;charset=utf-8");
response.setCharacterEncoding("utf-8");
if (ex instanceof RRException) {
r.put("code", ((RRException) ex).getCode());
r.put("msg", ((RRException) ex).getMessage());
}else if(ex instanceof DuplicateKeyException){
r = R.error("该数据已存在,请重新输入");
}else if(ex instanceof AuthorizationException){
r = R.error("没有权限,请联系管理员授权");
}else{
r = R.error();
}
//记录异常日志
logger.error(ex.getMessage(), ex);
String json = JSON.toJSONString(r);
response.getWriter().print(json);
} catch (Exception e) {
logger.error("RRExceptionHandler 异常处理失败", e);
}
return new ModelAndView();
}
}
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
houseService.deleteBatch(ids);
return R.ok();
}
}
/**
* 通知公告
*
* @email admin@gmail.com
*/
@RestController
@RequestMapping("news")
public class NewsController extends AbstractController {
@Autowired
private NewsService newsService;
/**
* 列表
*/
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params){
//查询列表数据
Query query = new Query(params);
/**
* 角色管理
*
* @email admin@gmail.com
*/
@RestController
@RequestMapping("/sys/role")
public class SysRoleController extends AbstractController {
@Autowired
private SysRoleService sysRoleService;
@Autowired
private SysRoleMenuService sysRoleMenuService;
/**
* 角色列表
*/
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params){
//如果不是超级管理员,则只查询自己创建的角色列表
// if(getUserId() != Constant.SUPER_ADMIN){
// params.put("createUserId", getUserId());
// }
//查询列表数据
Query query = new Query(params);
List<SysRoleEntity> list = sysRoleService.queryList(query);
int total = sysRoleService.queryTotal(query);
PageUtils pageUtil = new PageUtils(list, total, query.getLimit(), query.getPage());
return R.ok().put("page", pageUtil);
}
/**
* 角色列表
*/
@RequestMapping("/select")
public R select(){
Map<String, Object> map = new HashMap<>();
//如果不是超级管理员,则只查询自己所拥有的角色列表
// if(getUserId() != Constant.SUPER_ADMIN){
// map.put("createUserId", getUserId());
// }
List<SysRoleEntity> list = sysRoleService.queryList(map);
return R.ok().put("list", list);
}
/**
/**
* 获取登录的用户信息
*/
@RequestMapping("/info")
public R info() {
return R.ok().put("user", this.sysUserService.queryObject(getUser().getUserId()));
}
/**
* 修改登录用户密码
*/
@RequestMapping("/password")
public R password(String password, String newPassword) {
//sha256加密
// password = new Sha256Hash(password).toHex();
//sha256加密
//newPassword = new Sha256Hash(newPassword).toHex();
//更新密码
int count = sysUserService.updatePassword(getUserId(), password, newPassword);
if (count == 0) {
return R.error("原密码不正确");
}
//退出
ShiroUtils.logout();
return R.ok();
}
@RequestMapping("/updateInfo")
public R updateInfo(@RequestBody SysUserEntity user) {
this.sysUserService.update(user);
return R.ok();
}
/**
* 用户信息
*/
/**
* 上传资讯内容的图片
*
* @param upload 图片
* @param response 响应
*/
@ResponseBody
@RequestMapping("ckEditorUpload")
public void uploadFile(MultipartFile upload, String CKEditorFuncNum, HttpServletRequest request, HttpServletResponse response) throws IOException {
response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
try {
String path = null;
if (upload != null && !upload.isEmpty()) {
String url = MultipartFileUtil.uploadFile("/cdn", upload, request);
path = url;
}
// 返回“图像”选项卡并显示图片
out.println("<script type=\"text/javascript\">");
out.println("window.parent.CKEDITOR.tools.callFunction(" + CKEditorFuncNum + ",'" + path + "','')");
out.println("</script>");
} catch (RuntimeException e) {
out.println("<script type=\"text/javascript\">");
out.println("window.parent.CKEDITOR.tools.callFunction(" + CKEditorFuncNum + ",'','" + e.getMessage() + "');");
out.println("</script>");
}
}
}
/**
* 买家信息
*
* @email admin@gmail.com
*/
@RestController
@RequestMapping("buyer")
public class BuyerController extends AbstractController {
@Autowired
private BuyerService buyerService;
/**
* 列表
*/
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params){
//查询列表数据
Query query = new Query(params);
List<BuyerEntity> buyerList = buyerService.queryList(query);
int total = buyerService.queryTotal(query);
PageUtils pageUtil = new PageUtils(buyerList, total, query.getLimit(), query.getPage());
return R.ok().put("page", pageUtil);
}
/**
* 列表
*/
@RequestMapping("/list2")
public R list2(@RequestParam Map<String, Object> params){
Query query = new Query(params);
List<BuyerEntity> buyerList = buyerService.queryList(query);
return R.ok().put("list", buyerList );
}
/**
* 信息
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
menuList.add(root);
return R.ok().put("menuList", menuList);
}
/**
* 角色授权菜单
*/
@RequestMapping("/perms")
public R perms(){
//查询列表数据
List<SysMenuEntity> menuList = null;
//只有超级管理员,才能查看所有管理员列表
if(getUserId() == Constant.SUPER_ADMIN){
menuList = sysMenuService.queryList(new HashMap<String, Object>());
}else{
menuList = sysMenuService.queryUserList(getUserId());
}
return R.ok().put("menuList", menuList);
}
/**
* 菜单信息
*/
@RequestMapping("/info/{menuId}")
public R info(@PathVariable("menuId") Long menuId){
SysMenuEntity menu = sysMenuService.queryObject(menuId);
return R.ok().put("menu", menu);
}
/**
* 保存
*/
@RequestMapping("/save")
public R save(@RequestBody SysMenuEntity menu){
//数据校验
verifyForm(menu);
sysMenuService.save(menu);
return R.ok();
}
/**
* 修改