Android中利用数据库查询电话归属地

1.首先将我们的归属地的数据库放入assets/address.db
2.然后需要将我们的数据库文件copy到
data/data/com.ittest.address/files/address.db

private void copyDB(String dbName) {//dbName文件名        File destFile = new File(getFilesDir(),dbName);        //System.out.println(getFilesDir());        if(destFile.exists()){//如果存在就不需要再次copy了            System.out.println("数据库已存在");            return;        }        InputStream in = null;        FileOutputStream out = null;        try {            in = getAssets().open(dbName);            out = new FileOutputStream(destFile);            int len = 0;            byte[] buffer = new byte[1024];            while((len = in.read(buffer))!= -1){                out.write(buffer,0,len);            }        } catch (IOException e) {            e.printStackTrace();        }finally{            try {                in.close();                out.close();            } catch (IOException e) {                e.printStackTrace();            }        }    }

3.创建一个AddressDao.java，进行数据库查询操作
手机匹配较为简略，但是大致能够覆盖，但是对于3位，4位号码由于缺少数据库的支持，所以只是写个大概，知道意思就行了。

public class AddressDao {    private static final String PATH = "data/data/com.ittest.address/files/address.db";// 注意该路径必须是data/data否则数据库访问不到    public static String getAddress(String number) {        String address = "未知号码";//默认        // 获取数据库对象        SQLiteDatabase database = SQLiteDatabase.openDatabase(PATH, null,                SQLiteDatabase.OPEN_READONLY);        // 数据号码特点：1+(3,4,5,6,7,8)+(1-9)        // 正则表达式        // ^1[3-8]\d{9}$        if (number.matches("^1[3-8]\\d{9}$")) {// 匹配手机号码            Cursor cursor = database                    .rawQuery(                            "select location from data2 where id=(select outkey from data1 where id=?)",                            new String[] { number.substring(0, 7) });            if (cursor.moveToNext()) {                address = cursor.getString(0);            }            cursor.close();        } else if (number.matches("\\d+$")) {            switch (number.length()) {            case 3:                address = "报警电话";                break;            case 4:                address = "模拟器";                break;            case 5:                address = "客服电话";                break;            case 8:                address = "本地电话";                break;            default:                // 010-88881234                if (number.startsWith("0") && number.length() > 10) {                    // 有些区号是4位，有些区号是3位                    Cursor cursor = database.rawQuery(                            "select location from data2 where area=?",                            new String[] { number.substring(1, 4) });                    if (cursor.moveToNext()) {                        address = cursor.getString(0);                    } else {                        cursor = database.rawQuery(                                "select location from data2 where area=?",                                new String[] { number.substring(1, 3) });                        if (cursor.moveToNext()) {                            address = cursor.getString(0);                        }                        cursor.close();                    }                    break;                }            }        }        database.close();//关闭数据库        return address;    }}

4.最后是我们的activity，只有EditText，Buttion，TextView这三个，布局文件略。

public class AddressQueryActivity extends Activity {    private EditText etQueryPhone;    private TextView tvQueryResult;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_address_query);        etQueryPhone = (EditText) findViewById(R.id.et_queryPhone);        tvQueryResult = (TextView) findViewById(R.id.tv_queryResult);        etQueryPhone.addTextChangedListener(new TextWatcher() {//etittext变化监听器，可以不让用户去点击按钮            @Override            public void onTextChanged(CharSequence s, int start, int before, int count) {                String address = AddressDao.getAddress(s.toString());                tvQueryResult.setText(address);            }            @Override            public void beforeTextChanged(CharSequence s, int start, int count,                    int after) {            }            @Override            public void afterTextChanged(Editable s) {            }        });    }    public void query(View view) {        String phone = etQueryPhone.getText().toString().trim();        if (!TextUtils.isEmpty(phone)) {            String address = AddressDao.getAddress(phone);            tvQueryResult.setText(address);        }    }}