Skip to main content

Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "EDT:Code snippets"

m (updated loop thru SQL result set)
Line 107: Line 107:
  
 
     //Loop through results and write out customer name
 
     //Loop through results and write out customer name
     while(rs.setNext())
+
     while(rs.getNext())
 
         get myCust from rs;
 
         get myCust from rs;
         Syslib.writeStdOut (Customer name: " + myCust.name);
+
         Syslib.writeStdOut ("Customer name: " + myCust.name);
 
     end
 
     end
  

Revision as of 12:14, 6 January 2012

Real code for real people!

Please share your code snippets!

General

Declare variable

NumberOfWeeks Int;

Declare constant

const NUMBEROFDAYS INT = 7;

Denote Nullability

myInt Int[]?;



Rich UI

Services

Dynamic URI

http HttpRest{request.uri="http:host\\myService"};
srvc IRest?;
srvc = ServiceLib.completeBind(srvc, http);

HTTP Request Headers

http HttpRest{};
http.request.headers = new Dictionary{key1="a value to pass to my service"};
srvc IRest?{@Resource {}};
srvc = ServiceLib.completeBind(srvc, http);

HTTP Request and Response

function invokeDoSomething()
    call srvc.doSomething() returning to serviceCallback;
end
 
function serviceCallback(returnValueOne String, callbackHttp IHTTP in)
  // process callback request or response
end

Database access

Record definition

 record CUSTOMER type Entity{@table{name = "CUSTOMER"}}
     NAME string
     COUNTRY string{@id};
     STATE string?;
     CUSTID string;
 end

Get a record

 function getCust{id String in} returns (Customer)
     ds SQLDataSource?{@resource {}};
     aCust Customer;
     get aCust from ds using(id);
     return (aCust);
 end

Add a record

 function addCust{customer Customer in}
     ds SQLDataSource?{@resource {}};
     add customer to ds;
 end

Loop through a SQL result set

 function loopCust()
     ds SQLDataSource?{@resource{bindingkey = "MyDB"}};
     rs SQLResultSet?;
 
     open rs from ds with #sql{
	SELECT * FROM CUSTOMER
     };
 
     myCust Customer;
 
     //Loop through results and write out customer name
     while(rs.getNext())
        get myCust from rs;
        Syslib.writeStdOut ("Customer name: " + myCust.name);
     end
 
 end


Share a code snippet

Edit this page by logging in to eclipse.org and clicking the Edit tab. Use the Wikitext editor to add a new snippet. Add the title using Heading 4. Use the source lang="java" tag to provide a background for your snippet and some syntax highlighting.

Back to the top