Guest User

Untitled

a guest
Jan 13th, 2019
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.21 KB | None | 0 0
  1. Cannot retrieve data from database and display in listview
  2. //User Table
  3. public static final String KEY_ROWID = "_id";
  4. public static final String KEY_UNAME = "name";
  5. public static final String KEY_USURNAME = "surname";
  6. public static final String KEY_UUSERNAME = "username";
  7. public static final String KEY_UPASSWORD = "password";
  8. public static final String KEY_UEMAILADDRESS = "emailadd";
  9.  
  10. //Account Table
  11. public static final String KEY_ROWID1 = "_id";
  12. public static final String KEY_BANKNAME =" bankname";
  13. public static final String KEY_TYPE = " type";
  14. public static final String KEY_ACCNUM = " accnum";
  15. public static final String KEY_BALANCE = " balance";
  16. public static final String KEY_EXPIRYDATE = " expirydate";
  17.  
  18. private static final String DATABASE_NAME = "MoneyManagerSys";
  19. public static final String DATABASE_TABLE = " Usertb";
  20. public static final String DATABASE_TABLE1 = " Accounttb";
  21. private static final String DATABASE_TABLE2 = " Transactiontb";
  22. private static final String DATABASE_TABLE3 = " BillRemindertb";
  23. //Database Version
  24. private static final int DATABASE_VERSION = 1;
  25. private static String Usertb;
  26. private static String Accounttb;
  27. private DbHelper MHelper;
  28. private final Context MContext;
  29. private SQLiteDatabase Mdatabase;
  30.  
  31. private static final String DATABASE_USER_TABLE = "CREATE TABLE" + DATABASE_TABLE + " (" +
  32. KEY_ROWID + " INTEGER PRIMARY KEY, " +
  33. KEY_UNAME + " TEXT , " +
  34. KEY_USURNAME + " TEXT , " +
  35. KEY_UUSERNAME + " TEXT , " +
  36. KEY_UPASSWORD + " TEXT , " +
  37. KEY_UEMAILADDRESS + " TEXT );" ;
  38.  
  39. private static final String DATABASE_ACCOUNT_TABLE1 = "CREATE TABLE" + DATABASE_TABLE1 + " (" +
  40. KEY_ROWID1 + " INTEGER PRIMARY KEY, " +
  41. KEY_BANKNAME + " TEXT , " +
  42. KEY_TYPE + " TEXT , " +
  43. KEY_ACCNUM + " TEXT , " +
  44. KEY_BALANCE + " TEXT , " +
  45. KEY_EXPIRYDATE + " TEXT );" ;
  46.  
  47. public long createEntry1(String bankname, String type, String accnum, String balance, String expirydate) {
  48. ContentValues cv1 = new ContentValues();
  49. cv1.put(KEY_BANKNAME, bankname);
  50. cv1.put(KEY_TYPE, type);
  51. cv1.put(KEY_ACCNUM, accnum);
  52. cv1.put(KEY_BALANCE, balance);
  53. cv1.put(KEY_EXPIRYDATE, expirydate);
  54. return Mdatabase.insert(DATABASE_TABLE1, null, cv1);
  55. }
  56.  
  57. public long createEntry(String name, String surname, String username, String password, String emailadd) {
  58. // TODO Auto-generated method stub
  59. ContentValues cv = new ContentValues();
  60. cv.put(KEY_UNAME, name);
  61. cv.put(KEY_USURNAME, surname);
  62. cv.put(KEY_UUSERNAME, username);
  63. cv.put(KEY_UPASSWORD, password);
  64. cv.put(KEY_UEMAILADDRESS, emailadd);
  65. return Mdatabase.insert(DATABASE_TABLE, null, cv);
  66. }
  67.  
  68.  
  69. public String getData() {
  70. // TODO Auto-generated method stub
  71. String[] columns = new String[] {KEY_ROWID, KEY_UNAME, KEY_USURNAME, KEY_UUSERNAME, KEY_UPASSWORD, KEY_UEMAILADDRESS};
  72.  
  73. Cursor c = Mdatabase.query(DATABASE_TABLE, columns, null, null, null, null, null);
  74.  
  75. String result="";
  76. int iRow = c.getColumnIndex(KEY_ROWID);
  77. int iUname = c.getColumnIndex(KEY_UNAME);
  78. int iUsurnamne = c.getColumnIndex(KEY_USURNAME);
  79. int iUuserpassword = c.getColumnIndex(KEY_UPASSWORD);
  80. int iEmailAdd = c.getColumnIndex(KEY_UEMAILADDRESS);
  81.  
  82. for(c.moveToFirst(); !c.isAfterLast(); c.moveToNext()){
  83. result = result + c.getString(iRow) + " " + c.getString(iUname) + " " + c.getString(iUsurnamne) + " " + c.getString(iUsurnamne) + " " + c.getString(iUuserpassword) + " " + c.getString(iEmailAdd) + "n";
  84. }
  85. return result;
  86. }
  87.  
  88. public boolean Login(String username, String password) throws SQLException
  89. {
  90. Cursor mCursor = Mdatabase.rawQuery("SELECT * FROM " + DATABASE_TABLE + " WHERE username=? AND password=?", new String[]{username,password});
  91. if (mCursor != null) {
  92. if(mCursor.getCount() > 0)
  93. {
  94. return true;
  95. }
  96. }
  97. return false;
  98. }
  99.  
  100. public Cursor fetchListItems() {
  101.  
  102. Cursor cursor1 = Mdatabase.query(DATABASE_TABLE1, new String[]
  103. { KEY_ROWID1, KEY_BANKNAME, KEY_ACCNUM, KEY_BALANCE},
  104. null, null, null, null, null);
  105.  
  106. if (cursor1 != null) {
  107. cursor1.moveToFirst();
  108. }
  109. return cursor1;
  110. }
  111. }
  112.  
  113. public class TransactionListView extends ListActivity {
  114.  
  115.  
  116. /** Called when the activity is first created. */
  117. @Override
  118. public void onCreate(Bundle savedInstanceState) {
  119. super.onCreate(savedInstanceState);
  120. setContentView(R.layout.translistview);
  121. DatabaseAdapter dbHelper = new DatabaseAdapter(this);
  122. dbHelper.open();
  123.  
  124. // Get a Cursor for the list items
  125. Cursor listCursor = dbHelper.fetchListItems();
  126. startManagingCursor(listCursor);
  127.  
  128. // set the custom list adapter
  129. setListAdapter(new MyListAdapter(this, listCursor));
  130. }
  131.  
  132. private class MyListAdapter extends ResourceCursorAdapter {
  133.  
  134. public MyListAdapter(Context context, Cursor cursor) {
  135. super(context, R.layout.list_item_with_description, cursor);
  136. }
  137.  
  138. @Override
  139. public void bindView(View view, Context context, Cursor cursor1) {
  140.  
  141. TextView title = (TextView) view.findViewById(R.id.item_title);
  142. title.setText(cursor1.getString(
  143. cursor1.getColumnIndex(DatabaseAdapter.KEY_BANKNAME)));
  144.  
  145. TextView details = (TextView) view.findViewById(R.id.item_details);
  146. StringBuffer detailsText = new StringBuffer();
  147.  
  148. int price = cursor1.getInt(cursor1.getColumnIndex(DatabaseAdapter.KEY_ACCNUM));
  149. if (price > 0){
  150. detailsText.append("Rs"+price+".00");
  151. } else {
  152. detailsText.append("Price Unavailable");
  153. }
  154. String description = cursor1.getString(cursor1.getColumnIndex(
  155. DatabaseAdapter.KEY_BALANCE));
  156. if (description != null && description.length() > 0){
  157. detailsText.append(", "+description);
  158. }
  159. details.setText(detailsText.toString());
  160.  
  161. }
  162.  
  163. }
  164.  
  165. }
  166.  
  167. 10-07 16:23:10.437: E/CursorWindow(13987): Bad request for field slot 0,-1. numRows = 3, numColumns = 4
Add Comment
Please, Sign In to add comment