public class DBHelper { private static final String DATABASE_NAME = "example.db"; private static final int DATABASE_VERSION = 1; private static final String TABLE_NAME = "table1";
private SQLiteStatement insertStmt; private static final String INSERT = "insert into " + TABLE_NAME + "(name) values (?)"; //es la vista el context public DBHelper(Context context) { this.context = context; //gestiona la creacion de la base datos OpenHelper openHelper = new OpenHelper(this.context); this.db = openHelper.getWritableDatabase(); this.insertStmt = this.db.compileStatement(INSERT); }
public long insert(String name) { //enlasa va caer en el signo de ? el nombre this.insertStmt.bindString(1, name); return this.insertStmt.executeInsert(); }
public void deleteAll() { this.db.delete(TABLE_NAME, null, null); }
public List<String> selectAll() { List<String> list = new ArrayList<String>(); Cursor cursor = this.db.query(TABLE_NAME, new String[] { "name" }, null, null, null, null, "name desc"); if (cursor.moveToFirst()) { do { list.add(cursor.getString(0)); } while (cursor.moveToNext()); } if (cursor != null && !cursor.isClosed()) { cursor.close(); } return list; }
private static class OpenHelper extends SQLiteOpenHelper {
@Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY, name TEXT)");
}
@Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { Log.w("Example", "Upgrading database, this will drop tables and recreate."); db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME); onCreate(db); } } }
public class SQLiteDatabasesActivity extends Activity { /** Called when the activity is first created. */ private TextView output;
private DBHelper dh;
@Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); //layout statico
output = (TextView) findViewById(R.id.myTextView); this.dh = new DBHelper(this); this.dh.deleteAll(); this.dh.insert("Erwin San Juan"); this.dh.insert("Rodrigo Quiroz"); this.dh.insert("Leonardo Ilivares"); List<String> names = this.dh.selectAll(); StringBuilder sb = new StringBuilder(); //construir un string sb.append("Nombres en la base de datos:\n"); for (String name : names) { sb.append(name + "\n"); } Log.d("Ejemplo", "tama–o de los nombres - " + names.size());
import java.util.ArrayList;
import java.util.List;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteStatement;
import android.util.Log;
public class DBHelper {
private static final String DATABASE_NAME = "example.db";
private static final int DATABASE_VERSION = 1;
private static final String TABLE_NAME = "table1";
private Context context;
private SQLiteDatabase db;
private SQLiteStatement insertStmt;
private static final String INSERT = "insert into "
+ TABLE_NAME + "(name) values (?)";
//es la vista el context
public DBHelper(Context context) {
this.context = context;
//gestiona la creacion de la base datos
OpenHelper openHelper = new OpenHelper(this.context);
this.db = openHelper.getWritableDatabase();
this.insertStmt = this.db.compileStatement(INSERT);
}
public long insert(String name) {
//enlasa va caer en el signo de ? el nombre
this.insertStmt.bindString(1, name);
return this.insertStmt.executeInsert();
}
public void deleteAll() {
this.db.delete(TABLE_NAME, null, null);
}
public List<String> selectAll() {
List<String> list = new ArrayList<String>();
Cursor cursor = this.db.query(TABLE_NAME, new String[] { "name" },
null, null, null, null, "name desc");
if (cursor.moveToFirst()) {
do {
list.add(cursor.getString(0));
} while (cursor.moveToNext());
}
if (cursor != null && !cursor.isClosed()) {
cursor.close();
}
return list;
}
private static class OpenHelper extends SQLiteOpenHelper {
OpenHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY, name TEXT)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.w("Example", "Upgrading database, this will drop tables and recreate.");
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
onCreate(db);
}
}
}
import java.util.List;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.widget.TextView;
public class SQLiteDatabasesActivity extends Activity {
/** Called when the activity is first created. */
private TextView output;
private DBHelper dh;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main); //layout statico
output = (TextView) findViewById(R.id.myTextView);
this.dh = new DBHelper(this);
this.dh.deleteAll();
this.dh.insert("Erwin San Juan");
this.dh.insert("Rodrigo Quiroz");
this.dh.insert("Leonardo Ilivares");
List<String> names = this.dh.selectAll();
StringBuilder sb = new StringBuilder(); //construir un string
sb.append("Nombres en la base de datos:\n");
for (String name : names) {
sb.append(name + "\n");
}
Log.d("Ejemplo", "tama–o de los nombres - " + names.size());
output.setText(sb.toString());
}
}