kotlin
implementation("com.squareup.sqldelight:gradle-plugin:$sqldelight_version")
implementation("com.squareup.sqldelight:sqlite-driver:$sqldelight_version")
implementation("org.xerial:sqlite-jdbc:$jdbc_version")
sql
CREATE TABLE user (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
age INTEGER
);
SELECT *
FROM user;
kotlin
plugins {
id("com.squareup.sqldelight")
}
sqldelight {
database("AppDatabase") {
packageName = "com.example.app"
}
}
kotlin
import java.sql.*
val connection: Connection = DriverManager.getConnection("jdbc:sqlite:database.db")
val statement: PreparedStatement = connection.prepareStatement("SELECT * FROM user")
val resultSet: ResultSet = statement.executeQuery()
while (resultSet.next()) {
val userId: Int = resultSet.getInt("id")
val userName: String = resultSet.getString("name")
val userAge: Int = resultSet.getInt("age")
println("User: $userName (ID: $userId, Age: $userAge)")
}
resultSet.close()
statement.close()
connection.close()
