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: | 717 / 1473 | 
| Version history: | 1 change(s) | 
| Referenced in: | [show references] |