implementation 'com.squareup.sqldelight:jdbc-driver:<version>'
sql
CREATE TABLE user (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL
);
SELECT * FROM user WHERE id = ?;
./gradlew generateSqlDelightInterface
import com.squareup.sqldelight.sqlite.driver.JdbcSqliteDriver;
import com.example.generated.ExampleQueries;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;
public class ExampleApp {
public static void main(String[] args) {
try (Connection connection = DriverManager.getConnection("jdbc:sqlite:path/to/database.db")) {
JdbcSqliteDriver driver = new JdbcSqliteDriver(connection);
ExampleQueries exampleQueries = new ExampleQueries(driver);
List<ExampleQueries.User> users = exampleQueries.selectUser(1).executeAsList();
for (ExampleQueries.User user : users) {
System.out.println("User: " + user.name());
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
