package com.lfp.service;
import java.io.File;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.os.Environment;
import android.util.Log;
/**
*
* @author lifangping
* 可以传数据库路径的类
*/
public abstract class SDSQLiteOpenHelper {
private static final String TAG = SDSQLiteOpenHelper.class.getSimpleName();
@SuppressWarnings("unused")
private final Context mContext;
private final String mName;
private final CursorFactory mFactory;
private final int mNewVersion;
private SQLiteDatabase mDatabase = null;
private boolean mIsInitializing = false;
/**
* Create a helper object to create, open, and/or manage a database. The
* database is not actually created or opened until one of
* {@link #getWritableDatabase} or {@link #getReadableDatabase} is called.
*
* @param context
* to use to open or create the database
* @param name
* of the database file, or null for an in-memory database
* @param factory
* to use for creating cursor objects, or null for the default
* @param version
* number of the database (starting at 1); if the database is
* older, {@link #onUpgrade} will be used to upgrade the database
*/
public SDSQLiteOpenHelper(Context context, String name,
CursorFactory factory, int version) {
if (version < 1)
throw new IllegalArgumentException("Version must be >= 1, was "
+ version);
mContext = context;
mName = name;
mFactory = factory;
mNewVersion = version;
}
/**
* Create and/or open a database that will be used for reading and writing.
* Once opened successfully, the database is cached, so you can call this
* method every time you need to write to the database. Make sure to call
* {@link #close} when you no longer need it.
*
* <p>
* Errors such as bad permissions or a full disk may cause this operation to
* fail, but future attempts may succeed if the problem is fixed.
* </p>
*
* @throws SQLiteException
* if the database cannot be opened for writing
* @return a read/write database object valid until {@link #close} is called
*/
public synchronized SQLiteDatabase getWritableDatabase() {
if (mDatabase != null && mDatabase.isOpen() && !mDatabase.isReadOnly()) {
return mDatabase; // The database is already open for business
}
if (mIsInitializing) {
throw new IllegalStateException(
"getWritableDatabase called recursively");
}
// If we have a read-only database open, someone could be using it
// (though they shouldn't), which would cause a lock to be held on
// the file, and our attempts to open the database read-write would
// fail waiting for the file lock. To prevent that, we acquire the
// lock on the read-only database, which shuts out other users.
boolean success = false;
SQLiteDatabase db = null;
try {
mIsInitializing = true;
if (mName == null) {
db = SQLiteDatabase.create(null);
} else {
String path = getDatabasePath(mName).getPath();
db = SQLiteDatabase.openOrCreateDatabase(path, mFactory);
}
int version = db.getVersion();
if (version != mNewVersion) {
db.beginTransaction();
try {
if (version == 0) {
onCreate(db);
} else {
onUpgrade(db, version, mNewVersion);
}
db.setVersion(mNewVersion);
db.setTransactionSuccessful();
} finally {
db.endTransaction();
}
}
onOpen(db);
success = true;
return db;
} finally {
mIsInitializing = false;
if (success) {
if (mDatabase != null) {
try {
mDatabase.close();
} catch (Exception e) {
}
}
mDatabase = db;
} else {
if (db != null)
db.close();
}
}
}
/**
* Create and/or open a database. This will be the same object returned by
* {@link #getWritableDatabase} unless some problem, such as a full disk,
* requires the database to be opened read-only. In that case, a read-only
* database object will be returned. If the problem is fixed, a future call
* to {@link #getWritableDatabase} may succeed, in which case the read-only
* database object will be closed and the read/write object will be returned
* in the future.
*
* @throws SQLiteException
* if the database cannot be opened
* @return a database object valid until {@link #getWritableDatabase} or
* {@link #close} is called.
*/
public synchronized SQLiteDatabase getReadableDatabase() {
if (mDatabase != null && mDatabase.isOpen()) {
return mDatabase; // The database is already open for business
}
if (mIsInitializing) {
throw new IllegalStateException(
"getReadableDatabase called recursively");
}
try {
return getWritableDatabase();
} catch (SQLiteException e) {
if (mName == null)
throw e; // Can't open a temp database read-only!
Log.e(TAG, "Couldn't open " + mName
+ " for writing (will try read-only):", e);
}
SQLiteDatabase db = null;
try {
mIsInitializing = true;
String path = getDatabasePath(mName).getPath();
db = SQLiteDatabase.openDatabase(path, mFactory,
SQLiteDatabase.OPEN_READWRITE);
if (db.getVersion() != mNewVersion) {
throw new SQLiteException(
"Can't upgrade read-only database from version "
+ db.getVersion() + " to " + mNewVersion + ": "
+ path);
}
onOpen(db);
Log.w(TAG, "Opened " + mName + " in read-only mode");
mDatabase = db;
return mDatabase;
} finally {
mIsInitializing = false;
if (db != null && db != mDatabase)
db.close();
}
}
/**
* Close any open database object.
*/
public synchronized void close() {
if (mIsInitializing)
throw new IllegalStateException("Closed during initialization");
if (mDatabase != null && mDatabase.isOpen()) {
mDatabase.close();
mDatabase = null;
}
}
public File getDatabasePath(String name) {
String EXTERN_PATH = null;
if(Environment.getExternalStorageState().equals(Environment.MEDIA_MOU
没有合适的资源?快使用搜索试试~ 我知道了~
android公交地图源码
共45个文件
class:19个
java:9个
xml:5个
3星 · 超过75%的资源 需积分: 9 27 下载量 181 浏览量
2012-08-18
15:06:41
上传
评论
收藏 642KB RAR 举报
温馨提示
上传了一个 android 公交地图 源码,希望这个源码对下载的你们有用。
资源推荐
资源详情
资源评论
收起资源包目录
android公交地图.rar (45个子文件)
android公交地图
BjB
.project 839B
proguard.cfg 1KB
src
com
lfp
service
SDSQLiteOpenHelper.java 10KB
ImportDBFile.java 2KB
BusService.java 1KB
domain
Bus.java 594B
busactivity
DBTest.java 305B
Database.java 1KB
BusActivity.java 5KB
testBusService.java 704B
AndroidManifest.xml 1KB
res
raw
android.db 322KB
drawable-ldpi
icon.png 9KB
drawable-hdpi
icon.png 9KB
bg.png 115KB
menu
menu.xml 252B
drawable-mdpi
icon.png 9KB
layout
main.xml 2KB
values
color.xml 103B
strings.xml 453B
assets
gen
com
lfp
busactivity
R.java 2KB
default.properties 362B
.classpath 280B
bin
resources.ap_ 217KB
com
lfp
service
SDSQLiteOpenHelper.class 5KB
BusService.class 2KB
ImportDBFile.class 3KB
domain
Bus.class 1KB
busactivity
R$layout.class 397B
testBusService.class 1KB
Database.class 2KB
BusActivity$1.class 1KB
R$drawable.class 429B
R$attr.class 343B
R$raw.class 391B
BusActivity$2.class 3KB
DBTest.class 698B
R$id.class 529B
BusActivity.class 4KB
R.class 679B
R$string.class 604B
R$menu.class 384B
R$color.class 393B
BjB.apk 227KB
classes.dex 15KB
共 45 条
- 1
资源评论
- 疯狗大队大队长2012-12-14最近在研究只能公交,对我很有帮助啊。
- applesgr2013-06-09没有用 哎 不过还是谢谢分享了
yi_tian_yi
- 粉丝: 0
- 资源: 33
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功