...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
SQLFinder finder = FinderFactory.getSQLFinder();//udostępnia metody wyszukujące
SQLBuilder builder = SQLBuilder.getInstance();//pozwala zdefniować zapytanie
|
Podstawowe możliwości
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
//proste zapytanie
builder.setQuery( "select * from testtable" );
builder.addScalar( "boolcol", StandardBasicTypes.BOOLEAN );
builder.addScalar( "textcol", StandardBasicTypes.STRING );
builder.addScalar( "datecol", StandardBasicTypes.DATE );
builder.addScalar( "intcol", StandardBasicTypes.INTEGER );
builder.addScalar( "doublecol", StandardBasicTypes.DOUBLE );
List<Map<String,Object>> data=finder.find( builder );//wykonanie zapytania |
...