Java Code Examples for android.database.sqlite.SQLiteDatabase.isOpen()
The following are Jave code examples for showing how to use
isOpen() of the
android.database.sqlite.SQLiteDatabase
class.
You can vote up the examples you like. Your votes will be used in our system to get
more good examples.
Example 1
| Project: GCSApp File: DemoDBManager.java Source Code and License | 7 votes |
/**
* save a message
*
* @param message
* @return return cursor of the message
*/
public synchronized Integer saveMessage(InviteMessage message) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
int id = -1;
if (db.isOpen()) {
ContentValues values = new ContentValues();
values.put(InviteMessgeDao.COLUMN_NAME_FROM, message.getFrom());
values.put(InviteMessgeDao.COLUMN_NAME_GROUP_ID, message.getGroupId());
values.put(InviteMessgeDao.COLUMN_NAME_GROUP_Name, message.getGroupName());
values.put(InviteMessgeDao.COLUMN_NAME_REASON, message.getReason());
values.put(InviteMessgeDao.COLUMN_NAME_TIME, message.getTime());
values.put(InviteMessgeDao.COLUMN_NAME_STATUS, message.getStatus().ordinal());
values.put(InviteMessgeDao.COLUMN_NAME_GROUPINVITER, message.getGroupInviter());
db.insert(InviteMessgeDao.TABLE_NAME, null, values);
Cursor cursor = db.rawQuery("select last_insert_rowid() from " + InviteMessgeDao.TABLE_NAME, null);
if (cursor.moveToFirst()) {
id = cursor.getInt(0);
}
cursor.close();
}
return id;
}
Example 2
| Project: GitHub File: DBUtils.java Source Code and License | 6 votes |
public static boolean isFieldExists(SQLiteDatabase db, String tableName, String fieldName) {
if (tableName == null || db == null || fieldName == null || !db.isOpen()) return false;
Cursor cursor = null;
try {
cursor = db.rawQuery("SELECT * FROM " + tableName + " LIMIT 0", null);
return cursor != null && cursor.getColumnIndex(fieldName) != -1;
} catch (Exception e) {
OkLogger.printStackTrace(e);
return false;
} finally {
if (cursor != null) {
cursor.close();
}
}
}
Example 3
| Project: prada File: UploadLogDBHelper.java Source Code and License | 6 votes |
public void DisplayUploadFile(){
SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
if (db != null && db.isOpen()) {
Cursor cur = db.rawQuery("select upload_file_name, isForceUpload, isResend from file_info",
new String[]{});
if (!cur.isClosed()) {
try{
while(cur.moveToNext()){
Log.i(TAG, "upload_file_name: " + cur.getString(0) + " isForceUpload: " + cur.getInt(1) + " isResend: " + cur.getInt(2));
}
} catch(Exception ex){
Log.i(TAG, ex.toString());
} finally{
cur.close();
db.close();
}
}
}
}
Example 4
| Project: prada File: UploadLogDBHelper.java Source Code and License | 6 votes |
public String getBindId(File uploadFile){
SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
String bindID = null;
if (db != null && db.isOpen()) {
Cursor cur = db.rawQuery("select sourceid from uploadlog where uploadfilepath=?",
new String[]{uploadFile.getAbsolutePath()});
if (!cur.isClosed()) {
try{
if(cur.moveToFirst()){
bindID = cur.getString(0);
}
} catch(Exception ex){
} finally{
cur.close();
db.close();
}
}
}
return bindID;
}
Example 5
| Project: GCSApp File: DemoDBManager.java Source Code and License | 5 votes |
/**
* update message
*
* @param msgId
* @param values
*/
synchronized public void updateMessage(int msgId, ContentValues values) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
if (db.isOpen()) {
db.update(InviteMessgeDao.TABLE_NAME, values, InviteMessgeDao.COLUMN_NAME_ID + " = ?", new String[]{String.valueOf(msgId)});
}
}
Example 6
| Project: CCDownload File: DataSet.java Source Code and License | 5 votes |
public static void insertVideoPosition(String videoId, int position) {
SQLiteDatabase database = sqLiteOpenHelper.getWritableDatabase();
if (database.isOpen()) {
ContentValues values = new ContentValues();
values.put("videoId", videoId);
values.put("position", position);
database.insert(VIDEOPOSITION, null, values);
database.close();
}
}
Example 7
| Project: CCDownload File: DataSet.java Source Code and License | 5 votes |
public static int getVideoPosition(String videoId) {
int position = 0;
SQLiteDatabase database = sqLiteOpenHelper.getReadableDatabase();
if (database.isOpen()) {
Cursor cursor = database.query(VIDEOPOSITION, new String[]{"position"}, "videoId=?", new String[]{videoId}, null, null, null);
if (cursor.moveToFirst()) {
position = cursor.getInt(cursor.getColumnIndex("position"));
}
cursor.close();
database.close();
}
return position;
}
Example 8
| Project: CCDownload File: DataSet.java Source Code and License | 5 votes |
public static void updateVideoPosition(String videoId, int position) {
SQLiteDatabase database = sqLiteOpenHelper.getWritableDatabase();
if (database.isOpen()) {
ContentValues values = new ContentValues();
values.put("position", position);
database.update(VIDEOPOSITION, values, "videoId=?", new String[]{videoId});
database.close();
}
}
Example 9
| Project: prada File: UploadLogDBHelper.java Source Code and License | 5 votes |
public FileInfo getFileInfo(String uploadFileName){
FileInfo fileInfo = new FileInfo();
SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
if (db != null && db.isOpen()) {
Cursor cur = db.rawQuery("select upload_file_name, isForceUpload, isResend from file_info where upload_file_name = ?",
new String[]{uploadFileName});
if (!cur.isClosed()) {
try{
while(cur.moveToNext()){
if (cur.getInt(1) == 0) {
fileInfo.isForceUpload = false;
} else {
fileInfo.isForceUpload = true;
}
if (cur.getInt(2) == 0) {
fileInfo.isResend = false;
} else {
fileInfo.isResend = true;
}
}
} catch(Exception ex){
} finally{
cur.close();
db.close();
}
}
}
return fileInfo;
}
Example 10
| Project: GCSApp File: DemoDBManager.java Source Code and License | 5 votes |
synchronized int getUnreadNotifyCount() {
int count = 0;
SQLiteDatabase db = dbHelper.getReadableDatabase();
if (db.isOpen()) {
Cursor cursor = db.rawQuery("select " + InviteMessgeDao.COLUMN_NAME_UNREAD_MSG_COUNT + " from " + InviteMessgeDao.TABLE_NAME, null);
if (cursor.moveToFirst()) {
count = cursor.getInt(0);
}
cursor.close();
}
return count;
}
Example 11
| Project: GCSApp File: DemoDBManager.java Source Code and License | 5 votes |
synchronized void setUnreadNotifyCount(int count) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
if (db.isOpen()) {
ContentValues values = new ContentValues();
values.put(InviteMessgeDao.COLUMN_NAME_UNREAD_MSG_COUNT, count);
db.update(InviteMessgeDao.TABLE_NAME, values, null, null);
}
}
Example 12
| Project: GCSApp File: DemoDBManager.java Source Code and License | 5 votes |
synchronized private void setList(String column, List<String> strList) {
StringBuilder strBuilder = new StringBuilder();
for (String hxid : strList) {
strBuilder.append(hxid).append("$");
}
SQLiteDatabase db = dbHelper.getWritableDatabase();
if (db.isOpen()) {
ContentValues values = new ContentValues();
values.put(column, strBuilder.toString());
db.update(UserDao.PREF_TABLE_NAME, values, null, null);
}
}
Example 13
| Project: GCSApp File: DemoDBManager.java Source Code and License | 5 votes |
/**
* get contact list
*
* @return
*/
synchronized public Map<String, EaseUser> getContactList() {
SQLiteDatabase db = dbHelper.getReadableDatabase();
Map<String, EaseUser> users = new Hashtable<String, EaseUser>();
if (db.isOpen()) {
Cursor cursor = db.rawQuery("select * from " + UserDao.TABLE_NAME /* + " desc" */, null);
while (cursor.moveToNext()) {
String username = cursor.getString(cursor.getColumnIndex(UserDao.COLUMN_NAME_ID));
String nick = cursor.getString(cursor.getColumnIndex(UserDao.COLUMN_NAME_NICK));
String avatar = cursor.getString(cursor.getColumnIndex(UserDao.COLUMN_NAME_AVATAR));
String phone = cursor.getString(cursor.getColumnIndex(UserDao.COLUMN_NAME_PHONE));
String postion = cursor.getString(cursor.getColumnIndex(UserDao.ROBOT_COLUMN_NAME_POSITION));
String company = cursor.getString(cursor.getColumnIndex(UserDao.ROBOT_COLUMN_NAME_COMPANY));
String nickName = cursor.getString(cursor.getColumnIndex(UserDao.ROBOT_COLUMN_NAME_NICKNAME));
String memberid = cursor.getString(cursor.getColumnIndex(UserDao.COLUMN_NAME_MEMBER_ID));
EaseUser user = new EaseUser(username);
user.setNick(nick);
user.setNewnickName(nickName);
user.setAvatar(avatar);
user.setPhone(phone);
try {
user.setMemberId(Integer.valueOf(memberid));
} catch (Exception e) {
}
user.setPosition(postion);
user.setCompany(company);
if (username.equals(Constant.NEW_FRIENDS_USERNAME) || username.equals(Constant.GROUP_USERNAME)
|| username.equals(Constant.CHAT_ROOM) || username.equals(Constant.CHAT_ROBOT)) {
user.setInitialLetter("");
} else {
EaseCommonUtils.setUserInitialLetter(user);
}
users.put(username, user);
}
cursor.close();
}
return users;
}
Example 14
| Project: GCSApp File: DemoDBManager.java Source Code and License | 5 votes |
/**
* delete a contact
*
* @param username
*/
synchronized public void deleteContact(String username) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
if (db.isOpen()) {
db.delete(UserDao.TABLE_NAME, UserDao.COLUMN_NAME_ID + " = ?", new String[]{username});
}
}
Example 15
| Project: Android-2017 File: DataBaseHelper.java Source Code and License | 4 votes |
/**
* Cierra la base de datos
* @param db conexión a base de dato a cerrar
*/
public void closeDatabase (SQLiteDatabase db) {
if (db != null && db.isOpen()) {
db.close();
}
}
Example 16
| Project: Android-2017 File: DataBaseHelper.java Source Code and License | 4 votes |
/**
* Cierra la base de datos
* @param db conexión a base de dato a cerrar
*/
public void closeDatabase (SQLiteDatabase db) {
if (db != null && db.isOpen()) {
db.close();
}
}
Example 17
| Project: GCSApp File: DemoDBManager.java Source Code and License | 4 votes |
/**
* save a contact
*
* @param user
*/
synchronized public void saveContact(EaseUser user) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(UserDao.COLUMN_NAME_ID, user.getUsername());
if (user.getNick() != null) {
values.put(UserDao.COLUMN_NAME_NICK, user.getNewnickName());
} else {
values.put(UserDao.COLUMN_NAME_NICK, "");
}
if (user.getNewnickName() != null) {
values.put(UserDao.ROBOT_COLUMN_NAME_NICKNAME, user.getNewnickName());
} else {
values.put(UserDao.ROBOT_COLUMN_NAME_NICKNAME, "");
}
if (user.getAvatar() != null) {
values.put(UserDao.COLUMN_NAME_AVATAR, user.getAvatar());
} else {
values.put(UserDao.COLUMN_NAME_AVATAR, "");
}
if (user.getPhone() != null) {
values.put(UserDao.COLUMN_NAME_PHONE, user.getPhone());
} else {
values.put(UserDao.COLUMN_NAME_PHONE, "");
}
if (user.getPosition() != null) {
values.put(UserDao.ROBOT_COLUMN_NAME_POSITION, user.getPosition());
} else {
values.put(UserDao.ROBOT_COLUMN_NAME_POSITION, "");
}
if (user.getCompany() != null) {
values.put(UserDao.ROBOT_COLUMN_NAME_COMPANY, user.getCompany());
} else {
values.put(UserDao.ROBOT_COLUMN_NAME_COMPANY, "");
}
values.put(UserDao.COLUMN_NAME_MEMBER_ID, user.getMemberId());
if (db.isOpen()) {
db.replace(UserDao.TABLE_NAME, null, values);
}
}
Example 18
| Project: GCSApp File: DemoDBManager.java Source Code and License | 4 votes |
/**
* get messges
*
* @return
*/
synchronized public List<InviteMessage> getMessagesList() {
SQLiteDatabase db = dbHelper.getReadableDatabase();
List<InviteMessage> msgs = new ArrayList<InviteMessage>();
if (db.isOpen()) {
Cursor cursor = db.rawQuery("select * from " + InviteMessgeDao.TABLE_NAME + " desc", null);
while (cursor.moveToNext()) {
InviteMessage msg = new InviteMessage();
int id = cursor.getInt(cursor.getColumnIndex(InviteMessgeDao.COLUMN_NAME_ID));
String from = cursor.getString(cursor.getColumnIndex(InviteMessgeDao.COLUMN_NAME_FROM));
String groupid = cursor.getString(cursor.getColumnIndex(InviteMessgeDao.COLUMN_NAME_GROUP_ID));
String groupname = cursor.getString(cursor.getColumnIndex(InviteMessgeDao.COLUMN_NAME_GROUP_Name));
String reason = cursor.getString(cursor.getColumnIndex(InviteMessgeDao.COLUMN_NAME_REASON));
long time = cursor.getLong(cursor.getColumnIndex(InviteMessgeDao.COLUMN_NAME_TIME));
int status = cursor.getInt(cursor.getColumnIndex(InviteMessgeDao.COLUMN_NAME_STATUS));
String groupInviter = cursor.getString(cursor.getColumnIndex(InviteMessgeDao.COLUMN_NAME_GROUPINVITER));
msg.setId(id);
msg.setFrom(from);
msg.setGroupId(groupid);
msg.setGroupName(groupname);
msg.setReason(reason);
msg.setTime(time);
msg.setGroupInviter(groupInviter);
if (status == InviteMesageStatus.BEINVITEED.ordinal())
msg.setStatus(InviteMesageStatus.BEINVITEED);
else if (status == InviteMesageStatus.BEAGREED.ordinal())
msg.setStatus(InviteMesageStatus.BEAGREED);
else if (status == InviteMesageStatus.BEREFUSED.ordinal())
msg.setStatus(InviteMesageStatus.BEREFUSED);
else if (status == InviteMesageStatus.AGREED.ordinal())
msg.setStatus(InviteMesageStatus.AGREED);
else if (status == InviteMesageStatus.REFUSED.ordinal())
msg.setStatus(InviteMesageStatus.REFUSED);
else if (status == InviteMesageStatus.BEAPPLYED.ordinal())
msg.setStatus(InviteMesageStatus.BEAPPLYED);
else if (status == InviteMesageStatus.GROUPINVITATION.ordinal())
msg.setStatus(InviteMesageStatus.GROUPINVITATION);
else if (status == InviteMesageStatus.GROUPINVITATION_ACCEPTED.ordinal())
msg.setStatus(InviteMesageStatus.GROUPINVITATION_ACCEPTED);
else if (status == InviteMesageStatus.GROUPINVITATION_DECLINED.ordinal())
msg.setStatus(InviteMesageStatus.GROUPINVITATION_DECLINED);
msgs.add(msg);
}
cursor.close();
}
return msgs;
}
Example 19
| Project: boohee_v5.6 File: a.java Source Code and License | 4 votes |
private List<String> a() {
SQLiteDatabase readableDatabase;
Cursor rawQuery;
SQLiteDatabase sQLiteDatabase;
Throwable th;
Cursor cursor = null;
List<String> arrayList = new ArrayList();
try {
readableDatabase = getReadableDatabase();
try {
rawQuery = readableDatabase.rawQuery("select tid from tb_tid", null);
while (rawQuery.moveToNext()) {
try {
Object string = rawQuery.getString(0);
if (!TextUtils.isEmpty(string)) {
arrayList.add(b.a(2, string, com.alipay.sdk.util.a.c((Context) this.c.get())));
}
} catch (Exception e) {
cursor = rawQuery;
sQLiteDatabase = readableDatabase;
} catch (Throwable th2) {
th = th2;
}
}
if (rawQuery != null) {
rawQuery.close();
}
if (readableDatabase != null && readableDatabase.isOpen()) {
readableDatabase.close();
}
} catch (Exception e2) {
sQLiteDatabase = readableDatabase;
if (cursor != null) {
cursor.close();
}
if (sQLiteDatabase != null && sQLiteDatabase.isOpen()) {
sQLiteDatabase.close();
}
return arrayList;
} catch (Throwable th3) {
Throwable th4 = th3;
rawQuery = null;
th = th4;
if (rawQuery != null) {
rawQuery.close();
}
if (readableDatabase != null && readableDatabase.isOpen()) {
readableDatabase.close();
}
throw th;
}
} catch (Exception e3) {
sQLiteDatabase = null;
if (cursor != null) {
cursor.close();
}
sQLiteDatabase.close();
return arrayList;
} catch (Throwable th32) {
readableDatabase = null;
th = th32;
rawQuery = null;
if (rawQuery != null) {
rawQuery.close();
}
readableDatabase.close();
throw th;
}
return arrayList;
}
Example 20
| Project: GCSApp File: DemoDBManager.java Source Code and License | 4 votes |
/**
* save contact list
*
* @param contactList
*/
synchronized public void saveContactList(List<EaseUser> contactList) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
if (db.isOpen()) {
db.delete(UserDao.TABLE_NAME, null, null);
for (EaseUser user : contactList) {
ContentValues values = new ContentValues();
values.put(UserDao.COLUMN_NAME_ID, user.getUsername());
if (user.getNick() != null) {
values.put(UserDao.COLUMN_NAME_NICK, user.getNick());
} else {
values.put(UserDao.COLUMN_NAME_NICK, "");
}
if (user.getPhone() != null) {
values.put(UserDao.COLUMN_NAME_PHONE, user.getPhone());
} else {
values.put(UserDao.COLUMN_NAME_PHONE, "");
}
if (user.getAvatar() != null) {
values.put(UserDao.COLUMN_NAME_AVATAR, user.getAvatar());
} else {
values.put(UserDao.COLUMN_NAME_AVATAR, "");
}
// if (user.getNickName() != null) {
// values.put(UserDao.COLUMN_NAME_NICK, user.getNickName());
// } else {
// values.put(UserDao.COLUMN_NAME_NICK, "");
//
// }
if (user.getNewnickName() != null) {
values.put(UserDao.ROBOT_COLUMN_NAME_NICKNAME, user.getNewnickName());
} else {
values.put(UserDao.ROBOT_COLUMN_NAME_NICKNAME, "");
}
if (user.getPosition() != null) {
values.put(UserDao.ROBOT_COLUMN_NAME_POSITION, user.getPosition());
} else {
values.put(UserDao.ROBOT_COLUMN_NAME_POSITION, "");
}
if (user.getCompany() != null) {
values.put(UserDao.ROBOT_COLUMN_NAME_COMPANY, user.getCompany());
} else {
values.put(UserDao.ROBOT_COLUMN_NAME_COMPANY, "");
}
values.put(UserDao.COLUMN_NAME_MEMBER_ID, user.getMemberId());
db.replace(UserDao.TABLE_NAME, null, values);
}
}
}
