Assign an element [name] of the database that is in a list to an EditText

Question

Assign an element [name] of the database that is in a list to an EditText

Navigation

#1 by (0 votes)

0

nome = (EditText) findViewById(R.id.edt_nomecli);

listaclientes.setOnItemClickListener(new AdapterView.OnItemClickListener() {
    @Override
    public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {                   
        Integer cod = i;
        Cursor cursor = banco.rawQuery("SELECT nome FROM clientes WHERE id_cli = '"+cod+"' ",null);
        if(cursor!=null)
        {  
            int cnome=cursor.getColumnIndex("nome");
            nome.setText(cursor.getString(cnome), TextView.BufferType.EDITABLE);
        }  
    }  
});

The ERROR IS TIME TO IMPLEMENT.

android

asked by anonymous 16.02.2018 / 18:17

1 answer

How to create a Feature Table with more than one layer or feature layer with the ArcGIS API return json c # .net core sql

score 0 · Answer 1

I was able to resolve ...

nome = (EditText) findViewById(R.id.edt_nomecli);

listaclientes.setOnItemClickListener(new AdapterView.OnItemClickListener() {

@Override
public void onItemClick(AdapterView<?> adapterView, View view, int i, long l) {                   
    final Integer j = i;
      String n = adapternome.getItem(j).toString();
        try {
            Cursor cursor = banco.rawQuery("SELECT * FROM clientes WHERE nome = '" + n +"'", null);
            int colunaN = cursor2.getColumnIndex("nome");
            cursor.moveToFirst();
            while (cursor != null)
           {
             nome.setText(cursor.getString(colunaN), TextView.BufferType.EDITABLE);
             abas.setCurrentTab(1);
             cursor.moveToNext();
            }
       }catch (Exception E ){E.printStackTrace();}
    }  
});