34 lines
721 B
Markdown
34 lines
721 B
Markdown
# Query API (RU)
|
||
|
||
Raw SQL через `api.query()` с биндингом параметров.
|
||
|
||
## Execute
|
||
|
||
```java
|
||
int rows = api.query().execute(
|
||
"UPDATE players SET level = level + 1 WHERE id = ?",
|
||
java.util.Collections.singletonList(1)
|
||
);
|
||
```
|
||
|
||
## Query
|
||
|
||
```java
|
||
List<String> names = api.query().query(
|
||
"SELECT name FROM players WHERE level >= ?",
|
||
java.util.Collections.singletonList(10),
|
||
rs -> rs.getString("name")
|
||
);
|
||
```
|
||
|
||
## Транзакции
|
||
|
||
```java
|
||
try (Transaction tx = api.beginTransaction()) {
|
||
tx.execute("UPDATE players SET level = level + 1 WHERE id = ?", java.util.Collections.singletonList(1));
|
||
tx.commit();
|
||
} catch (Exception ex) {
|
||
// rollback при ошибке
|
||
}
|
||
```
|