SQLiteOutsideDB

原创于 2017-07-07 16:38:05 发布 · 232 阅读

CC 4.0 BY-SA版权

本文介绍了一种在Android应用中从assets目录导入外部SQLite数据库的方法，并演示了如何使用该数据库查询电话号码对应的地理位置信息。

//将要导入的外部数据库，放在了assets包下
import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.os.Environment;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class MainActivity extends Activity {

    private EditText et_phone;
   private Button btnFind;
   private TextView tvLocal;
   private SQLiteDatabase db;

   @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        loadInOutsideDB();
        db = openOrCreateDatabase(Environment.getExternalStorageDirectory()+"/mobilelocationCopy.db", MODE_PRIVATE, null);

        initView();
        btnFind.setOnClickListener(new OnClickListener() {

           @Override
           public void onClick(View v) {
               String phone = et_phone.getText().toString().trim();
               Cursor cursor = db.query("location_date", null, "number = ?", new String[]{phone}, null, null, null);
               String string="";
               while (cursor.moveToNext()) {
                   string = cursor.getString(cursor.getColumnIndex("location"));
               }
               tvLocal.setText("归属地 : "+string);
           }
       });

    }

   private void initView() {
       et_phone = (EditText) findViewById(R.id.et_phone);
       btnFind = (Button) findViewById(R.id.btnFind);
       tvLocal = (TextView) findViewById(R.id.tvLocal);
   }
   @SuppressWarnings("resource")
   public void loadInOutsideDB(){
       try {
           InputStream is = getAssets().open("mobilelocation.db");
           File file = new File(Environment.getExternalStorageDirectory(),"mobilelocationCopy.db");
           FileOutputStream os = new FileOutputStream(file);
           byte[] buffer=new byte[1024];
           int length=0;
           while ((length=is.read(buffer))!=-1) {
               os.write(buffer, 0, length);
           }
           is.close();
           os.close();
       } catch (Exception e) {
           e.printStackTrace();

       }
   }
}