// Maven
<dependency>
<groupId>com.squareup.sqldelight</groupId>
<artifactId>sqldelight-jdbc-driver</artifactId>
<version>1.4.0</version>
</dependency>
// Gradle
implementation 'com.squareup.sqldelight:sqldelight-jdbc-driver:1.4.0'
sql
-- example.sq
SELECT * FROM users WHERE age > ?;
bash
$ sqldelight generate
import com.example.example.ExampleQueries;
import java.sql.*;
public class Main {
public static void main(String[] args) throws SQLException {
String url = "jdbc:yourDatabaseUrl";
Connection connection = DriverManager.getConnection(url);
ExampleQueries exampleQueries = new ExampleQueries(connection);
ResultSet resultSet = exampleQueries.getUsersAboveAge(18).executeQuery();
while (resultSet.next()) {
String name = resultSet.getString("name");
int age = resultSet.getInt("age");
System.out.println("Name: " + name + ", Age: " + age);
}
connection.close();
}
}
