Android編程之數據庫Sql編程實例分析

本文實例講述了Android編程之數據庫Sql編程實現方法。分享給大家供大家參考。具體分析如下：

Android中安裝輕量級數據庫Sqlite,現在測試數據庫基本操作。

數據庫基本操作：創建表，插入，刪除可以用execSQL();讀取可以用rawQuery();這兩個函數都可以標准SQL語句進行操作。

源代碼：

package com.test.sql; 
import android.app.Activity; 
import android.content.Context; 
import android.database.Cursor; 
import android.database.sqlite.SQLiteDatabase; 
import android.database.sqlite.SQLiteOpenHelper; 
import android.os.Bundle; 
import android.util.Log; 
public class test_sql extends Activity 
{ 
 DatabaseHelper mOpenHelper; 
 private static final String DATABASE_NAME = "test.db"; 
 private static final int DATABASE_VERSION = 1; 
 private static class DatabaseHelper extends SQLiteOpenHelper { 
  DatabaseHelper(Context context) { 
   super(context, DATABASE_NAME, null, DATABASE_VERSION); 
  } 
  @Override 
  public void onCreate(SQLiteDatabase db) 
  { 
   //新建一個用戶表 
   //共有5項：Id Pwd Name OnLineTime Level 
   db.execSQL("CREATE TABLE User_Table ('Id' INT,'Pwd' VARCHAR,'Name' VARCHAR,'OnLineTime' INT,'Level' INT)");
  } 
  @Override 
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  } 
 } 
 /** Called when the activity is first created. */ 
 @Override 
 public void onCreate(Bundle savedInstanceState) { 
  super.onCreate(savedInstanceState);
  setContentView(R.layout.main);
  mOpenHelper = new DatabaseHelper(this);
  SQLiteDatabase db = mOpenHelper.getWritableDatabase();
  //清空數據 
  db.execSQL("DELETE FROM User_Table"); 
  //插入數據10000 123456 "jdh" 0 0 
  //插入數據10001 123456 "jim" 0 0 
  db.execSQL("INSERT INTO User_Table VALUES (?,?,?,?,?)", new Object[]{10000,"123456","jdh",0,0}); 
  db.execSQL("INSERT INTO User_Table VALUES (?,?,?,?,?)", new Object[]{10001,"123456","jim",0,0}); 
  //讀取數據 
  Cursor cursor = db.rawQuery("SELECT * FROM User_Table WHERE Name = ?",new String[]{"jdh"}); 
  while (cursor.moveToNext()) 
  { 
   String str = cursor.getInt(0) + cursor.getString(1) + cursor.getString(2) + cursor.getInt(3) + cursor.getInt(4); 
   Log.i("str:", str); 
  }  
 } 
}

希望本文所述對大家的Android程序設計有所幫助。