Witam, piszę program w eclipse, który będzie dodawał dane z formularza do bazy danych. Mam tylko 2 pola do dodania data i komentarz. Program odpala się wpisuje wszystkie dane do formularza i po kliknięciu przycisku który dodaje dane do bazy wyskakuje komunikat "Aplikacja została zatrzymana"
Może powiecie mi co źle zrobiłem poniżej zamieszczam kody źródłowe:
package com.example.database;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DatabaseHandler extends SQLiteOpenHelper {
// All Static variables
// Database Version
private static final int DATABASE_VERSION = 1;
// Database Name
private static final String DATABASE_NAME = "tankDatabase";
// Contacts table name
public static final String TABLE_MEMORIES = "memories";
// Contacts Table Columns names
public static final String COLUMN_MEM_ID = "memID";
public static final String COLUMN_MEM_DATE = "memDATE";
public static final String COLUMN_MEM_NOTE = "memNOTE";
public DatabaseHandler(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_MEMORIES_TABLE = "CREATE TABLE " + TABLE_MEMORIES + "("
+ COLUMN_MEM_ID + " INTEGER PRIMARY KEY," + COLUMN_MEM_DATE + " TEXT,"
+ COLUMN_MEM_NOTE + " TEXT," + ")";
db.execSQL(CREATE_MEMORIES_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// Drop older table if existed
db.execSQL("DROP TABLE IF EXISTS " + TABLE_MEMORIES);
// Create tables again
onCreate(db);
}
}
package com.example.database.memories;
public class MemBean {
private int memID;
private String memDATE;
private String memNOTE;
public MemBean(int memID, String memDATE, String memNOTE) {
this.memID = memID;
this.memDATE = memDATE;
this.memNOTE = memNOTE;
}
public MemBean() {
}
public int getMemID() {
return memID;
}
public void setMemID(int memID) {
this.memID = memID;
}
public String getMemDATE() {
return memDATE;
}
public void setMemDATE(String memDATE) {
this.memDATE = memDATE;
}
public String getMemNOTE() {
return memNOTE;
}
public void setMemNOTE(String memNOTE) {
this.memNOTE = memNOTE;
}
public MemBean(String memDATE, String memNOTE) {
this.memDATE = memDATE;
this.memNOTE = memNOTE;
}
}
package com.example.database.memories;
import java.util.ArrayList;
import java.util.List;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import com.example.database.DatabaseHandler;
import com.example.database.memories.MemBean;
public class MemDao {
private SQLiteDatabase database;
private final DatabaseHandler dbHandler;
private final String[] allMemColumns = { DatabaseHandler.COLUMN_MEM_ID,
DatabaseHandler.COLUMN_MEM_DATE, DatabaseHandler.COLUMN_MEM_NOTE };
public MemDao(Context context) {
dbHandler = new DatabaseHandler(context);
}
public void open() throws SQLException {
database = dbHandler.getWritableDatabase();
}
public void close() {
dbHandler.close();
}
public void addMem(MemBean memBean) {
ContentValues values = new ContentValues();
values.put(DatabaseHandler.COLUMN_MEM_DATE, memBean.getMemDATE());
values.put(DatabaseHandler.COLUMN_MEM_NOTE, memBean.getMemNOTE());
// Inserting Row
database.insert(DatabaseHandler.TABLE_MEMORIES, null, values);
}
public MemBean getMem(int id) {
Cursor cursor = database.query(DatabaseHandler.TABLE_MEMORIES,
allMemColumns, DatabaseHandler.COLUMN_MEM_ID + "=?",
new String[] { String.valueOf(id) }, null, null, null, null);
if (cursor != null) {
cursor.moveToFirst();
}
MemBean mem = new MemBean(Integer.parseInt(cursor.getString(0)),
cursor.getString(1), cursor.getString(2));
// return contact
return mem;
}
public List<MemBean> getAllMems() {
List<MemBean> memList = new ArrayList<MemBean>();
// Select All Query
String selectQuery = "SELECT * FROM " + DatabaseHandler.TABLE_MEMORIES;
Cursor cursor = database.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
MemBean mem = new MemBean();
mem.setMemID(Integer.parseInt(cursor.getString(0)));
mem.setMemDATE(cursor.getString(1));
mem.setMemNOTE(cursor.getString(2));
// Adding contact to list
memList.add(mem);
} while (cursor.moveToNext());
}
return memList;
}
public int updateMem(MemBean mem, int memID) {
ContentValues values = new ContentValues();
values.put(DatabaseHandler.COLUMN_MEM_DATE, mem.getMemDATE());
values.put(DatabaseHandler.COLUMN_MEM_NOTE, mem.getMemNOTE());
return database.update(DatabaseHandler.TABLE_MEMORIES, values,
DatabaseHandler.COLUMN_MEM_ID + "=" + memID, null);
}
public int deleteMem(int memID) {
return database.delete(DatabaseHandler.TABLE_MEMORIES,
DatabaseHandler.COLUMN_MEM_ID + "=?",
new String[] { String.valueOf(memID) });
}
}
package com.example.samochodspalanieiwydatki;
import java.util.List;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import com.example.database.memories.MemBean;
import com.example.database.memories.MemDao;
public class PrzypomnienieActivity extends Activity {
private EditText memDATE;
private EditText memNOTE;
private Button addMem;
private MemDao database;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_przypomnienie);
memDATE= (EditText) findViewById(R.id.mdate);
memNOTE = (EditText) findViewById(R.id.mopis);
addMem = (Button) findViewById(R.id.addMem);
database.open();
List<MemBean> memList = database.getAllMems();
database.close();
addMem.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
MemBean mem = new MemBean();
String date = memDATE.getText().toString();
mem.setMemDATE(date);
String note = memNOTE.getText().toString();
mem.setMemNOTE(note);
database.open();
database.addMem(mem);
;
database.close();
}
});
}
}