数据库查询并存放

来源：互联网发布：c语言有什么用? 编辑：程序博客网时间：2024/05/16 09:29

写一个   泛型

public class Cloud {
   int Type;
   String Filename;
   int size;
   int Time;
   public int getType() {
       return Type;
   }
   public void setType(int type) {
       Type = type;
   }
   public String getFilename() {
       return Filename;
   }
   public void setFilename(String filename) {
       Filename = filename;
   }
   public int getSize() {
       return size;
   }
   public void setSize(int size) {
       this.size = size;
   }
   public int getTime() {
       return Time;
   }
   public void setTime(int time) {
       Time = time;
   }


}

写一个公共类可以调用

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

public class Cloudpublic {
public static List<Cloud> cloud = new ArrayList<Cloud>();
}

查询数据库

List<Cloud> getdate(){
       SQLiteDatabase date = dbHelper.getReadableDatabase();
       if(db.isOpen()){
           Cursor cursor = db.rawQuery("select Type,Filename,Size,Time frpm "
                   + "CloudFiles",null);
           while(cursor.moveToNext()){
               Cloud cloud = new Cloud();
               cloud.setType(cursor.getInt(cursor.getColumnIndex("Tyoe")));
               cloud.setFilename(cursor.getString(cursor.getColumnIndex("Filename")));
               cloud.setTime(cursor.getInt(cursor.getColumnIndex("Time")));
               cloud.setSize(cursor.getInt(cursor.getColumnIndex("Size")));
               Cloudpublic.cloud.add(cloud);
           }
       }
       return Cloudpublic.cloud;
   }

在另一个.class中调用

public void test(){

       String name = Cloudpublic.cloud.get(0).getFilename();

       Toast.makeText(this, "名字"+name, Toast.LENGTH_LONG).show();
   }

0 0