80,356
社区成员
发帖
与我相关
我的任务
分享
public class AddressDao {
public static final String path = "/data/data/com.zhong.mobilesafe/files/address.db";
/**
* 获取手机号码的归属地
*
* @param number
* 传入的手机号码
* @return 归属地
*/
public static String getAddress(String number) {
String address = number;
SQLiteDatabase db = SQLiteDatabase.openDatabase(path, 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.moveToNext()) {
address = cursor.getString(0);
}
cursor.close();
}
db.close();
return address;
[/quote]public class AddressDao {
public static final String path = "/data/data/com.zhong.mobilesafe/files/address.db";
/**
* 获取手机号码的归属地
*
* @param number
* 传入的手机号码
* @return 归属地
*/
public static String getAddress(String number) {
String address = number;
SQLiteDatabase db = SQLiteDatabase.openDatabase(path, 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.moveToNext()) {
address = cursor.getString(0);
}
cursor.close();
}
db.close();
return address;