test

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;
	}
}
posted @ 2015-06-17 17:50  月贝凡YBF  阅读(80)  评论(0)    收藏  举报