关于不确定字段查询问题-mybatis

  		and order_id = #{orderId,jdbcType=BIGINT}

  	

  	 0">

  		and order_id in 

  		

            #{item}

        

  	

  	

  		and order_type_id = #{fromOrderId,jdbcType=BIGINT}

  	

  	

  		= #{startFinDate,jdbcType=TIMESTAMP} ]]>

  	

  	

  		

  	

@RequestMapping(value="/orderList" ,method = RequestMethod.POST)

	public ModelAndView orderBuyPage(HttpServletRequest request ,Model model,

			@RequestParam(value="pageNum" ,defaultValue="1")String pageNum,

			@RequestParam(value="pageSize" ,defaultValue="10")String pageSize){

		String orderIdOrProdName = request.getParameter("orderIdOrProdName");

		String fromOrderId = request.getParameter("fromOrderId");

		String startFinDate = request.getParameter("startFinDate");

		String endFinDate = request.getParameter("endFinDate");

		String sellOrgName = request.getParameter("sellOrgName");

		String evaluate = request.getParameter("evaluate");

		String orderStatus = request.getParameter("orderStatus");

		String trnsctWay = request.getParameter("trnsctWay");

		

		List listTrn = orderService.getTrnsctList();

		model.addAttribute("listTrn", listTrn);

		List listOrderType = orderService.getOrderTypeList();

		model.addAttribute("listOrderType", listOrderType);

		List listStatus = orderService.getOrderStatusList();

		model.addAttribute("listStatus", listStatus);

		//分页查询订单列表

		PageBO page = orderService.queryPageByBuyCondition(orderIdOrProdName, 

				fromOrderId, startFinDate, endFinDate, sellOrgName, 

				evaluate, orderStatus, trnsctWay, pageNum, pageSize);

		model.addAttribute("orderIdOrProdName", orderIdOrProdName);

		model.addAttribute("fromOrderId", fromOrderId);

		model.addAttribute("startFinDate", startFinDate);

		model.addAttribute("endFinDate", endFinDate);

		model.addAttribute("sellOrgName", sellOrgName);

		model.addAttribute("evaluate", evaluate);

		model.addAttribute("orderStatus", orderStatus);

		model.addAttribute("trnsctWay", trnsctWay);

		model.addAttribute("page", page);

		return getModelAndView("/order/buyer/buyer_order_list");

	}