listview non aggiorna textview

salve ho una listview personalizzata con due textview e due bottoni.
un bottone una volte premuto modifica il database sqlite e inserisce il nuovo valore sulla textview
il problema è che premendo un bottone esso modifica il database sqlite ma la textview presente nella listview non viene aggiornata
vi posto il codice dell'adapter
<br /> class myCustomObject {<br /> private String text1;<br /> private int text2;<br /> <br /> public String getText1(){<br /> <br /> return this.text1;<br /> }<br /> public void setText1(String text1){ this.text1= text1;<br /> }<br /> <br /> public int getText2(){<br /> return this.text2;<br /> }<br /> public void setText2(int text2){<br /> this.text2= text2;<br /> }<br /> <br /> public myCustomObject(String text1, int text2) {<br /> this.text1 = text1;<br /> this.text2 = text2;<br /> }<br /> <br /> <br /> }<br /> <br /> <br /> <br /> <br /> public class Adapter_MainActivity extends BaseAdapter {<br /> private ArrayList mapData;<br /> Context context;<br /> int layoutResourceId;<br /> <br /> Holder holder;<br /> <br /> public Adapter_MainActivity(Context context, int layoutResourceId, Map<Integer, myCustomObject> arList) {<br /> this.layoutResourceId = layoutResourceId;<br /> this.context = context;<br /> <br /> mapData = new ArrayList();<br /> mapData.addAll(arList.entrySet());<br /> }<br /> <br /> @<a href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a><br /> public int getCount() {<br /> return mapData.size();<br /> }<br /> <br /> <br /> @<a href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a><br /> public Map.Entry<Integer, myCustomObject> getItem(int position) {<br /> return (Map.Entry) mapData.get(position);<br /> }<br /> <br /> @<a href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a><br /> public long getItemId(int position) {<br /> return 0;<br /> }<br /> <br /> @<a href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a><br /> public View getView(int position, View view, ViewGroup parent) {<br /> if(view == null) {<br /> holder = new Holder();<br /> <br /> LayoutInflater inflater = ((Activity)context).getLayoutInflater();<br /> view = inflater.inflate(layoutResourceId, parent, false);<br /> <br /> holder.textView = (TextView)view.findViewById(R.id.textViewList);<br /> holder.textView2 = (TextView)view.findViewById(R.id.numero);<br /> <br /> FloatingActionButton fab = (FloatingActionButton) view.findViewById(R.id.fab);<br /> fab.setTag(position);<br /> fab.setOnClickListener(new View.OnClickListener() {<br /> @<a href="https://www.androidiani.com/forum/members/override.html" target="_blank">Override</a><br /> public void onClick(View view) {<br /> int position = (Integer) view.getTag();<br /> DbHelper helper = new DbHelper(context);<br /> SQLiteDatabase db = helper.getReadableDatabase();<br /> String titol = holder.textView.getText().toString();<br /> String numero = holder.textView2.getText().toString();<br /> <br /> //valore incremento<br /> String[] selectionArg = {titol};<br /> Cursor p = db.rawQuery("SELECT _id FROM contatore WHERE titolo=?", selectionArg);<br /> int tot = 0;<br /> while (p.moveToNext()) {<br /> Cursor g = db.rawQuery("SELECT * FROM promemoria WHERE idcont=? ORDER BY _id DESC LIMIT 1", new String[]{p.getString(0)});<br /> while (g.moveToNext()) {<br /> String Valore_in = g.getString(3);//ultimo valore incremento inserito<br /> int valore_in = Integer.parseInt(Valore_in);<br /> int numer = Integer.parseInt(numero);<br /> tot = numer + valore_in;<br /> Log.d("errore", "numero=" + String.valueOf(numero) + " valore incremento =" + Valore_in + "totale " + tot);<br /> <br /> //data<br /> long date = System.currentTimeMillis();<br /> SimpleDateFormat sdf = new SimpleDateFormat("E, dd/MM/yyyy h:mm a");<br /> String dateString = sdf.format(date);<br /> <br /> ContentValues values = new ContentValues();<br /> values.put("numero", tot);<br /> values.put("data", String.valueOf(dateString));<br /> values.put("valore_incremento", valore_in);<br /> values.put("incremento_decremento", "+");<br /> values.put("idcont", g.getString(5));<br /> db.insert("promemoria", null, values); //inserimento nella tabella<br /> <br /> }<br /> }<br /> holder.textView2.setText(tot);<br /> <br /> }<br /> });<br /> view.setTag(holder);<br /> } else {<br /> holder = (Holder)view.getTag();<br /> }<br /> <br /> Map.Entry<Integer, myCustomObject> item = getItem(position);<br /> holder.textView.setText(item.getValue().getText1());<br /> holder.textView2.setText(String.valueOf(item.getValue().getText2()));<br /> <br /> return view;<br /> }<br /> public void add(Map<Integer, myCustomObject> map) {<br /> mapData.addAll(map.entrySet());<br /> }<br /> public void clear() {<br /> mapData.clear();<br /> }<br /> <br /> }<br /> class Holder {<br /> TextView textView, textView2;<br /> }

ho provato con holder.textView2.setText(tot);
ma l'app va in crash

sono riuscito a far stampare i valori nella textview
ma solo al primo click
se clicco nuovamente mi aggiorna il db ma la textview no