Caused by: org.apache.ibatis.binding.BindingException: Parameter ‘assetsNo‘ not found. Available par

解决：
需要使用(@Param(“assets”)
调用需要使用assets.id

数据层代码：

在这里插入代码片
    /**
     * 分页查询物资信息

     * @return List
     */
    public List<Assets> queryAssetsPage(@Param("assets")Assets assets,@Param("startIndex") int startIndex,@Param("pageSize") int pageSize,  @Param("startTime")Date startTime,
                                        @Param("endTime")Date endTime);

mybatis.xml

在这里插入代码片
<select id="queryAssetsPage" parameterType="com.example.demo.entity.Assets" resultType="com.example.demo.entity.Assets">
        SELECT id,assets_no,category_no,assets_name,rfid_no,material_no,
        center_no,supplier_no,supplier_name,price,overdue,organization_no,organization_name,
        location_no,location_name,person_name,state,repair_date,maintain_state,maintain_date,
        maintain_effective_date,maintain_early_date,maintain_record,
        calibration_state,calibration_date,calibration_effective_date,calibration_early_date,
        remarks,buy_date,getout_date,borrow_date,return_date,scrap_date,equiment_name,
        operator,createup_date
        FROM assets
        WHERE 1=1
        <choose>
        <when test="assets.id!=null and assets.id!=0"> and id=#{assets.id}</when>
         </choose>
        limit #{startIndex},#{pageSize}
    </select>