Android——SQLite数据库使用详解

}

public TUser(Integer id, String username, String password, String name,

String sex) {

super();

this.id = id;

this.username = username;

this.password = password;

this.name = name;

this.sex = sex;

}

public TUser() {

super();

}

}

DbOpenHelper.java链接数据库，创建数据库类

package com.example.androiddemo01.dao;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

import android.database.sqlite.SQLiteOpenHelper;

public class DbOpenHelper extends SQLiteOpenHelper {

private static final String DBNAME = “data.db”;

private static int version = 1;

//content容器，name链接数据库名字，version版本号,factory游标工厂

public DbOpenHelper(Context context) {

super(context, DBNAME, null, version);

}

//运行DbOpenHelper时执行，建立表和数据库，没有数据库则建立，只有第一次运行执行

@Override

public void onCreate(SQLiteDatabase db) {

String sql = “create table t_user(”+

“id integer primary key autoincrement not null,”+

“username text(10),”+

“password text(10),”+

“name text(10),”+

“sex text(2))”;

//执行SQL语句

db.execSQL(sql);

sql = “insert into t_user (‘username’, ‘password’, ‘name’, ‘sex’) values(‘admin’,‘admin’, ‘张三’, ‘男’)”;

db.execSQL(sql);

}

//更新，版本升级

@Override

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

}

}

TUserDAO.java数据库操作类，增删改查。

package com.example.androiddemo01.dao;

import java.util.ArrayList;

import java.util.List;

import com.example.androiddemo01.model.TUser;

import android.content.Context;

import android.database.Cursor;

import