RESTExample          
  
   
 


Get Action

RESTFul

/OpenForum/JarManager/JDBC/RESTExample/Employees /OpenForum/JarManager/JDBC/RESTExample/Employee/Last_Name/King

Server Side Javascript for GET method

request = transaction.getRequest(); request = request.substring( "/OpenForum/JarManager/JDBC/RESTExample".length ); if(request.length()==0) { transaction.setResult(transaction.SHOW_PAGE); } else { dbName = "xe"; db = js.getApi("/OpenForum/JarManager/JDBC"); parts = request.split('/'); if(parts[1]=="Employees") { query = "select * from Employees" } else if(parts[1]=="Employee") { query = "select * from Employees where "+parts[2]+" = '"+parts[3]+"'"; } else { transaction.sendPage( request+" "+parts[0]+" parts:"+parts.length ); return; } try{ result = db.query(dbName,query); } catch(e) { transaction.sendPage(e); } data = ""; columns = Number(result.getAttributeValueByName("columns")); xColumns = result.getElementByName("columns"); for(column=0;column<columns;column++) { data+="|__"+xColumns.getElementByIndex(column).getValue()+"__"; } data+="\n"; rows = result.getElementsByName("row"); for(row=0;row<rows.size();row++) { for(column=0;column<columns;column++) { data+="|"+rows.elementAt(row).getElementByIndex(column).getValue(); } data+="\n"; } page = wiki.buildPage( transaction.getRequest(),data,true ); transaction.sendPage(page); }
by Admin on 21/04/2008 at 10:08 PM