3.3 手机号码归属地查询

/**

 *  号码归属地查询的 dao

 *  @author Administrator

 *

 */

public  class AddressDao {

      

      public  static String getAddress(String number,Context context){

            String location= null;

             //打开数据库

            SQLiteDatabase  db=SQLiteDatabase.openDatabase("/data/data/"+context.getPackageName()+"/files/address.db",

          null,SQLiteDatabase. OPEN_READONLY);

            

            

             //判断传入的号码是否是手机号

             if (number.matches( "^1[3458]\\d{9}$")) {// 手机号码

                  Cursor cursor = db.rawQuery( "select location  from data2 where id=(select outkey from data1 where id=?)", new String[]{number.substring(0, 7)});

                if(cursor.moveToFirst()){

                  location=cursor.getString(0);

                }

                cursor.close();

                db.close();     //关闭数据库

                  

            } else{

                  Toast. makeText(context, "输入的手机号有误", 0).show();

            }

            

             return location;

      }

      

      

      

}