public class AddressQueryDao {
public static String queryAddr(String num){
String addr="";
//可以直接在这里写文字吗
File file = new File("data/data/com.example.mobilemangerii/address.db");
SQLiteDatabase sqLiteDatabase = SQLiteDatabase.openDatabase(file.getAbsolutePath(), null, SQLiteDatabase.OPEN_READONLY);
String regex = "^1\\d{10}";
if (num.matches(regex)) {
Cursor cursor = sqLiteDatabase.rawQuery("select location from data2 where id=(select outkey from data1 where id=?)", new String[]{num});
if (cursor.moveToNext()) {
addr=cursor.getString(0);
}
}else if (num.length()==5) {
addr="客服电话";
}else {
System.out.println("AddressQueryDao.queryAddr()");
}
return addr;
}
}