最后
**要想成为高级安卓工程师,必须掌握许多基础的知识。**在工作中,这些原理可以极大的帮助我们理解技术,在面试中,更是可以帮助我们应对大厂面试官的刁难。
网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。
一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
-
VIDEO_COL_NAME + " TEXT," + VIDEO_COL_LOCK + " INTEGER,"
-
VIDEO_COL_RESOLUTION + " INTEGER" + “);”;
db.execSQL(createRouteTableSql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// Drop older table if existed
db.execSQL("DROP TABLE IF EXISTS " + VIDEO_TABLE_NAME);
// Create tables again
onCreate(db);
}
// Add new DriveVideo
public int addDriveVideo(DriveVideo driveVideo) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(VIDEO_COL_NAME, driveVideo.getName());
values.put(VIDEO_COL_LOCK, driveVideo.getLock());
values.put(VIDEO_COL_RESOLUTION, driveVideo.getResolution());
// Insert to database
long rowId = db.insert(VIDEO_TABLE_NAME, null, values);
// Close the database
db.close();
return (int) rowId;
}
// Get DriveVideo By ID
public DriveVideo getRouteDistanceById(int id) {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(VIDEO_TABLE_NAME, VIDEO_COL_PROJECTION,
VIDEO_COL_ID + “=?”, new String[] { String.valueOf(id) }, null,
null, null, null);
if (cursor != null)
cursor.moveToFirst();
DriveVideo driveVideo = new DriveVideo(cursor.getInt(0),
cursor.getString(1), cursor.getInt(2), cursor.getInt(3));
db.close();
cursor.close();
return driveVideo;
}
// Get DriveVideo By Name
public DriveVideo getDriveVideoByName(String name) {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(VIDEO_TABLE_NAME, VIDEO_COL_PROJECTION,
VIDEO_COL_NAME + “=?”, new String[] { name }, null, null, null,
null);
if (cursor != null)
cursor.moveToFirst();
DriveVideo driveVideo = new DriveVideo(cursor.getInt(0),
cursor.getString(1), cursor.getInt(2), cursor.getInt(3));
db.close();
cursor.close();
return driveVideo;
}
public boolean isVideoExist(String name) {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(VIDEO_TABLE_NAME, VIDEO_COL_PROJECTION,
VIDEO_COL_NAME + “=?”, new String[] { name }, null, null, null,
null);
if (cursor.getCount() > 0) {
db.close();
cursor.close();
return true;
} else {
db.close();
cursor.close();
return false;
}
}
/**
-
根据视频名查询是否加锁
-
@param name
-
@return
*/
public int getLockStateByVideoName(String name) {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(VIDEO_TABLE_NAME, VIDEO_COL_PROJECTION,
VIDEO_COL_NAME + “=?”, new String[] { name }, null, null, null,
null);
if (cursor.getCount() > 0) {
cursor.moveToFirst();
int videoLock = cursor
.getInt(cursor.getColumnIndex(VIDEO_COL_LOCK));
db.close();
cursor.close();
return videoLock;
} else {
db.close();
cursor.close();
return 0;
}
}
/**
-
获取所有的视频信息
-
@return
*/
public List getAllDriveVideo() {
List driveVideoList = new ArrayList();
String selectQuery = "SELECT * FROM " + VIDEO_TABLE_NAME;
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
DriveVideo driveVideo = new DriveVideo(cursor.getInt(0),
cursor.getString(1), cursor.getInt(2), cursor.getInt(3));
driveVideoList.add(driveVideo);
} while (cursor.moveToNext());
}
db.close();
cursor.close();
// return list
return driveVideoList;
}
public Cursor getAllDriveVideoCursor() {
String selectQuery = "SELECT * FROM " + VIDEO_TABLE_NAME;
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
return cursor;
}
/**
-
获取加锁视频Cursor
-
@return
*/
public Cursor getLockVideoCursor() {
String sqlLine = "SELECT * FROM " + VIDEO_TABLE_NAME + " WHERE "
- VIDEO_COL_LOCK + “=?”;
String selection[] = new String[] { “1” };
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(sqlLine, selection);
return cursor;
}
/**
-
获取最旧且未加锁视频ID
-
@return
*/
public int getOldestUnlockVideoId() {
String sqlLine = "SELECT * FROM " + VIDEO_TABLE_NAME + " WHERE "
- VIDEO_COL_LOCK + “=?”;
String selection[] = new String[] { “0” };
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(sqlLine, selection);
if (cursor.getCount() > 0) {
cursor.moveToFirst();
int id = cursor.getInt(cursor.getColumnIndex(VIDEO_COL_ID));
db.close();
cursor.close();
return id;
} else {
db.close();
cursor.close();
return -1;
}
}
/**
-
获取最旧视频(包括加锁)ID
-
@return
*/
public int getOldestVideoId() {
String sqlLine = "SELECT * FROM " + VIDEO_TABLE_NAME;
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(sqlLine, null);
if (cursor.getCount() > 0) {
cursor.moveToFirst();
int id = cursor.getInt(cursor.getColumnIndex(VIDEO_COL_ID));
db.close();
cursor.close();
return id;
} else {
db.close();
cursor.close();
return -1;
}
}
public String getVideNameById(int id) {
String sqlLine = "SELECT * FROM " + VIDEO_TABLE_NAME + " WHERE "
- VIDEO_COL_ID + “=?”;
String selection[] = new String[] { String.valueOf(id) };
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(sqlLine, selection);
if (cursor.getCount() > 0) {
cursor.moveToFirst();
String videoName = cursor.getString(cursor
.getColumnIndex(VIDEO_COL_NAME));
db.close();
cursor.close();
return videoName;
} else {
db.close();
cursor.close();
return “”;
}
}
public int updateDriveVideo(DriveVideo driveVideo) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(VIDEO_COL_NAME, driveVideo.getName());
values.put(VIDEO_COL_LOCK, driveVideo.getLock());
values.put(VIDEO_COL_RESOLUTION, driveVideo.getResolution());
return db.update(VIDEO_TABLE_NAME, values, VIDEO_COL_ID + “=?”,
new String[] { String.valueOf(driveVideo.getId()) });
}
public void deleteDriveVideoById(int driveVideoId) {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(VIDEO_TABLE_NAME, VIDEO_COL_ID + “=?”,
new String[] { String.valueOf(driveVideoId) });
db.close();
}
public void deleteDriveVideoByName(String name) {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(VIDEO_TABLE_NAME, VIDEO_COL_NAME + “=?”,
new String[] { name });
db.close();
}
public void deleteAllDriveVideo() {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(VIDEO_TABLE_NAME, null, null);
db.close();
}
}
不过,函数写这么长真的好么?
/**
- 删除最旧视频
*/
private boolean deleteOldestUnlockVideo() {
try {
String sdcardPath = Constant.Path.SDCARD_1 + File.separator;// “/storage/sdcard1/”;
if (Constant.Record.saveVideoToSD2) {
sdcardPath = Constant.Path.SDCARD_2 + File.separator;// “/storage/sdcard2/”;
}
// sharedPreferences.getString(“sdcardPath”,“/mnt/sdcard2”);
float sdFree = StorageUtil.getSDAvailableSize(sdcardPath);
float sdTotal = StorageUtil.getSDTotalSize(sdcardPath);
int intSdFree = (int) sdFree;
MyLog.v(“[deleteOldestUnlockVideo] sdFree:” + intSdFree);
while (sdFree < sdTotal * Constant.Record.SD_MIN_FREE_PERCENT
|| intSdFree < Constant.Record.SD_MIN_FREE_STORAGE) {
int oldestUnlockVideoId = videoDb.getOldestUnlockVideoId();
// 删除较旧未加锁视频文件
if (oldestUnlockVideoId != -1) {
String oldestUnlockVideoName = videoDb
.getVideNameById(oldestUnlockVideoId);
File f = new File(sdcardPath + “tachograph/”
-
oldestUnlockVideoName.split(“_”)[0]
-
File.separator + oldestUnlockVideoName);
if (f.exists() && f.isFile()) {
MyLog.d(“Delete Old Unlock Video:” + f.getName());
int i = 0;
最后说一下我的学习路线
其实很简单就下面这张图,含概了Android所有需要学的知识点,一共8大板块:
- 架构师筑基必备技能
- Android框架体系架构(高级UI+FrameWork源码)
- 360°Androidapp全方位性能调优
- 设计思想解读开源框架
- NDK模块开发
- 移动架构师专题项目实战环节
- 移动架构师不可不学习微信小程序
- 混合开发的flutter
Android学习的资料
我呢,把上面八大板块的分支都系统的做了一份学习系统的资料和视频,大概就下面这些,我就不全部写出来了,不然太长了影响大家的阅读。
330页PDF Android学习核心笔记(内含上面8大板块)
Android学习的系统对应视频
总结
我希望通过我自己的学习方法来帮助大家去提升技术:
-
1、多看书、看源码和做项目,平时多种总结
-
2、不能停留在一些基本api的使用上,应该往更深层次的方向去研究,比如activity、view的内部运行机制,比如Android内存优化,比如aidl,比如JNI等,并不仅仅停留在会用,而要通过阅读源码,理解其实现原理
-
3、同时对架构是有一定要求的,架构是抽象的,但是设计模式是具体的,所以一定要加强下设计模式的学习
-
4、android的方向也很多,高级UI,移动架构师,数据结构与算法和音视频FFMpeg解码,如果你对其中一项比较感兴趣,就大胆的进阶吧!
希望大家多多点赞,转发,评论加关注,你们的支持就是我继续下去的动力!加油!
网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。
一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!
330页PDF Android学习核心笔记(内含上面8大板块)
[外链图片转存中…(img-cD8PyGuI-1715010881140)]
Android学习的系统对应视频
总结
我希望通过我自己的学习方法来帮助大家去提升技术:
-
1、多看书、看源码和做项目,平时多种总结
-
2、不能停留在一些基本api的使用上,应该往更深层次的方向去研究,比如activity、view的内部运行机制,比如Android内存优化,比如aidl,比如JNI等,并不仅仅停留在会用,而要通过阅读源码,理解其实现原理
-
3、同时对架构是有一定要求的,架构是抽象的,但是设计模式是具体的,所以一定要加强下设计模式的学习
-
4、android的方向也很多,高级UI,移动架构师,数据结构与算法和音视频FFMpeg解码,如果你对其中一项比较感兴趣,就大胆的进阶吧!
希望大家多多点赞,转发,评论加关注,你们的支持就是我继续下去的动力!加油!
网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。
一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!