android gps 定位及导航实例

package com.moon.dataaccess; import android.app.Activity; import android.os.Bundle; public class actDataCommon extends Activity { // 常数 private final String MY_DATABASE_NAME = "pointsDB"; private final String MY_DATABASE_TABLE = "pointsInf"; // members private android.database.Cursor cur = null; private android.database.sqlite.SQLiteDatabase.CursorFactory fac = null; private android.database.sqlite.SQLiteDatabase db = null; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); this.createTable(MY_DATABASE_NAME, MY_DATABASE_TABLE); this.insertRecord(); //下面几个测试方法 // this.createTable(MY_DATABASE_NAME, "dropT"); // this.dropTable("dropT"); //this.updateRecord(); //this.deleteRecord(); java.util.ArrayList<String> results =this.getArrayList(this.getCursor()); String s=results.get(0); android.widget.Toast.makeText(actDataCommon.this, " "+s, android.widget.Toast.LENGTH_LONG).show(); } //打开或者创建数据库，如果没有则创建，并且打开 public void openOrCreateDB(String dbName) { android.widget.Toast.makeText(actDataCommon.this, "begin", android.widget.Toast.LENGTH_LONG).show(); db = this.openOrCreateDatabase(dbName, 1, fac); } //创建数据表 public void createTable(String dbName, String tableName) { this.openOrCreateDB(dbName); db .execSQL("CREATE TABLE IF NOT EXISTS " + tableName + " (villageName VARCHAR,houseNo VARCHAR,houseHoldName VARCHAR," + " longitude DOUBLE, latitude DOUBLE);"); } // 插入记录 public void insertRecord() { String villageName = "userHzl"; String houseNo = "1号"; String houseHoldName = "dhh"; double longvalue = 120.1; double latvalue = 23.5; db.execSQL("INSERT INTO " + MY_DATABASE_TABLE + " (villageName,houseNo,houseHoldName,longitude, latitude)" + " VALUES " + "(" + "'" + villageName + "'" + "," + "'" + houseNo + "'" + "," + "'" + houseHoldName + "'" + "," + longvalue + "," + latvalue + ");"); } //删除记录 public void deleteRecord() { db.execSQL("delete from " + MY_DATABASE_TABLE+";"); } //修改记录 public void updateRecord() { //注意sql语句中各个关键字等之间的空格 下面问题在于表名和SET间的空格 db.execSQL("update " + MY_DATABASE_TABLE + " set latitude =45.4;"); //下面这句可以 //db.execSQL("update pointsinf set latitude =123.45;"); } // 删除表结构 public void dropTable(String tableName) { db.execSQL("drop table " + tableName); } // 查询出结果android.database.Cursor，相当于DataTable public android.database.Cursor getCursor() { android.database.Cursor cursor = null; cursor = db.rawQuery( "SELECT villageName,houseNo,houseHoldName,longitude,latitude" + " FROM " + MY_DATABASE_TABLE, null); return cursor; } //将结果转化成字符列表 public java.util.ArrayList<String> getArrayList(android.database.Cursor c) { java.util.ArrayList<String> results = new java.util.ArrayList<String>(); // villageName houseHoldName longitude latitude int villageNameColumn = c.getColumnIndex("villageName"); int houseHoldNameColumn = c.getColumnIndex("houseHoldName"); // int longitudeColumn = c.getColumnIndex("longitude"); // int latitudeColumn = c.getColumnIndex("latitude"); /* Check if our result was valid. */ if (c != null) { /* Check if at least one Result was returned. */ if (c.moveToFirst()) { int i = 0; /* Loop through all Results */ do { i++; String villageNameValue = c.getString(villageNameColumn); String houseHoldNameValue = c .getString(houseHoldNameColumn); results.add("" + i + ": " + c.getColumnName(villageNameColumn) + ": " + villageNameValue + " " + c.getColumnName(houseHoldNameColumn) + ": " + houseHoldNameValue + " "); } while (c.moveToNext()); } } return results; } }