sqlite 個人寫增刪改查例項

//建立資料庫的程式碼
// DbConn conn = new DbConn(MainActivity.this, "hellodb", null, 1);

// conn.createTable("worldtb");

package com.oschina.osmf;


import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;


public class DbConn extends SQLiteOpenHelper{


public DbConn(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
}


@Override
public void onCreate(SQLiteDatabase db) {

}


@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}


public void createTable(String tableName)
{
SQLiteDatabase db = this.getWritableDatabase();
String sql = "create table if not exists "+tableName+"(id integer primary key,name varchar)";
db.execSQL(sql);
Log.i("test", "建立表成功");
}

public void selectTable(String tableName)
{

}
}