Define a SQL select
query with parameters
indicated by ?
placeholders.
no subtypes hierarchy
Initializer |
Select(String sql) |
Attributes | |
limit | Source Codeshared variable Integer? limit An optional limit to the number of rows to return. |
Inherited Attributes |
Attributes inherited from: Object |
Methods | |
execute | Source Codeshared Row[] execute(Object* arguments) |
forEachRow | Source Codeshared void forEachRow(Object* arguments)(void do(Row row)) |
singleValue | Source Codeshared Value singleValue<Value>(Object* arguments) Execute this query with the given value count = sql.Select("select count(*) from table") .singleValue<Integer>(); |
Inherited Methods |
Methods inherited from: Object |
Nested Classes | |
Results | Source Codeshared Results Execute this query with the given Should be instantiated using try (results = sql.Select("select * from table").Results()) { for (row in results) { //read the row here } } |