查询聊天消息
<p>[TOC]</p>
<h5>简要描述</h5>
<ul>
<li>查询聊天消息</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><a href="http://localhost:30001/QueryDB">http://localhost:30001/QueryDB</a></li>
</ul>
<h5>请求方式</h5>
<ul>
<li>POST </li>
</ul>
<h5>参数</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">dbname</td>
<td style="text-align: left;">string</td>
<td>数据库文件名(注意区分大小写)</td>
</tr>
<tr>
<td style="text-align: left;">sql</td>
<td style="text-align: left;">string</td>
<td>查询语句</td>
</tr>
</tbody>
</table>
<h5>发送示例</h5>
<pre><code>{
&quot;dbname&quot;:&quot;MSG0.db&quot;,
&quot;sql&quot;:&quot;select * from MSG where StrTalker = '25350948040@chatroom'&quot;
}</code></pre>
<h5>返回示例</h5>
<pre><code>{
&quot;data&quot;: [
{
&quot;localId&quot;: &quot;35&quot;,
&quot;TalkerId&quot;: &quot;10&quot;,
&quot;MsgSvrID&quot;: &quot;2587501163508675819&quot;,
&quot;Type&quot;: &quot;1&quot;,
&quot;SubType&quot;: &quot;0&quot;,
&quot;IsSender&quot;: &quot;0&quot;,
&quot;CreateTime&quot;: &quot;1658807627&quot;,
&quot;Sequence&quot;: &quot;1658807627000&quot;,
&quot;StatusEx&quot;: &quot;0&quot;,
&quot;FlagEx&quot;: &quot;0&quot;,
&quot;Status&quot;: &quot;2&quot;,
&quot;MsgServerSeq&quot;: &quot;1&quot;,
&quot;MsgSequence&quot;: &quot;763738230&quot;,
&quot;StrTalker&quot;: &quot;25350948040@chatroom&quot;,
&quot;StrContent&quot;: &quot;[炸弹]酒泉、武威等多个地市确定27号开始资格复审,8月6日面试,面试时间紧张,省市县乡面试有啥区别??老师正在讲,快来听课,听课入口:https://i.offcn.com/c/1095614?mis=lht74958\n\n[嘴唇]成绩排名还没发布,大家可以扫码查,出排名前报名面试班,交200抢占2000,最高优惠15000元,课程私聊即可咨询!!&quot;,
&quot;Reserved0&quot;: &quot;0&quot;,
&quot;BytesExtra&quot;:&quot;\n\b&quot;
},
{
&quot;localId&quot;: &quot;36&quot;,
&quot;TalkerId&quot;: &quot;10&quot;,
&quot;MsgSvrID&quot;: &quot;5705531825961494711&quot;,
&quot;Type&quot;: &quot;3&quot;,
&quot;SubType&quot;: &quot;0&quot;,
&quot;IsSender&quot;: &quot;0&quot;,
&quot;CreateTime&quot;: &quot;1658807627&quot;,
&quot;Sequence&quot;: &quot;1658807627001&quot;,
&quot;StatusEx&quot;: &quot;0&quot;,
&quot;FlagEx&quot;: &quot;0&quot;,
&quot;Status&quot;: &quot;2&quot;,
&quot;MsgServerSeq&quot;: &quot;1&quot;,
&quot;MsgSequence&quot;: &quot;763738231&quot;,
&quot;StrTalker&quot;: &quot;25350948040@chatroom&quot;,
&quot;StrContent&quot;: &quot;&lt;?xml version=\&quot;1.0\&quot;?&gt;\n&lt;msg&gt;\n\t&lt;img aeskey=\&quot;e03658d85f4d491db938ec9919bccdb9\&quot; encryver=\&quot;0\&quot; cdnthumbaeskey=\&quot;\&quot; cdnthumburl=\&quot;\&quot; cdnthumblength=\&quot;0\&quot; cdnthumbheight=\&quot;0\&quot; cdnthumbwidth=\&quot;0\&quot; cdnmidheight=\&quot;0\&quot; cdnmidwidth=\&quot;0\&quot; cdnhdheight=\&quot;0\&quot; cdnhdwidth=\&quot;0\&quot; cdnmidimgurl=\&quot;\&quot; length=\&quot;0\&quot; tpthumburl=\&quot;https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&amp;t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&amp;p=3\&quot; tpthumblength=\&quot;158989\&quot; tpthumbheight=\&quot;0\&quot; tpthumbwidth=\&quot;0\&quot; tpthumbaeskey=\&quot;e03658d85f4d491db938ec9919bccdb9\&quot; tpurl=\&quot;https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&amp;t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&amp;p=2\&quot; tplength=\&quot;173494\&quot; tpheight=\&quot;2160\&quot; tpwidth=\&quot;2160\&quot; tpauthkey=\&quot;0A2B6F4E2D4D77415141414141436A6E4B576975452D756D687A67457A3348354A646E40696D2E7778776F726B10E083DCE706\&quot; tphdurl=\&quot;https://wwfile.work.weixin.qq.com/cgi-bin/download?f=3081900201020481883081850201000204235c386202030f55cb0204ae8e1e6f020462df6540044934376237373464332d383736302d346335622d623238632d3136353962633361363439385f66363262666335312d363563352d343666322d623138352d34343965393434663933313302010002030c97e0041060d10a04e0bf98459a62819a160c3ddb0201010201000400&amp;t=69A9B890E8BE6A01CF7417D090DA1AC5EA0BCEA3537DB9AFD1589D5CB060C9D73598628E7BE920F8BE4A27198520AB610CFFB26FEE6AE57CCED0F9E165C4DB4BBF04B71F08D079319A70FAEAA17138E2486E295F5718C84307F4922AB98BA9473657592C607BF5A1B61A2C2385B9EE8C5E426620DE83DBA6C5C62D9788FC73A231410EC6CBA8CB0F5BC6080A7706932D6BDD203850311C159A764637AC56E78FFD7BC1E0F4D5D6907A55E4D295EA4B986BAE5D54D604F4A05F988E5618A720E04D1A69E7C56BA077532DD0E59CDAD3AC8525252682DCB3BB5A0BB50099D72F8A775AEA3D2306566C7F56FAAA9181C468CB6996546F7329D43C3F622BBD8AD96F785B32852D5D7BE1300BDD0B9396BAF3DF266188A20913A4708B2546A43D5F9B04AF454F4A0951C787FF1FECED3D55BF95B368914DE3D42C7444D8E368EDE32A85668692FA4FB98859506EE7FCF298A08F1850FBB929FA83B80090A57C336328&amp;p=1\&quot; tphdlength=\&quot;825300\&quot; /&gt;\n&lt;/msg&gt;\n&quot;,
&quot;Reserved0&quot;: &quot;0&quot;,
&quot;BytesExtra&quot;:&quot;\n\b&quot;
}
]
}</code></pre>
<h5>返回参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">data</td>
<td style="text-align: left;">string</td>
<td>查询到的数据</td>
</tr>
</tbody>
</table>
<h5>备注</h5>
<ul>
<li>更多返回错误代码请看首页的错误代码描述</li>
</ul>