sqlit导入外部数据库查找数据方法

在ddms界面把数据库文件*.db导入/data/data/包名/下,执行如下代码

// TODO Auto-generated method stubdb = SQLiteDatabase.openOrCreateDatabase("/data/data/com.xunfang.demo_weather.db/chinacity.db", null);String string = etInput.getText().toString();System.out.println("输入数据为" + string);try {String sql = "Select WEATHER_ID from city_table where CITY=" + "\""+ string + "\"";Cursor cursor = db.rawQuery(sql, null);cursor.moveToFirst();System.out.println(cursor.getString(cursor.getColumnIndex("WEATHER_ID")));} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();System.out.println("没有这个数据!");}