· 10 years ago · May 19, 2016, 08:45 PM
1Connection c=null;
2try {
3 Class.forName("org.sqlite.JDBC");
4 c = DriverManager.getConnection("jdbc:sqlite:test.db");
5 Verb.createTable(c.createStatement());
6
7public static void createTable(Statement stmt) {
8 String sql = "CREATE TABLE IF NOT EXISTS Verb "
9 + "(id INTEGER PRIMARY KEY NOT NULL,"
10 + "infinitiv TEXT)";
11
12 try {
13 stmt.execute(sql);
14
15 } catch (SQLException e) {
16 // TODO Auto-generated catch block
17 e.printStackTrace();
18
19 }
20
21Class.forName("org.sqlite.JDBC");
22 c = DriverManager.getConnection("jdbc:sqlite:" + getFilesDir() + "/test.db");
23 Log.d("main", "task done");