Database database = new Database(new SimpleDataSource("jdbc:h2:mem:test", "sa", "", "org.h2.Driver"));
database.execute("CREATE TABLE Airport (id int auto_increment , IATA VARCHAR(3) , name VARCHAR2(255))");
database.insert("INSERT INTO Airport (IATA , name) VALUES( ? , ? )" , "TLL" , "Tallinn Ülemiste");
database.insert("INSERT INTO Airport (IATA , name) VALUES( ? , ? )" , "HEL" , "Helsinki Vaanta");
for( Record record : database.select("SELECT * FROM Airport ORDER BY name")){
System.out.println( record);
}
-
Notifications
You must be signed in to change notification settings - Fork 0
smkv/sqlutils
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published