2014年做了一个关于酒窖监测的项目,我负责的部分是Android的sqlite数据部分。通过查阅资料,大致了解了sqlite的基本使用方法。现在将简化版代码贴出来。
package com.example.blog;
/*本项目建立的数据库有cellarNum(窖池编号)、temperature(窖池温度)、ph、time(时间)
* 有关的变量都是通过字符串进行传递的
* */
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DBHelper extends SQLiteOpenHelper {
public static final String TB_NAME = "my_tablea";
public static final String TB_NAME01 = "my_table01";
public static final String cellarNum = "cellarNum";
public static final String temperature = "temperature";
public static final String ph = "ph";
public static final String time = "time";
private static final String DB_CREATE="create table if not exists " + TB_NAME + " (" + cellarNum
+ " varchar," + temperature+ " varchar," +
ph+ " varchar," + time +" date" + ")";
private static final String DB_CREATE01="create table if not exists " + TB_NAME01 + " ("+ temperature+ " varchar," +
ph+ " varchar," + time +" date" + ")";
public DBHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
}
public void onCreate(SQLiteDatabase db1) {
db1.execSQL(DB_CREATE01);
db1.execSQL(DB_CREATE);
}
public void onUpgrade(SQLiteDatabase db1, int oldVersion, int newVersion) {
db1.execSQL("DROP TABLE IF EXISTS " + TB_NAME01);
db1.execSQL("DROP TABLE IF EXISTS " + TB_NAME);
onCreate(db1);
}
public void onOpen(SQLiteDatabase db1) {
super.onOpen(db1);
}
}