手机归属地查询

手机归属地查询

效果图：

 

分析：

1、传递多个参数，用一个类就好

2、打开数据库

　　private SQLiteDatabase database;

　　database=SQLiteDatabase.openOrCreateDatabase(file, null);

　　　　file是数据库的路径

3、在逻辑中多加判断

　　比如是否获取到正确的手机号

　　比如我们操作的字符串是否为空

　　比如时候获取正确参数

4、通过文件流来实现释放APK中包中的数据库文件到手机本地

5、需要用的数据库放在assets目录中

　　bufferIn = new BufferedInputStream(getAssets().open("naddress.db"));

6、确保输出流flush，如果不flush，数据会变少，有一部分没有成功写出到本地

　　bufferOut.flush();

7、try-catch的时候记得finally，去关闭输入流和输出流

8、-1为文件末

　　while ((len = bufferIn.read(buffer)) != -1)

9、File file = getDatabasePath("naddress.db");

　　这个方法得到这样的路径data/data/包/database/naddress.db

10、如果文件没有成功创建，我们取创建文件夹

　　if (!file.exists())

　　　　file.getParentFile().mkdirs();

11、正则表达式匹配手机号

　　Pattern p = Pattern.compile("^((13[0-9])|(15[^4,\\D])|(18[0,5-9]))\\d{8}$");  

　　Matcher m = p.matcher(phoneNumber);  

　　if (!m.matches()) 

12、百度的正确姿势

　　java 正则表达式验证手机号

13、找错误的时候多去看cause by

 

代码：

/查询手机号归属地2/res/layout/activity01.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:orientation="horizontal" >

        <TextView
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="请输入手机号码：" />

        <EditText
            android:id="@+id/et_mobileNum"
            android:layout_width="205dip"
            android:layout_height="wrap_content" />
    </LinearLayout>

    <TextView
        android:id="@+id/tv_city_cardType"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:textColor="#ff0000"
        android:textSize="25sp"
        android:text="归属地：" />

    <Button 
        android:id="@+id/btn_search"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="center_horizontal"
        android:onClick="query"
        android:text="查询号码归属地" />

</LinearLayout>

database.AddressDao

package database;

import java.io.File;

import bean.InfoBean;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

/*
 * 操作数据库
 */
public class AddressDao {
    private SQLiteDatabase database;
    public AddressDao(File file){
        database=SQLiteDatabase.openOrCreateDatabase(file, null);
    }
    /**
     * 获取城市及卡类型
     * @param mobilePrefix 手机号码前缀
     */
    public InfoBean getCityOrCardType(String mobilePrefix){
        String sql="select city,cardtype from address_tb where _id in(select outkey from numinfo where mobileprefix=?);";
        Cursor cursor=database.rawQuery(sql, new String[]{mobilePrefix});
        //就一条记录，不用用while，就if就好了
        if(cursor.moveToNext()){
            String city=cursor.getString(cursor.getColumnIndex("city"));
            String cardtype=cursor.getString(cursor.getColumnIndex("cardtype"));
            return new InfoBean(city, cardtype);
        }
        return null;
    }
}

bean.InfoBean

package bean;

public class InfoBean {
    private String city;
    private String cardType;
    
    
    public InfoBean(String city, String cardType) {
        super();
        this.city = city;
        this.cardType = cardType;
    }
    public String getCity() {
        return city;
    }
    public void setCity(String city) {
        this.city = city;
    }
    public String getCardType() {
        return cardType;
    }
    public void setCardType(String cardType) {
        this.cardType = cardType;
    }
    
    
}

fry.Activity01

package fry;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import bean.InfoBean;

import com.example.searchMobileCity.R;

import database.AddressDao;
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

public class Activity01 extends Activity {
    private Button btn_search;
    private EditText et_mobileNum;
    private TextView tv_city_cardType;
    private AddressDao dao;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity01);
        initView();
        // file就是数据库文件路径
        File file = initDatabaseData();
        dao = new AddressDao(file);

    }

    private void initView() {
        tv_city_cardType = (TextView) findViewById(R.id.tv_city_cardType);
        et_mobileNum = (EditText) findViewById(R.id.et_mobileNum);
        btn_search = (Button) findViewById(R.id.btn_search);
    }

    /*
     * 查询归属地
     */
    public void query(View view) {
        tv_city_cardType.setText("归属地:");
        String phoneNumber = et_mobileNum.getText().toString();
        Pattern p = Pattern.compile("^((13[0-9])|(15[^4,\\D])|(18[0,5-9]))\\d{8}$");  
        Matcher m = p.matcher(phoneNumber);  
        if (!m.matches()) {
            Toast.makeText(this, "请输入正确的手机号", Toast.LENGTH_SHORT).show();
            return ;
        } else {
            String mobilePrefix = phoneNumber.substring(0, 7);
            InfoBean bean = dao.getCityOrCardType(mobilePrefix);
            if (bean == null) {
                tv_city_cardType.setText("没查询到该号码的城市与归属地！！");
            } else {
                tv_city_cardType.setText("城市：" + bean.getCity() + "   \n卡类型： "
                        + bean.getCardType());
            }
        }
    }

    /*
     * 释放APK中包中的数据库文件到手机本地 读和写
     */
    private File initDatabaseData() {
        // 这个方法得到这样的路径data/data/包/database/naddress.db
        File file = getDatabasePath("naddress.db");
        if (!file.exists()) {
            file.getParentFile().mkdirs();
        } else {
            return file;
        }

        // 获取读入流
        BufferedInputStream bufferIn = null;
        // 输出流
        BufferedOutputStream bufferOut = null;
        try {
            bufferIn = new BufferedInputStream(getAssets().open("naddress.db"));
            bufferOut = new BufferedOutputStream(new FileOutputStream(file));
            // 开始释放缓存流
            // 读的时候，弄个缓存区，让释放快一点
            byte[] buffer = new byte[8000];
            int len = 0;
            // -1为文件末
            while ((len = bufferIn.read(buffer)) != -1) {
                bufferOut.write(buffer, 0, len);
                // 不flush的话文件大小会变小的
                bufferOut.flush();
            }
            return file;
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            try {
                if (bufferIn != null)
                    bufferIn.close();
                if (bufferOut != null)
                    bufferOut.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return null;
    }
}