Wygląda na to jakby nie było bazy danych hmm...
E/SQLiteLog: (1)
D/AndroidRuntime: Shutting down VM
E/AndroidRuntime: FATAL EXCEPTION: main
Process: pl.pawel.notatnikpablo, PID: 29687
java.lang.RuntimeException: Unable to start activity ComponentInfo{pl.pawel.notatnikpablo/pl.pawel.notatnikpablo.MainActivity}: android.database.sqlite.SQLiteException: no such table: notes_contetn (Sqlite code 1 SQLITE_ERROR): , while compiling: SELECT title FROM notes_contetn, (OS error - 2:No such file or directory)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3300)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3484)
at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:86)
at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:108)
at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:68)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2123)
at android.os.Handler.dispatchMessage(Handler.java:109)
at android.os.Looper.loop(Looper.java:207)
at android.app.ActivityThread.main(ActivityThread.java:7470)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:524)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:958)
Caused by: android.database.sqlite.SQLiteException: no such table: notes_contetn (Sqlite code 1 SQLITE_ERROR): , while compiling: SELECT title FROM notes_contetn, (OS error - 2:No such file or directory)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:948)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:559)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:603)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:63)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:46)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1493)
at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1335)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1206)
at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1374)
at pl.pawel.notatnikpablo.Notes_Database_Helper.getAlltitle(Notes_Database_Helper.java:47)
at pl.pawel.notatnikpablo.MainActivity.onCreate(MainActivity.java:31)
at android.app.Activity.performCreate(Activity.java:7436)
at android.app.Activity.performCreate(Activity.java:7426)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1286)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3279)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3484)
at android.app.servertransaction.LaunchActivityItem.execute(LaunchActivityItem.java:86)
at android.app.servertransaction.TransactionExecutor.executeCallbacks(TransactionExecutor.java:108)
at android.app.servertransaction.TransactionExecutor.execute(TransactionExecutor.java:68)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2123)
at android.os.Handler.dispatchMessage(Handler.java:109)
at android.os.Looper.loop(Looper.java:207)
at android.app.ActivityThread.main(ActivityThread.java:7470)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:524)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:958)
package pl.pawel.notatnikpablo;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import java.util.ArrayList;
public class Notes_Database_Helper extends SQLiteOpenHelper {
public Notes_Database_Helper(Context context) {
super(context, "note.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(
"create table notes_table(" +
"id integer primary key autoincrement," +
"title text," +
"note_contetn text)" +
"");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
public void add_note(String title, String content) {
SQLiteDatabase db = getWritableDatabase();
ContentValues walues = new ContentValues();
walues.put("title", title);
walues.put("note_contetn", content);
db.insertOrThrow("notes_table", null, walues);
}
public ArrayList<String> getAlltitle() {
ArrayList<String> columns = new ArrayList<String>();
String[] temp = {"title"};
SQLiteDatabase db = getReadableDatabase();
Cursor kursor = db.query("notes_contetn", temp, null, null, null, null, null);
kursor.moveToPosition(0);
do {
columns.add(kursor.getString(kursor.getColumnIndex("title")));
}while (kursor.moveToNext());
return columns;
}
}
tylko dlaczego ?