Last week I introduced JoSQL, this week I continue to show a sample JoSQL query... we start off with a keep it simple (KISS) sample with some points to remember.
The goal of this JoSQL query is to get a list of contracts that all have a given product:
Query q = new Query();
q.parse("select * from com.sales.Contract where productId = :p");
QueryResults qr = q.execute(contracts);
- All JoSQL classes are kept in the org.josql package, Eclipse IDE will import these nicely for you.
- We start by creating a Query object instance this is where our query starts.
- q.parse will check your query for any issues, an exception will occure if the query is incorrect. Note that we need to provide the full package location of our Contract class else JoSQL wouldn't find the class. This can cause a problem if you refactor your code, like move the Contract class to a different package location but don't update the JoSQL query.
- The following line we set the :p variable using setVariable method.
- We then execute the query and put the results into qr which is an instance of QueryResults.
- contractResult will contain the result.