changeset 3:c191aabf698f

Add jar file.
author Kazuma
date Thu, 01 Dec 2016 03:43:48 +0900
parents aebf5df61545
children a2754aa62e7a
files lib/sqlite-jdbc-3.8.6.jar src/test/java/jp/ac/u_ryukyu/ie/cr/JDBCSqliteTest.java
diffstat 2 files changed, 49 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
Binary file lib/sqlite-jdbc-3.8.6.jar has changed
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/test/java/jp/ac/u_ryukyu/ie/cr/JDBCSqliteTest.java	Thu Dec 01 03:43:48 2016 +0900
@@ -0,0 +1,49 @@
+package jp.ac.u_ryukyu.ie.cr;
+
+import org.junit.Test;
+
+import java.sql.*;
+
+/**
+ * Created by 和馬 on 2016/12/01.
+ */
+public class JDBCSqliteTest {
+    @Test
+    public void GetConnect () throws SQLException, ClassNotFoundException {
+        try {
+            Class.forName("org.sqlite.JDBC");
+
+            Connection conn = DriverManager.getConnection("jdbc:sqlite:C:/sqlite/database.db");
+
+            Statement stmt = conn.createStatement();
+
+            stmt.executeUpdate("drop table if exists user");
+            stmt.executeUpdate("drop table if exists type");
+
+            stmt.executeUpdate("create table user (id integer, name string, age integer, type_id integer, parent_id integer, FOREIGN KEY(parent_id) references user (id))");
+            stmt.executeUpdate("create table type (id integer, name string)");
+
+            stmt.executeUpdate("insert into type values(1, 'Teacher')");
+            stmt.executeUpdate("insert into type values(2, 'Student')");
+
+            stmt.executeUpdate("insert into user values(1, 'Kono', 40, 1, null)");
+            stmt.executeUpdate("insert into user values(2, 'Kanagawa', 30, 1, 1)");
+            stmt.executeUpdate("insert into user values(3, 'Takeda', 20, 2, 2)");
+            stmt.executeUpdate("insert into user values(4, 'Miyagi', 21, 2, 2)");
+            stmt.executeUpdate("insert into user values(5, 'Higashionna', 22, 2, 2)");
+
+            ResultSet get_user = stmt.executeQuery("select * from user where name=\'Kono\'");
+            ResultSet rs = stmt.executeQuery("with recursive n as (select * from user where id="+ get_user.getInt("id") +" union all select user.* from user, n where user.parent_id = n.id) select * from n");
+
+            while (rs.next()){
+                System.out.println("User ->  " + rs.getString("name"));
+            }
+
+            stmt.close();
+            conn.close();
+
+        } catch (ClassNotFoundException e) {
+            e.printStackTrace();
+        }
+    }
+}