Android复习考点
Android复习考点
1.数据库读写
首先新建一个数据库工具类继承自SQLiteOpenHelper,然后在构造方法中指定数据库名称
和版本号进行初始化。代码如下:
MyDataBase.java
package chzu.csci.pwn.androidquiz;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDataBase extends SQLiteOpenHelper {
private static final String DB_NAME="2017211808.db";
private static final int DB_VERSION=1;
MyDataBase(Context context){
super(context,DB_NAME,null,DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(//第一次运行时新建一个BANK表,并且插入初始数据
"CREATE TABLE BANK (_id INTEGER PRIMARY KEY AUTOINCREMENT,"
+"TYPE TEXT,"
+"QUESTION TEXT,"
+"ANSWER TEXT);"
);
insertBank(db,"架构","Android系统架构自底向上第二层是?");
insertBank(db,"编程","Android App开发支持编程语言包括?");
insertBank(db,"服务","绑定服务使用什么方法?");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
private static void insertBank(SQLiteDatabase db,String type,String question){
ContentValues value=new ContentValues();
value.put("TYPE",type);
value.put("QUESTION",question);
long result=db.insert("BANK",null,value);
}
}
1.插入数据
调用SQLiteDatabase类的insert方法即可,代码如下,具体调用可以看上面的MyDataBase.java:
ContentValues value=new ContentValues();
value.put("TYPE",type);//字段名和值
value.put("QUESTION",question);//字段名和值
long result=db.insert("BANK",null,value);
2.删除数据
调用SQLiteDatabase类的delete方法即可,代码如下:
SQLiteOpenHelper helper=new MyDataBase(<