android 点滴积累

最新推荐文章于 2024-09-13 10:00:10 发布

weixin_33720078

最新推荐文章于 2024-09-13 10:00:10 发布

阅读量57

点赞数

文章标签：移动开发数据库

原文链接：https://yq.aliyun.com/articles/460883

版权

1、android程序查詢包含"*" "#"的號碼時出錯的解決辦法

代碼錯誤提示: E/AndroidRuntime(1145): Caused by: android.database.sqlite.SQLiteException: near "*": syntax error: , while compiling: SELECT numbertype, new, duration, _id, numberlabel, name, number, type, date FROM calls WHERE (number = **9) ORDER BY date desc  解決:    	strQuery = "number = " + strQueryNumber; 			callLogCursor = TApplication.nowTApplication.getContentResolver() 					.query(CallLog.Calls.CONTENT_URI, null, strQuery, null, 							"date desc"); 							 							查詢代碼改成: 							 								strQuery = "number = " + "'strQueryNumber'"; 			callLogCursor = TApplication.nowTApplication.getContentResolver() 					.query(CallLog.Calls.CONTENT_URI, null, strQuery, null, 							"date desc"); 							 	總結:因為"*"為數據庫里的關鍵字(未經證實),所有查找是會報語法錯誤,只需要拼接字符串,把"*"改成非關鍵字即可

2、 android通过查询电话号码获取联系人头像

// 取得Intent中的頭像 			ivShowImage = (ImageView) findViewById(R.id.call_log_detail_contact_img); 			//通话电话号码获取头像uri 			Uri uriNumber2Contacts = Uri 					.parse("content://com.android.contacts/" 							+ "data/phones/filter/" + strPhoneNumber); 			Cursor cursorCantacts = SApplication.nowSApplication 					.getContentResolver().query(uriNumber2Contacts, null, null, 							null, null); 			if (cursorCantacts.getCount() > 0) {	//若游标不为0则说明有头像,游标指向第一条记录 				cursorCantacts.moveToFirst(); 				Long contactID = cursorCantacts.getLong(cursorCantacts 						.getColumnIndex("contact_id")); 				Uri uri = ContentUris.withAppendedId( 						ContactsContract.Contacts.CONTENT_URI, contactID); 				InputStream input = ContactsContract.Contacts 						.openContactPhotoInputStream( 								SApplication.nowSApplication 										.getContentResolver(), uri); 				btContactImage = BitmapFactory.decodeStream(input); 				Log.i("info", "bt======" + btContactImage); 				ivShowImage.setImageBitmap(btContactImage);  			} else {//么有头像设置默认头像 				ivShowImage 						.setImageResource(R.drawable.call_log_contact_image2);  			}

本文转自xyz_lmn51CTO博客，原文链接：http://blog.51cto.com/xyzlmn/1230803，如需转载请自行联系原作者