Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejava
titlePobranie przydatnych obiektów
linenumberstrue
		SQLFinder finder = FinderFactory.getSQLFinder();//udostępnia metody wyszukujące
        SQLBuilder builder = SQLBuilder.getInstance();//pozwala zdefniować zapytanie
        

Podstawowe możliwości

Code Block
languagejava
titleProste zapytanie SELECT
linenumberstrue
		//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

...