数据库操作

创建表

public static final String STEPTABLE = "create table if not exists step_info(_id INTEGER PRIMARY KEY,day TEXT ,date TEXT, startStep INTEGER)";
db.execSQL(STEPTABLE);

表里面插入元素

db.execSQL("alter table step_info add startStep INTEGER ");

插入数据

String insertStepSql = "insert into step_info(day,date,startStep)values(?,?,?)";
db.execSQL(insertStepSql, new Object[] { item.day,item.date, item.startStep });

更新数据

String updateStepSql = String.format("update step_info set day='%s',date='%s',startStep='%s' where day='%s'", item.day,item.date, item.startStep,item.day);
db.execSQL(updateStepSql);

查询数据

String selectStepSql = String.format("select * from step_info where day='%s'", item.day);
Cursor cursor=db.rawQuery(selectStepSql, null);