<dependency>
<groupId>com.squareup.sqldelight</groupId>
<artifactId>sqldelight-jdbc</artifactId>
<version>1.4.4</version>
<scope>runtime</scope>
</dependency>
groovy
implementation 'com.squareup.sqldelight:sqldelight-jdbc:1.4.4'
sql
-- database.sq
CREATE TABLE person (
id INTEGER PRIMARY KEY,
name TEXT,
age INTEGER
);
SELECT name, age FROM person;
sh
sqldelight database.sq
import com.squareup.sqldelight.*;
public class DatabaseHelper {
private Database database;
public DatabaseHelper() {
database = new Database(MySqliteOpenHelper.newInstance());
}
public void insertPerson(int id, String name, int age) {
database.personQueries.insertPerson(id, name, age);
}
public void updatePerson(int id, String name, int age) {
database.personQueries.updatePerson(name, age, id);
}
public void deletePerson(int id) {
database.personQueries.deletePerson(id);
}
public List<Person> getAllPersons() {
return database.personQueries.selectAllPersons().executeAsList();
}
}
import java.util.List;
public class Main {
public static void main(String[] args) {
DatabaseHelper dbHelper = new DatabaseHelper();
List<Person> persons = dbHelper.getAllPersons();
for (Person person : persons) {
}
dbHelper.deletePerson(1);
}
}
