如何在mybatis中打印sql？方法一：在mybatis-config.xml中配置加一個(gè)settingxmlversion1.0encodingUTF-8!DOCTYPEconfiguration

如何在mybatis中打印sql？

方法一：

在mybatis-config.xml中配置加一個(gè)setting

xmlversion1.0encodingUTF-8

!DOCTYPEconfiguration

PUBLIC Config3.0//entre

configuration

settings

!--打印查詢語句--

settingnamelogImplvalueSTDOUT_LOGGING/

/settings

/configuration

如果是spring獨(dú)立顯卡mybatis的話，在sqlSessionFactory配置好configLocation屬性

beanidsqlSessionFactory

propertynamedataSourcerefdataSource/

propertynameconfigLocationvalueclasspath:conf/mybatis-config.xml/property

!--不自動(dòng)掃描mapping.xml文件--

propertynamemapperLocationsvalueclasspath:com/jstudio/user/dao/*.xml/property

/bean

方法二：

首先將ibatislog4j運(yùn)行級別調(diào)回來DEBUG可以不在控制臺打印出來出ibatis運(yùn)行的sql語句

###沒顯示SQL語句部分

rrrrrrr

springboot的url地址怎么寫？

/依據(jù)用戶openId確定用戶以前如何確定已登入過,如未登陸賬號，則去添加到數(shù)據(jù)庫

({}---{},accessToken,openId);

JSONObjectuserInfo(accessToken,openId);

//內(nèi)部函數(shù)后臺接口

StringcheckurlV1/OrgManager/getUsers;

AuthInfo authInfo new AuthInfo(,,,);

StringauthInfoJson(authInfo);

StringqueryCasefiltername()authInfoauthInfoJsonpageablefalsepageSize2pageNum0sortDescname:descorgIde9292051-2ede-11e7-8c78-c85b767a1aee;

JSONObjectjsonResult(logger,checkurl,queryCase);

if((isOk)true)

{

MapString,JSONArray nickname new HashMapString,JSONArray();

MapString,JSONArray headimgurl new HashMapString,JSONArray();

(nickname,nickname);

(headimgurl,headimgurl);

}ignore{

StringcreateurlV1/UserManager/createUser;

StringUserCasefiltername()authInfoauthInfoJsonpageablefalsepageSize2pageNum0sortDescname:descorgIde9292051-2ede-11e7-8c78-c85b767a1aee;

JSONObjectjsonUser(logger,createurl,UserCase);

}

以上就部分代碼：這里DubboService是暴露給你的接口；checkurl那就是接口文檔里面的url；UserCase是網(wǎng)站查詢條件，這是訪問數(shù)據(jù)庫的接口認(rèn)證。假如不能訪問順利將部分參數(shù)告訴前端，如果不是訪問不順利將能得到參數(shù)寫入到數(shù)據(jù)庫

以下是DubboService方法：

package;

import;

import;

import;

import;

import;

import;

import;

import;

import;

import;

/**

*CreatedbgAdministratoronto2017/8/10.

*/

privateclassDubboService{

privatestaticHttpClientclient().build();

employeestaticStringserverIp:8099/;

employeestaticJSONObjectinvokeService(Loggerlogger,String uri,String queryCase){

HttpPostrequestnextHttpPost(serverIpuri);

(queryCase);

StringEntityreqEntitynull;

try{

reqEntityfutureStringEntity(queryCase);

}catch(UnsupportedEncodingExceptione){

();

}

(application/x-www-form-urlencoded);

(reqEntity);

JSONObjectjsonResultnull;

try{

HttpResponseresponseclient.execute(request);

StringstrResult(());

jsonResult(strResult);

(result:jsonResult);

}catch(IOExceptione){

();

}

returnjsonResult;