Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import android.app.Activity;
- import android.os.Bundle;
- import android.view.View;
- import android.view.View.OnClickListener;
- import android.widget.Button;
- import android.widget.EditText;
- import android.widget.TextView;
- public class MainActivity extends Activity implements OnClickListener {
- TextView listContent;
- EditText edt;
- private SQLiteAdapter mySQLiteAdapter;
- /** Called when the activity is first created. */
- @Override
- public void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- listContent = (TextView) findViewById(R.id.textView1);
- edt = (EditText) findViewById(R.id.title);
- Button save = (Button) findViewById(R.id.confirm);
- save.setOnClickListener(this);
- }
- public void onClick(View v) {
- /*
- * Create/Open a SQLite database and fill with dummy content and close
- * it
- */
- mySQLiteAdapter = new SQLiteAdapter(this);
- mySQLiteAdapter.openToWrite();
- mySQLiteAdapter.deleteAll();
- String s = edt.getText().toString();
- mySQLiteAdapter.insert(s);
- mySQLiteAdapter.close();
- /*
- * Open the same SQLite database and read all it's content.
- */
- mySQLiteAdapter = new SQLiteAdapter(this);
- mySQLiteAdapter.openToRead();
- String contentRead = mySQLiteAdapter.queueAll();
- mySQLiteAdapter.close();
- listContent.setText(contentRead);
- }
- public class SQLiteAdapter {
- public static final String MYDATABASE_NAME = "MY_DATABASE";
- public static final String MYDATABASE_TABLE = "MY_TABLE";
- public static final int MYDATABASE_VERSION = 1;
- public static final String KEY_CONTENT = "Content";
- // create table MY_DATABASE (ID integer primary key, Content text not null);
- private static final String SCRIPT_CREATE_DATABASE = "create table "
- + MYDATABASE_TABLE + " (" + KEY_CONTENT + " text not null);";
- private SQLiteHelper sqLiteHelper;
- private SQLiteDatabase sqLiteDatabase;
- private Context context;
- public SQLiteAdapter(Context c) {
- context = c;
- }
- public SQLiteAdapter openToRead() throws android.database.SQLException {
- sqLiteHelper = new SQLiteHelper(context, MYDATABASE_NAME, null,
- MYDATABASE_VERSION);
- sqLiteDatabase = sqLiteHelper.getReadableDatabase();
- return this;
- }
- public SQLiteAdapter openToWrite() throws android.database.SQLException {
- sqLiteHelper = new SQLiteHelper(context, MYDATABASE_NAME, null,
- MYDATABASE_VERSION);
- sqLiteDatabase = sqLiteHelper.getWritableDatabase();
- return this;
- }
- public void close() {
- sqLiteHelper.close();
- }
- public long insert(String content) {
- ContentValues contentValues = new ContentValues();
- contentValues.put(KEY_CONTENT, content);
- return sqLiteDatabase.insert(MYDATABASE_TABLE, null, contentValues);
- }
- public int deleteAll() {
- return sqLiteDatabase.delete(MYDATABASE_TABLE, null, null);
- }
- public String queueAll() {
- String[] columns = new String[] { KEY_CONTENT };
- Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns, null,
- null, null, null, null);
- String result = "";
- int index_CONTENT = cursor.getColumnIndex(KEY_CONTENT);
- for (cursor.moveToFirst(); !(cursor.isAfterLast()); cursor.moveToNext()) {
- result = result + cursor.getString(index_CONTENT) + "n";
- }
- return result;
- }
- public class SQLiteHelper extends SQLiteOpenHelper {
- public SQLiteHelper(Context context, String name,
- CursorFactory factory, int version) {
- super(context, name, factory, version);
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- // TODO Auto-generated method stub
- db.execSQL(SCRIPT_CREATE_DATABASE);
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- // TODO Auto-generated method stub
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement