//Create a table
public boolean createTable(){
SQLiteDatabase db=();
String sql="CREATE TABLE IF NOT EXISTS "+TABLE_NAME+"(ID INTEGER PRIMARY KEY,Name VARCHAR,Age INTEGER)";
try{
(sql);
return true;
}catch(SQLException ex){
(tag, "create table failure");
return false;
}
}
//Add data
public boolean addData(){
String name=().toString();
String age=().toString();
SQLiteDatabase db=();
String sql="insert into "+TABLE_NAME+"(name,age) values ('"+name+"','"+age+"')";
try{
(sql);
return true;
}catch(SQLException ex){
(tag, "add data failure");
return false;
}
}
//Revise
public boolean updateData(){
SQLiteDatabase db=();
String sql="update "+TABLE_NAME+" set age='2' where name like 'cb'";
Object[] bindArgs={"cb"};
try{
(sql, bindArgs);
return true;
}catch(SQLException ex){
(tag, "update data failure");
return false;
}
}