runs a write query that returns a key for insert's ID or update's affectedRows
val id = con.execute(query1).key
val ar = con.execute(query2).affectedRowsgets a single row of result providing a callback to build it
con.getOne(query) { rs ->
Person(rs.getString("name"), rs.getTimestamp("birthdate"))
}gets a list of results providing a callback to build each row
con.getList(query) { rs ->
Person(rs.getString("name"), rs.getTimestamp("birthdate"))
}You can use ResultBuilder to help you organize your model build
return true if there is any resulting row
con.exist(query)
returns the first column of the first resulting row
con.getFirstInt(query)returns a list of the first column of each row
con.getIntList(query)returns the first column of the first resulting row
con.getFirstLong(query)returns a list of the first column of each row
con.getLongList(query)returns the first column of the first resulting row
con.getFirstDouble(query)returns a list of the first column of each row
con.getDoubleList(query)returns the first column of the first resulting row
con.getFirstString(query)returns a list of the first column of each row
con.getStringList(query)returns the first column of the first resulting row
con.getFirstDate(query)returns a list of the first column of each row
con.getDateList(query)returns the first column of the first resulting row
con.getFirstBoolean(query)returns a list of the first column of each row
con.getBooleanList(query)