SQlite数据库查找功能

代码如下：

Dao.java(其中Constants.TABLE_NAME为数据库的表名)

public class Dao {

    private final MyDatabaseHelper mHelper;

    public Dao(Context context){
        //创建数据库
        mHelper=new MyDatabaseHelper(context);
    }

    public List<persion> Query(String name){
        SQLiteDatabase db=mHelper.getWritableDatabase();
        List<persion> list=new ArrayList<persion>();
        String sql="select * from "+Constants.TABLE_NAME+" where name=?";
        Cursor cursor=db.rawQuery(sql,new String[]{name});
        while (cursor.moveToNext())// 判断Cursor中是否有数据  name,data,time,local,temperature
        {
            // 如果有用户，则把查到的值填充这个用户实体
            String persion_Name=cursor.getString(cursor.getColumnIndex("name"));
            String persion_Date=cursor.getString(cursor.getColumnIndex("data"));
            String persion_Time=cursor.getString(cursor.getColumnIndex("time"));
            String persion_Local=cursor.getString(cursor.getColumnIndex("local"));
            String persion_Temperature=cursor.getString(cursor.getColumnIndex("temperature"));
            String persion_Instruction=cursor.getString(cursor.getColumnIndex("instruction"));
            persion per = new persion(persion_Name,persion_Date,persion_Time,persion_Local,persion_Temperature,persion_Instruction);
            list.add(per);
        }
        return list;// 返回一个用户给前台
    }

}

persion.java

public class persion {
    String name;
    String date;
    String time;
    String local;
    String temperature;
    String instruction;

    public String getInstruction() {
        return instruction;
    }

    public void setInstruction(String instruction) {
        this.instruction = instruction;
    }

    public String getTemperature() {
        return temperature;
    }

    public void setTemperature(String temperature) {
        this.temperature = temperature;
    }

    public String getLocal() {
        return local;
    }

    public void setLocal(String local) {
        this.local = local;
    }

    public String getTime() {
        return time;
    }

    public void setTime(String time) {
        this.time = time;
    }

    public String getDate() {
        return date;
    }

    public void setDate(String date) {
        this.date = date;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public persion(){}

    public persion(String name,String date,String time,String local,String temperature,String instruction){
        super();
        this.name=name;
        this.date=date;
        this.temperature=temperature;
        this.time=time;
        this.local=local;
        this.instruction=instruction;
    }

    @Override
    public String toString() {
        return "persion{" +
                "name='" + name + '\'' +
                ", date='" + date + '\''+
                ", time='" + time + '\''+
                ", local='" +local + '\''+
                ", temperature='" + temperature + '\''+
                ", instruction='" + instruction + '\'' +
                '}';
    }
}