控制层导包
package com.dengfeng.house.controller;
import java.text.ParseException;
import java.util.Date;
import java.util.List;
import javax.annotation.Resource;
import javax.servlet.http.HttpSession;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.dengfeng.house.pojo.District;
import com.dengfeng.house.pojo.House;
import com.dengfeng.house.pojo.HouseQuery;
import com.dengfeng.house.pojo.Street;
import com.dengfeng.house.pojo.Type;
import com.dengfeng.house.pojo.User;
import com.dengfeng.house.service.IDistrictService;
import com.dengfeng.house.service.IHouseService;
import com.dengfeng.house.service.IStreetService;
import com.dengfeng.house.service.ITypeService;
springmvc控制层代码
@Controller
@RequestMapping("/house")
public class HouseController {
@Resource
private IHouseService houseService;
@Resource
private ITypeService typeService;
@Resource
private IDistrictService districtService;
@Resource
private IStreetService streetService;
//manage页面全查,返回值PageInfo是为了分页查询功能
@RequestMapping("/findAll")
@ResponseBody
public PageInfo findAll(@RequestParam(defaultValue="1")int pageIndex){
PageHelper.startPage(pageIndex, 3);
List<House> housList = houseService.selectHouse();
PageInfo pageInfo=new PageInfo<House>(housList);
return pageInfo;
}
//修改渲染
@RequestMapping("/update/{id}")
public String update(Model model,@PathVariable int id){
List<Type> typeList = typeService.findAllType();
List<District> districtList = districtService.findAllDistrict();
List<Street> streetList= streetService.findAllStreet();
House house = houseService.findHouseById(id);
model.addAttribute("house", house);
model.addAttribute("typeList", typeList);
model.addAttribute("districtList", districtList);
model.addAttribute("streetList", streetList);
return "/page/update";
}
//保存修改
@RequestMapping("/updateSave")
public String update(House house){
houseService.alterHouse(house);
return "redirect:/page/manage.jsp";
}
//渲染增加,下拉框推荐用ajxj做,,=所有这个方法没什么用
@RequestMapping("/add")
public String add(Model model){
List<Type> typeList = typeService.findAllType();
/* List<District> districtList = districtService.findAllDistrict();
List<Street> streetList= streetService.findAllStreet();*/
model.addAttribute("typeList", typeList);
/* model.addAttribute("districtList", districtList);
model.addAttribute("streetList", streetList);
*/
return "/page/add";
}
//真正保存增加的方法
@RequestMapping("/addSave")
public String addSave(House house,HttpSession session){
houseService.insertHouse(house);
return "redirect:/page/manage.jsp";
}
/*house_list.jsp查询。/
@RequestMapping("/find")
@ResponseBody
public List<House> find(HouseQuery houseQuery,String money,String size){
//如果是选中状态
if(money!=null&&!money.equals("")){
String[] moneyArray=money.split("-");
houseQuery.setMinPrice(Integer.parseInt(moneyArray[0]));
houseQuery.setMaxPrice(Integer.parseInt(moneyArray[1]));
}
if(size!=null&&!size.equals("")){
String[] sizeArray=size.split("-");
houseQuery.setMinFloorAge(Integer.parseInt(sizeArray[0]));
houseQuery.setMaxFloorAge(Integer.parseInt(sizeArray[1]));
}
List<House> list = houseService.find(houseQuery);
return list;
}
//推荐,动态查询
/* @RequestMapping("/findAllHouseList")
@ResponseBody
public PageInfo<House> findAll(HttpSession session,@RequestParam(defaultValue="1")Integer pageIndex,
@RequestParam(defaultValue="")String title,
@RequestParam(defaultValue="")String price,
@RequestParam(defaultValue="")Integer typeId,
@RequestParam(defaultValue="0")String floorage,Date beginTime,Date endTime) throws ParseException{
User user=(User)session.getAttribute("userSession");
String[] prices = price.split("-");
String[] floorages = floorage.split("-");
if(user!=null) {
PageHelper.startPage(pageIndex,2);
House house =new House ();
house.setTitle(title);
house.setMinPrice(Integer.parseInt(prices[0]));
house.setMaxPrice(Integer.parseInt(prices[1]));
house.setTypeId(typeId);
house.setMinFloorage(Integer.parseInt(floorages[0]));
house.setMaxFloorage(Integer.parseInt(floorages[1]));
if(beginTime!=null && endTime!=null){
house.setBeginTime(beginTime);
house.setEndTime(endTime);
}else if(beginTime!=null){
house.setBeginTime(beginTime);
}else if(endTime!=null){
house.setEndTime(endTime);
}
List<House> list = houseService.findByCondition(house);
PageInfo<House> pageInfo=new PageInfo<House>(list);
return pageInfo;
}
return new PageInfo<House>();
}*/
//删除房子
@RequestMapping("/deleteById")
@ResponseBody
public String delete(int id){
houseService.deletehouse(id);
return "删除成功";
}
}
前端页面
<%@ page language="java" contentType="text/html;charset=UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
int total = (Integer)request.getAttribute("total");
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>用户管理</title>
<%-- <link type="text/css" rel="stylesheet" href="${pageContext.request.contextPath}css/style.css" />
<script type="text/javascript" src="${pageContext.request.contextPath}/scripts/function.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath}/scripts/jquery.min.js"></script> --%>
<script type="text/javascript" src="${pageContext.request.contextPath}/scripts/jquery.min.js"></script>
<link type="text/css" rel="stylesheet" href="${pageContext.request.contextPath}/css/style.css" />
<script type="text/javascript" src="${pageContext.request.contextPath}/scripts/function.js"></script>
<style type="text/css">
/* .space{
给js里的td设置字体颜色有效
color: red
} */
</style>
</head>
<body>
<input type="hidden" id="path" value="${pageContext.request.contextPath}"/>
<div id="header" class="wrap">
<div id="logo"></div>
<div class="search">
<label class="ui-green"><a href="${pageContext.request.contextPath }/house/add"><input type="button" name="search" value="发布房屋信息" /></a></label>
<label class="ui-green"><a href="${pageContext.request.contextPath }/user/logout"><input type="button" name="search" value="退 出" /></a></label>
</div>
</div>
<div class="main wrap">
<div id="houseArea">
<!-- 这个隐藏框用于分页查询 -->
<input type="hidden" name="pageIndex" value="1"/>
<table class="house-list">
<!-- <img src="../images/thumb_house.gif" /> -->
</table>
<div class="page-bar">
<ul class="page-num-ul clearfix">
<li>共${param.totalCount }条记录 ${param.currentPageNo }/${param.totalPageCount }页</li>
<c:if test="${param.currentPageNo > 1}">
<a href="javascript:page_nav(document.forms[0],1);">首页</a>
<a href="javascript:page_nav(document.forms[0],${param.currentPageNo-1});">上一页</a>
</c:if>
<c:if test="${param.currentPageNo < param.totalPageCount }">
<a href="javascript:page_nav(document.forms[0],${param.currentPageNo+1 });">下一页</a>
<a href="javascript:page_nav(document.forms[0],${param.totalPageCount });">最后一页</a>
</c:if>
</ul>
<!-- <span class="page-go-form"><label>跳转至</label>
<input type="text" name="inputPage" id="inputPage" class="page-key" />页
<button type="button" class="page-btn" onClick='jump_to(document.forms[0],document.getElementById("inputPage").value)'>GO</button>
</span> -->
</div>
</div>
JS代码
<script type="text/javascript">
var path;
$(function(){
alert("1")
path=$("#path").val();
findHouse();
});
/* 让页面一加载完就调用走这个函数 */
//这个方法用于全查数据来展示到页面
function findHouse(){
/*alert("2")*/
$.post(path+"/house/findAll",{"pageIndex":$("[name='pageIndex']").val()},function(data){
/* 每次获取用户列表,都需要将上一次的结果清除 */
/*alert("3")*/
$("tr").remove();
$(data.list).each(function(i,e){
/*alert("6")*/
var content="<tr>";
content+="<td class=\"house-thumb\"><span><img src=\"../images/thumb_house.gif\" /></span></td>";
content+="<td class=\"space\"><dl><dt><a href=\"#\">"+e.title+"</a></dt>";
content+="<dd>"+e.districtName+"区"+"";
content+="<span style=\"margin-left:20px\"></span>";
content+=""+e.streetName+"街"+"";
content+="<span style=\"margin-left:20px\"></span>";
content+=""+"面积"+e.floorage+"平米"+"<br/>";
content+=""+"联系方式:"+e.contact+"</dd></dl></td>";
/* this指a标签自己 ,javascript:void(0)的意思是让这个标签有a标签的样式,但没有a标签的功能,找到a标签自己把父节点删除,tr*/
content+="<td class=\"house-type\"><label class=\"ui-green\"><a href=\""+path+"/house/update/"+e.id+"\" class=\"modifyBill\"><input type=\"button\" name=\"search\" value=\"修 改\" />"+"</a></label></td>"+
"<td class=\"house-price\"><label class=\"ui-green\"><input type=\"button\" name=\"search\" οnclick=\"deleteHouse("+e.id+",this)\" value=\"删 除\" />"+"</label> </td>";
content+="</tr>";
$("table").append(content);
});
//开始覆盖分页节点
$(".page-num-ul li").html("共"+data.total+"条记录 "+data.pageNum+"/"+data.pages+"页");
//每次添加上一页、下一页都要把上一次的结果清除,否则会累加
$(".page-num-ul a").remove();
//动态的添加上一页、下一页
if(!data.isFirstPage){
$(".page-num-ul").append("<a href=\"javascript:jump(1)\">首页</a>"+
"<a href=\"javascript:jump("+(data.pageNum-1)+")\">上一页</a>");
}
if(!data.isLastPage){
$(".page-num-ul").append("<a href=\"javascript:jump("+(data.pageNum+1)+")\">下一页</a>"+
"<a href=\"javascript:jump("+(data.pages)+")\">末页</a>");
}
},"json");
}
//下一页
function jump(pageNum){
//动态的修改当前页数
$("[name='pageIndex']").val(pageNum);
//提交
findHouse();
}
//修改
function update(id){
alert("3")
/* 上面a标签点击事件调用方法时候 把商品的id传了过来,再把这个商品的id传到后台*/
$.post(path+"/house/update",{"id":id},function(data){
/*alert(data);*/
/*οnclick=\"update("+e.id+")\"
*/ },"text");
}
//删除
function deleteHouse(id,a){
/* 上面a标签点击事件调用方法时候 把商品的id传了过来,再把这个商品的id传到后台*/
$.post(path+"/house/deleteById",{"id":id},function(data){
//现在后台已经删除成功了,前台页面也需要从对应的节点删掉
alert(data);
$(a).parents("tr").remove();
},"text");
}
//时间函数,从数据库拿的时间需要处理一下才能正确显示在前端,直接在ajax调用这个函数即可
function getDateTime(obj){
var date = new Date(parseInt(obj,10));
//月份得+1,且只有个位数时在前面+0
var month = date.getMonth() + 1 < 10 ? "0" + (date.getMonth() + 1) : date.getMonth() + 1;
//日期为个位数时在前面+0
var currentDate = date.getDate() < 10 ? "0" + date.getDate() : date.getDate();
//拼接日期显示格式
var hours = date.getHours()<10?"0"+date.getHours():date.getHours();
var minutes = date.getMinutes()<10?"0"+date.getMinutes():date.getMinutes();
var seconds = date.getSeconds()<10?"0"+date.getSeconds():date.getSeconds();
var newTime = date.getFullYear() + "-" + month + "-" + currentDate+" "+hours+":"+minutes+":"+seconds;
return newTime;
}
</script>
<script type="text/javascript" src="${pageContext.request.contextPath}/scripts/manage.js"></script>
</body>
</html>