手机归属地从raw读入到databases中

package com.jamin; import android.app.Activity; import android.app.ProgressDialog; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.os.Handler; import android.os.Message; import android.util.Log; import android.view.View; import android.view.View.OnClickListener; import android.widget.Button; import android.widget.EditText; import android.widget.TextView; public class AttrActivity extends Activity implements OnClickListener{ /** Called when the activity is first created. */ Button button; EditText et; TextView tv; ProgressDialog mProgressDialog; public DBManager dbhelper; SQLiteDatabase sqldb; private static final String TAG = "wangjieming"; Handler handler; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); button = (Button) findViewById(R.id.button); et = (EditText) findViewById(R.id.edittext); tv = (TextView) findViewById(R.id.textview); initProgressDialog(); Log.d(TAG, "thread run"); new Thread(){ public void run() { // TODO Auto-generated method stub Log.d(TAG, "run start"); dbhelper = new DBManager(AttrActivity.this); dbhelper.openDatabase(); dbhelper.closeDatabase(); // handler.sendEmptyMessage(1); Message msg = new Message(); msg.arg1 = 100; msg.arg2 = 200; msg.what = 1; handler.sendMessage(msg); } }.start(); handler = new Handler(){ @Override public void handleMessage(Message msg) { // TODO Auto-generated method stub super.handleMessage(msg); if(msg.what == 1){ Log.d(TAG, "msg.arg1 = " + msg.arg1); Log.d(TAG, "msg.arg2 = " + msg.arg2); mProgressDialog.dismiss(); } } }; button.setOnClickListener(this); sqldb = SQLiteDatabase.openOrCreateDatabase(DBManager.DB_PATH + "/" + DBManager.DB_NAME, null); } public void initProgressDialog(){ mProgressDialog = new ProgressDialog(AttrActivity.this); mProgressDialog.setTitle("~~~"); mProgressDialog.setMessage("aaa"); // mProgressDialog.setProgressStyle(ProgressDialog.STYLE_SPINNER); mProgressDialog.show(); } public void onClick(View v) { // TODO Auto-generated method stub if(v == button){ Log.d(TAG, "onClick"); String searchstring = et.getText().toString(); Cursor c = sqldb.rawQuery("select code from numloc where " +"number=" +Integer.parseInt(searchstring) , null); c.moveToFirst(); tv.setText(c.getString(c.getColumnIndex("code"))); } } }