Download Jar. Uses 1780K of libraries. Click here for Pure Java version (869L/6K).
!7 lib 1011900 // h2 import java.sql.*; p { Class.forName("org.h2.Driver"); Connection conn = DriverManager.getConnection("jdbc:h2:~/test", "sa", ""); S sql = "SELECT * FROM triple"; ResultSet rs = conn.createStatement().executeQuery(sql); while (rs.next()) { S webID = rs.getString("globalID"); int a = rs.getInt("a"); int b = rs.getInt("b"); int c = rs.getInt("c"); print(webID + ": " + a + " " + b + " " + c); } rs.close(); conn.close(); }
Began life as a copy of #1011901
download show line numbers debug dex old transpilations
Travelled to 13 computer(s): aoiabmzegqzx, bhatertpkbcr, cbybwowwnfue, cfunsshuasjs, gwrvuhgaqvyk, ishqpsrjomds, lpdgvwnxivlt, mqqgnosmbjvj, pyentgdyhuwx, pzhvpgtvlbxg, tslmcundralx, tvejysmllsmz, vouqrxazstgt
No comments. add comment
Snippet ID: | #1011903 |
Snippet name: | Connect to internal H2 Database (OK) |
Eternal ID of this version: | #1011903/2 |
Text MD5: | 5648640f9144fd2d06607b9c59859ba2 |
Transpilation MD5: | 3213f525f22b7aeb29ba65264358122e |
Author: | stefan |
Category: | javax / h2 database |
Type: | JavaX source code (desktop) |
Public (visible to everyone): | Yes |
Archived (hidden from active list): | No |
Created/modified: | 2017-11-09 10:22:44 |
Source code size: | 509 bytes / 23 lines |
Pitched / IR pitched: | No / No |
Views / Downloads: | 485 / 986 |
Version history: | 1 change(s) |
Referenced in: | #1011905 - Connect to H2 server, insert stuff (OK) |