学习整理重点、盲区,笔记如下:干干巴巴,麻麻赖赖,一点都不圆润……
联网等操作需要开启新线程,所以可以在工具类中提供一个 全局线程池,
private ExecutorService executors = Executors.newCachedThreadPool();
public ExecutorService getGlobalThreadPool(){
return executors;
}
//代码中使用:
getGolbalThreadPool().execute(new Runnable() {
@Override
public void run() {
……
数据库建表语句
public class UserAccountTable {
public static final String TAB_NAME = "tab_account";
public static final String COL_NAME = "name";
public static final String COL_HXID = "hxid";
public static final String COL_NICK = "nick";
public static final String COL_PHOTO = "photo";
public static final String CREATE_TAB = "create table "
+ TAB_NAME + " ("
+ COL_HXID + " text primary key,"
+ COL_NAME + " text,"
+ COL_NICK + " text,"
+ COL_PHOTO + " text);";
}
用户账号表操作类
// 添加用户到数据库
public void addAccount(UserInfo user) {
// 获取数据库对象
SQLiteDatabase db = mHelper.getReadableDatabase();
// 执行添加操作
ContentValues values = new ContentValues();
values.put(UserAccountTable.COL_HXID, user.getHxid());
values.put(UserAccountTable.COL_NAME, user.getName());
values.put(UserAccountTable.COL_NICK, user.getNick());
values.put(UserAccountTable.COL_PHOTO, user.getPhoto());
db.replace(UserAccountTable.TAB_NAME, null, values);
}
// 根据环信id获取所有用户信息
public UserInfo getAccountByHxId(String hxId) {
// 获取数据库对象
SQLiteDatabase db = mHelper.getReadableDatabase();
// 执行查询语句
String sql = "select * from " + UserAccountTable.TAB_NAME + " where " + UserAccountTable.COL_HXID + "=?";
Cursor cursor = db.rawQuery(sql, new String[]{hxId});
UserInfo userInfo = null;
if(cursor.moveToNext()) {
userInfo = new UserInfo();
// 封装对象
userInfo.setHxid(cursor.getString(cursor.getColumnIndex(UserAccountTable.COL_HXID)));
userInfo.setName(cursor.getString(cursor.getColumnIndex(UserAccountTable.COL_NAME)));
userInfo.setNick(cursor.getString(cursor.getColumnIndex(UserAccountTable.COL_NICK)));
userInfo.setPhoto(cursor.getString(cursor.getColumnIndex(UserAccountTable.COL_PHOTO)));
}
// 关闭资源
cursor.close();
return userInfo;
}
但我真的好不喜欢这节课……
android:state_checked
;Android项目实战—— 商城APP.
Android项目实战—— 新闻APP.
本文地址:https://blog.csdn.net/liusaisaiV1/article/details/106476367
如对本文有疑问, 点击进行留言回复!!
PostgreSQL select for update指定列(兼容oracle)
SQL语句中的WHERE、聚合函数(SUM、MIN、MAX、AVG、COUNT)、HAVING
sql server登录名、服务器角色、数据库用户、数据库角色、架构区别联系
网友评论