Android-Sqlite以遞增or遞減查資料

Cursor的參數

public Cursor query(String table, String[] columns, String selection, 
                 String[] selectionArgs, String groupBy, 
                 String having, String orderBy)

orderBy參數：
遞增：ACS
遞減：DESC

 Cursor cursor = db.query("mCalendar", null, null, null, null, null, null);
if(cursor!=null && cursor.getCount()>0){
  Log.d("##$$##",String.valueOf(cursor.getCount()));
  cursor = db.query("mCalendar", null, null, null, null, null, "_realid DESC");//Change here
  while(cursor.moveToNext()){
    ITEM1=cursor.getInt(1);
    ITEM2=cursor.getInt(2);
         .
         .
         .
    }
}

Blogger-在文章貼程式碼

在Blogger的Html範本中</head>前貼入以下程式碼

接著以Html模式編輯文章

<pre class="brush: html">
//Code section
</pre>

Android-傳data給onDraw()

MainActivity：

mCanvasView=(CanvasView)findViewById(R.id.custom_view);
mCanvasView.setRender(true);
mCanvasView.setValue(w, d);
mCanvasView.invalidate();

To trigger the UI refresh：

mCanvasView.invalidate();

Canvas：

public class CanvasView extends View {
    private boolean isRender=false;
    public CanvasView(Context context,AttributeSet attrs) {
        super(context,attrs);
    }
    public void setValue(String[] mw,String[] md){
        w=mw;
        d=md;
    }
    public void setRender(boolean render){
        isRender=render;
    }
    @Override
    protected void onDraw(Canvas canvas) {
        super.onDraw(canvas);
        if(isRender) {
           //Draw
        }
    }
}

使用isRender，在Create還沒傳送data，先不Draw

XML：