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