TbzLQw6t

1public class Create {
2
3    public void createtable() {
4        SQLiteDatabase db = Maindb.getInstancia().getWritableDatabase();
5        String colunas = "(id INTEGER , valoragua INTEGER , acordar INTERGER ,
6        dormir INTERGER )";
7        String query = "CREATE TABLE IF NOT EXISTS " + Maindb.TABELA +
8            colunas;
9        db.execSQL(query);
10    }
11}
12	
13public class Maindb extends SQLiteOpenHelper{
14
15    public static final String DATABASE = "bdrespostas";
16    public static final  int VERSION = 1;
17    public static final String TABELA = "respostasAguaCasa";
18    public static Maindb instancia;
19
20    public static  Maindb   getInstancia(){
21        if(instancia == null) instancia = new Maindb();
22        return instancia;
23    }
24
25    private Maindb( ){
26      super(Myapp.getContext() , DATABASE,null , VERSION);
27
28    }
29
30    @Override
31    public void onCreate(SQLiteDatabase db) {
32
33    }
34
35    @Override
36    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
37
38    }
39}
40	
41private static Context context;
42
43@Override
44public void onCreate() {
45    context = getApplicationContext();
46    super.onCreate();
47}
48
49public static Context getContext() {
50    return context;
51}
52	
53public class Read {
54      public ArrayList<RespostasAguaCasa> getLista() {
55            SQLiteDatabase db =
56                Maindb.getInstancia().getWritableDatabase();
57            String query = "SELECT * FROM " + Maindb.TABELA;
58            ArrayList<RespostasAguaCasa> lista = new ArrayList<>();
59
60            Cursor c = db.rawQuery(query, null);
61            if (c.moveToFirst()) {
62
63              do {
64                RespostasAguaCasa resp = new RespostasAguaCasa(c.getString(0));
65
66                resp.setValoragua(c.getInt(1));
67                resp.setAcordar(c.getInt(2));
68                resp.setDormir(c.getInt(3));
69                lista.add(resp);
70              }
71              while (c.moveToNext());
72              {
73              }
74            }
75            c.close();
76            return lista;
77      }
78}
79	
80public class Create {
81
82    public void createtable() {
83        SQLiteDatabase db = Maindb.getInstancia().getWritableDatabase();
84        String colunas  = "(id INTEGER , valoragua INTEGER , acordar
85        INTERGER , dormir INTERGER )";
86        String query  = "CREATE TABLE IF NOT EXISTS " + Maindb.TABELA +
87            colunas;
88        db.execSQL(query);
89
90    }
91}