删除单个数据 SQLite 并显示B. TextView /发展 Android/

目的

: 从表中删除单个数据 SQLite 并在表格中显示它们 TextView.

案子：

无法获取数据并无法显示它们 mainactivity.

预期结果：

TextView 在主要类型的活动中显示当前的公共银行余额 /例如，整体球： $7600/

笔记

注意，请告诉我代码 mainactiviy 收据，以及显示信息。 先感谢您 /对不起我的英语不好/.

package com.fa.money;

import java.util.ArrayList;

import java.util.HashMap;

import android.util.Log;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;



public class DBController extends SQLiteOpenHelper {

private static final String LOGCAT = null;



public DBController/Context applicationcontext/ {

 super/applicationcontext, "androidsqlite.db", null, 1/;

 Log.d/LOGCAT,"Created"/;

}



@Override

public void onCreate/SQLiteDatabase database/ {

 String query, query2;

// query = "CREATE TABLE tbBank / bankID INTEGER PRIMARY KEY, bankname TEXT/";

 query = "CREATE TABLE tbBank / bankID INTEGER PRIMARY KEY AUTOINCREMENT, bankname TEXT, baccID TEXT, baccBal TEXT, remarks TEXT/";

 query2 = "CREATE TABLE tbMain /mainID INTEGER PRIMARY KEY AUTOINCREMENT, bankbal TEXT, loanbal TEXT/";

 database.execSQL/query/;

 database.execSQL/query2/;



 Log.d/LOGCAT,"Bank Account Created"/;

}

@Override

public void onUpgrade/SQLiteDatabase database, int version_old, int current_version/ {

 String query,query2;

 query = "DROP TABLE IF EXISTS tbBank";

 query2 = "DROP TABLE IF EXISTS tbMain";

 database.execSQL/query/;

 database.execSQL/query2/;

 onCreate/database/;

}



public void addBank/HashMap<string, string=""> queryValues/ {

 SQLiteDatabase database = this.getWritableDatabase//;

 ContentValues values = new ContentValues//;

 values.put/"bankname", queryValues.get/"bankname"//;

 values.put/"baccID", queryValues.get/"bankaccid"//;

 values.put/"baccBal", queryValues.get/"totalbal"//;

 values.put/"remarks", queryValues.get/"remarks"//;

 database.insert/"tbBank", null, values/;

 database.close//;

}



public int updateBank/HashMap<string, string=""> queryValues/ {

 SQLiteDatabase database = this.getWritableDatabase//; 

 ContentValues values = new ContentValues//;

 values.put/"bankname", queryValues.get/"bankname"//;

 return database.update/"tbBank", values, "bankID" + " = ?", new String[] { queryValues.get/"bankID"/ }/;

 //String updateQuery = "Update words set txtWord='"+word+"' where txtWord='"+ oldWord +"'";

 //Log.d/LOGCAT,updateQuery/;

 //database.rawQuery/updateQuery, null/;

 //return database.update/"words", values, "txtWord = ?", new String[] { word }/;

}



public void deleteBank/String id/ {

 Log.d/LOGCAT,"delete"/;

 SQLiteDatabase database = this.getWritableDatabase//; 

 String deleteQuery = "DELETE FROM tbBank where bankID='"+ id +"'";

 Log.d/"query",deleteQuery/; 

 database.execSQL/deleteQuery/;

}



public ArrayList<hashmap<string, string="">&gt; getAllbank// {

 ArrayList<hashmap<string, string="">&gt; wordList;

 wordList = new ArrayList<hashmap<string, string="">&gt;//;

 String selectQuery = "SELECT * FROM tbBank";

 SQLiteDatabase database = this.getWritableDatabase//;

 Cursor cursor = database.rawQuery/selectQuery, null/;

 if /cursor.moveToFirst/// {

 do {

 HashMap<string, string=""> map = new HashMap<string, string="">//;

 map.put/"bankID", cursor.getString/0//;

 map.put/"bankname", cursor.getString/1//;

 wordList.add/map/;

 } while /cursor.moveToNext///;

 }





 return wordList;

}



public HashMap<string, string=""> getBankinfo/String id/ {

 HashMap<string, string=""> wordList = new HashMap<string, string="">//;

 SQLiteDatabase database = this.getReadableDatabase//;

 String selectQuery = "SELECT * FROM tbBank where bankID='"+id+"'";

 Cursor cursor = database.rawQuery/selectQuery, null/;

 if /cursor.moveToFirst/// {

 do {

 //HashMap<string, string=""> map = new HashMap<string, string="">//;

 wordList.put/"bankname", cursor.getString/1//;

 //wordList.add/map/;

 } while /cursor.moveToNext///;

 } 

return wordList;

}

//getbankbal - ERROR here !

public String getBankbal// {

 String bankbalresult;

 SQLiteDatabase database = this.getReadableDatabase//;

 String selectQuery = "SELECT bankbal FROM tbMain";

 Cursor cursor = database.rawQuery/selectQuery, null/;

 if /cursor.moveToFirst/// {

 do {

 bankbalresult.put/"bankbal", cursor.getString/1//;

 } while /cursor.moveToNext///;

 } 

 return bankbalresult;

 } }

</string,></string,></string,></string,></string,></string,></string,></hashmap<string,></hashmap<string,></hashmap<string,></string,></string,>