package com.yangguangfu.database;
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;
/**
* 数据库方法封装,创建表,删除表,数据(增删该查)...
* @author 阿福(trygf521@126.com)
*
*/
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))";
dbOpenHelper.getWritableDatabase().execSQL(sql);
}
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))";
dbOpenHelper.getWritableDatabase().execSQL(sql);
}
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))";
dbOpenHelper.getWritableDatabase().execSQL(sql);
}
public void saveConfigInfo(ConfigInfo configInfo) {
dbOpenHelper.getWritableDatabase().execSQL(
"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) {
dbOpenHelper
.getWritableDatabase()
.execSQL(
"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) {
dbOpenHelper.getWritableDatabase().execSQL(
"insert into install (na,it,d) values(?,?,?)",
new Object[] { configInfo.getNa(), configInfo.getIt(),
configInfo.getD() });
}
public void updateConfigInfo(ConfigInfo configInfo) {
dbOpenHelper.getWritableDatabase().execSQL(
"update config set s=?, rt=?, st=?, ru=?, v=?,i=? where id=?",
new Object[] { configInfo.getS(), configInfo.getRt(),
configInfo.getSt(), configInfo.getRu(),
configInfo.getV(), configInfo.getI(),
configInfo.getId() });
}
public void updateApplicationInfo(ApplicationInfo configInfo) {
dbOpenHelper
.getWritableDatabase()
.execSQL(
"update application set s=?, tt=?, st=?, tc1=?, tc2=?,ru=?,tn=?,m=? where id=?",
new Object[] { configInfo.getS(), configInfo.getTt(),
configInfo.getSt(), configInfo.getTc1(),
configInfo.getTc2(), configInfo.getRu(),
configInfo.getTn(),configInfo.getM(), configInfo.getId() });
}
public void updateInstallInfo(InstallInfo configInfo) {
dbOpenHelper.getWritableDatabase().execSQL(
"update install set na=?, it=?, d=? where id=?",
new Object[] { configInfo.getNa(), configInfo.getIt(),
configInfo.getD(), configInfo.getId() });
}
public void updateSMSInfo(SMSInfo configInfo) {
dbOpenHelper
.getWritableDatabase()
.execSQL(
"update smslist set t=?, st=?, n1=?, n2=?, n=?, m=?, a=? where id=?",
new Object[] { configInfo.getT(), configInfo.getSt(),
configInfo.getN1(), configInfo.getN2(),
configInfo.getN(), configInfo.getM(),
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) {
Cursor cursor = dbOpenHelper.getWritableDatabase().rawQuery(
"select id,s,rt,st,ru,v,i from config where id=?",
new String[] { String.valueOf(id) });
if (cursor.moveToNext()) {
ConfigInfo configInfo = new ConfigInfo();
configInfo.setId((cursor.getInt(0)));
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));
return configInfo;
}
return null;
}
public SMSInfo findSMSInfo(Integer id) {
Cursor cursor = dbOpenHelper.getWritableDatabase().rawQuery(
"select id,t,st,n1,n2,n,m,a from smslist where id=?",
new String[] { String.valueOf(id) });
if (cursor.moveToNext()) {
SMSInfo configInfo = new SMSInfo();
configInfo.setId((cursor.getInt(0)));
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));
return configInfo;
}
return null;
}
public ApplicationInfo findApplication(Integer id) {
Cursor cursor = dbOpenHelper
.getWritableDatabase()
.rawQuery(
"select id,s,tt,st,tc1,tc2,ru,tn,m from application where id=?",
new String[] { String.valueOf(id) });
if (cursor.moveToNext()) {
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;
}
return null;
}
public long getDataCount(String tableName) {
Cursor cursor = dbOpenHelper.getReadableDatabase().rawQuery(
"select count(*) from " + tableName, null);
cursor.moveToFirst();
return cursor.getLong(0);
}
// // ///////////////////////
// public LinkedList<ConfigInfo> getScrollData(int startindex, int maxResult) {
// LinkedList<ConfigInfo> xmlInfos = new LinkedList<ConfigInfo>();
// Cursor
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
Database_sqlite.zip (72个子文件)
Database_sqlite
.project 851B
src
install.xml 164B
application.xml 253B
com
yangguangfu
database
DBOpenHelper.java 2KB
DatabaseTest.java 5KB
DatabaseService.java 9KB
bean
ApplicationInfo.java 2KB
InstallInfo.java 1KB
SMSInfo.java 2KB
ConfigInfo.java 1KB
VersionInfo.java 297B
smslist.xml 224B
config.xml 201B
version.xml 52B
AndroidManifest.xml 620B
res
drawable-ldpi
icon.png 2KB
drawable-hdpi
icon.png 4KB
drawable-mdpi
icon.png 3KB
layout
main.xml 409B
values
strings.xml 237B
assets
gen
com
leequer
readxml
tgxx
readxml
R.java 782B
default.properties 449B
.classpath 280B
ReadXml
.project 843B
src
com
leequer
service
XMLContentHandler.java 3KB
demo
Country.java 1KB
readxml
SaxReadxml.java 2KB
XMLBroadcastReceiver.java 1KB
AndroidManifest.xml 1KB
res
drawable-ldpi
icon.png 2KB
drawable-hdpi
icon.png 4KB
drawable-mdpi
icon.png 3KB
layout
main.xml 409B
values
strings.xml 237B
assets
gen
com
leequer
readxml
R.java 785B
default.properties 449B
.classpath 280B
bin
resources.ap_ 11KB
ReadXml.apk 16KB
com
leequer
service
demo
Country.class 1KB
XMLContentHandler.class 2KB
readxml
R$layout.class 397B
R$drawable.class 403B
R$attr.class 343B
SaxReadxml.class 3KB
XMLBroadcastReceiver.class 1KB
R$id.class 385B
R.class 538B
R$string.class 459B
classes.dex 7KB
bin
resources.ap_ 11KB
install.xml 164B
application.xml 253B
com
leequer
readxml
tgxx
readxml
R$layout.class 388B
R$drawable.class 394B
R$attr.class 334B
R$id.class 376B
R.class 517B
R$string.class 450B
yangguangfu
database
DatabaseService.class 8KB
DatabaseTest.class 7KB
DBOpenHelper.class 2KB
bean
InstallInfo.class 2KB
VersionInfo.class 752B
SMSInfo.class 3KB
ConfigInfo.class 2KB
ApplicationInfo.class 3KB
smslist.xml 224B
Database_sqlite.apk 21KB
classes.dex 18KB
config.xml 201B
version.xml 52B
共 72 条
- 1
资源评论
睿子
- 粉丝: 39
- 资源: 40
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功