質問編集履歴

ソースを修正

2018/09/23 05:03

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -140,7 +140,7 @@
 }
+```
 ### 試したこと

必要でない部分を削除

2018/09/23 05:03

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -140,328 +140,6 @@
 }
-```
-```ここに言語を入力
-package com.example.lavi.mojitest;
-import android.content.Context;
-import android.content.res.AssetManager;
-import android.database.SQLException;
-import android.database.sqlite.SQLiteDatabase;
-import android.database.sqlite.SQLiteOpenHelper;
-import android.database.sqlite.SQLiteStatement;
-import android.util.Log;
-import java.io.BufferedReader;
-import java.io.IOException;
-import java.io.InputStream;
-import java.io.InputStreamReader;
-import java.util.ArrayList;
-import java.util.Iterator;
-import java.util.List;
-public class WordsDatabaseHelper extends SQLiteOpenHelper {
-    static final private String DB_NAME = "words.sqlite";
-    static final private int VERSION = 1;
-    private String[] fileName={"category","data","large","middle","small","lang"};
-    private Context context;
-    private String[] data;
-    private int[][] intData;
-    int intCol;
-    public WordsDatabaseHelper(Context context) {
-        super(context, DB_NAME, null, VERSION);
-        this.context = context;
-    }
-    @Override
-    public void onOpen(SQLiteDatabase db) {
-        super.onOpen(db);
-    }
-    private void buildTable(SQLiteDatabase db){
-        String[] createSQL={
-                "CREATE TABLE [category] (" +
-                        "[category_id] INTEGER NOT NULL UNIQUE," +
-                        "[large_id] INTEGER DEFAULT '0'," +
-                        "[middle_id] INTEGER DEFAULT '0'," +
-                        "[small_id] INTEGER DEFAULT '0'," +
-                        "[lang_id] INTEGER DEFAULT '0'," +
-                        "[sample] VARCHAR(255),\n" +
-                        "PRIMARY KEY([category_id])" +
-                        ");"
-                ,"CREATE TABLE [data](" +
-                "[category_id] INTEGER, " +
-                "[number] INTEGER, " +
-                "[data] VARCHAR(255), " +
-                "PRIMARY KEY([category_id],[number])" +
-                ");"
-                ,"CREATE TABLE [large](" +
-                "[large_id] INTEGER PRIMARY KEY, " +
-                "[large] VARCHAR(255));"
-                ,"CREATE TABLE [middle](" +
-                "[middle_id] INTEGER PRIMARY KEY, " +
-                "[large_id] INTEGER, " +
-                "[middle_num] INTEGER, " +
-                "[middle] VARCHAR(255));"
-                ,"CREATE TABLE [small](" +
-                "[small_id] INTEGER PRIMARY KEY, " +
-                "[small] VARCHAR(255));"
-                ,"CREATE TABLE [lang](" +
-                "[lang_id] INTEGER PRIMARY KEY," +
-                "[lang] VARCHAR(255));"
-        };
-        String[] insertSQL={
-                " (category_id,large_id,middle_id,small_id,lang_id,sample) VALUES(?,?,?,?,?,?)",
-                " (category_id,number,data) VALUES(?,?,?)",
-                " (large_id,large) VALUES(?,?)",
-                " (middle_id,large_id,middle_num,middle) VALUES(?,?,?,?)",
-                " (small_id,small) VALUES(?,?)",
-                " (lang_id,lang) VALUES(?,?)"};
-        for (int i = 0; i < fileName.length; i++) {
-            List<String> strList=readFile(fileName[i]);
-            db.execSQL(createSQL[i]);
-            db.beginTransaction();
-            try {
-                for (int j = 1; j <strList.size()-1; j++) {
-                    String[] strValue=(strList.get(j).split(","));
-                    SQLiteStatement sql = db.compileStatement(
-                            "INSERT INTO "+fileName[i]+insertSQL[i]);
-                    for (int k = 0; k <strValue.length ; k++) {
-                        strValue[k]=strValue[k].replaceAll("\"","");//余計な"を消す
-                        if(isNum(strValue[k])) {
-                            sql.bindLong(k+1, Integer.valueOf(strValue[k]));
-                        }else {
-                            sql.bindString(k+1, strValue[k]);
-                        }
-                    }
-                    sql.executeInsert();
-                }
-                db.setTransactionSuccessful();
-            } catch (SQLException e) {
-                e.printStackTrace();
-            } finally {
-                db.endTransaction();
-            }
-        }
-    }
-    private boolean isNum(String number) {
-        try {
-            Integer.parseInt(number);
-            return true;
-        } catch (NumberFormatException e) {
-            return false;
-        }
-    }
-    private List<String> readFile(String filename){
-        //csvファイル読み込み
-        AssetManager assetManager = context.getResources().getAssets();
-        List<String> list = null;
-        try {
-            InputStream inputStream = assetManager.open(filename+".csv");
-            InputStreamReader inputStreamReader = new InputStreamReader(inputStream);
-            BufferedReader br = new BufferedReader(inputStreamReader);
-            String line;
-            list = new ArrayList<String>();
-            line = br.readLine();
-            while ((line = br.readLine()) != null) {
-                list.add(line);
-            }
-            br.close();
-        } catch (IOException e) {
-            e.printStackTrace();
-        }
-        return list;
-    }
-    @Override
-    public void onCreate(SQLiteDatabase db) {
-        buildTable(db);
-    }
-    @Override
-    public void onUpgrade(SQLiteDatabase db, int old_v, int new_v) {
-        db.execSQL("DROP TABLE IF EXISTS words");
-        onCreate(db);
-    }
-}
-```
 ### 試したこと
@@ -480,8 +158,6 @@
 ### 補足情報（FW/ツールのバージョンなど）
-windows10 64bit
 android studio 3.1.4
  classpath 'com.android.tools.build:gradle:3.1.4'

開発環境追記

2018/09/23 05:02

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -338,8 +338,6 @@
                         if(isNum(strValue[k])) {
-                            Log.d("", "にゃ："+i+"j="+k+"val="+strValue[k]);
                             sql.bindLong(k+1, Integer.valueOf(strValue[k]));
                         }else {
@@ -482,7 +480,21 @@
 ### 補足情報（FW/ツールのバージョンなど）
+windows10 64bit
+android studio 3.1.4
+ classpath 'com.android.tools.build:gradle:3.1.4'
+   testImplementation 'junit:junit:4.12'
+    testImplementation 'org.hamcrest:hamcrest-library:1.3'
+    androidTestImplementation 'com.android.support.test:runner:1.0.2'
+    androidTestImplementation 'com.android.support.test.espresso:espresso-core:3.0.2'
-    compileSdkVersion 27
+ compileSdkVersion 27
         minSdkVersion 16

継承したクラスのソースを追加しました。

2018/09/22 08:16

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -142,6 +142,328 @@
 ```
+```ここに言語を入力
+package com.example.lavi.mojitest;
+import android.content.Context;
+import android.content.res.AssetManager;
+import android.database.SQLException;
+import android.database.sqlite.SQLiteDatabase;
+import android.database.sqlite.SQLiteOpenHelper;
+import android.database.sqlite.SQLiteStatement;
+import android.util.Log;
+import java.io.BufferedReader;
+import java.io.IOException;
+import java.io.InputStream;
+import java.io.InputStreamReader;
+import java.util.ArrayList;
+import java.util.Iterator;
+import java.util.List;
+public class WordsDatabaseHelper extends SQLiteOpenHelper {
+    static final private String DB_NAME = "words.sqlite";
+    static final private int VERSION = 1;
+    private String[] fileName={"category","data","large","middle","small","lang"};
+    private Context context;
+    private String[] data;
+    private int[][] intData;
+    int intCol;
+    public WordsDatabaseHelper(Context context) {
+        super(context, DB_NAME, null, VERSION);
+        this.context = context;
+    }
+    @Override
+    public void onOpen(SQLiteDatabase db) {
+        super.onOpen(db);
+    }
+    private void buildTable(SQLiteDatabase db){
+        String[] createSQL={
+                "CREATE TABLE [category] (" +
+                        "[category_id] INTEGER NOT NULL UNIQUE," +
+                        "[large_id] INTEGER DEFAULT '0'," +
+                        "[middle_id] INTEGER DEFAULT '0'," +
+                        "[small_id] INTEGER DEFAULT '0'," +
+                        "[lang_id] INTEGER DEFAULT '0'," +
+                        "[sample] VARCHAR(255),\n" +
+                        "PRIMARY KEY([category_id])" +
+                        ");"
+                ,"CREATE TABLE [data](" +
+                "[category_id] INTEGER, " +
+                "[number] INTEGER, " +
+                "[data] VARCHAR(255), " +
+                "PRIMARY KEY([category_id],[number])" +
+                ");"
+                ,"CREATE TABLE [large](" +
+                "[large_id] INTEGER PRIMARY KEY, " +
+                "[large] VARCHAR(255));"
+                ,"CREATE TABLE [middle](" +
+                "[middle_id] INTEGER PRIMARY KEY, " +
+                "[large_id] INTEGER, " +
+                "[middle_num] INTEGER, " +
+                "[middle] VARCHAR(255));"
+                ,"CREATE TABLE [small](" +
+                "[small_id] INTEGER PRIMARY KEY, " +
+                "[small] VARCHAR(255));"
+                ,"CREATE TABLE [lang](" +
+                "[lang_id] INTEGER PRIMARY KEY," +
+                "[lang] VARCHAR(255));"
+        };
+        String[] insertSQL={
+                " (category_id,large_id,middle_id,small_id,lang_id,sample) VALUES(?,?,?,?,?,?)",
+                " (category_id,number,data) VALUES(?,?,?)",
+                " (large_id,large) VALUES(?,?)",
+                " (middle_id,large_id,middle_num,middle) VALUES(?,?,?,?)",
+                " (small_id,small) VALUES(?,?)",
+                " (lang_id,lang) VALUES(?,?)"};
+        for (int i = 0; i < fileName.length; i++) {
+            List<String> strList=readFile(fileName[i]);
+            db.execSQL(createSQL[i]);
+            db.beginTransaction();
+            try {
+                for (int j = 1; j <strList.size()-1; j++) {
+                    String[] strValue=(strList.get(j).split(","));
+                    SQLiteStatement sql = db.compileStatement(
+                            "INSERT INTO "+fileName[i]+insertSQL[i]);
+                    for (int k = 0; k <strValue.length ; k++) {
+                        strValue[k]=strValue[k].replaceAll("\"","");//余計な"を消す
+                        if(isNum(strValue[k])) {
+                            Log.d("", "にゃ："+i+"j="+k+"val="+strValue[k]);
+                            sql.bindLong(k+1, Integer.valueOf(strValue[k]));
+                        }else {
+                            sql.bindString(k+1, strValue[k]);
+                        }
+                    }
+                    sql.executeInsert();
+                }
+                db.setTransactionSuccessful();
+            } catch (SQLException e) {
+                e.printStackTrace();
+            } finally {
+                db.endTransaction();
+            }
+        }
+    }
+    private boolean isNum(String number) {
+        try {
+            Integer.parseInt(number);
+            return true;
+        } catch (NumberFormatException e) {
+            return false;
+        }
+    }
+    private List<String> readFile(String filename){
+        //csvファイル読み込み
+        AssetManager assetManager = context.getResources().getAssets();
+        List<String> list = null;
+        try {
+            InputStream inputStream = assetManager.open(filename+".csv");
+            InputStreamReader inputStreamReader = new InputStreamReader(inputStream);
+            BufferedReader br = new BufferedReader(inputStreamReader);
+            String line;
+            list = new ArrayList<String>();
+            line = br.readLine();
+            while ((line = br.readLine()) != null) {
+                list.add(line);
+            }
+            br.close();
+        } catch (IOException e) {
+            e.printStackTrace();
+        }
+        return list;
+    }
+    @Override
+    public void onCreate(SQLiteDatabase db) {
+        buildTable(db);
+    }
+    @Override
+    public void onUpgrade(SQLiteDatabase db, int old_v, int new_v) {
+        db.execSQL("DROP TABLE IF EXISTS words");
+        onCreate(db);
+    }
+}
+```
 ### 試したこと

2018/09/22 07:28

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

File without changes