Android Cursor遍历

最新推荐文章于 2025-03-13 20:12:00 发布

钱大进

最新推荐文章于 2025-03-13 20:12:00 发布

阅读量3.9w

点赞数 14

分类专栏： Android 文章标签： android sql string null

本文链接：https://blog.youkuaiyun.com/qjlhlh/article/details/7822325

版权

Android 专栏收录该内容

28 篇文章

订阅专栏

public List<PointBean> getAllPoints() {
		String sql = "select * from points";
		SQLiteDatabase db = helper.getWritableDatabase();
		List<PointBean> pointList = new ArrayList<PointBean>();
		PointBean point = null;
		Cursor cursor = db.rawQuery(sql, null);
		while (cursor.moveToNext()) {
			point = new PointBean();
			point.setPointName(cursor.getString(cursor
					.getColumnIndex("point_name")));
			point.setLongitude(cursor.getDouble(cursor
					.getColumnIndex("longitude")));
			point.setLatitude(cursor.getDouble(cursor
					.getColumnIndex("latitude")));
			pointList.add(point);
		}
		return pointList;
	}