}
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