編集履歴

質問編集履歴

微修正

2017/02/03 04:23

投稿

rain_sun

スコア12

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -282,4 +282,6 @@
     }
+}
-}```
+```

修正

2017/02/03 04:22

投稿

rain_sun

スコア12

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -6,33 +6,105 @@
 ###発生している問題・エラーメッセージ
+DBを読み込む際に
+末尾のデータが
-SQLiteに保存する際に
+listviewに表示されない
-一つ遅れて保存されます
-###MainActivity.java
+###SqlLoad.java
 ```
+package com.example.innovation.f_featnote;
+import android.app.Activity;
+import android.app.ListActivity;
+import android.content.Context;
+import android.content.Intent;
+import android.database.Cursor;
+import android.database.sqlite.SQLiteDatabase;
+import android.database.sqlite.SQLiteException;
+import android.database.sqlite.SQLiteOpenHelper;
+import android.os.Bundle;
+import android.provider.ContactsContract;
+import android.util.Log;
+import android.view.LayoutInflater;
+import android.view.View;
+import android.view.ViewGroup;
+import android.widget.AdapterView;
+import android.widget.ArrayAdapter;
+import android.widget.BaseAdapter;
+import android.widget.Button;
+import android.widget.ListView;
+import android.widget.TextView;
+import android.widget.Toast;
+import com.example.innovation.f_featnote.SubOpenHelper;
+import com.example.innovation.f_featnote.MainActivity;
+import java.util.ArrayList;
+import java.util.Arrays;
-import 省略
+import java.util.List;
+/**
+ * Created by Innovation on 2017/01/26.
+ */
-public class MainActivity extends AppCompatActivity
+public class SqlLoad extends Activity {
+    ListView lv;
+    static String[][] list;
-        implements View.OnClickListener {
+    static String[] Did = new String[2];
-    //前準備
-    static int Tflg;
+    static long id_;
-    //外クラス参照用
+    static boolean[] flg;
+    static String[] Data;
+    private final int WC = ViewGroup.LayoutParams.WRAP_CONTENT;
@@ -42,512 +114,172 @@
         super.onCreate(savedInstanceState);
-        setContentView(R.layout.activity_main);
+        setContentView(R.layout.sql_load);
-        Button textSave = (Button) findViewById(R.id.Text_Save);
+       // final boolean[] flg = new boolean[1];
-        Button textLoad = (Button) findViewById(R.id.Text_Load);
-        textSave.setOnClickListener(this);
+        Main();
-        textLoad.setOnClickListener(this);
-    }
+    }
+    public void Main(){
+        Data = SQLDataGet();
+       // lv = new ListView(this);
+    //    ArrayList<String> Data = new ArrayList<>(Arrays.asList(SQLDataGet()));
+        lv = (ListView)findViewById(R.id.sql_load_main);
+        ArrayAdapter<String> adapter = new ArrayAdapter<>(this, android.R.layout.simple_expandable_list_item_1, Data);
+        lv.setAdapter(adapter);//リスト表示
+     //   setContentView(lv,new ViewGroup.LayoutParams(WC,WC));
+        lv.setOnItemClickListener(new AdapterView.OnItemClickListener(){
+            @Override
+            public void onItemClick(AdapterView<?> parent,View view,int position,long id){
+                //  ListView listView = (ListView) parent;
+                //   String item = (String)listView.getItemAtPosition(position);
+                Log.d("id",""+id);
+                id_ = id;
+                SQLDContentGet();
+                SQLDataSet();
+                finish();
+                // Toast.makeText(getApplicationContext(),item + "clicked",Toast.LENGTH_LONG).show();
+            }
+        });
+    }
+    public String[] SQLDataGet(){
+        MainActivity main = new MainActivity();
+        Context con = this;
+        List ls = null;
+        SQLiteDatabase sdb = main.SQLopen(con.getApplicationContext());//MainActivity参照
+        final String[] columns = new String[]{"title","content","date"};//列名
+        String where = null;//条件
+        String[] Args = new String[]{""};//？の置き換え
+        Cursor c = sdb.query("MemoContents", columns,where, null, null, null, null);
+        int startPostion = c.getPosition();
+        c.moveToFirst();
+        Log.d("DBG",""+c.getCount());
+        list = new String[c.getCount()-1][columns.length];
+        String[] Dlist = new String[c.getCount()-1];
+        for (int i = 0; i< list.length; i++){
+            for (int j = 0; j < list[1].length; j++){
+                list[i][j] = c.getString(j);
+                Log.d(i+"-"+j,list[i][j]);//デバッグ
+                Dlist[i] = list[i][0];
+            }
+            c.moveToNext();
+        }
+        c.moveToPosition(startPostion);
-    //前準備 ここまで
+      //  finish();
+        return Dlist;
+    }
+    public void SQLDContentGet(){
+        Did[0] = list[(int)id_][0];
+        Did[1] = list[(int)id_][1];
+    }
+    public void SQLDataSet(){
+        Intent data = new Intent();
+        Bundle bundle = new Bundle();
+        data.putExtra("key.data",Did);
+        data.putExtras(bundle);
+        setResult(RESULT_OK,data);
+        finish();
+    }
     @Override
-    //クリックイベント（一括管理）
-    public void onClick(View v) {
-        switch (v.getId()) {
-            case R.id.Text_Load://読み込み
-          省略
-            case R.id.Text_Save://保存
-                AlertDialog.Builder alertDlg2 = new AlertDialog.Builder(this);
-                final Toast toast2 = Toast.makeText(this, R.string.Text_Save_Error, Toast.LENGTH_LONG);
-                final Toast toast3 = Toast.makeText(this, R.string.Text_Saved, Toast.LENGTH_LONG);
-                alertDlg2.setTitle(R.string.Save_check_T);
-                alertDlg2.setMessage(R.string.Save_check_C);
-                alertDlg2.setPositiveButton(
-                        R.string.Save_check_O,
-                        new DialogInterface.OnClickListener() {
-                            public void onClick(DialogInterface dialog, int which) {
-                                //OK処理
-                                boolean flg = Flist(2);
-                                if (flg == false){
-                                    MainActivity.Tflg = 1;
-                                }else {
-                                    MainActivity.Tflg = 2;
-                                }
-                                switch (Tflg){
-                                    case 1:
-                                        toast2.show();
-                                        break;
-                                    case 2:
-                                        toast3.show();
-                                        break;
-                                }
-                            }
-                        });
-                alertDlg2.setNegativeButton(
-                        R.string.Save_check_N,
-                        new DialogInterface.OnClickListener() {
-                            public void onClick(DialogInterface dialog, int which) {
-                                //キャンセル処理
-                            }
-                        });
-                alertDlg2.create().show();//ダイアログ呼び出し
-                break;
-        }
-    }
-    public boolean Flist(int c) {//R/W処理 引数分岐
-        switch (c) {
-            case 1://txt出力用
-                Fsavetxt();
-                break;
-            case 2://SQLite出力用
-                boolean flg = FsaveSQL();
-                return flg;
-            case 3://sdカード書き込み実装用
-                break;
-            case 4://txt読み込み
-                Fload();
-                break;
-            case 5://SQLite読み込み
-                FSelectSQL();
-                break;
-        }
-        return true;
-    }
-    public void Fsavetxt() {//保存処理 txt
-        String path = DateG(1);
-        EditText con = (EditText) findViewById(R.id.Text_Main);
-        SpannableStringBuilder content = (SpannableStringBuilder) con.getText();
-        OutputStream Csave;
-        try
-        {
-            Csave = openFileOutput(path, MODE_PRIVATE | MODE_APPEND);
-            PrintWriter writer = new PrintWriter(Csave, true);
-            writer.println(ContentG(0));//書き込み
-            writer.close();//終了
-        } catch (
-                IOException e
-                )
-        {
-            e.printStackTrace();
-        }
-    }
-    public boolean FsaveSQL() {//保存処理 SQL
-        SQLiteDatabase sdb = SQLopen();
-        ContentValues values = new ContentValues();
-        String tit = ContentG(1);
-        String con = ContentG(0);
-        if (tit == null || con == null || tit.length() == 0 || con.length() == 0) {
-            return false;
-        }
-        values.put("title", tit);
-        values.put("content", con);
-        values.put("date", DateG(2));
-        long id = sdb.insert("MemoContents", null, values);
-        if (id < 0){}
-        return true;
-    }
-    public void Fload() {//txt読み込み
-        FileListDialog dialog = new FileListDialog(this);
-        dialog.setDirectorySelect(false);
-        dialog.setOnFileListDialogListener(new FileListDialog.onFileListDialogListener() {//ファイル選択ダイアログ
-            @Override
-            public void onClickFileList(File file) {
-                if (file == null) {
-                } else {
-                    String Dfile = Ctext(file.toString());
-                    EditText text = (EditText) findViewById(R.id.Text_Main);
-                    try {
-                        FileInputStream input = openFileInput(Dfile);
-                        BufferedReader reader = new BufferedReader(new InputStreamReader(input));
-                        String str = "";
-                        String tmp;
-                        while ((tmp = reader.readLine()) != null) {
-                            str = str + tmp + "\n";
-                        }
-                        text.setText(str);//.txt読み込み
-                        reader.close();
-                        //デバッグ用
-                        //     Log.d("test",str);
-                    } catch (IOException e) {
-                        e.printStackTrace();
-                    }
-                }
-            }
-        });
-        dialog.show("/data/data/com.example.innovation.f_featnote/files", "select");//ファイル保存場所
-    }
-    public void FSelectSQL() {
-        Intent intent = new Intent(MainActivity.this,SqlLoad.class);
-       // intent.putExtra();
-        startActivity(intent);
-        int lis = 0;
-        startActivityForResult(intent,lis);
-        FloadSQL();
-    }
-    @Override
-    protected void onActivityResult(int requestCode,int resultCode,Intent data){
-        super.onActivityResult(requestCode,resultCode,data);
-        Bundle bundle = data.getExtras();
-        switch (requestCode){
-            case 0:
-                if (resultCode == RESULT_OK) {
-                    String[] str = bundle.getStringArray("key.data");
-                    EditText tit = (EditText) findViewById(R.id.Text_Title);
-                    EditText cont = (EditText) findViewById(R.id.Text_Main);
-                    assert str != null;
-                    tit.setText(str[0]);
-                    cont.setText(str[1]);
-                }
-        }
-    }
-    public void FloadSQL(){
-    }
-    public String Ctext(String file) {//FileListDialog→openFileInput  変換用
-        String Cfile = file.substring(51);
-        return Cfile;
-    }
-    public String DateG(int flg) {//日時取得+拡張子
-        Date date = new Date();
-        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddkkmmssSSS");//ファイルタイトル
-        String path = null;
-        switch (flg) {
-            case 1://.txt
-                path = sdf.format(date) + ".txt";
-                break;
-            case 2://SQL
-                path = sdf.format(date);
-                break;
-        }
-        return path;
-    }
-    public String ContentG(int d) {//テキスト内容取得
-        EditText con = (EditText) findViewById(R.id.Text_Main);//0
-        EditText tit = (EditText) findViewById(R.id.Text_Title);//1
-        SpannableStringBuilder content = (SpannableStringBuilder) con.getText();
-        SpannableStringBuilder title = (SpannableStringBuilder) tit.getText();
-        String[] str = {content.toString(),title.toString()};
-        return str[d];
-    }
-    public SQLiteDatabase SQLopen() {//SQL生成
-        SQLiteDatabase sdb;
-        SubOpenHelper helper =
-                new SubOpenHelper(getApplicationContext(), "Memo.db", 1);
-        try {
-            sdb = helper.getWritableDatabase();
-        } catch (SQLiteException e) {
-            //異常終了
-            sdb = helper.getReadableDatabase();
-        }
-        return sdb;
-    }
-    public SQLiteDatabase SQLopen(Context con) {//SQL生成
-        SQLiteDatabase sdb;
-        SubOpenHelper helper =
-                new SubOpenHelper(con, "Memo.db", 1);
-        try {
-            sdb = helper.getWritableDatabase();
-        } catch (SQLiteException e) {
-            //異常終了
-            sdb = helper.getReadableDatabase();
-        }
-        return sdb;
-    }
-}
-class SubOpenHelper extends SQLiteOpenHelper {//SQL
-    public SubOpenHelper(Context c, String dbname, int version) {
-        super(c, dbname, null, version);
-    }
-    public void onCreate(SQLiteDatabase db) {
-        db.execSQL("create table MemoContents(_id integer primary key autoincrement,title integer not null,content integer not null,date integer not null)");
-    }
-    @Override
-    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
-    }
-}
-```
+    public void finish() {
+        super.finish();
+    }
+}```