我的类对象没有转换成json,我认为它返回对象引用,尽管在本地执行它时,它执行得很好。
这是代码
private def static sql private static List<ProductAlertsResponse> executeSelection(String query) { List<ProductAlertsResponse> prodAlerts=new ArrayList<ProductAlertsResponse>() sql.eachRow(query) { ProductAlertsResponse prodAlert=new ProductAlertsResponse((String)it.id,(String)it.name,(String)it.description,(String)it.active,(String)it.release_date) prodAlerts.add(prodAlert) } return prodAlerts } static main(args) { AppProperties.load() sql = Sql.newInstance("jdbc:oracle:thin:@"+AppProperties.get("hostname")+":"+AppProperties.get("port")+":"+AppProperties.get("service"), AppProperties.get("username"), AppProperties.get("password"),"oracle.jdbc.OracleDriver") List<ProductAlertsResponse> sqlResult=executeSelection("select ID,NAME,DESCRIPTION,ACTIVE,RELEASE_DATE from productinfo where ACTIVE='A'") def json = new groovy.json.JsonBuilder([response: sqlResult]) String response=json.toPrettyString() println "$response" }
这给了我以下回复
{ "response": [ { "active": "A", "release_date": "2011-09-23 00:00:00.0", "id": "1", "description": "Test", "name": "ABC7" }, { "active": "A", "release_date": "2012-01-19 00:00:00.0", "id": "5", "description": "Test1", "name": "ABC3" }, { "active": "A", "release_date": "2011-09-23 00:00:00.0", "id": "3", "description": "Test", "name": "ABC1" }, { "active": "A", "release_date": "2012-01-19 00:00:00.0", "id": "6", "description": "Test2", "name": "ABC2" } ] }
在我的服务器上运行它(struts和commons链)时,它给我以下json响应(在删除静态后)
{ "response": [ "com.est.dxclient.common.ProductAlertsResponse@67f797", "com.est.dxclient.common.ProductAlertsResponse@1e8f2a0", "com.est.dxclient.common.ProductAlertsResponse@c3d9ac", "com.est.dxclient.common.ProductAlertsResponse@7d8bb" ] }
注意: 我正在使用groovy 1.8.0
更新 添加服务器端代码
My server side class GetProductAlertsResponse implements Command { //Command is import org.apache.commons.chain.Command private def sql @Override public boolean execute(Context ctx) throws Exception { AppProperties.load() sql = Sql.newInstance("jdbc:oracle:thin:@"+AppProperties.get("hostname")+":"+AppProperties.get("port")+":"+AppProperties.get("service"), AppProperties.get("username"), AppProperties.get("password"),"oracle.jdbc.OracleDriver") List<ProductAlertsResponse> sqlResult=executeSelection("select ID,NAME,DESCRIPTION,ACTIVE,RELEASE_DATE from productinfo where ACTIVE='A'") def json = new groovy.json.JsonBuilder([response: sqlResult]) /*I am trying to debug the code here*/ println sqlResult.size() sqlResult.each{ println it.getName() } String response=json.toPrettyString() println "Inside commands $response" ctx.put(CSMContextParams.response,response) return false; } }
在控制台上打印
4 ABC7 ABC3 ABC1 ABC2 Inside commands [ "com.est.dxclient.common.ProductAlertsResponse@a63599", "com.est.dxclient.common.ProductAlertsResponse@156f14c", "com.est.dxclient.common.ProductAlertsResponse@9ba632", "com.est.dxclient.common.ProductAlertsResponse@bc5245" ]
这个答案可能会有所帮助-Grails JSONBuilder。
也许您的服务器代码使用了不同版本的Grails,或者在本地和服务器环境之间Grails的设置不同。