ensacom-laptop tools # ./adb shell
$ sqlite3 data/data/com.ensacom.android.ensacom1/databases/tankpro
sqlite3: permission denied
$ListAdapter mAdapter = new SimpleCursorAdapter(this, R.layout.fahrzeuge, c, columns, names);public class fahrzeuge extends ListActivity {
SQLiteDatabase myDB = null;
private final String MY_DATABASE_NAME = "tankpro";
private final String MY_DATABASE_TABLE = "fahrzeuge";
@Override
public void onCreate(Bundle icicle) {
super.onCreate(icicle);
//Datenbank erstellen oder öffnen
myDB = this.openOrCreateDatabase(MY_DATABASE_NAME, MODE_PRIVATE, null);
//Tabelle erstellen wenn noch nicht vorhanden
myDB.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DATABASE_TABLE
+ " (id integer AUTO_INCREMENT PRIMARY KEY, name varchar(100), model varchar(100), bemerkungen varchar(255), kraftstoffart varchar(100))"
+";");
//Daten in Tabelle einfügen
myDB.execSQL("INSERT INTO "+MY_DATABASE_TABLE+" (name, model, bemerkungen, kraftstoffart) "
+"VALUES ('Audi','TT','Keine Bemerkung','Super');");
//Daten aus Tabelle auslesen
Cursor c = myDB.rawQuery("SELECT name, model FROM " + MY_DATABASE_TABLE + ";", null);
//Indizies der Spalten speichern
int kfzNameColumn = c.getColumnIndex("name");
int kfzModelColumn = c.getColumnIndex("model");
//Cursor an ersten Treffer setzten
c.moveToFirst();
//KFZName in Variable speichern
String kfzname = c.getString(kfzNameColumn);
//KFZModel in Variable speichern
String kfzmodel = c.getString(kfzModelColumn);
startManagingCursor(c);
String[] columns = new String[]{kfzname};
int[] names = new int[]{R.id.row_entry};
ListAdapter mAdapter = new SimpleCursorAdapter(this, R.layout.fahrzeuge, c, columns, names);
this.setListAdapter(mAdapter);
}Toast toast = Toast.makeText(fahrzeuge.this, kfzname + kfzmodel, Toast.LENGTH_SHORT);public class ensacom1 extends Activity {
SQLiteDatabase myDB = null;
final static String MY_DATABASE_NAME = "tankpro";
final static String MY_DATABASE_TABLE = "fahrzeuge";
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
onCreateDBAndDBTabled(); //DB und Tables erstellen wenn noch nicht vorhanden
setContentView(R.layout.main);
}
private void onCreateDBAndDBTabled()
{
myDB = this.openOrCreateDatabase(MY_DATABASE_NAME, MODE_PRIVATE, null);
myDB.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DATABASE_TABLE
+ " (id integer AUTO_INCREMENT PRIMARY KEY, name varchar(100), model varchar(100), bemerkungen varchar(255), kraftstoffart varchar(100))"
+";");
}//Klick auf einen Menüpunkt
public boolean onOptionsItemSelected(MenuItem item){
switch (item.getItemId()) {
case MENU_SAVE:
EditText KfzName = (EditText)findViewById(R.id.ed_fahrzeugname);
EditText KfzModel = (EditText)findViewById(R.id.ed_fahrzeugmodel);
EditText KfzBemerkungen = (EditText)findViewById(R.id.ed_fahrzeugbemerkung);
Spinner KfzKraftstoffart = (Spinner)findViewById(R.id.cb_Kraftstoffarten);
InsertToDB(KfzName.getText().toString(), KfzModel.getText().toString(), KfzBemerkungen.getText().toString(), KfzKraftstoffart.getSelectedItem().toString());
Intent ifahrzeuge = new Intent(this, fahrzeuge.class);
startActivity(ifahrzeuge);
return true;
}
return false;
}
//Neues Fahrzeug in DB speichern
public void InsertToDB(String kfzName, String kfzModel, String kfzBemerkungen, String kfzKraftstoffart)
{
SQLiteDatabase myDB = null;
try {
myDB = this.openOrCreateDatabase(ensacom1.MY_DATABASE_NAME, MODE_PRIVATE, null);
myDB.execSQL("INSERT INTO "+ensacom1.MY_DATABASE_TABLE+" (name, model, bemerkungen, kraftstoffart) "
+"VALUES ('"+kfzName+"','"+kfzModel+"','"+kfzBemerkungen+"','"+kfzKraftstoffart+"');");
}
finally
{
if (myDB != null)
myDB.close();
}
}public class fahrzeuge extends ListActivity {
SQLiteDatabase myDB = null;
ArrayList<String> results = new ArrayList<String>();
@Override
public void onCreate(Bundle icicle) {
super.onCreate(icicle);
myDB = this.openOrCreateDatabase(ensacom1.MY_DATABASE_NAME, MODE_PRIVATE, null);
Cursor c = myDB.rawQuery("SELECT name, model FROM " + ensacom1.MY_DATABASE_TABLE + ";", null);
int kfzNameColumn = c.getColumnIndex("name");
int kfzModelColumn = c.getColumnIndex("model");
startManagingCursor(c);
c.moveToFirst();
if (c != null) {
if (c.isFirst()) {
int i = 0;
do {
i++;
String kfzname = c.getString(kfzNameColumn);
String kfzmodel = c.getString(kfzModelColumn);
results.add(kfzname + " - " + kfzmodel);
} while(c.moveToNext());
}
}
this.setListAdapter(new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, results));
}this.setListAdapter(new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, results));
