來電顯示歸屬地是手機安全/通訊類 App 的核心功能。純聯網查詢延遲高、離線不可用;純本地資料庫包體大、更新不及時。最佳實踐是 「本地優先,聯網補查」:App 內置精簡離線資料庫(含主流號段),查無結果再發起網路請求,兼顧速度、離線可用性與包體大小。
assets/address.db 複製到 /data/data/pkg/files/address.db(僅首次)。TextWatcher 實現輸入即時查詢。data1 表獲取 outkey,再關聯 data2 表取得 location。private void copyDatabaseIfNeeded() {
File dbFile = new File(getFilesDir(), "address.db");
if (dbFile.exists() && dbFile.length() > 0) return; // 已存在
try (InputStream is = getAssets().open("address.db");
FileOutputStream fos = new FileOutputStream(dbFile)) {
byte[] buffer = new byte[1024];
int len;
while ((len = is.read(buffer)) > 0) {
fos.write(buffer, 0, len);
}
fos.flush();
} catch (IOException e) {
e.printStackTrace();
}
}
package com.example.mobilesafe.db.dao;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
public class AddressDao {
private static final String DB_PATH = "data/data/com.example.mobilesafe/files/address.db";
public static String getAddress(String number) {
String address = number; // 預設顯示號碼本身
// 簡易手機號格式驗證(支援 13/14/15/16/18/19 開頭)
if (number.matches("^1[3-9]\\d{9}$")) {
String sql = "SELECT location FROM data2 WHERE id = (SELECT outkey FROM data1 WHERE id = ?)";
SQLiteDatabase db = SQLiteDatabase.openDatabase(DB_PATH, null, SQLiteDatabase.OPEN_READONLY);
Cursor cursor = db.rawQuery(sql, new String[]{number.substring(0, 7)});
if (cursor.moveToNext()) {
address = cursor.getString(0);
}
cursor.close();
db.close();
} else {
address = "非手機號碼";
}
return address;
}
}
// 按鈕點擊查詢
public void queryAddress(View view) {
String number = etPhone.getText().toString().trim();
String address = AddressDao.getAddress(number);
etAddress.setText(address);
}
// 輸入框文字變化監聽:輸入超過 3 碼即時查詢
etPhone.addTextChangedListener(new TextWatcher() {
@Override
public void onTextChanged(CharSequence s, int start, int before, int count) {
if (s.length() >= 3) {
String address = AddressDao.getAddress(s.toString());
etAddress.setText(address);
}
}
@Override public void beforeTextChanged(CharSequence s, int start, int count, int after) {}
@Override public void afterTextChanged(Editable s) {}
});
data1:id (VARCHAR, 前7碼號段) → outkey (INTEGER, 外鍵指向 data2.id)data2:id (INTEGER PK) → location (VARCHAR, 歸屬地字串,如「北京移動」)此結構將重複的歸局地字串正規化至 data2,大幅壓縮資料庫體積(約 1-2MB 覆蓋全中國號段)。
// 本地查無結果時觸發
if ("非手機號碼".equals(address) || address.equals(number)) {
// 發起非同步網路請求,例如:https://apis.juhe.cn/mobile/get?phone=xxx&key=YOUR_KEY
// 解析 JSON 取得 province + city + company,組合顯示
// 可選:插入本地 data2 表快取(需資料庫可寫權限)
}
data1.id 建立索引,查詢速度可達毫秒級。ExecutorService / RxJava / Coroutines),避免主執行緒阻塞導致輸入卡頓。