package
com.andro;
import
java.util.ArrayList;
import
android.os.Bundle;
import
android.app.ListActivity;
import
android.database.Cursor;
import
android.database.sqlite.SQLiteDatabase;
import
android.database.sqlite.SQLiteException;
import
android.view.View;
import
android.widget.ArrayAdapter;
import
android.widget.Button;
import
android.widget.EditText;
import
android.widget.TextView;
public
class
MemoListActivity
extends
ListActivity{
ArrayAdapter<String> mAdapter;
DBManager dbmgr;
SQLiteDatabase sql;
Cursor cursor;
@Override
protected
void
onCreate(Bundle savedInstanceState) {
super
.onCreate(savedInstanceState);
setContentView(R.layout.main);
mAdapter =
new
ArrayAdapter<String>(getApplication(),R.layout.list_row,
new
ArrayList<String>());
setListAdapter(mAdapter);
Button button = (Button)findViewById(R.id.btn_add);
TextView tv = (TextView)findViewById(R.id.list_row_text);
button.setOnClickListener(
new
View.OnClickListener() {
@Override
public
void
onClick(View v) {
addStringData();
}
});
}
private
void
addStringData(){
EditText edit = (EditText)findViewById(R.id.edit_text);
mAdapter.add(edit.getText().toString());
mAdapter.notifyDataSetChanged();
try
{
dbmgr =
new
DBManager(
this
);
sql = dbmgr.getWritableDatabase();
sql.execSQL(
"insert into MEMO valuse('"
+edit.getText().toString()+
"'"
+
"'"
+
null
+
"');"
);
dbmgr.close();
}
catch
(SQLiteException e){}
}
}