---+!! =paraworld.MQL.query= <div style="float: right; margin: 5px; width: 250px; color: #4e5155; background-color: #f0eded; border: #ccc 1px solid; padding: 5px"> *Contents* %TOC% </div> ---++ Description 执行传入的MQL语句,并将结果返回 MQL语法类似于简化了的T-SQL。 %BLUE%不区分%ENDCOLOR%大小字 %BLUE%不支持%ENDCOLOR%多表联合查询,%BLUE%不支持%ENDCOLOR%聚合函数,%BLUE%不支持%ENDCOLOR%Top语句; %BLUE%支持%ENDCOLOR%where、order by 、group by语句; %BLUE%支持%ENDCOLOR%的操作符:>, <, =, <>, >=, <=, is null, is not null, like ; %BLUE%支持%ENDCOLOR%的通配符:_(匹配任意单个字符), %(匹配任意多个字符); %BLUE%MQL特有关键字%ENDCOLOR%:<br/> PageSize: 用在where语句中,以分页的形式返回数据,该值指定每页的最大数据量,必须与PageIndex一起使用才起作用,否则忽略,若指定了PageIndex,却没有提供PageSize,则默认的每页最大数据量为10<br/> PageIndex:用在where语句中,以分页的形式返回数据,该值指定返回的页码,若指定了PageIndex,则必须指定Order by。<br/> 示例:select * from users where PageIndex = 0 and PageSize = 20 order by createDate desc //每页最多20条数据,返回第一页的数据 ---++ Parameters |*Required*|*Name*|*Type*|*Description*| |<font color="#4682b4">required</font>|query|%BLUE%string%ENDCOLOR%|规范的MQL语句| |<font color="#4682b4">optional</font>|appKey|%BLUE%string%ENDCOLOR%|应用程序Key| |^|sessionKey|%BLUE%string%ENDCOLOR%|用户凭证| ---++ Return XML (1)若是select语句,则返回类似于下面的XML格式: <verbatim> <msg xmlns=""> <users> <param index="1"> <uid type="string">f5f3de7a-05b2-42a0-bd78-415a939020c2</uid> <uname type="string">clayman</uname> <createDate type="string">2008-5-5 7:44:11</createDate> </param> <param index="2"> <uid type="string">6ea770c6-92b2-4b2b-86da-6f574641ec11</uid> <uname type="string">andy</uname> <createDate type="string">2008-5-5 7:36:12</createDate> </param> <param index="3"> <uid type="string">8ec11316-bc2e-491d-8f18-667501687e69</uid> <uname type="string">ParaEngine</uname> <createDate type="string">2008-5-5 7:36:05</createDate> </param> </users> <query type="string"> select uid,uname,createdate from users where pageindex = 0 and pagesize = 3 and createdate > '2008-1-1' order by createdate desc </query> </msg> </verbatim> (2)若是update、delete、insert语句,则返回类似于下面的XML: <verbatim> <msg> <isSuccess>true</isSuccess> <query type="string"> update users set email = 'aaa@gmail.com' where uid = 'f5f3de7a-05b2-42a0-bd78-415a939020c2' </query> </msg> </verbatim> (3)若发生异常,则返回类似于下面的XML: <verbatim> <msg> <errorCode>494</errorCode> <query type="string"> select uid,uname,createdate from users where pageindex = 0 and pagesize = 3 and createdate > '2008-1-1' </query> </msg> </verbatim> ---++ Tables [[Paraworld.MQL.Users][users]] <br/> __fields__ |*Name*|*Type*|*Description*| |<font color="#4682b4">uid</font>|GUID|用户的唯一标识符| |<font color="#4682b4">uname</font>|string|用户名| |<font color="#4682b4">createDate</font>|datetime|注册时间| |<font color="#4682b4">lastActivityDate</font>|datetime|最后活跃时间| |<font color="#4682b4">email</font>|string|用户的电子邮箱地址| |<font color="#4682b4">isOnline</font>|boolean|当前是否在线| __支持的MQL语句__ |select语句|支持| |update语句|不支持| |delete语句|不支持| |insert语句|不支持| [[Paraworld.MQL.Friends][friends]] <br/> __fields__ |*Name*|*Type*|*Description*| |<font color="#4682b4">uid1</font>|GUID|用户ID| |<font color="#4682b4">uid2</font>|GUID|好友的用户ID| __支持的MQL语句__ |select语句|支持| |update语句|不支持| |delete语句|不支持| |insert语句|不支持| ---++ Error Codes 当发生异常时,返回数据中会有一个“errorCode”节点,该节点记录了错误码。0:无异常 500:未知错误 499:提供的数据不完整 498:非法的访问 494:语法错误
Edit
|
Attach
|
P
rint version
|
H
istory
:
r12
|
r10
<
r9
<
r8
<
r7
|
B
acklinks
|
V
iew topic
|
Raw edit
|
More topic actions...
Topic revision: r8 - 2008-06-13
-
CaoYF
Home
Site map
CCWeb web
HaqiTeen web
Main web
ParaEngine web
TWiki web
Main Web
Users
Groups
Index
Search
Changes
Notifications
RSS Feed
Statistics
导航页WebTopMenu
Preferences
开发指南
Getting Started
ParacraftSDK
NPL
MCML
NPL Reference Manual
美术Mod
Account
Log In
English
简体中文
簡體中文
Edit
Attach
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback