PHP SQLite addition, deletion, modification, and reduction implementation code _ PHP Tutorial

Added, deleted, modified, and subtracted implementation code for phpSQLite. Db.exe csql (SQL); or db. insert (), db. delete (), db. you can also create a table publicbooleancreatetable () {db.exe csql (SQL); or db through execsql. insert (), db. delete (), db. update (), including creating and deleting data tables, can also be implemented through execsql
// Create a table

Public boolean createtable (){
Sqlitedatabase db = dbhelper. getwritabledatabase ();
String SQL = "create table if not exists" + table_name + "(id integer primary key, name varchar, age integer )";
Try {
Db.exe csql (SQL );
Return true;
} Catch (sqlexception ex ){
Log. d (tag, "create table failure ");
Return false;
}
}

// Add data

Public boolean adddata (){
String name = etname. gettext (). tostring ();
String age = etage. gettext (). tostring ();
Sqlitedatabase db = dbhelper. getwritabledatabase ();
String SQL = "insert into" + table_name + "(name, age) values ('" + name + "', '" + age + "')";
Try {
Db.exe csql (SQL );
Return true;
} Catch (sqlexception ex ){
Log. d (tag, "add data failure ");
Return false;
}
}

// Modify

Public boolean updatedata (){
Sqlitedatabase db = dbhelper. getwritabledatabase ();
String SQL = "update" + table_name + "set age = '2' where name like 'cb '";
Object [] bindargs = {"cb "};
Try {
Db.exe csql (SQL, bindargs );
Return true;
} Catch (sqlexception ex ){
Log. d (tag, "update data failure ");
Return false;
}

}

Http://www.bkjia.com/PHPjc/630782.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/630782.htmlTechArticledb.execsql (SQL); or db. insert (), db. delete (), db. update (), including creating and deleting data tables, etc. you can also execsql to create a public boolean createtable (){...