何を書けばセットメッセージが出来るのか分かりません。場所も合っているのかよく分からなくて…
どうか教えてください<(_ _)>
public class MainActivity extends Activity {
private ListView myListView; private SQLiteDatabase db; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); } private void insertToDb(String[] regData) throws Exception { db.execSQL("insert into myData(" + MyDbHelper.REG_NAME + ", " + MyDbHelper.REG_CONTENT + ", " + MyDbHelper.REG_MAIL + ", " + MyDbHelper.REG_DATE + ")values( '" + regData[0] + "' , '" + regData[1] + "' , '" + regData[2] + "' , '" + regData[3] + "' )"); } private Cursor searchToDB() throws Exception { Cursor c = db.rawQuery("select * from " + MyDbHelper.TABLE_NAME, null); return c; } public void onStart() { super.onStart(); Button mainButton = (Button) findViewById(R.id.transRegButton); mainButton.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { Intent mainIntent = new Intent(MainActivity.this, RegisterActivity.class); startActivity(mainIntent); } }); myListView = (ListView) findViewById(R.id.listView); MyDbHelper dbHelper = new MyDbHelper(this); db = dbHelper.getWritableDatabase(); String[] regData = new String[4]; Intent intent = this.getIntent(); if (intent != null) { regData[0] = intent.getStringExtra("regName"); regData[1] = intent.getStringExtra("regContent"); regData[2] = intent.getStringExtra("regMail"); regData[3] = intent.getStringExtra("regDate"); AlertDialog.Builder ab = new AlertDialog.Builder(MainActivity.this); ab.setTitle("登録しました"); //searchToDBの結果を表示したい ab.setMessage(); ab.show(); } try { insertToDb(regData); Cursor c = searchToDB(); String[] from = {MyDbHelper.REG_NAME, MyDbHelper.REG_CONTENT, MyDbHelper.REG_MAIL, MyDbHelper.REG_DATE}; int[] to = {R.id.regName, R.id.regContent, R.id.regMail, R.id.regDate}; SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.lisitem_layout, c, from, to, 0); myListView.setAdapter(adapter); myListView.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) { String s1 = ((TextView) view.findViewById(R.id.regName)).getText().toString(); String s2 = ((TextView) view.findViewById(R.id.regContent)).getText().toString(); String s3 = ((TextView) view.findViewById(R.id.regMail)).getText().toString(); String s4 = ((TextView) view.findViewById(R.id.regDate)).getText().toString(); Log.v("name ", "= " + s1); Log.v("content", "= " + s2); Log.v("mail ", "= " + s3); Log.v("date ", "= " + s4); } }); } catch (Exception e) { e.printStackTrace(); } finally { db.close(); } }
}
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。