SQLite

package com.sql;

import android.app.Application;


/**
 * 继承这个应用程序Application
 * 
 */
public class Myapp extends Application {
public static MyDateBasrHelp db;
public static String username;
@Override
public void onCreate() {
// TODO Auto-generated method stub
super.onCreate();
// 创建数据库
db = new MyDateBasrHelp(getApplicationContext());
}

}

package com.sql;


import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class MyDateBasrHelp extends SQLiteOpenHelper {

//DBNAME ：数据库名

//version ：数据库版本号
final static String DBNAME = "myqq.db";
final static int version = 1;


public MyDateBasrHelp(Context context) {
super(context, DBNAME, null, version);
}


// 创建表
@Override
public void onCreate(SQLiteDatabase db) {
// 用户表
String usersql = "create table table(uid integer primary key autoincrement,username varchar,password varchar)";
db.execSQL(usersql);// 执行sql语句
}


// 数据库版本号发生改变的时候才会执行
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
}
}

/**
* 往数据库写入数据
*/
SQLiteDatabase dp = Myapp.db.getWritableDatabase();
String sql = "insert into table(username,password)values('"
+ values0 + "','"
+ values1 + "')";
dp.execSQL(sql);

Toast.makeText(Acyivity_Register.this, "pass",
Toast.LENGTH_SHORT).show();

/**
* 从数据库读取数据
*/
SQLiteDatabase dp = Myapp.db.getReadableDatabase();
String sql = "select * from table";
Cursor cursor = dp.rawQuery(sql, null);
while(cursor.moveToNext()) {
String username=cursor.getString(cursor.getColumnIndex("username"));
String password=cursor.getString(cursor.getColumnIndex("password"));

}