如何将 JSON 字符串传递到我的 ColdFusion Web 服务中并返回成功/失败消息?

Question

我正在用ColdFusion编写一个简单的RESTful Web服务(cfc(，并希望将JSON字符串传递给同一个服务。像这样：

我写了如下内容：

{
"CustomerID": 100,
"UserName": "test",
"Password": "xxxxx",
}

另外，我想在验证后返回成功/失败消息。 知道我应该如何实现这一目标吗？

<cfcomponent rest="true" restpath="/folder">    
<cfscript>
record=deserializeJSON(
'{
"CustomerID": 100,
"UserName": "aimsweb",
"Password": "xxxxx",
}'
);
</cfscript>

<cffunction name="UserDetails" returnType="JSON" access="remote" HttpMethod="GET">
<cfargument name="Username" type="string" required="Yes">
<cfargument name="Password" type="string" required="Yes">
<cfargument name="CustomerID" type="string" required="Yes">
<cfset Form.CustomerID = arguments.CustomerID>
<cfset Form.Username = arguments.Username>
<cfset Form.Password = Hash(arguments.Password)>

<cfquery name="AW1Users" datasource="#request.app.dsn#">
SELECT * FROM tableName where UserName='xxxx'
</cfquery>  

<cfif AW1Users.RecordCount>
<cfthrow errorcode="200"                 
detail="Success"
message="Success"
type="Application">
<cfelseif AW1Users.CustomerID NEQ form.CustomerID>
<cfthrow errorcode="400"                 
detail="Customer Id doesn't exist"
message="Customer Id doesn't exist"
type="Application">                 
</cfif>
<cfreturn AW1Users>
</cffunction>
</cfcomponent>

Answer 1

您可以在 restful Web 服务中返回 cfheader。

未经 授权：

<cfheader statusCode = "401" statusText = "unauthorized">

或

<cfheader statusCode = "401" statusText = "Customer Id doesn't exist">

授权：

<cfheader statusCode = "200" statusText = "Authorized">

或

<cfheader statusCode = "200" statusText = "Success">

Helper URL for coldfusion restful webservice：

http://www.adobe.com/devnet/coldfusion/articles/restful-web-services.html

杰森：

<cfquery datasource="xxx" name="qGetRecords">
select userId, login, email from users limit 0,3
</cfquery>
<cfset dataset = [] />
<cfloop query="qGetRecords">
<cfset record = {} />
<cfset record["one"] = qGetRecords.userId />
<cfset record["two"] = qGetRecords.login />
<cfset record["three"] = qGetRecords.email />
<cfset ArrayAppend(dataset, record) />
</cfloop>
<!--- You can return this JSON  -->  
<cfoutput>
<p>#SerializeJSON(qGetRecords)#</p>
<p>#SerializeJSON(dataset)#</p>
</cfoutput>

希望会有所帮助