CampusDao.java

/**
 * author :  lipan
 * filename :  CampusDao.java
 * create_time : 2014年8月24日 下午9:33:49
 */
package com.sets.speedtest.db;

import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;

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

import com.sets.speedtest.domain.Campus;
import com.sets.speedtest.utils.StringB;

/**
 * @author : lipan
 * @create_time : 2014年8月24日 下午9:33:49
 * @desc :
 * @update_person:
 * @update_time :
 * @update_desc :
 *
 */
public class CampusDao
{
    private SQLiteDatabase db;

    public CampusDao(SQLiteDatabase db)
    {
        this.db = db;
    }
    
    /**
     * 获得所有地市信息
     * 
     * @return
     */
    public List<String> getCityList()
    {
        List<String> list = new ArrayList<String>();
        Cursor cursor = db.query("campus", new String[] { "city" }, null, null, " city ",
                null, null);
        while (cursor.moveToNext())
        {
            list.add(cursor.getString(cursor.getColumnIndex("city")).trim());
        }
        cursor.close();
        return list;
    }

    /**
     * 获得所有学校信息
     * 
     * @return
     */
    public LinkedList<Campus> getCampusList(String city)
    {
        String selection = null;
        String[] selectionArgs = null;
        if (StringB.isNotBlank(city))
        {
            selection = " city=?"; 
            selectionArgs = new String[] { city }; 
        }
        LinkedList<Campus> campusArray = new LinkedList<Campus>();
        Cursor campusCursor = db.query("campus", new String[] { "name", "city" }, selection, selectionArgs, null,
                null, null);
        Campus campus;
        while (campusCursor.moveToNext())
        {
            campus = new Campus();
            campus.name = campusCursor.getString(campusCursor.getColumnIndex("name")).trim();
            campus.city = campusCursor.getString(campusCursor.getColumnIndex("city")).trim();
            campusArray.add(campus);
        }
        campusCursor.close();
        return campusArray;
    }

    /**
     * 根据名称查询学校信息
     * 
     * @return
     */
//    public SparseArray<Campus> getCampusList(String input)
//    {
//        SparseArray<Campus> campusArray = new SparseArray<Campus>();
//        String where = "name like ? limit 10";
//        String[] whereArgs = new String[] { "%" + input + "%"};
//        Cursor campusCursor = db.query("campus", new String[] { "name", "city" },
//                where, whereArgs, null, null, null);
//        Campus campus;
//        int index = 0;
//        while (campusCursor.moveToNext())
//        {
//            campus = new Campus();
//            campus.index = index;
//            campus.name = campusCursor.getString(campusCursor.getColumnIndex("name"));
//            campus.city = campusCursor.getString(campusCursor.getColumnIndex("city"));
//            campus.matchWord = campusCursor.getString(campusCursor.getColumnIndex("match_word"));
//            campusArray.put(campus.index, campus);
//            index++;
//        }
//        campusCursor.close();
//        return campusArray;
//    }
    
    /**
     * 根据名称查询学校信息
     * 
     * @return
     */
//    public Cursor getCampusListCursor(String input)
//    {
//        String where = "name like ? limit 10";
//        String[] whereArgs = new String[] { "%" + input + "%"};
//        return db.query("campus", new String[] { "name as _id", "city"},
//                where, whereArgs, null, null, null);
//    }
}