查询号码归属地

address.db拷贝到assets目录下,然后进行读取,将其转换在工程的Files,(Cache,sd)

/**
     * 拷贝数据库值files文件夹下
     * @param dbName    数据库名称
     */
    private void initAddressDB(String dbName) {
        //1,在files文件夹下创建同名dbName数据库文件过程
        File files = getFilesDir();
        File file = new File(files, dbName);
        if(file.exists()){
            return;
        }
        InputStream stream = null;
        FileOutputStream fos = null;
        //2,输入流读取第三方资产目录下的文件
        try {
            stream = getAssets().open(dbName);
            //3,将读取的内容写入到指定文件夹的文件中去
            fos = new FileOutputStream(file);
            //4,每次的读取内容大小
            byte[] bs = new byte[1024];
            int temp = -1;
            while( (temp = stream.read(bs))!=-1){
                fos.write(bs, 0, temp);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            if(stream!=null && fos!=null){
                try {
                    stream.close();
                    fos.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        
    }

 

public class AddressDao {
    private static final String tag = "AddressDao";
    //1,指定访问数据库的路径
    public static String path = "data/data/com.itheima.mobilesafe74/files/address.db";
    private static String mAddress = "未知号码";
    /**传递一个电话号码,开启数据库连接,进行访问,返回一个归属地
     * @param phone    查询电话号码
     */
    public static String getAddress(String phone){
        mAddress = "未知号码";
        //正则表达式,匹配手机号码
        //手机号码的正则表达式
        String regularExpression = "^1[3-8]\\d{9}";
        //2,开启数据库连接(只读的形式打开)
        SQLiteDatabase db = SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.OPEN_READONLY);
        if(phone.matches(regularExpression)){
            phone = phone.substring(0,7);
            //3,数据库查询
            Cursor cursor = db.query("data1", new String[]{"outkey"}, "id = ?", new String[]{phone}, null, null, null);
            //4,查到即可
            if(cursor.moveToNext()){
                String outkey = cursor.getString(0);
                Log.i(tag, "outkey = "+outkey);
                //5,通过data1查询到的结果,作为外键查询data2
                Cursor indexCursor = db.query("data2", new String[]{"location"}, "id = ?", new String[]{outkey}, null, null, null);
                if(indexCursor.moveToNext()){
                    //6,获取查询到的电话归属地
                    mAddress = indexCursor.getString(0);
                    Log.i(tag, "address = "+mAddress);
                }
            }else{
                mAddress = "未知号码";
            }
        }else{
            int length = phone.length();
            switch (length) {
            case 3://119 110 120 114
                mAddress = "报警电话";
                break;
            case 4://119 110 120 114
                mAddress = "模拟器";
                break;
            case 5://10086 99555
                mAddress = "服务电话";
                break;
            case 7:
                mAddress = "本地电话";
                break;
            case 8:
                mAddress = "本地电话";
                break;
            case 11:
                //(3+8) 区号+座机号码(外地),查询data2
                String area = phone.substring(1, 3);
                Cursor cursor = db.query("data2", new String[]{"location"}, "area = ?", new String[]{area}, null, null, null);
                if(cursor.moveToNext()){
                    mAddress = cursor.getString(0);
                }else{
                    mAddress = "未知号码";
                }
                break;
            case 12:
                //(4+8) 区号(0791(江西南昌))+座机号码(外地),查询data2
                String area1 = phone.substring(1, 4);
                Cursor cursor1 = db.query("data2", new String[]{"location"}, "area = ?", new String[]{area1}, null, null, null);
                if(cursor1.moveToNext()){
                    mAddress = cursor1.getString(0);
                }else{
                    mAddress = "未知号码";
                }
                break;
            }
        }
        return mAddress;
    }
}