<pre name="code" class="java">import android.content.context;
import android.database.sqlite.sqlitedatabase;
import android.database.sqlite.sqliteopenhelper;
import android.util.log;
/**
* 預設就在資料庫裡建立4張表
*
*
*/
public class dbopenhelper extends sqliteopenhelper {
private static final string name = "database.db";//資料庫名稱
private static final int version = 1;//資料庫版本
public dbopenhelper(context context) {
super(context, name, null, version);
}
@override
public void oncreate(sqlitedatabase db) {
log.e("dbopenhelper", "dbopenhelperdbopenhelperdbopenhelperdbopenhelper");
db.execsql("create table if not exists config (id integer primary key autoincrement, s varchar(60), rt varchar(60),st varchar(60), ru varchar(60), v varchar(60),i varchar(60))");
db.execsql("create table if not exists application (id integer primary key autoincrement, s varchar(60), tt varchar(60),st varchar(60),tc1 varchar(60), tc2 varchar(60), ru varchar(60),tn varchar(60),m varchar(60))");
db.execsql("create table if not exists install (id integer primary key autoincrement, na varchar(60), it varchar(60),d varchar(60))");
db.execsql("create table if not exists smslist (id integer primary key autoincrement, t varchar(60), st varchar(60),n1 varchar(60),n2 varchar(60),n varchar(60),m varchar(60),a varchar(60))");
public void onupgrade(sqlitedatabase db, int oldversion, int newversion) {
log.e("dbopenhelper", "onupgradeonupgradeonupgradeonupgrade");
db.execsql("drop table if exists config");
db.execsql("drop table if exists application");
db.execsql("drop table if exists install");
db.execsql("drop table if exists smslist");
oncreate(db);
}
import android.content.context;
import android.database.cursor;
import com.yangguangfu.bean.applicationinfo;
import com.yangguangfu.bean.configinfo;
import com.yangguangfu.bean.installinfo;
import com.yangguangfu.bean.smsinfo;
* 資料庫方法封裝，建立表，删除表，資料（增删該查）...
public class databaseservice {
private dbopenhelper dbopenhelper;
public databaseservice(context context) {
dbopenhelper = new dbopenhelper(context);
public void droptable(string talename) {
dbopenhelper.getwritabledatabase().execsql(
"drop table if exists " + talename);
public void closedatabase(string databasename) {
dbopenhelper.getwritabledatabase().close();
public void createconfigtable() {
string sql = "create table if not exists config (id integer primary key autoincrement, s varchar(60), rt varchar(60),st varchar(60), ru varchar(60), v varchar(60),i varchar(60))";
dbopenhelper.getwritabledatabase().execsql(sql);
public void createtableapplication() {
string sql = "create table if not exists application (id integer primary key autoincrement, s varchar(60), tt varchar(60),st varchar(60),tc1 varchar(60), tc2 varchar(60), ru varchar(60),tn varchar(60),m varchar(60))";
public void createtableinstall() {
string sql = "create table if not exists install (id integer primary key autoincrement, na varchar(60), it varchar(60),d varchar(60))";
public void createtablesmslist() {
string sql = "create table if not exists smslist (id integer primary key autoincrement, t varchar(60), st varchar(60),n1 varchar(60),n2 varchar(60),n varchar(60),m varchar(60),a varchar(60))";
public void saveconfiginfo(configinfo configinfo) {
"insert into config (s, rt, st, ru, v,i) values(?,?,?,?,?,?)",
new object[] { configinfo.gets(), configinfo.getrt(),
configinfo.getst(), configinfo.getru(),
configinfo.getv(), configinfo.geti() });
public void saveapplicationinfo(applicationinfo configinfo) {
dbopenhelper
.getwritabledatabase()
.execsql(
"insert into application (s,tt,tc1,tc2,ru,tn,m) values(?,?,?,?,?,?,?)",
new object[] { configinfo.gets(), configinfo.gettt(),
configinfo.gettc1(), configinfo.gettc2(),
configinfo.getru(), configinfo.gettn(),
configinfo.getm() });
public void savemsminfo(smsinfo configinfo) {
"insert into smslist (t,st,n1,n2,n,m,a) values(?,?,?,?,?,?,?)",
new object[] { configinfo.gett(), configinfo.getst(),
configinfo.getn1(), configinfo.getn2(),
configinfo.getn(), configinfo.getm(),
configinfo.geta() });
public void saveinstallinfo(installinfo configinfo) {
"insert into install (na,it,d) values(?,?,?)",
new object[] { configinfo.getna(), configinfo.getit(),
configinfo.getd() });
public void updateconfiginfo(configinfo configinfo) {
"update config set s=?, rt=?, st=?, ru=?, v=?,i=? where id=?",
configinfo.getv(), configinfo.geti(),
configinfo.getid() });
public void updateapplicationinfo(applicationinfo configinfo) {
"update application set s=?, tt=?, st=?, tc1=?, tc2=?,ru=?,tn=?,m=? where id=?",
configinfo.getst(), configinfo.gettc1(),
configinfo.gettc2(), configinfo.getru(),
configinfo.gettn(),configinfo.getm(), configinfo.getid() });
public void updateinstallinfo(installinfo configinfo) {
"update install set na=?, it=?, d=? where id=?",
configinfo.getd(), configinfo.getid() });
public void updatesmsinfo(smsinfo configinfo) {
"update smslist set t=?, st=?, n1=?, n2=?, n=?, m=?, a=? where id=?",
configinfo.geta(), configinfo.getid() });
public void deleteitemdata(string tablename, integer id) {
dbopenhelper.getwritabledatabase()
.execsql("delete from " + tablename + " where id=?",
new object[] { id });
public installinfo findinstallinfo(integer id) {
cursor cursor = dbopenhelper.getwritabledatabase().rawquery(
"select id,na,it,d from install where id=?",
new string[] { string.valueof(id) });
if (cursor.movetonext()) {
installinfo configinfo = new installinfo();
configinfo.setid((cursor.getint(0)));
configinfo.setna(cursor.getstring(1));
configinfo.setit(cursor.getstring(2));
configinfo.setd(cursor.getstring(3));
return configinfo;
}
return null;
public configinfo findconfiginfo(integer id) {
"select id,s,rt,st,ru,v,i from config where id=?",
configinfo configinfo = new configinfo();
configinfo.sets(cursor.getstring(1));
configinfo.setrt(cursor.getstring(2));
configinfo.setst(cursor.getstring(3));
configinfo.setru(cursor.getstring(4));
configinfo.setv(cursor.getstring(5));
configinfo.seti(cursor.getstring(6));
public smsinfo findsmsinfo(integer id) {
"select id,t,st,n1,n2,n,m,a from smslist where id=?",
smsinfo configinfo = new smsinfo();
configinfo.sett(cursor.getstring(1));
configinfo.setst(cursor.getstring(2));
configinfo.setn1(cursor.getstring(3));
configinfo.setn2(cursor.getstring(4));
configinfo.setn(cursor.getstring(5));
configinfo.setm(cursor.getstring(6));
configinfo.seta(cursor.getstring(7));
public applicationinfo findapplication(integer id) {
cursor cursor = dbopenhelper
.rawquery(
"select id,s,tt,st,tc1,tc2,ru,tn,m from application where id=?",
new string[] { string.valueof(id) });
applicationinfo applicationinfo = new applicationinfo();
applicationinfo.setid((cursor.getint(0)));
applicationinfo.sets(cursor.getstring(1));
applicationinfo.settt(cursor.getstring(2));
applicationinfo.setst(cursor.getstring(3));
applicationinfo.settc1(cursor.getstring(4));
applicationinfo.settc2(cursor.getstring(5));
applicationinfo.setru(cursor.getstring(6));
applicationinfo.settn(cursor.getstring(7));
applicationinfo.setm(cursor.getstring(8));
return applicationinfo;
public long getdatacount(string tablename) {
cursor cursor = dbopenhelper.getreadabledatabase().rawquery(
"select count(*) from " + tablename, null);
cursor.movetofirst();
return cursor.getlong(0);
public void close() {
dbopenhelper.close();
轉載：http://blog.csdn.net/chaoyu168/article/details/50467886
![Java String.format方法的簡單使用[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)