而且控制台输出的sql语句也很奇怪，莫名其妙出来了count()。把返回类型最外层的page去掉，就不会报错，一分页就报错。请问这是为什么？

今天在用navicat连接非本地的Mysql服务器的数据库，居然无法连接很奇怪，报1130错误，ERROR1130:Host192.168.3.100isnotallowedtoconnecttothisMySQLserver

images.sunofbeaches.com/content/2022_08_22/1011235441409523712.png">

图中圈住这个log是可以打出来的，但是下面的log，也就是sdf那一串，打不出来，就很奇怪

结果如下，log没有输出setData的log，size也为0，好奇怪啊适配器的代码如下privateList<String>mStrings=newArrayList<>();

总裁奇怪。老太太说：这是我的律师，这么大宗的赌注，总要有个证人在场。总裁觉得言之有理。总裁得意洋洋地说：“你输了，我的蛋蛋还是圆的”。老太太说：我要亲自摸摸。

在本机上直接运行什么问题也没有但是打成jar包放到linux服务器上就请求不回来但是输入keyword=电脑又可以

很奇怪的是他为啥一点反应都没有，然后为啥还换了个电动车。这个电动车我没见他骑过。然后我骑过去和他搭话，但我刚骑过去他就走了，我喊他也没有反应，然后他回头我才意识到，我认错人了！

另外两个女生，一个和B一样比较外向（但没有B这么社牛）另一个是班上最内向的女生（整个高中阶段没说过话）然后就这么一个奇怪的组合一块打扫了两年半卫生。

子回答有点奇怪，因为网站内子回答的输入是没有插入图片，代码块等等，可能以后支持，同样用展示内容方式来。基本上要注意的就是这样了。剩下的就是如何写答案，回复答案。

心理多多少少逆反心理，学习老容易被一些无关紧要的吸引过去，比如写个算法题，脑子突然蹦出个奇奇怪怪的想法，就想去实现它。就是逆反心理使得熵变大了，稳定性下降了。

有偿请教啊大佬们帮帮忙都折腾一个星期了~~！importbutterknife.BindView;publicclassSearchFragmentextendsBaseFragmentimplementsISearchViewCallback,SearchResultAdapter.OnListItmeClick{privateISearchPresentermSearchPresenter;@BindView(R.id.search_history_view)publicTextFlowLayoutmHistoriesView;@BindView(R.id.search_recommend_view)publicTextFlowLayoutmRecommendView;@BindView(R.id.search_recommend_contriner)publicViewmRecommendContainer;@BindView(R.id.search_history_container)publicViewmHistoryContainer;@BindView(R.id.search_btn)//搜索按钮publicTextViewmSearchBtn;@BindView(R.id.secarch_clean_btn)//搜索输入框里的删除按钮publicImageViewmCleanInputBtn;@BindView(R.id.search_input_box)//搜索输入框publicEditTextmSearchInputBox;@BindView(R.id.search_history_delete)//删除搜索历史按键publicViewmHistoryDelete;//搜索推荐词列表@BindView(R.id.search_result_list)publicRecyclerViewmSearchList;@BindView(R.id.search_result_container)publicTwinklingRefreshLayoutmRefreshContainer;@BindView(R.id.base_container)publicFrameLayoutbasecontainer;privateSearchResultAdaptermSearchResultAdapter;protectedvoidinitPresenter(){mSearchPresenter=PresenterManager.getInstance().getmSearchPresenter();mSearchPresenter.registerViewCallback(this);//后去搜索关键词mSearchPresenter.getRecommendWords();//mSearchPresenter.doSearch("鞋子");mSearchPresenter.getHistories();}@OverrideprotectedvoidloadData(){}//释放资源@Overrideprotectedvoidrelease(){if(mSearchPresenter!=null){mSearchPresenter.unregisterViewCallback(this);}}@OverrideprotectedViewloadRootView(LayoutInflaterinflater,ViewGroupcontainer){returninflater.inflate(R.layout.fragment_search_layout,container,false);}@OverrideprotectedintgetRootViewResId(){returnR.layout.fragment_search;}//点击删除搜索历史jilpublicvoidinitListener(){mSearchResultAdapter.setOnListeItemClick(this);//列表点击事件//点击搜索开始动作mSearchBtn.setOnClickListener(newView.OnClickListener(){@OverridepublicvoidonClick(Viewv){Stringkeyword=mSearchInputBox.getText().toString();mSearchPresenter.doSearch(keyword);LogUtils.d(this,"点击搜索获取到的数据======>"+keyword);}});/**mSearchInputBox.setOnEditorActionListener(newTextView.OnEditorActionListener(){@OverridepublicbooleanonEditorAction(TextViewv,intactionId,KeyEventevent){//LogUtils.d(SearchFragment.this,"actionID======>"+actionId);if(actionId==EditorInfo.IME_ACTION_SEARCH&&mSearchPresenter!=null){LogUtils.d(SearchFragment.this,"inputtext=====>"+v.getText());mKeyword=v.getText().toString();LogUtils.d(this,"mkeyword======>"+mKeyword);if(TextUtils.isEmpty(mKeyword)){ToasUtil.showToast("请输入后搜索");}else{}//判断拿到的内容是否为空}returntrue;}});*/mHistoryDelete.setOnClickListener(newView.OnClickListener(){@OverridepublicvoidonClick(Viewv){//TOOD:mSearchPresenter.delHistories();LogUtils.d(this,"点击删除"+mHistoryDelete.getMeasuredHeight());}});//下拉去加载更多内容mRefreshContainer.setOnRefreshListener(newRefreshListenerAdapter(){@OverridepublicvoidonLoadMore(TwinklingRefreshLayoutrefreshLayout){//下拉加载更多if(mSearchPresenter!=null){mSearchPresenter.loaderMoer();}}});}@OverrideprotectedvoidinitView(ViewrootView){setUpState(State.SUCCESS);//设置布局管理器mSearchList.setLayoutManager(newLinearLayoutManager(getContext()));//设置适配器mSearchResultAdapter=newSearchResultAdapter();mSearchList.setAdapter(mSearchResultAdapter);//设置刷新控件上拉下拉mRefreshContainer.setEnableLoadmore(true);mRefreshContainer.setEnableRefresh(false);mRefreshContainer.setEnableOverScroll(true);}@OverridepublicvoidonHistoriesLoaded(Historieshistories){setUpState(State.SUCCESS);LogUtils.d(this,"hitrories"+histories);if(histories==null||histories.getHistories().size()==0){mHistoryContainer.setVisibility(View.GONE);}else{mHistoryContainer.setVisibility(View.VISIBLE);mHistoriesView.setTextList(histories.getHistories());LogUtils.d(this,"histories=====>"+histories);}}@OverridepublicvoidonHistoriesDeleted(){if(mSearchPresenter!=null){mSearchPresenter.getHistories();}}@OverridepublicvoidonSearchSuccess(List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>result){//List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>map_data=results.getData().getTbk_dg_material_optional_response().getResult_list().getMap_data();//LogUtils.d(this,"guanjianci"+result);setUpState(State.SUCCESS);//隐藏历史记录和推荐需要时显示mRecommendContainer.setVisibility(View.GONE);mHistoryContainer.setVisibility(View.GONE);//显示搜索界面mRefreshContainer.setVisibility(View.VISIBLE);//设置数据//try{mSearchResultAdapter.setData(result);//}catch(Exceptione){//e.printStackTrace();//如果数据异常切换到搜索内容为空//setUpState(State.EMPTY);//}//LogUtils.d(this,"搜索列表"+results);mSearchList.addItemDecoration(newRecyclerView.ItemDecoration(){@OverridepublicvoidgetItemOffsets(@NonNullRectoutRect,@NonNullViewview,@NonNullRecyclerViewparent,@NonNullRecyclerView.Statestate){super.getItemOffsets(outRect,view,parent,state);outRect.top=8;outRect.bottom=8;}});}@OverridepublicvoidonMoreLoad(List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>result){//List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>moreData=resultmRefreshContainer.finishLoadmore();//加载到更多的结果//拿到结果添加到适配器mSearchResultAdapter.addData(result);//提示加载到更多数据成功ToasUtil.showToast("加载成功");}@OverridepublicvoidonMoreLoadedError(){mRefreshContainer.finishLoadmore();}@OverridepublicvoidonMoreLoadedEmpty(){mRefreshContainer.finishLoadmore();}//获取的搜索关键词@OverridepublicvoidonRecommendWordsLoaded(SearchRecommend.DataBeanrecommendWords){setUpState(State.SUCCESS);List<String>recommendKeywords=newArrayList<>();recommendKeywords.add(recommendWords.getKeyword());mHistoriesView.setTextList(recommendKeywords);LogUtils.d(this,"搜索关键词=========>"+recommendKeywords);if(recommendWords==null){mRecommendContainer.setVisibility(View.GONE);}else{mRecommendContainer.setVisibility(View.VISIBLE);mRecommendView.setTextList(recommendKeywords);}}@OverridepublicvoidonError(){}@OverridepublicvoidonLoading(){}@OverridepublicvoidonEmpty(){}/**@OverridepublicvoidonItemClice(List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>item){//点击列表内容了该加载淘口令界面handleItemClick(item);LogUtils.d(this,"itemclick"+item.getTitle());}*/privatevoidhandleItemClick(SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBeanitem){//处理数据Stringtitle=item.getTitle();//商品详情的地址//Stringurl=item.getClickUrl();Stringurl=item.getCoupon_share_url();//淘口令if(TextUtils.isEmpty(url)){url=item.getUrl();}Stringcover=item.getPict_url();//拿到TiketPresenter去加载数据ITicketPresentertickePresenter=PresenterManager.getInstance().getTicketPresenter();tickePresenter.getTicket(title,url,cover);startActivity(newIntent(getContext(),TickeActivity.class));}@OverridepublicvoidonItemClice(SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBeanitem){handleItemClick(item);}}//presenter类packagecom.example.taobaounion.presenter.impl;importcom.example.taobaounion.model.Api;importcom.example.taobaounion.model.domain.Histories;importcom.example.taobaounion.model.domain.SearchRecommend;importcom.example.taobaounion.model.domain.SearchResult;importcom.example.taobaounion.presenter.ISearchPresenter;importcom.example.taobaounion.utils.JsonCacheUtil;importcom.example.taobaounion.utils.LogUtils;importcom.example.taobaounion.utils.RetrofitManager;importcom.example.taobaounion.view.ISearchViewCallback;importjava.net.HttpURLConnection;importjava.util.ArrayList;importjava.util.List;importretrofit2.Call;importretrofit2.Callback;importretrofit2.Response;importretrofit2.Retrofit;publicclassSearchPresenterimplementsISearchPresenter{privatefinalApimApi;privateISearchViewCallbackmSearchViewCallback=null;privateStringmCurrentKeyword=null;privatefinalJsonCacheUtilmJsonCacheUtil;privateStrings=null;publicSearchPresenter(){RetrofitManagerinstance=RetrofitManager.getInstance();Retrofitretrofit=instance.getmRetrofit();mApi=retrofit.create(Api.class);mJsonCacheUtil=JsonCacheUtil.getInstance();}publicstaticfinalintDEFAULT_PAGE=2;privateintmCurrentpage=DEFAULT_PAGE;@OverridepublicvoidgetHistories(){Historieshistories=mJsonCacheUtil.getValue(KEY_HISTORIES,Histories.class);if(mSearchViewCallback!=null){mSearchViewCallback.onHistoriesLoaded(histories);}}@OverridepublicvoiddelHistories(){mJsonCacheUtil.delCache(KEY_HISTORIES);if(mSearchViewCallback!=null){mSearchViewCallback.onHistoriesDeleted();}}publicstaticfinalStringKEY_HISTORIES="key_histories";publicstaticfinalintDEFAULT_HISTORIES_SIZE=10;privateintmHistoriesMaxSize=DEFAULT_HISTORIES_SIZE;/***添加历史记录*@paramhistory*/privatevoidSaveHistory(Stringhistory){Historieshistories=mJsonCacheUtil.getValue(KEY_HISTORIES,Histories.class);//如果有记录就更新记录List<String>historiesList=null;if(histories!=null&&histories.getHistories()!=null){historiesList=histories.getHistories();if(historiesList.contains(history)){historiesList.remove(history);}}if(historiesList==null){historiesList=newArrayList<>();}if(histories==null){histories=newHistories();}histories.setHistories(historiesList);//对记录个数进行限制if(historiesList.size()>mHistoriesMaxSize){historiesList=historiesList.subList(0,mHistoriesMaxSize);}//添加记录historiesList.add(history);//保存记录mJsonCacheUtil.saveCache(KEY_HISTORIES,histories);}@OverridepublicvoiddoSearch(Stringkeyword){//更新UI状态s=keyword;if(mSearchViewCallback!=null){mSearchViewCallback.onLoading();}Call<SearchResult>task=mApi.sea(mCurrentpage,s);//Call<SearchResult>task=mApi.sea(mCurrentpage,s);LogUtils.d(SearchPresenter.this,"页码+搜索词是=====》"+mCurrentpage+s);task.enqueue(newCallback<SearchResult>(){@OverridepublicvoidonResponse(Call<SearchResult>call,Response<SearchResult>response){intcode=response.code();LogUtils.d(this,"返回码code=====>"+code);LogUtils.d(this,"URL==========>"+response);if(code==HttpURLConnection.HTTP_OK){List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>mdata=response.body().getData().getTbk_dg_material_optional_response().getResult_list().getMap_data();mSearchViewCallback.onSearchSuccess(mdata);LogUtils.d(this,"搜索成功加载回来的结果========》"+mdata);}else{onError();}}@OverridepublicvoidonFailure(Call<SearchResult>call,Throwablet){t.printStackTrace();onError();}});if(mCurrentKeyword==null||!mCurrentKeyword.endsWith(keyword)){this.SaveHistory(keyword);this.mCurrentKeyword=keyword;}}privatevoidonError(){if(mSearchViewCallback!=null){mSearchViewCallback.onError();}}/**privateCall<SearchResult>createTask(intpage,Objectkeyword){StringSearchPagerUrl=UrlUtils.searchPagerUrl(page,keyword);Retrofitretrofit=RetrofitManager.getInstance().getmRetrofit();Apiapi=retrofit.create(Api.class);returnapi.sea(SearchPagerUrl);}*//**privatevoidhandleSearchResult(SearchResultResult){List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>map_data1=Result.getData().getTbk_dg_material_optional_response().getResult_list().getMap_data();if(mSearchViewCallback!=null){if(isResuliEmpty(map_data1)){//mSearchViewCallback.onEmpty();}else{mSearchViewCallback.onSearchSuccess(map_data1);}}}*/privatebooleanisResuliEmpty(List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>result){try{returnresult==null||result.size()==0;}catch(Exceptione){returnfalse;}}/***重新搜索*/@Overridepublicvoidresearch(){if(mCurrentKeyword==null){if(mSearchViewCallback!=null){mSearchViewCallback.onEmpty();}}else{//可以重新搜索doSearch(s);}}//搜索下拉加载更多@OverridepublicvoidloaderMoer(){mCurrentpage++;if(mCurrentKeyword==null){if(mSearchViewCallback!=null){mSearchViewCallback.onEmpty();}}else{//做搜索的事情doSearchMore();}}privatevoiddoSearchMore(){Call<SearchResult>task=mApi.sea(mCurrentpage,s);task.enqueue(newCallback<SearchResult>(){@OverridepublicvoidonResponse(Call<SearchResult>call,Response<SearchResult>response){intcode=response.code();LogUtils.d(this,"code=====>"+code);if(code==HttpURLConnection.HTTP_OK){SearchResultsearchResult=response.body();handleMoreSearchResult(searchResult);}else{onLoaderMoreError();}}@OverridepublicvoidonFailure(Call<SearchResult>call,Throwablet){t.printStackTrace();onLoaderMoreError();}});}/***处理搜索加载更多的结果*@param*/privatevoidhandleMoreSearchResult(SearchResultsearchResult){List<SearchResult.DataBean.TbkDgMaterialOptionalResponseBean.ResultListBean.MapDataBean>map_data=searchResult.getData().getTbk_dg_material_optional_response().getResult_list().getMap_data();if(mSearchViewCallback!=null){if(isResuliEmpty(map_data)){mSearchViewCallback.onMoreLoadedEmpty();}else{mSearchViewCallback.onMoreLoad(map_data);}}}//加载更多搜索内容失败privatevoidonLoaderMoreError(){if(mSearchViewCallback!=null){mSearchViewCallback.onMoreLoadedError();}}//获取搜索关键词@OverridepublicvoidgetRecommendWords(){Call<SearchRecommend>task=mApi.getRecommendWords();task.enqueue(newCallback<SearchRecommend>(){@OverridepublicvoidonResponse(Call<SearchRecommend>call,Response<SearchRecommend>response){intcode=response.code();if(code==HttpURLConnection.HTTP_OK){//获取成功处理结果if(mSearchViewCallback!=null){mSearchViewCallback.onRecommendWordsLoaded(response.body().getData());LogUtils.d(this,"SearchPresenter推荐搜索词=========>"+response.body().getData().toString());}}else{}}@OverridepublicvoidonFailure(Call<SearchRecommend>call,Throwablet){t.printStackTrace();}});}@OverridepublicvoidregisterViewCallback(ISearchViewCallbackcallback){this.mSearchViewCallback=callback;}@OverridepublicvoidunregisterViewCallback(ISearchViewCallbackcallback){this.mSearchViewCallback=null;}}

缺点：如果你的版本比要导入的版本低，有可能某些主题，某些api用不了而出现各种奇怪新手比较难解决的问题。所以如果你要改成你的版本的话，希望你的版本比较高。这样子出现问题的概率比较小。

通常来讲，我们会在愚人节的时候捉弄一下朋友，告诉朋友老师找他这类的话，那年的愚人节，我收到了一个奇怪的礼物。

看了一下我们的项目，我们的是使用了room这个第三方库，用于去管理数据库的，这么一看貌似是这个第三方库没有导进去，但是奇怪的是我们在dependencies中是没有看到这个库打印出来，并且在ExternalLibraries

看了一下我们的项目，我们的是使用了room这个第三方库，用于去管理数据库的，这么一看貌似是这个第三方库没有导进去，但是奇怪的是我们在dependencies中是没有看到这个库打印出来，并且在ExternalLibraries