<dependency>
<groupId>com.squareup.sqldelight</groupId>
<artifactId>jdbc-driver</artifactId>
<version>1.5.1</version>
</dependency>
groovy
implementation 'com.squareup.sqldelight:jdbc-driver:1.5.1'
sql
CREATE TABLE users (
id INTEGER PRIMARY KEY NOT NULL,
name TEXT NOT NULL
);
SELECT * FROM users;
sqldelight generate MyDatabase.sqlite3 --output src/main/java
groovy
plugins {
id "com.squareup.sqldelight" version "1.5.1"
}
sqldelight {
MyDatabase {
packageName = "com.example.db"
schemaOutputDirectory = outputDir
}
}
Class.forName("com.squareup.sqldelight.jdbc.JdbcSqliteDriver");
Connection connection = DriverManager.getConnection("jdbc:sqldelight:file:/path/to/database.db");
PreparedStatement statement = connection.prepareStatement("SELECT * FROM users");
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
System.out.println("User ID: " + id + ", Name: " + name);
}
resultSet.close();
statement.close();
connection.close();
