IT修真院·坑乎 | Java(后端),CSS(前端),JavaScript(前端),PM(产品经理),UI(交互设计),QA(测试),Android(安卓APP),iOS(苹果APP),OP(运维),Python(后端)日常在线问答学习平台

全部问题

已收录问题

未收录问题

没有找到答案，去提问>>>

该问题已被官方收录

无法打开database中的数据库

class="cursor-pointer"> 详细描述

class="cursor-pointer"> 截图

class="cursor-pointer"> 代码

public class SetAddressFragment extends Fragment {

    private static final String TAG = "SetAddressFragment";
    private static final String DB_NAME = "mydb.db";

    private TextView confirmTV, cancelTV;
    private NumberPicker provinceNP, cityNP, areaNP;
    private AddressManager manager;
    private SendMessageAddress sendMessageAddress;


    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container,Bundle saveInstanceState) {
        View square = inflater.inflate(R.layout.fragment_setaddress, container, false);

        manager = new AddressManager(getContext().getDatabasePath(DB_NAME).getPath());
        initView(square);
        initProvince();
        return square;
    }

......

}

#####################################################################################################################

public class AddressManager {


    private static final String TABLE_NAME = "ssq"; //表名
    private static final String PROVINCE = "province"; //省
    private static final String CITY = "city"; //市
    private static final String AREA = "area"; //区/县

    private SQLiteDatabase database;

    /**
     * @param dbPath 数据库中“省市区”表的路径
     */
    public AddressManager(String dbPath) {
        database = SQLiteDatabase.openOrCreateDatabase(dbPath, null);
    }

    /**
     * 查询所有省份
     *
     * @return 所有的省份名称
     */
    public List<String> getProvinces() {

        String sql = "select distinct " + PROVINCE + " from " + TABLE_NAME;
        Cursor cursor = database.rawQuery(sql, null);
        List<String> provinceList = new ArrayList<>();
        if (cursor != null) {
            while (cursor.moveToNext()) {
                String province = cursor.getString(cursor.getColumnIndex("province"));
                Log.i("tag", "province----->" + province);
                provinceList.add(province);
            }
            cursor.close();
        }
        return provinceList;
    }

    /**
     * 查询指定省份或直辖市的所有市的集合
     *
     * @param province 省份名称
     * @return 查询到的所有城市
     */
    public List<String> getCities(String province) {
        String sql = "select distinct " + CITY + " from " + TABLE_NAME + " where " + PROVINCE + " = ?";
        Cursor cursor = database.rawQuery(sql, new String[]{province});
        List<String> addressList = new ArrayList<>();
        while (cursor.moveToNext()) {
            String city = cursor.getString(cursor.getColumnIndex(CITY));
            Log.i("tag", "city----->" + city);
            addressList.add(city);
        }
        //关闭游标
        cursor.close();
        return addressList;
    }


    /**
     * 查询指定市的所有区的列表的List集合
     *
     * @param city 市的名称
     * @return 查询到的所有区
     */
    public List<String> getAreas(String city) {
        //获取指定市的所有区的列表的sql语句
        String sql = "select distinct " + AREA + " from " + TABLE_NAME + " where " + CITY + " = ?";
        Cursor cursor = database.rawQuery(sql, new String[]{city});
        List<String> addressList = new ArrayList<>();
        while (cursor.moveToNext()) {
            //获取区的名称
            String area = cursor.getString(cursor.getColumnIndex(AREA));
            Log.i("tag", "area----->" + area);
            //把所有的区添加到List集合
            addressList.add(area);
        }
        //关闭游标
        cursor.close();
        return addressList;
    }
}