来自现有SQLite数据库的java查询数据

2 周，5 日 Questions & Answers 156

我遵循了本教程： http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-安卓-applications/ 使用SQLite数据库浏览器创建数据库，将数据库文件放入“资产”文件夹等

然后我将这个方法添加到DataBaseHelper类的末尾

  public ArrayList<market> getMarkets(String table) {

    ArrayList<market> markets = new ArrayList<market>();
    market mrkt = new market();

    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery("SELECT * FROM " + table, null);

    if(cursor.moveToFirst()) {
        do {
            mrkt.market_id = cursor.getInt(cursor.getColumnIndex("marketid"));
            mrkt.market_name = cursor.getString(cursor.getColumnIndex("name"));
            mrkt.market_telno = cursor.getInt(cursor.getColumnIndex("telno"));
            mrkt.market_location = cursor.getString(cursor.getColumnIndex("location"));
            mrkt.market_hours = cursor.getString(cursor.getColumnIndex("hours"));
            markets.add(mrkt);
        }while(cursor.moveToNext());
    }

    cursor.close();
    db.close();
    return markets;
}

并尝试在主活动类中使用以下行在listview上显示市场：

 dbh = new DataBaseHelper(getApplicationContext());
 markets = new ArrayList<market>();
 marketListView = (ListView) findViewById(R.id.listViewMarkets);

 markets = dbh.getMarkets("markets");



 // Create The Adapter with passing ArrayList as 3rd parameter
 ArrayAdapter<market> arrayAdapter =      
 new ArrayAdapter<market>(this,安卓.R.layout.simple_list_item_1, markets);

 // Set The Adapter
 marketListView.setAdapter(arrayAdapter);

我的布局xml文件：

<LinearLayout xmlns:安卓="http://schemas.安卓.com/apk/res/安卓"
安卓:layout_width="match_parent"
安卓:layout_height="match_parent"
安卓:orientation="vertical" >

<ListView
    安卓:id="@+id/listViewMarkets"
    安卓:layout_width="fill_parent"
    安卓:layout_height="fill_parent" 
    安卓:dividerHeight="0.1dp"
    安卓:divider="#0000CC"
    >
</ListView>

</LinearLayout>

然而，我得到了一个错误，“unfotunaly应用程序已停止”。。我是安卓新手，有人能帮我吗？谢谢

这里是logcat：

04-09 16:32:00.125: W/dalvikvm(17103): threadid=1: thread exiting with uncaught exception (group=0x41685c80)
04-09 16:32:00.130: E/AndroidRuntime(17103): FATAL EXCEPTION: main
04-09 16:32:00.130: E/AndroidRuntime(17103): Process: com.example.deneme, PID: 17103
04-09 16:32:00.130: E/AndroidRuntime(17103): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.deneme/com.example.deneme.MainActivity}: 安卓.database.sqlite.SQLiteException: no such table: markets (code 1): , while compiling: SELECT * FROM markets
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.app.ActivityThread.performLaunchActivity(ActivityThread.java:2215)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2265)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.app.ActivityThread.access$800(ActivityThread.java:145)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.app.ActivityThread$H.handleMessage(ActivityThread.java:1206)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.os.Handler.dispatchMessage(Handler.java:102)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.os.Looper.loop(Looper.java:136)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.app.ActivityThread.main(ActivityThread.java:5081)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at java.lang.reflect.Method.invokeNative(Native Method)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at java.lang.reflect.Method.invoke(Method.java:515)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at com.安卓.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:781)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at com.安卓.internal.os.ZygoteInit.main(ZygoteInit.java:597)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at dalvik.system.NativeStart.main(Native Method)
04-09 16:32:00.130: E/AndroidRuntime(17103): Caused by: 安卓.database.sqlite.SQLiteException: no such table: markets (code 1): , while compiling: SELECT * FROM markets
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at com.example.deneme.DataBaseHelper.getMarkets(DataBaseHelper.java:165)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at com.example.deneme.MainActivity.onCreate(MainActivity.java:25)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.app.Activity.performCreate(Activity.java:5231)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1087)
04-09 16:32:00.130: E/AndroidRuntime(17103):    at 安卓.app.ActivityThread.performLaunchActivity(ActivityThread.java:2169)
04-09 16:32:00.130: E/AndroidRuntime(17103):    ... 11 more

Python中文网

有 Java 编程相关的问题?

来自现有SQLite数据库的java查询数据

共 (1) 个答案

# 1 楼答案