根据运单号查询,

进行运单号查询,Spring Boot+Mybatis,进行方法的映射.

//通过订单号查询,方法映射 

<select id="selectBySign" parameterType="String" resultMap="BaseResultMap">
      select * from TEST_LOGISTIC where WAYBILLCODE = #{sign}
</select>

 

List<Test_Logistic> selectBySign(String sign);//根据订单号查询

 查询

    public String SFLogistic(HttpServletRequest request,HttpServletResponse response) {
        
　　　　 //获取订单号        
        String waybillCode = request.getParameter("orderid");
        //根据运货单号查询货单信息
        List<Test_Logistic> test_LogisticList =  test_logisticMapper.selectBySign(waybillCode);
        logger.debug("查询成功");