changeset 5:25e515cb5a35

Add Comments.
author Kazuma
date Thu, 01 Dec 2016 03:54:30 +0900
parents a2754aa62e7a
children 233bb94ec43a
files src/test/java/jp/ac/u_ryukyu/ie/cr/JDBCSqliteTest.java
diffstat 1 files changed, 5 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/src/test/java/jp/ac/u_ryukyu/ie/cr/JDBCSqliteTest.java	Thu Dec 01 03:46:38 2016 +0900
+++ b/src/test/java/jp/ac/u_ryukyu/ie/cr/JDBCSqliteTest.java	Thu Dec 01 03:54:30 2016 +0900
@@ -13,6 +13,10 @@
         try {
             Class.forName("org.sqlite.JDBC");
 
+            /*
+            - create db file on working directory. name ex. @windows -> C:/workingspace/test.db", @mac -> "jdbc:sqlite:workingspace/test.db
+            - do not need create table and columns in Sqlite console.
+             */
             Connection conn = DriverManager.getConnection("jdbc:sqlite:C:/sqlite/database.db");
 
             Statement stmt = conn.createStatement();
@@ -35,6 +39,7 @@
             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");
 
+            // get all children from root.
             while (rs.next()){
                 System.out.println("User ->  " + rs.getString("name"));
             }