//使用openOrCreateDatabase()创建一个数据库
// getFilesDir() data–date–package name –files目录下
db = SQLiteDatabase.openOrCreateDatabase(getFilesDir() + “/info.db”, null);
- 创建数据库:
String createtableSql = “create table user(_id integer primary key autoincrement,username,password)”;
db.execSQL(createtableSql);
插入数据:
String insertSql = “insert into user(username,password) values(?,?)”;
// 给?,?(占位符)赋予值
db.execSQL(insertSql, new String[] { username, pwd });
- 更新数据:
String updateSql = “update user set username=?,password=? where username=?”;
db.execSQL(updateSql, new String[] { username, pwd, previoususername });
- 删除数据:
String deleteSql = “delete from user where _id=?”;
db.execSQL(deleteSql, new String[] { id });