B4J Question JRDC2 return Json

[elitevenkat]

hi, I want to get the resultset as a json response. is it possible?

 

[josejad]

Type DBResult (Tag As Object, Columns As Map, Rows As List)

You get a DBResult, You can create a map with the column name and the values, and then create a json with jsonGenerator

 

[aeric]

Sub ReturnJSON(map As Map, resp As ServletResponse)
    resp.ContentType = "application/json"
    resp.Write(Map2Json(map))
End Sub

[B4J] [MySQL] [API] Server (Key + Token) and [B4X] User Login Apps

Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/ Finally I would like to share my B4J API server written in B4J. Compare to my previous PHP API, this API server implements user...

www.b4x.com

 

[elitevenkat]

Thanks @aeric

 

[aeric]

Here is another sample:

JQuiz - API Server for B4XQuiz

This is the full source code for B4XQuiz server. SQL script to generate database in post #2 For B4XQuiz client app, please check: https://www.b4x.com/android/forum/threads/b4jquiz-desktop-app.124202/ Update It is now easier to create Web API Server using B4X Template Check...

www.b4x.com