sql - android sqlite query no return? -

-

i have sqlite database , want query through db , populate listview return, listview shows 1 row return more 1 row , there no error. item class contains setters , getters.

i use method query: 

filllist2(edtseach.getquery().tostring().tolowercase(),"zankodict", "id","eng",long.valueof(1),long.valueof(1794));

which method:

 private void filllist2(string keyword,string table, string columnn,string column2,long num1,long num2) {         if (keyword.equals(buildconfig.flavor)) {             this.mylist = new arraylist();         } else if (keyword.tochararray().length < 2) {             mylist.clear();             mylist.add(dbquery.a(keyword,table,columnn,column2,num1,num2));          } else {             mylist.clear();             mylist.add(dbquery.a(keyword,table,columnn,column2,num1,num2));         }                 mylistview.setadapter(new adapteren(getactivity(), r.layout.single_row, mylist,keyword));         }     }

dbquery.class

import android.database.cursor;   public class dbquery {     private static item itemm, itemm2;     private static cursor cursor10;     public static item a(string keyword,string table, string columnn,string column2, long num1,long num2) {         c0101f.getdatabasehelper().opendatabase();          cursor10 =  c0101f.getdatabasehelper().querydata("select * "+ table +" "+ columnn +" between "+num1+" , "+num2+ " , " +column2+ " '"+ keyword + "%'");         itemm2 = cur(table);         c0101f.getdatabasehelper().closedatabase();         return itemm2;     }     public static item cur(string table){         switch (table) {             case "zankodict":                 if (cursor10 != null) {                     if (cursor10.movetofirst()) {                         {                             itemm = new item();                             itemm.setid(cursor10.getstring(0));                             itemm.seteng(cursor10.getstring(1));                         } while (cursor10.movetonext());                     }                 }                 break;             case "kudict":                 if (cursor10 != null) {                     if (cursor10.movetofirst()) {                         {                             itemm = new item();                             itemm.setid(cursor10.getstring(0));                             itemm.setkurd(cursor10.getstring(1));                             itemm.setid2(cursor10.getlong(2));                         } while (cursor10.movetonext());                     }                 }                 break;             case "ardict":                 if (cursor10 != null) {                     if (cursor10.movetofirst()) {                         {                             itemm = new item();                             itemm.setid(cursor10.getstring(0));                             itemm.setar(cursor10.getstring(1));                             itemm.setid2(cursor10.getlong(2));                         } while (cursor10.movetonext());                     }                 }                 break;         }         return itemm;     }  }

i added array list adds items every time go through loop.

import android.database.cursor;  import java.util.arraylist;  /**  * created rrr on 11/12/2016.  */  public class dbquery {     public static arraylist<item> mylist = new arraylist<item>();     public static arraylist<item> mylist2 = new arraylist<item>();     private static item itemm;     private static cursor cursor10;     public static arraylist<item> a(string keyword,string table, string columnn,string column2, long num1,long num2) {         c0101f.getdatabasehelper().opendatabase();          cursor10 =  c0101f.getdatabasehelper().querydata("select * "+ table +" "+ columnn +" between "+num1+" , "+num2+ " , " +column2+ " '"+ keyword + "%'");         mylist2 = cur(table);         c0101f.getdatabasehelper().closedatabase();         return mylist2;     }     public static arraylist<item> cur(string table){         switch (table) {             case "zankodict":                 if (cursor10 != null) {                     if (cursor10.movetofirst()) {                         {                             itemm = new item();                             itemm.setid(cursor10.getstring(0));                             itemm.seteng(cursor10.getstring(1));                             mylist.add(itemm);                         } while (cursor10.movetonext());                     }                 }                 break;             case "kudict":                 if (cursor10 != null) {                     if (cursor10.movetofirst()) {                         {                             itemm = new item();                             itemm.setid(cursor10.getstring(0));                             itemm.setkurd(cursor10.getstring(1));                             itemm.setid2(cursor10.getlong(2));                             mylist.add(itemm);                         } while (cursor10.movetonext());                     }                 }                 break;             case "ardict":                 if (cursor10 != null) {                     if (cursor10.movetofirst()) {                         {                             itemm = new item();                             itemm.setid(cursor10.getstring(0));                             itemm.setar(cursor10.getstring(1));                             itemm.setid2(cursor10.getlong(2));                             mylist.add(itemm);                         } while (cursor10.movetonext());                     }                 }                 break;         }         return mylist;     }  }

Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more