[转]将cursor转换成任意类型VO__dashlayout初步

原帖地址：
http://blog.csdn.net/Oo8_8oO/article/details/7003162

package com.sql2vo.helper;
import java.lang.reflect.Constructor;  
import java.lang.reflect.Field;  
import java.util.HashMap;  
import java.util.LinkedList;  
import java.util.List;  
import java.util.Map;  

import android.database.Cursor;  
import android.database.sqlite.SQLiteDatabase;  

/** 
 * 通过SQL语句查询出结果并封闭到VO里 
 *  
 * @author dengzer@gmail.com 
 * @version 创建时间：2011-10-28 下午05:27:39 
 */  
public class HappySQL {  

    /** 
     * 通过SQL语句获得对应的VO。注意：Cursor的字段名或者别名一定要和VO的成员名一样 
     *  
     * @param db 
     * @param sql 
     * @param clazz vo class
     * @return 
     */  
    @SuppressWarnings("rawtypes")  
    public static Object sql2VO(SQLiteDatabase db, String sql, Class clazz) {  
        Cursor c = db.rawQuery(sql, null);  
        return cursor2VO(c, clazz);  
    }  

    /** 
     * 通过SQL语句获得对应的VO。注意：Cursor的字段名或者别名一定要和VO的成员名一样 
     *  
     * @param db 
     * @param sql 
     * @param selectionArgs 
     * @param clazz 
     * @return 
     */  
    @SuppressWarnings("rawtypes")  
    public static Object sql2VO(SQLiteDatabase db, String sql,  
            String[] selectionArgs, Class clazz) {  
        Cursor c = db.rawQuery(sql, selectionArgs);  
        return cursor2VO(c, clazz);  
    }  

    /** 
     * 通过SQL语句获得对应的VO的List。注意：Cursor的字段名或者别名一定要和VO的成员名一样 
     *  
     * @param db 
     * @param sql 
     * @param clazz 
     * @return 
     */  
    @SuppressWarnings("rawtypes")  
    public static List sql2VOList(SQLiteDatabase db, String sql, Class clazz) {  

    	Cursor c = db.rawQuery(sql, null);

        return cursor2VOList(c, clazz);  
    }  

    /** 
     * 通过SQL语句获得对应的VO的List。注意：Cursor的字段名或者别名一定要和VO的成员名一样 
     *  
     * @param db 
     * @param sql 
     * @param selectionArgs 
     * @param clazz 
     * @return 
     */  
    @SuppressWarnings("rawtypes")  
    public static List sql2VOList(SQLiteDatabase db, String sql,  
            String[] selectionArgs, Class clazz) {  
        Cursor c = db.rawQuery(sql, selectionArgs);  
        return cursor2VOList(c, clazz);  
    }  

    /** 
     * 通过Cursor转换成对应的VO。注意：Cursor里的字段名（可用别名）必须要和VO的属性名一致 
     *  
     * @param c 
     * @param clazz 
     * @return 
     */  
    @SuppressWarnings({ "rawtypes", "unused" })  
    private static Object cursor2VO(Cursor c, Class clazz) {  
        if (c == null) {  
            return null;  
        }  
        Object obj;  
        int i = 1;  
        try {  
            c.moveToNext();  
            obj = setValues2Fields(c, clazz);  

            return obj;  
        } catch (Exception e) {  
            System.out.println(e);  
            System.out.println("ERROR @：cursor2VO");  
            return null;  
        } finally {  
            c.close();  
        }  
    }  

    /** 
     * 通过Cursor转换成对应的VO集合。注意：Cursor里的字段名（可用别名）必须要和VO的属性名一致 
     *  
     * @param c 
     * @param clazz 
     * @return 
     */  
    @SuppressWarnings({ "rawtypes", "unchecked" })  
    private static List cursor2VOList(Cursor c, Class clazz) {  
        if (c == null) {  
            return null;  
        }  
        List list = new LinkedList();  
        Object obj;  
        try {  
            while (c.moveToNext()) {  
                obj = setValues2Fields(c, clazz);

                list.add(obj);  
            }  
            return list;  
        } catch (Exception e) {  
            e.printStackTrace();  
            System.out.println("ERROR @：cursor2VOList");  
            return null;  
        } finally {  
            c.close();  
        }  
    }  

    /** 
     * 把值设置进类属性里 
     *  
     * @param columnNames 
     * @param fields 
     * @param c 
     * @param obj 
     * @throws Exception 
     */  
    @SuppressWarnings("rawtypes")  
    private static Object setValues2Fields(Cursor c, Class clazz)  
            throws Exception {  

    	String[] columnNames = c.getColumnNames();// 字段数组  
    	//init a instance from the VO`s class
        Object obj = clazz.newInstance();  
        //return a field array from obj`s ALL(include private exclude inherite(from father)) field
        Field[] fields = clazz.getDeclaredFields();  

        for (Field _field : fields) 
        { 
        	//field`s type
            Class<? extends Object> typeClass = _field.getType();// 属性类型  
            for (int j = 0; j < columnNames.length; j++) 
            {  
                String columnName = columnNames[j];  
                typeClass = getBasicClass(typeClass);  
                //if typeclass is basic class ,package.if not,no change
                boolean isBasicType = isBasicType(typeClass);  

                if (isBasicType) {  
                    if (columnName.equalsIgnoreCase(_field.getName())) {// 是基本类型  
                        String _str = c.getString(c.getColumnIndex(columnName));  
                        if (_str == null) {  
                            break;  
                        }  
                        _str = _str == null ? "" : _str;
                        //if value is null,make it to ""
                        //use the constructor to init a attribute instance by the value
                        Constructor<? extends Object> cons = typeClass  
                                .getConstructor(String.class);  
                        Object attribute = cons.newInstance(_str);  
                        _field.setAccessible(true);
                        //give the obj the attr
                        _field.set(obj, attribute);  
                        break;  
                    }  
                } else {  
                    Object obj2 = setValues2Fields(c, typeClass);// 递归  
                    _field.set(obj, obj2);  
                    break;  
                }  

            }  
        }  
        return obj;  
    }  

    /** 
     * 判断是不是基本类型 
     *  
     * @param typeClass 
     * @return 
     */  
    @SuppressWarnings("rawtypes")  
    private static boolean isBasicType(Class typeClass) {  
        if (typeClass.equals(Integer.class) || typeClass.equals(Long.class)  
                || typeClass.equals(Float.class)  
                || typeClass.equals(Double.class)  
                || typeClass.equals(Boolean.class)  
                || typeClass.equals(Byte.class)  
                || typeClass.equals(Short.class)  
                || typeClass.equals(String.class)) {  

            return true;  

        } else {  
            return false;  
        }  
    }  

    /** 
     * 获得包装类 
     *  
     * @param typeClass 
     * @return 
     */  
    @SuppressWarnings("all")  
    public static Class<? extends Object> getBasicClass(Class typeClass) {  
        Class _class = basicMap.get(typeClass);  
        if (_class == null)  
            _class = typeClass;  
        return _class;  
    }  

    @SuppressWarnings("rawtypes")  
    private static Map<Class, Class> basicMap = new HashMap<Class, Class>();  
    static {  
        basicMap.put(int.class, Integer.class);  
        basicMap.put(long.class, Long.class);  
        basicMap.put(float.class, Float.class);  
        basicMap.put(double.class, Double.class);  
        basicMap.put(boolean.class, Boolean.class);  
        basicMap.put(byte.class, Byte.class);  
        basicMap.put(short.class, Short.class);  
    }  
}  

界面

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >

    <include layout="@layout/test_db"/>    

</LinearLayout>

Button的布局
其中style在另一个文件

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
  xmlns:android="http://schemas.android.com/apk/res/android"
  android:orientation="vertical"
  android:layout_width="match_parent"
  android:layout_height="match_parent">

    <LinearLayout android:layout_height="wrap_content" android:id="@+id/linearLayout1" android:layout_width="match_parent">
        <Button 
        android:text="Button" 
        android:id="@+id/button1"
		android:layout_width="wrap_content" 
		android:layout_height="wrap_content"
		android:drawableLeft="@drawable/icon"
		style="@style/style1"
		></Button>
    </LinearLayout>
</LinearLayout>

/values/styles

<?xml version="1.0" encoding="utf-8"?>
<resources>
    <style name="style1">
    	<item name="android:layout_gravity">center_vertical</item>
        <item name="android:layout_width">wrap_content</item>
        <item name="android:layout_height">wrap_content</item>
        <item name="android:gravity">center_horizontal</item>
        <item name="android:drawablePadding">2dp</item>
        <item name="android:textSize">16dp</item>
        <item name="android:textStyle">bold</item>
        <item name="android:textColor">#ff29549f</item>
        <item name="android:background">@null</item>
    </style>

</resources>

效果如下
图片和button文字都是Button按钮的一部分