I have a task at work ,using web services , to make communication between a web site based on Classic Asp & an application based on android platform , to create function with a parameter Date which provide data from the bd,i dont have any idea how to proceede , can u plz give me an example or tutos to follow ?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
回答1:
Your easiest option is to produce json (which can easily be consumed by the android side) like this:
ASP "service"
<!--
this is one example of a library of json helpers that you can use.
You can get it from this page
http://www.webdevbros.net/2007/04/26/generate-json-from-asp-datatypes/
http://www.webdevbros.net/wp-content/uploads/2008/07/json151.zip
save the downloaded json.asp file in the same folder as your .asp
-->
<!--#include file="json.asp" -->
<%
REM 1. Create and populate ADO Recordset from database
REM Note: I am providing just an example and you might
REM ant to look into using a more appropriate command type
REM or cursor type when populating your recordset
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "put your connection string here"
Set cmd = Server.CreateObject("ADODB.Command")
cmd.CommandType = adCmdText 'note must have this constant defined in scope'
Set cmdTemp.ActiveConnection = conn
cmd.CommandText = "put your SQL here; be careful to protect against SQL injections"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open cmd, ,adOpenForwardOnly,adLockReadOnly 'note make sure these constants are defined in scope'
REM 2. Prepare json
Dim jsonObject
Set jsonObject = New JSON 'JSON class is in the include file json.asp'
jsonResult = jsonObject.toJSON(Empty, rs, False) 'You may have to play with the parameters here, if the way json is formatted does not suit you'
'check the documentation of json.asp library'
REM 3. stream json to client
Response.ContentType = "application/json"
Response.Write jsonResult
%>
You could find more libraries that help format values or structures into JSON: just search for "classic ASP" + JSON on SO or google. Here's one library that takes vbscript/ASP structures and outputs them in JSON. Look at the SQL example.
Check this SO thread for more "classic" ASP and JSON