Sqlite数据库操作

/**创建数据库和表*/

private void createDetailTable() {
//语言:(操作数据库)
String sql=//定义创建表的SQL语句
"create table if not exists detail(" +
"_id integer primary key autoincrement," +
"_sid text ," +
"_pid text ," +
"_type text ," +
"_prjcomefrom text ," +
"_sell_prjmaster text ," +
"_prjtrack text ," +
"_prj_alter_date text ," +
"_prj_event text ," +
"_typeInfo text )"; 
//将SQL语句发送到SQLite数据库端执行
detailSdb.execSQL(sql);//只是创建表结构
//Log.i("TAG", "table2 create ok!");

}

/**向city城市列表中写入数据*/
public void insertTable(){
for (int i = 0; i <userAreaDatas.size(); i++) {
UserAreaData userAreaData=userAreaDatas.get(i);
int pid=userAreaData.getPid();
String name = userAreaData.getName();
int sid=userAreaData.getSid();
//1.定义SQL
String sql=//(将来数据来自用户输入)
"insert into city " +
"values ( null,'"+sid+"','"+name+"','"+pid+"' )";
//2.发送SQL
sdb.execSQL(sql);
}
//Log.i("TAG", "insert OK!");
}

/**该方法是查询city城市列表中数据*/
private void queryTable(){
//1.sql
String sql=//查询表中所有数据
"select * from city";
//其中"*"代表所有列
//2.发送SQL
Cursor c=//借助此对象获得查询的记录
sdb.rawQuery(sql,null);//selectionArgs
//3.获得记录
//Cursor对象中封装了一个指针对象
//此对象默认指向第一个记录的上面
//通过移动指针获得具体记录
if(c==null)return;
while(c.moveToNext()){//循环一次，移动一次指针，取一行记录
int sid=c.getInt(1);   
String name = c.getString(2);
int pid=c.getInt(3);
UserAreaData userAreaData=new UserAreaData(pid, sid, name);
userAreaData.setPid(pid);
userAreaData.setName(name);
userAreaData.setSid(sid);
userAreaDatas.add(userAreaData);
}

//关闭Cursor对象(释放资源)
c.close();
}