onItemClick＆QUOT;通过＆QUOT获取从SQLite数据库到数据的意图;在Android版的ListView项目 [英] Get data from SQLite database to intent through "onItemClick" on item in ListView Android

问题描述

我真的需要你的帮助。

我有经纬度数据的数据库，这里的例子：

I have a database with latitude and longitude data, here the example:

id_____name_____lat_________long

id_____name_____lat_________long

1_ _ 的___ 酒店one___6.1234______-106.12345

1_____hotel one___6.1234______-106.12345

2_ _ __ 酒店two____6.54321_____-107.23456

2____hotel two____6.54321_____-107.23456

3_ _ _ 酒店three___7.12345_____-106.98765

3___hotel three___7.12345_____-106.98765

在Android的ListView中的数据显示。我用onItemClick，所以如果我点击的ListView的项目之一，它会去

The data display in ListView on Android. And i use onItemClick, so if i click one of the item in ListView it will go to

意图（android.content.Intent.ACTION_VIEW，Uri.parse（http://maps.google.com/maps?f=d&saddr=&daddr=+ lat_var + + long_var））

但是，如果我点击的ListView项目之一lat_var和long_var的意图上述数据不会给我从我的数据库lat和长数据问题是...

But the problem is if i click one of the item in ListView the data in lat_var and long_var on intent above won't give me the lat and long data from my database...

下面我code，您可以编辑它，所以如果我在ListView中单击该项目中的一个，它会给我从我的数据库lat和长数据。例如，如果我点击酒店两个lat_var将变更为6.54321和long_var将变为-107.23456上的意图。

Here my code, can you edit it, so if i click one of the item in ListView it will give me the lat and long data from my database. For example if i click hotel two the lat_var will change to 6.54321 and the long_var will change to -107.23456 on that intent.

public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
                long arg3) {
            // TODO Auto-generated method stub
            SQLiteDatabase dbs = dbHotelHelper.getReadableDatabase();

            String get_lat = "SELECT lat FROM hoteltbl";
            Cursor result_lat = dbs.rawQuery(get_lat, null);
            double lat_var = result_lat.getColumnIndex("lat");
            String get_long = "SELECT lat FROM hoteltbl";
            Cursor result_long = dbs.rawQuery(get_long, null);
            double long_var = result_long.getColumnIndex("long");

            Intent intent = new Intent(android.content.Intent.ACTION_VIEW, Uri.parse("http://maps.google.com/maps?f=d&saddr=&daddr="+lat_var+","+long_var));
            startActivity(intent);

        }

我不知道这个问题是我的语法还是什么。请修正我的code。我真的很感谢的人谁回答这个...

I don't know if the problem is my syntax or what. Please fix my code. I really thanks for anyone who answer this...

推荐答案

首先，只有一个查询是必要的。无需查询表格两次。
其次，你需要从你选择参数，以适应您的查询：

First, only one query is necessary. No need to query your table twice. Second, you need to adapt your query with parameters from your selection:

@Override
protected void onListItemClick(ListView listView, View view, int position, long id) {id) {    
    String selectedItem = (String) getListAdapter().getItem(position);
    String query = "SELECT lat, long FROM hoteltbl WHERE name = '" + selectedItem + "'";
    SQLiteDatabase dbs = dbHotelHelper.getReadableDatabase();
    Cursor result = dbs.rawQuery(query, null);
    result.moveToFirst();

    double lat = result.getDouble(result.getColumnIndex("lat"));
    double long = result.getDouble(result.getColumnIndex("long"));

    ....

这code写的计算器编辑器，它也可能无法工作等，但会给你一个想法。

This code was written in the StackOverflow editor, it might not work as such, but will give you an idea.

（另外，不要_long添加后缀_var，或你的变量，它没有必要像Java的强类型语言）

(Also, don't add suffixes "_var", or "_long" to your variables, it's not necessary in a strongly-typed language like Java)

这篇关于onItemClick＆QUOT;通过＆QUOT获取从SQLite数据库到数据的意图;在Android版的ListView项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！