Android139 360 blacklist additions and deletions-database operations
Last Update:2016-01-16
Source: Internet
Author: User
<span id="Label3"></p><p><p>Blacknumberopenhelper.java</p></p><pre><span style="color: #0000ff;"><span style="color: #0000ff;"></span> package</span><span style="color: #000000;"><span style="color: #000000;">com.itheima52.mobilesafe.db.dao;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.content.Context;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.database.sqlite.SQLiteDatabase;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.database.sqlite.SQLiteOpenHelper;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">class</span></span>Blacknumberopenhelper<span style="color: #0000ff;"><span style="color: #0000ff;">extends</span></span><span style="color: #000000;"><span style="color: #000000;">sqliteopenhelper{</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span><span style="color: #000000;"><span style="color: #000000;">blacknumberopenhelper (context Context) {</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Super</span></span>(context, "safe.db",<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span>, 1<span style="color: #000000;"><span style="color: #000000;">); } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">* Blacknumber Table name * _id PRIMARY KEY Auto-grow * Number phone * mode intercept pattern phone intercept SMS intercept</span></span><span style="color: #008000;"><span style="color: #008000;">*/</span></span><span style="color: #000000;"><span style="color: #000000;">@Override</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span><span style="color: #000000;"><span style="color: #000000;">onCreate (sqlitedatabase db) {db.execsql (</span></span>"create table Blacknumber (_id integer PRIMARY key autoincrement,number varchar (), mode varchar (2))"<span style="color: #000000;"><span style="color: #000000;">); } @Override</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span>Onupgrade (sqlitedatabase db,<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>oldversion,<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span><span style="color: #000000;"><span style="color: #000000;">Newversion) { }}</span></span></pre><p><p>Blacknumberdao.java</p></p><pre><span style="color: #0000ff;"><span style="color: #0000ff;"></span> package</span><span style="color: #000000;"><span style="color: #000000;">main.java.com.itheima52.mobilesafe.db.dao;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.content.ContentValues;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.content.Context;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.database.Cursor;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.database.sqlite.SQLiteDatabase;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.os.SystemClock;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">com.itheima52.mobilesafe.bean.BlackNumberInfo;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">java.util.ArrayList;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">java.util.List;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">class</span></span>Blacknumberdao {<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">Change and delete</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span><span style="color: #000000;"><span style="color: #000000;">Blacknumberopenhelper helper; </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span><span style="color: #000000;"><span style="color: #000000;">Blacknumberdao (context Context) {helper</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Blacknumberopenhelper (context); } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">Add a number *</span></span><span style="color: #808080;"><span style="color: #808080;">@param</span></span><span style="color: #008000;"><span style="color: #008000;">Number blacklist *</span></span><span style="color: #808080;"><span style="color: #808080;">@param</span></span><span style="color: #008000;"><span style="color: #008000;">Mode intercept Modes</span></span><span style="color: #008000;"><span style="color: #008000;">*/</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">Boolean</span></span><span style="color: #000000;"><span style="color: #000000;">add (string number, string mode) {sqlitedatabase db</span></span>=<span style="color: #000000;"><span style="color: #000000;">Helper.getwritabledatabase (); Contentvalues contentvalues</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">contentvalues (); Contentvalues.put (</span></span>"number"<span style="color: #000000;"><span style="color: #000000;">, number); Contentvalues.put (</span></span>"mode"<span style="color: #000000;"><span style="color: #000000;">, mode); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Long</span></span>rowID = Db.insert ("blacknumber",<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span><span style="color: #000000;"><span style="color: #000000;">, contentvalues); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(rowid = =-1<span style="color: #000000;"><span style="color: #000000;">) { </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">false</span></span>;<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">Add failed</span></span>}<span style="color: #0000ff;"><span style="color: #0000ff;">Else</span></span><span style="color: #000000;"><span style="color: #000000;"> { </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">true</span></span><span style="color: #000000;"><span style="color: #000000;">; } } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">* Delete by phone number *</span></span><span style="color: #808080;"><span style="color: #808080;">@param</span></span><span style="color: #008000;"><span style="color: #008000;">number</span></span><span style="color: #008000;"><span style="color: #008000;">*/</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">Boolean</span></span><span style="color: #000000;"><span style="color: #000000;">Delete (String number) {sqlitedatabase db</span></span>=<span style="color: #000000;"><span style="color: #000000;">Helper.getwritabledatabase (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>RowNumber = Db.delete ("blacknumber", "number=?",<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">string[]{number}); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(rowNumber = = 0) {<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">Number of deletions</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">false</span></span><span style="color: #000000;"><span style="color: #000000;">; } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Else</span></span><span style="color: #000000;"><span style="color: #000000;"> { </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">true</span></span><span style="color: #000000;"><span style="color: #000000;">; } } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">* Change the interception mode by phone number</span></span><span style="color: #008000;"><span style="color: #008000;">*/</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">Boolean</span></span><span style="color: #000000;"><span style="color: #000000;">changenumbermode (string number, string mode) {sqlitedatabase db</span></span>=<span style="color: #000000;"><span style="color: #000000;">Helper.getwritabledatabase (); Contentvalues Values</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">contentvalues (); Values.put (</span></span>"mode"<span style="color: #000000;"><span style="color: #000000;">, mode); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>RowNumber =db.update ("blacknumber", values, "number=?",<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>string[]{number});<span style="color: #008000;"><span style="color: #008000;">//</span></span><span style="color: #008000;"><span style="color: #008000;">"number=?" is the Where Condition</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span>(rownumber = = 0<span style="color: #000000;"><span style="color: #000000;">) { </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">false</span></span><span style="color: #000000;"><span style="color: #000000;">; } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Else</span></span><span style="color: #000000;"><span style="color: #000000;"> { </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">true</span></span><span style="color: #000000;"><span style="color: #000000;">; } } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">* Returns a blacklist number interception mode</span></span><span style="color: #008000;"><span style="color: #008000;">*/</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span><span style="color: #000000;"><span style="color: #000000;">string findnumber (string number) {string mode</span></span>= ""<span style="color: #000000;"><span style="color: #000000;">; Sqlitedatabase DB</span></span>=<span style="color: #000000;"><span style="color: #000000;">Helper.getreadabledatabase (); Cursor Cursor</span></span>= Db.query ("blacknumber",<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>string[]{"mode"}, "number=?",<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>string[]{number},<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span>,<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span>,<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">if</span></span><span style="color: #000000;"><span style="color: #000000;">(cursor.movetonext ()) {mode</span></span>= Cursor.getstring (0<span style="color: #000000;"><span style="color: #000000;">); } cursor.close (); Db.close (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span><span style="color: #000000;"><span style="color: #000000;">mode; } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">* Check all the blacklists</span></span><span style="color: #008000;"><span style="color: #008000;">*/</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span>List<blacknumberinfo><span style="color: #000000;"><span style="color: #000000;">findAll () {sqlitedatabase db</span></span>=<span style="color: #000000;"><span style="color: #000000;">Helper.getreadabledatabase (); List</span></span><BlackNumberInfo> Blacknumberinfos =<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>Arraylist<blacknumberinfo><span style="color: #000000;"><span style="color: #000000;">(); Cursor Cursor</span></span>= Db.query ("blacknumber",<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>string[]{"number", "mode"},<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span>,<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span>,<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span>,<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span>,<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span><span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> while</span><span style="color: #000000;"><span style="color: #000000;">(cursor.movetonext ()) {blacknumberinfo blacknumberinfo</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Blacknumberinfo (); Blacknumberinfo.setnumber (cursor.getstring (</span></span>0<span style="color: #000000;"><span style="color: #000000;">)); Blacknumberinfo.setmode (cursor.getstring (</span></span>1<span style="color: #000000;"><span style="color: #000000;">)); Blacknumberinfos.add (blacknumberinfo); } cursor.close (); Db.close (); Systemclock.sleep (</span></span>3000<span style="color: #000000;"><span style="color: #000000;">); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span><span style="color: #000000;"><span style="color: #000000;">blacknumberinfos; } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">* Paging Load Data *</span></span><span style="color: #808080;"><span style="color: #808080;">@param</span></span><span style="color: #008000;"><span style="color: #008000;">pagenumber indicates which page is currently *</span></span><span style="color: #808080;"><span style="color: #808080;">@param</span></span><span style="color: #008000;"><span style="color: #008000;">PageSize indicates how many data per page *</span></span><span style="color: #808080;"><span style="color: #808080;">@return</span></span><span style="color: #008000;"><span style="color: #008000;">limit indicates how much data is currently available * offset means jumping</span> from the beginning of the first</span><span style="color: #008000;"><span style="color: #008000;">*/</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span>List<blacknumberinfo> Findpar (<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>pagenumber,<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span><span style="color: #000000;"><span style="color: #000000;">PageSize) {sqlitedatabase DB</span></span>=<span style="color: #000000;"><span style="color: #000000;">Helper.getreadabledatabase (); Cursor Cursor</span></span>= Db.rawquery ("select number,mode from Blacknumber limit? offset? ",<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">string[]{string.valueof (pageSize), string.valueof (pageSize</span></span>*<span style="color: #000000;"><span style="color: #000000;">pagenumber)}); List</span></span><BlackNumberInfo> Blacknumberinfos =<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>Arraylist<blacknumberinfo><span style="color: #000000;"><span style="color: #000000;">(); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> while</span><span style="color: #000000;"><span style="color: #000000;">(cursor.movetonext ()) {blacknumberinfo blacknumberinfo</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Blacknumberinfo (); Blacknumberinfo.setmode (cursor.getstring (</span></span>1<span style="color: #000000;"><span style="color: #000000;">)); Blacknumberinfo.setnumber (cursor.getstring (</span></span>0<span style="color: #000000;"><span style="color: #000000;">)); Blacknumberinfos.add (blacknumberinfo); } cursor.close (); Db.close (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span><span style="color: #000000;"><span style="color: #000000;">blacknumberinfos; } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">* Load data in batches *</span></span><span style="color: #808080;"><span style="color: #808080;">@param</span></span><span style="color: #008000;"><span style="color: #008000;">startIndex Start Position *</span></span><span style="color: #808080;"><span style="color: #808080;">@param</span></span><span style="color: #008000;"><span style="color: #008000;">MaxCount The largest entry per page</span></span><span style="color: #008000;"><span style="color: #008000;">*/</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span>List<blacknumberinfo> FindPar2 (<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>startIndex,<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span><span style="color: #000000;"><span style="color: #000000;">MaxCount) {sqlitedatabase DB</span></span>=<span style="color: #000000;"><span style="color: #000000;">Helper.getreadabledatabase (); Cursor Cursor</span></span>= Db.rawquery ("select number,mode from Blacknumber limit? offset? ",<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">string[]{string.valueof (maxCount), string.valueof (startIndex)}); List</span></span><BlackNumberInfo> Blacknumberinfos =<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span>Arraylist<blacknumberinfo><span style="color: #000000;"><span style="color: #000000;">(); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> while</span><span style="color: #000000;"><span style="color: #000000;">(cursor.movetonext ()) {blacknumberinfo blacknumberinfo</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Blacknumberinfo (); Blacknumberinfo.setmode (cursor.getstring (</span></span>1<span style="color: #000000;"><span style="color: #000000;">)); Blacknumberinfo.setnumber (cursor.getstring (</span></span>0<span style="color: #000000;"><span style="color: #000000;">)); Blacknumberinfos.add (blacknumberinfo); } cursor.close (); Db.close (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span><span style="color: #000000;"><span style="color: #000000;">blacknumberinfos; } </span></span><span style="color: #008000;"><span style="color: #008000;">/**</span></span><span style="color: #008000;"><span style="color: #008000;">* Get the total number of records</span></span><span style="color: #008000;"><span style="color: #008000;">*/</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span><span style="color: #000000;"><span style="color: #000000;">gettotalnumber () {sqlitedatabase db</span></span>=<span style="color: #000000;"><span style="color: #000000;">Helper.getreadabledatabase (); Cursor Cursor</span></span>= Db.rawquery ("select count (*) from blacknumber",<span style="color: #0000ff;"><span style="color: #0000ff;">NULL</span></span><span style="color: #000000;"><span style="color: #000000;">); Cursor.movetonext (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>Count = Cursor.getint (0<span style="color: #000000;"><span style="color: #000000;">); Cursor.close (); Db.close (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">return</span></span><span style="color: #000000;"><span style="color: #000000;">count; }}</span></span></pre><p><p>Test Testblacknumberdao.java</p></p><pre><span style="color: #0000ff;"><span style="color: #0000ff;"></span> package</span><span style="color: #000000;"><span style="color: #000000;">com.itheima52.mobilesafe;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.content.Context;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">android.test.AndroidTestCase;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">com.itheima52.mobilesafe.bean.BlackNumberInfo;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">com.itheima52.mobilesafe.db.dao.BlackNumberDao;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">java.util.List;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Import</span></span><span style="color: #000000;"><span style="color: #000000;">java.util.Random;</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">class</span></span>Testblacknumberdao<span style="color: #0000ff;"><span style="color: #0000ff;">extends</span></span><span style="color: #000000;"><span style="color: #000000;">Androidtestcase {</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span><span style="color: #000000;"><span style="color: #000000;">Context mcontext; @Override</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">protected</span></span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span>SetUp ()<span style="color: #0000ff;"><span style="color: #0000ff;">throws</span></span><span style="color: #000000;"><span style="color: #000000;">Exception {</span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> this</span>. Mcontext =<span style="color: #000000;"><span style="color: #000000;">GetContext (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Super</span></span><span style="color: #000000;"><span style="color: #000000;">. SetUp (); } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span><span style="color: #000000;"><span style="color: #000000;">testadd () {blacknumberdao DAO</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Blacknumberdao (mcontext); Random Random</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Random (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> for</span>(<span style="color: #0000ff;"><span style="color: #0000ff;">int</span></span>i = 0; I < 200; i++<span style="color: #000000;"><span style="color: #000000;">) {Long</span> number</span>= 13300000000l +<span style="color: #000000;"><span style="color: #000000;">i; Dao.add (</span> number</span>+ "", string.valueof (random.nextint (3) + 1<span style="color: #000000;"><span style="color: #000000;">)); } } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span><span style="color: #000000;"><span style="color: #000000;">testdelete () {blacknumberdao DAO</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Blacknumberdao (mcontext); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;">Boolean</span></span>Delete = Dao.delete ("13300000000"<span style="color: #000000;"><span style="color: #000000;">); Assertequals (</span></span><span style="color: #0000ff;"><span style="color: #0000ff;">true</span></span><span style="color: #000000;"><span style="color: #000000;">, delete); } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span><span style="color: #000000;"><span style="color: #000000;">testfind () {blacknumberdao DAO</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Blacknumberdao (mcontext); String</span> number</span>= Dao.findnumber ("13300000004"<span style="color: #000000;"><span style="color: #000000;">); System.out.println (number); } </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> public</span> <span style="color: #0000ff;"><span style="color: #0000ff;">void</span></span><span style="color: #000000;"><span style="color: #000000;">testfindall () {blacknumberdao DAO</span></span>=<span style="color: #0000ff;"><span style="color: #0000ff;">New</span></span><span style="color: #000000;"><span style="color: #000000;">Blacknumberdao (mcontext); List</span></span><BlackNumberInfo> Blacknumberinfos =<span style="color: #000000;"><span style="color: #000000;">Dao.findall (); </span></span><span style="color: #0000ff;"><span style="color: #0000ff;"></span> for</span><span style="color: #000000;"><span style="color: #000000;">(blacknumberinfo blacknumberinfo:blacknumberinfos) {System.out.println (blacknumberinfo.getmode ()</span></span>+ "" +<span style="color: #000000;"><span style="color: #000000;">Blacknumberinfo.getnumber ()); } }}</span></span></pre><p><p></p></p><p><p>Android139 360 blacklist additions and deletions-database operations</p></p></span>