http://localhost:8080/bus_ssm/login.jsp#

部分代码展示

线路管理代码

<form action="rk" method="post">
 <div class="rt_content">
      <div class="page_title">
       <h2 class="fl">请输入车辆信息</h2>
      </div>
      <ul class="ulColumn2">
       <li>
        <span class="item_name" style="width:120px;">名称：</span>
        <input type="text" name="name" class="textbox textbox_225"  placeholder="名称..."/>
       </li>
       <li>
        <span class="item_name" style="width:120px;">时间：</span>
        <input type="text" name="number" class="textbox textbox_225"  placeholder="时间"/>
       </li>
       <li>
        <span class="item_name" style="width:120px;" name="sex介绍：</span>
       <input type="text" name="money" class="textbox textbox_225"  placeholder="介绍.."/>
       </li>
       <li>
        <span class="item_name" style="width:120px;">地区：</span>
        <input type="text"  name="gy" class="textbox textbox_225" placeholder="地区..."/>
       </li>
       <li>
        <span class="item_name" style="width:120px;">分类：</span>
        <input type="tel" name="phone" class="textbox textbox_225"  placeholder="分类..."/>
       </li>
       <li>
        <span class="item_name" style="width:120px;"></span>
        <input type="submit" class="link_btn" value="提交"/>
       </li>
      </ul>
 </div>
 </form>

按照查询条件查询公交车次记录代码

 /*按照查询条件分页查询公交车次记录*/
    public ArrayList<BusLine> queryBusLine(String name,BusStation startStation,BusStation endStation,String company,int currentPage) throws Exception { 
     	String where = "where 1=1";
    	if(!name.equals("")) where = where + " and t_busLine.name like '%" + name + "%'";
    	if(null != startStation && startStation.getStationId()!= null && startStation.getStationId()!= 0)  where += " and t_busLine.startStation=" + startStation.getStationId();
    	if(null != endStation && endStation.getStationId()!= null && endStation.getStationId()!= 0)  where += " and t_busLine.endStation=" + endStation.getStationId();
    	if(!company.equals("")) where = where + " and t_busLine.company like '%" + company + "%'";
    	int startIndex = (currentPage-1) * this.rows;
    	return busLineMapper.queryBusLine(where, startIndex, this.rows);
    }

    /*按照查询条件查询所有记录*/
    public ArrayList<BusLine> queryBusLine(String name,BusStation startStation,BusStation endStation,String company) throws Exception  { 
     	String where = "where 1=1";
    	if(!name.equals("")) where = where + " and t_busLine.name like '%" + name + "%'";
    	if(null != startStation && startStation.getStationId()!= null && startStation.getStationId()!= 0)  where += " and t_busLine.startStation=" + startStation.getStationId();
    	if(null != endStation && endStation.getStationId()!= null && endStation.getStationId()!= 0)  where += " and t_busLine.endStation=" + endStation.getStationId();
    	if(!company.equals("")) where = where + " and t_busLine.company like '%" + company + "%'";
    	return busLineMapper.queryBusLineList(where);
    }

ajax方式按照查询条件分页查询站点信息

	@RequestMapping(value = { "/list" }, method = {RequestMethod.GET,RequestMethod.POST})
	public void list(String stationName,Integer page,Integer rows, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
		if (page==null || page == 0) page = 1;
		if (stationName == null) stationName = "";
		if(rows != 0)busStationService.setRows(rows);
		List<BusStation> busStationList = busStationService.queryBusStation(stationName, page);
	    /*计算总的页数和总的记录数*/
	    busStationService.queryTotalPageAndRecordNumber(stationName);
	    /*获取到总的页码数目*/
	    int totalPage = busStationService.getTotalPage();
	    /*当前查询条件下总记录数*/
	    int recordNumber = busStationService.getRecordNumber();
        response.setContentType("text/json;charset=UTF-8");
		PrintWriter out = response.getWriter();
		//将要被返回到客户端的对象
		JSONObject jsonObj=new JSONObject();
		jsonObj.accumulate("total", recordNumber);
		JSONArray jsonArray = new JSONArray();
		for(BusStation busStation:busStationList) {
			JSONObject jsonBusStation = busStation.getJsonObject();
			jsonArray.put(jsonBusStation);
		}
		jsonObj.accumulate("rows", jsonArray);
		out.println(jsonObj.toString());
		out.flush();
		out.close();
	}

	@RequestMapping(value = { "/listAll" }, method = {RequestMethod.GET,RequestMethod.POST})
	public void listAll(HttpServletResponse response) throws Exception {
		List<BusStation> busStationList = busStationService.queryAllBusStation();
        response.setContentType("text/json;charset=UTF-8"); 
		PrintWriter out = response.getWriter();
		JSONArray jsonArray = new JSONArray();
		for(BusStation busStation:busStationList) {
			JSONObject jsonBusStation = new JSONObject();
			jsonBusStation.accumulate("stationId", busStation.getStationId());
			jsonBusStation.accumulate("stationName", busStation.getStationName());
			jsonArray.put(jsonBusStation);
		}
		out.println(jsonArray.toString());
		out.flush();
		out.close();
	}

	/*前台按照查询条件分页查询站点信息信息*/
	@RequestMapping(value = { "/frontlist" }, method = {RequestMethod.GET,RequestMethod.POST})
	public String frontlist(String stationName,Integer currentPage, Model model, HttpServletRequest request) throws Exception  {
		if (currentPage==null || currentPage == 0) currentPage = 1;
		if (stationName == null) stationName = "";
		List<BusStation> busStationList = busStationService.queryBusStation(stationName, currentPage);
	    /*计算总的页数和总的记录数*/
	    busStationService.queryTotalPageAndRecordNumber(stationName);
	    /*获取到总的页码数目*/
	    int totalPage = busStationService.getTotalPage();
	    /*当前查询条件下总记录数*/
	    int recordNumber = busStationService.getRecordNumber();
	    request.setAttribute("busStationList",  busStationList);
	    request.setAttribute("totalPage", totalPage);
	    request.setAttribute("recordNumber", recordNumber);
	    request.setAttribute("currentPage", currentPage);
	    request.setAttribute("stationName", stationName);
		return "BusStation/busStation_frontquery_result"; 
	}