public class MainActivity extends Activity {
private List<City> cities;
private ListView citylistview;
private SqLiteHelper sqLiteHelper;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
mkDB();
sqLiteHelper = SqLiteHelper.getSqlSqLiteHelper(MainActivity.this);
initDatas();
}
private void initDatas() {
cities = sqLiteHelper.queryCities(0, 20);
citylistview = (ListView) findViewById(R.id.citylistview);
MyAdapter adapter = new MyAdapter(cities, MainActivity.this);
citylistview.setAdapter(adapter);
}
private void mkDB() {
String path = "data/data/" + getPackageName() + "/databases";// 得到数据库的路径
File db_path = new File(path);// 在path创建db_path路径
if (!db_path.exists()) {// 判断改文件是否存在
db_path.mkdirs();
}
File file = new File(db_path, "city.db");// 在db_path路径下创建city.db数据库
if (!file.exists()) {
try {
InputStream input = getResources().openRawResource(R.raw.city