selectionner des elements à partir d'une base sqlite

Version imprimable

Bonjour,
j'ai créer une méthode qui permet de parcourir les éléments d'une colonne,mais je veux sélectionner des éléments si par exemple id =2 ..
voilà mon code :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
public ArrayList<String> getCreator() {
	ArrayList<String> output = new ArrayList<String>();
 
	String[] colonnesARecup = new String[] { "CREATOR" };
 
	Cursor cursorResults = bdd.query(TABLE_COLLECTOR, colonnesARecup, null,
			null, null, null, "ID", null);
	if (null != cursorResults) {
		if (cursorResults.moveToFirst()) {
			do {
				int columnIdxNom = cursorResults.getColumnIndex("CREATOR");
 
				String nomDb = cursorResults.getString(columnIdxNom);
 
				output.add(nomDb);
			} while (cursorResults.moveToNext());
		} // end§if
	}

merci

22/08/2011, 13h18
Feanorin

Bonjour,

Pour sélectionner un item dans un Adapter

Citation:

public abstract void setSelection (int position)

Since: API Level 1
Sets the currently selected item. To support accessibility subclasses that override this method must invoke the overriden super method first.
Parameters

position Index (starting at 0) of the data item to be selected.

http://developer.android.com/referen...Selection(int)
22/08/2011, 13h23
tabbabi

Non,c'est pas ça
je veux récupérer à partir du base des informations avec une condition (exemple select a from tab where id=1)
22/08/2011, 13h38
Feanorin

Oups , pas compris la question

via la fonction query que tu utilises tu peux le faire directement, il te suffit juste de rentrer ta condition.

http://developer.android.com/referen...a.lang.String)

Citation:

public Cursor query (String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)

Since: API Level 1
Query the given table, returning a Cursor over the result set.
Parameters

table The table name to compile the query against.
columns A list of which columns to return. Passing null will return all columns, which is discouraged to prevent reading data from storage that isn't going to be used.
selection A filter declaring which rows to return, formatted as an SQL WHERE clause (excluding the WHERE itself). Passing null will return all rows for the given table.
selectionArgs You may include ?s in selection, which will be replaced by the values from selectionArgs, in order that they appear in the selection. The values will be bound as Strings.
groupBy A filter declaring how to group rows, formatted as an SQL GROUP BY clause (excluding the GROUP BY itself). Passing null will cause the rows to not be grouped.
having A filter declare which row groups to include in the cursor, if row grouping is being used, formatted as an SQL HAVING clause (excluding the HAVING itself). Passing null will cause all row groups to be included, and is required when row grouping is not being used.
orderBy How to order the rows, formatted as an SQL ORDER BY clause (excluding the ORDER BY itself). Passing null will use the default sort order, which may be unordered.
limit Limits the number of rows returned by the query, formatted as LIMIT clause. Passing null denotes no LIMIT clause.
Returns

A Cursor object, which is positioned before the first entry. Note that Cursors are not synchronized, see the documentation for more details.
See Also

Cursor

est ce que je peux utiliser ça:

Code:

1
2
3
 
p_query = "SELECT CREATOR FROM INFO_COLLECTOR WHERE IDCOL=1" ;
mDb.rawQuery( p_query, null );

22/08/2011, 13h48
Feanorin

Citation:

est ce que je peux utiliser ça:

Oui, cela marche également.
22/08/2011, 13h50
tabbabi

oui ça marche ,merci