package com.archermind.assistant.util;
import java.sql.SQLDataException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.text.format.DateFormat;
import com.archermind.assistant.data.DBHelper;
import com.archermind.assistant.util.ContactsUtils.Contacts;
/**
* @see FilterDatabaseUtils 数据库操作帮助类 实现对数据库增删改查动作
* @author 002221
*
*/
public class FilterDatabaseUtils {
/**
* 拦截下的电话
*/
public static final int FHONECALL = 1;
/**
* 拦截下的短信
*/
public static final int MSM = 2;
/**
* 7个时间段的子列表
*/
@SuppressWarnings("unchecked")
private List<ArrayList> arrayList = new ArrayList<ArrayList>();
@SuppressWarnings("unchecked")
private List<ArrayList> arrayList2 = new ArrayList<ArrayList>();
@SuppressWarnings("unchecked")
private List<ArrayList> arrayList3 = new ArrayList<ArrayList>();
@SuppressWarnings("unchecked")
private List<ArrayList> arrayList4 = new ArrayList<ArrayList>();
@SuppressWarnings("unchecked")
private List<ArrayList> arrayList5 = new ArrayList<ArrayList>();
@SuppressWarnings("unchecked")
private List<ArrayList> arrayList6 = new ArrayList<ArrayList>();
@SuppressWarnings("unchecked")
private List<ArrayList> arrayList7 = new ArrayList<ArrayList>();
/**
* selectData 查询Filter_Record中的电话拦截记录
*
* @param beging
* @param end
* @return Cursor 查询到的所有电话拦截记录 数据
*/
public Cursor selectPhoneData(SQLiteDatabase database)
throws SQLiteException {
Cursor cursor;
cursor = database
.rawQuery(
"select * from Filter_Record where filter_mold = 1 order by _id desc",
null);
return cursor;
}
/**
* selectData 查询Filter_Record中的短信拦截记录
*
* @param beging
* @param end
* @return Cursor 查询到的所有电话拦截记录 数据
*/
public Cursor selectMSMData(SQLiteDatabase database) throws SQLiteException {
Cursor cursor;
cursor = database
.rawQuery(
"select * from Filter_Record where filter_mold = 2 order by _id desc",
null);
return cursor;
}
/**
* converPhoneCursorTolist(Cursor cursor) 从cursor中取出所有的list数据
*
* @param cursor
* 查询所有的电话拦截记录
* @return List<List<ArrayList>> 返回存放的所有的list 按天数封装好的list
* @throws ParseException
*/
@SuppressWarnings("unchecked")
public List<List<ArrayList>> converPhoneCursorTolist(Cursor cursor)
throws ParseException, SQLiteException {
List<List<ArrayList>> list_child = new ArrayList<List<ArrayList>>();
/**
* 今天凌晨的时间
*/
String nowdate = (String) extracted();
nowdate = nowdate + " 00:00:00";
while (cursor.moveToNext()) {
ArrayList<String> list = new ArrayList<String>();
// list添加联系人号码
list.add(cursor.getString(1));
// list添加联系人姓名 根据号码从系统数据库中得姓名 (从拦截设置中调用查询获得姓名 暂时使用”张三“测试名)
list.add("张三");
// 根据日期做的处理
String stringdata = cursor.getString(2);
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd ");
Date infodate = dateFormat.parse(stringdata);
if (cursor.getInt(4) == 1) {
// 电话list添加时间
list.add(stringdata);
}
// 是短信拦截 需添加新的字段
if (cursor.getInt(4) == 2) {
String msgTime = stringdata.substring(11);
list.add(msgTime);
// 添加短信内容
list.add(cursor.getString(3));
}
cursor.close();
Date date2 = dateFormat.parse(nowdate);
long datetime = date2.getTime();// 当天凌晨毫秒标准
long gettime = infodate.getTime();// 查询数据库得到的毫秒
long adaytime = 24 * 60 * 60 * 1000;
if (gettime >= datetime && gettime < (datetime + adaytime)) { // 今天
arrayList.add(list);
} else if (gettime >= (datetime - adaytime) && gettime < (datetime)) { // 前1天
arrayList2.add(list);
} else if (gettime >= (datetime - 2 * adaytime) // 前2天
&& gettime < (datetime - adaytime)) {
arrayList3.add(list);
} else if (gettime >= (datetime - 3 * adaytime)
&& gettime < (datetime - 2 * adaytime)) { // 前3天
arrayList4.add(list);
} else if (gettime >= (datetime - 4 * adaytime)
&& gettime < (datetime - 3 * adaytime)) { // 前4天
arrayList5.add(list);
} else if (gettime >= (datetime - 10 * adaytime)
&& gettime < (datetime - 4 * adaytime)) { // 前5-10天
arrayList6.add(list);
} else if (gettime >= (datetime - 15 * adaytime)
&& gettime < (datetime - 10 * adaytime)) { // 前10-15天
arrayList7.add(list);
}
}
// 展示子list是为不规律的7个字段
list_child.add(arrayList);
list_child.add(arrayList2);
list_child.add(arrayList3);
list_child.add(arrayList4);
list_child.add(arrayList5);
list_child.add(arrayList6);
list_child.add(arrayList7);
return list_child;
}
/**
* @see extracted()
* @return CharSequence 今天的时间(CharSequence类型)
*
*/
@SuppressWarnings("static-access")
private CharSequence extracted() {
return (new DateFormat().format("yyyy-MM-dd", new Date()));
}
/**
* @see deleteFromNumber() 删除对指定联系人的拦截
* @param databasewrite
* @param number
*/
public void deleteFilterNumber(SQLiteDatabase databasewrite, String number)
throws SQLiteException {
databasewrite.execSQL("delete from Filter_Set where phone_num="
+ number + "");
}
/**
* @see deleteInfoFromNumber() 对指定联系人的时间段的拦截记录的删除
* @param databasewrite
* @param number
*/
public void deleteInfoFromNumber(SQLiteDatabase databasewrite,
String number, String timebegin, String timeend)
throws SQLiteException {
databasewrite.execSQL("delete from Filter_Record where filter_num="
+ number + " and filter_time > '" + timebegin
+ "' and filter_time < '" + timeend + "' ");
}
/**
* @see getCount() 得到数据库中拦截记录的总纪录数
* @return
*/
public long getCount(SQLiteDatabase database) throws SQLiteException {
Cursor cursor = database.rawQuery("select count(*) from Filter_Record",
null);
cursor.moveToFirst();
return cursor.getLong(0);
}
/**
* @see getExist(SQLiteDatabase database,String num) 是否存在此拦截号码
* @param database
* @param num
* @return
*/
public boolean getExist(SQLiteDatabase database, String num)
throws SQLiteException {
Cursor cursor = database.rawQuery(
"select phone_num from Filter_Set where phone_num=" + num + "",
null);
return cursor.moveToNext();
}
/**
* @see getExistMsgNumber() 查询这个号码是否是需要拦截短信的电话号码
* @param database
* @param num
* @return
*/
public boolean getExistMsgNumber(SQLiteDatabase database, String num)
throws SQLiteException {
Cursor cursor = database.rawQuery(
"select phone_num from Filter_Set where phone_num=" + num
+ " and filter_type = 0 or filter_type=2", null);
return cursor.moveToNext();
}
/**
* @see getExistPhoneNumber() 查询这个号码是否是需要拦截电话的电话号码
* @param database
* @param num
* @return boolean
*/
public boolean getExistPhoneNumber(SQLiteDatabase database, String num)
throws SQLiteException {
Cursor cursor = database.rawQuery(
"select phone_num from Filter_Set where phone_num=" + num
+ " and filter_type = 0 or filter_type=1", null);
return cursor.moveToNext();
}
/**
* @see setPhoneInto(String phoneNumber, SQLiteDatabase database) 插入拦截下的电话信息
* @param phoneNumber
* @param database
*/
public void setPhoneInto(String phoneNumber, SQLiteDatabase data
没有合适的资源?快使用搜索试试~ 我知道了~
Android应用源码之拦截软件,拦截电话,短信.zip项目安卓应用源码下载
![preview](https://csdnimg.cn/release/downloadcmsfe/public/img/white-bg.ca8570fa.png)
共682个文件
svn-base:232个
class:190个
java:87个
![preview-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/scale.ab9e0183.png)
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
![star](https://csdnimg.cn/release/downloadcmsfe/public/img/star.98a08eaa.png)
温馨提示
Android应用源码之拦截软件,拦截电话,短信.zip项目安卓应用源码下载Android应用源码之拦截软件,拦截电话,短信.zip项目安卓应用源码下载 1.适合学生毕业设计研究参考 2.适合个人学习研究参考 3.适合公司开发项目技术参考
资源推荐
资源详情
资源评论
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
共 682 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
- weixin_672699782022-03-25用户下载后在一定时间内未进行评价,系统默认好评。
- 2301_771405882023-06-12发现一个宝藏资源,赶紧冲冲冲!支持大佬~
![avatar](https://profile-avatar.csdnimg.cn/default.jpg!1)
yxkfw
- 粉丝: 78
- 资源: 2万+
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
最新资源
- C# winform置托盘图标并闪烁演示源码.zip
- 打包和分发Rust工具.pdf
- SQL中的CREATE LOGFILE GROUP 语句.pdf
- C语言-leetcode题解之第172题阶乘后的零.zip
- C语言-leetcode题解之第171题Excel列表序号.zip
- C语言-leetcode题解之第169题多数元素.zip
- ocr-图像识别资源ocr-图像识别资源
- 图像识别:基于Resnet50 + VGG16模型融合的人体细胞癌症分类模型实现-图像识别资源
- C语言-leetcode题解之第168题Excel列表名称.zip
- C语言-leetcode题解之第167题两数之和II-输入有序数组.zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
![feedback](https://img-home.csdnimg.cn/images/20220527035711.png)
![feedback](https://img-home.csdnimg.cn/images/20220527035711.png)
![feedback-tip](https://img-home.csdnimg.cn/images/20220527035111.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)