目前正在使用的归属地数据库,查询方式如下:
如一个手机号码 13712345678
prefix: 137
num: 1234 - 1
String sql1 = "select city_id from number_" + prefix + " limit " + num + ",1";//空格不能少
String sql2 = "select province_id from city where _id = (" + sql1 + ")";
String sql = "select province,city from province,city where _id=(" + sql1 + ")and id=(" + sql2 + ")";