ContentValue添加數(shù)據(jù)
/**
* @param model 數(shù)據(jù)模型
* @return 返回添加數(shù)據(jù)有木有成功
*/
public boolean addPersonData(PersonModel model)
{
//把數(shù)據(jù)添加到ContentValues
ContentValues values = new ContentValues();
values.put(VALUE_NAME,model.getName());
values.put(VALUE_AGE,model.getAge());
values.put(VALUE_ISBOY,model.getIsBoy());
values.put(VALUE_ADDRESS,model.getAddress());
values.put(VALUE_PIC,model.getPic());//儲(chǔ)存圖片，這里是byte數(shù)據(jù)
//添加數(shù)據(jù)到數(shù)據(jù)庫
long index = getWritableDatabase().insert(TABLE_NAME_PERSON,null,values);
//大于0表示添加成功
if(index > 0)
{
return true;
}else
{
return false;
}
}
sql語句添加數(shù)據(jù)
/**
* sql語句添加數(shù)據(jù)驯妄，比較麻煩
*/
public void addPersonDataSql(PersonModel model)
{
//格式： insert into 表名 （字段名,字段名,…）value('字段值','字段值','…')
//看著很多荷并，其實(shí)就是這個(gè) insert into person (name,age,isboy,address,pic) values('五天','3','0','上海市浦東新區(qū)x606','[B@5340395')
String insertSql = "insert into "+TABLE_NAME_PERSON+" ("+
VALUE_NAME + ","+
VALUE_AGE + ","+
VALUE_ISBOY + ","+
VALUE_ADDRESS + ","+
VALUE_PIC+")"+
" values"+"("+
"'"+model.getName()+"',"+
"'"+model.getAge()+"',"+
"'"+model.getIsBoy()+"',"+
"'"+model.getAddress()+"',"+
"'"+model.getPic()+"'"+
")";
Log.e(TAG, ""+insertSql);
getWritableDatabase().execSQL(insertSql);
}
sqlite也無非就創(chuàng)建、增青扔、刪源织、改、查微猖、更新谈息。
