@Override public String getRemark(DBUser user, DBUser contact) { // db = getTransactionDB(); // // // select fs.[remark] from friend_state fs,friend_group fg where // // fs.user_account='100009' and fg.[user_account]='100000' and // // fs.[friend_group_account] = fg.[account]; // Cursor cursor = db.rawQuery("SELECT fs." // + DBColumns.FRIEND_STATE_REMARK + " FROM " // + DBColumns.FRIEND_STATE_TABLE_NAME + " fs," // + DBColumns.FRIEND_GROUP_TABLE_NAME + " fg WHERE fs." // + DBColumns.FRIEND_STATE_USER_ACCOUNT + "=? AND fg." // + DBColumns.FRIEND_GROUP_USER_ACCOUNT + "=? AND fs." // + DBColumns.FRIEND_STATE_FRIEND_GROUP_ACCOUNT + "=fg." // + DBColumns.FRIEND_GROUP_ACCOUNT, // new String[] { contact.getAccount(), mUser.getAccount() }); // String remark = null; // if (cursor.moveToFirst()) { // remark = cursor.getString(0); // } // cursor.close(); // // return remark; return getRemark(user.getAccount(), contact.getAccount()); }
@Override public void delete(String userAccount, String jid) { db = getTransactionDB(); DBUser contact = userDao.findByName(jid); if (contact == null) { return; } // 查找对应的account // select fs.[account] from friend_state fs,friend_group fg where // fs.[user_account]='100003' AND fs.[friend_group_account]=fg.[account] // and fg.[user_account]='100000' DBFriendGroupMapping mapping = find(userAccount, contact.getAccount()); delete(mapping); // db.execSQL("DELETE * FROM " + DBColumns., new Object[]{}); }
@Override // public synchronized void update(String userAccount, XMPPUser contact) { public void update(String userAccount, XMPPUser contact) { db = getTransactionDB(); synchronized (synchObj) { // 是否存在 DBUser user = userDao.findByAccount(userAccount); if (user == null) { return; } DBUser ct = userDao.findByName(contact.getJid()); if (ct == null) { add(userAccount, contact); return; } // 查找group,不存在会创建新的分组 String group = contact.getGroup(); DBFriendGroup fg = fgDao.find(userAccount, group); DBFriendGroupMapping mp = new DBFriendGroupMapping(); mp.setUser(ct); mp.setFriendGroup(fg); mp.setLoginState(contact.getStatusMode()); mp.setRemark(contact.getNickname()); // 查找mapping中是否存在 DBFriendGroupMapping mapping = find(userAccount, ct.getAccount()); if (mapping != null) { // 更新 mp.setAccount(mapping.getAccount()); update(mp); } else { // 不存在,添加 String acc = Integer.parseInt(getMaxAccount()) + 1 + ""; mp.setAccount(acc); add(mp); } } }
@Override public int delete(DBUser user) { db = getTransactionDB(); DBUser u = userDao.findByAccount(user.getAccount()); if (u == null) { return DBColumns.ERROR_USER_NOT_FOUND; } db.execSQL( "DELETE FROM " + DBColumns.FRIEND_STATE_TABLE_NAME + " WHERE " + DBColumns.FRIEND_STATE_USER_ACCOUNT + "=?", new Object[] {user.getAccount()}); return DBColumns.RESULT_OK; }
@Override // public synchronized void add(String account, XMPPUser contact) { public void add(String account, XMPPUser contact) { db = getTransactionDB(); synchronized (synchObj) { // 查找group String group = contact.getGroup(); DBFriendGroup fg = fgDao.find(account, group); // 查找contact String jid = contact.getJid(); DBUser ct = userDao.findByName(jid); if (ct == null) { // 添加contact // 查找account String ua = userDao.findMaxAccount(); ua = Integer.parseInt(ua) + 1 + ""; ct = new DBUser(); ct.setAccount(ua); ct.setNickname(jid); // ct.setState(contact.getStatusMode()); ct.setDesp(contact.getStatusMessage()); ct.setRegisterTime(new Date().getTime()); userDao.add(ct); } // 是否已经存在,add(mapping)中会检查 // 添加mapping DBFriendGroupMapping mapping = new DBFriendGroupMapping(); mapping.setFriendGroup(fg); mapping.setUser(ct); mapping.setRemark(contact.getNickname()); mapping.setLoginState(contact.getStatusMode()); String ac = Integer.parseInt(getMaxAccount()) + 1 + ""; mapping.setAccount(ac); add(mapping); } }
@Override public void updateXMPPFriendState(String userAccount, String jid, int status) { // public void updateXMPPFriendState(String jid, int status) { Logger.d("db", "user:"******",jid:" + jid + ",status:" + status); // 更新对应状态 db = getTransactionDB(); // 根据jid查询user_account // String userAccount = userDao.findByName(jid).getAccount(); DBUser contact = userDao.findByName(jid); if (contact == null) { // 抛出异常,暂时不做 return; } String contactAccount = contact.getAccount(); // update friend_state set login_state=5 where user_account='100120' and // exists(select * from friend_group where account='33' and user_account='100118'); // group_account不好获取 // db.execSQL("UPDATE " +DBColumns.FRIEND_STATE_TABLE_NAME // + " SET " + DBColumns.FRIEND_STATE_LOGIN_STATE + "=? WHERE " // + DBColumns.FRIEND_STATE_USER_ACCOUNT + "=? AND EXISTS(SELECT * FROM " // + DBColumns.FRIEND_GROUP_TABLE_NAME + " WHERE " // + DBColumns.FRIEND_GROUP_ACCOUNT + "=? AND " // + DBColumns.FRIEND_GROUP_USER_ACCOUNT + "=?)" // ,new Object[]{status,contactAccount}); // 查询对应的friend_state_account,然后修改 // select fs.account // from friend_state fs,friend_group fg // where fs.[user_account]='100120' // and fs.[friend_group_account]=fg.[account] // and fg.[user_account]='100112' Cursor cursor = db.rawQuery( "SELECT fs." + DBColumns.FRIEND_STATE_ACCOUNT + " FROM " + DBColumns.FRIEND_STATE_TABLE_NAME + " fs," + DBColumns.FRIEND_GROUP_TABLE_NAME + " fg WHERE fs." + DBColumns.FRIEND_STATE_USER_ACCOUNT + "=? AND fs." + DBColumns.FRIEND_STATE_FRIEND_GROUP_ACCOUNT + "=fg." + DBColumns.FRIEND_GROUP_ACCOUNT + " AND fg." + DBColumns.FRIEND_GROUP_USER_ACCOUNT + "=?", new String[] {contactAccount, userAccount}); String account = null; if (cursor.moveToFirst()) { account = cursor.getString(0); } cursor.close(); if (account == null) { // 不存在,抛出异常,暂不处理 return; } // 修改状态 db.execSQL( "UPDATE " + DBColumns.FRIEND_STATE_TABLE_NAME + " SET " + DBColumns.FRIEND_STATE_LOGIN_STATE + "=? WHERE " + DBColumns.FRIEND_STATE_ACCOUNT + "=?", new Object[] {status, account}); }