|
1
5 package org.h2.samples;
6
7 import java.sql.Connection  ;
8 import java.sql.DriverManager ;
9 import java.sql.Statement ;
10
11 import org.h2.tools.Backup;
12 import org.h2.tools.DeleteDbFiles;
13 import org.h2.tools.RunScript;
14
15 public class Compact {
16 public static void main(String [] args) throws Exception {
17 DeleteDbFiles.execute("data", "test", true);
18 Class.forName("org.h2.Driver");
19 Connection conn = DriverManager.getConnection("jdbc:h2:data/test", "sa", "");
20 Statement stat = conn.createStatement();
21 stat.execute("CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR)");
22 stat.execute("INSERT INTO TEST VALUES(1, 'Hello'), (2, 'World');");
23 conn.close();
24
25 System.out.println("Compacting...");
26 compact("data", "test", "sa", "");
27 System.out.println("Done.");
28
29 }
30
31 public static void compact(String dir, String dbName, String user, String password) throws Exception {
32 String url = "jdbc:h2:" + dir + "/" + dbName;
33 String script = "data/test.sql";
34 Backup.execute(url, user, password, script);
35 DeleteDbFiles.execute(dir, dbName, true);
36 RunScript.execute(url, user, password, script, null, false);
37 }
38 }
39 |
Popular Tags |
Java API By Example, From Geeks To Geeks.