SNkxVKk2

1public class Create {
2
3
4
5public void createtable() {
6    SQLiteDatabase db = Maindb.getInstancia().getWritableDatabase();
7String colunas  = "(id INTEGER PRIMARY KEY , valoragua INTEGER , 
8acordarhora INTERGER , dormirhora INTERGER , acordarminutos INTERGER , 
9dormirminutos INTERGER )";
10String query  = "CREATE TABLE IF NOT EXISTS " + Maindb.TABELA + colunas;
11db.execSQL(query);
12	
13public class Read {
14     public ArrayList<RespostasAguaCasa> getLista() {
15            SQLiteDatabase db = 
16 Maindb.getInstancia().getWritableDatabase();
17            String query = "SELECT * FROM " + Maindb.TABELA;
18            ArrayList<RespostasAguaCasa> lista = new ArrayList<>();
19
20            Cursor c = db.rawQuery(query, null);
21            if (c.moveToFirst()) {
22
23                do {
24                    RespostasAguaCasa resp = new RespostasAguaCasa(c.getString(0));
25                    resp.setId(c.getInt(1));
26                    resp.setValoragua(c.getInt(2));
27                    resp.setAcordarhora(c.getInt(3));
28                    resp.setAcordarminu(c.getInt(4));
29                    resp.setDormirhora(c.getInt(5));
30                    resp.setDormirminu(c.getInt(6));
31                    lista.add(resp);
32                }
33                while (c.moveToNext());
34                {
35                }
36
37
38    }
39    c.close();
40    return lista;
41}
42	
43public class Update {
44public boolean addResposta(RespostasAguaCasa respostasAguaCasa){
45    SQLiteDatabase db = Maindb.getInstancia().getWritableDatabase();
46    ContentValues cv = new ContentValues();
47    cv.put("id" , respostasAguaCasa.getId());
48    cv.put("valoragua" , respostasAguaCasa.getValoragua());
49    cv.put("acordar" , respostasAguaCasa.getAcordarhora());
50    cv.put("dormir" , respostasAguaCasa.getDormirhora());
51    return  db.insert(Maindb.TABELA, null , cv)!= -1;
52}
53
54public boolean UpdateResposta(RespostasAguaCasa respostasAguaCasa){
55    SQLiteDatabase db = Maindb.getInstancia().getWritableDatabase();
56    ContentValues cv = new ContentValues();
57    cv.put("valoragua" , respostasAguaCasa.getValoragua());
58    cv.put("acordar" , respostasAguaCasa.getAcordarhora());
59    cv.put("dormir" , respostasAguaCasa.getDormirhora());
60    String where = "id = '" + respostasAguaCasa.getId() + "'";
61
62
63    return db.update(Maindb.TABELA, cv, where, null) > 0;
64}
65	
66public class MainDB extends SQLiteOpenHelper {
67
68private static String NOME_DB = "DB";
69private static int VERSAO_DB = 1;
70public static String TABELA_PESSOA = "TABELA_PESSOA";
71
72
73private static MainDB instancia;
74
75
76public static MainDB getInstancia() {
77    if (instancia == null) instancia = new MainDB();
78    return instancia;
79}
80
81
82private MainDB() {
83    super(MyApp.getContext(), NOME_DB, null, VERSAO_DB);
84}
85
86
87@Override
88public void onCreate(SQLiteDatabase db) {
89
90}
91
92@Override
93public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
94
95}
96
97
98@Override
99public synchronized void close() {
100    instancia = null;
101    super.close();
102}
103	
104public class Myapp extends Application {
105      private static Context mContext;
106
107
108@Override
109public void onCreate() {
110    mContext = getApplicationContext();
111    super.onCreate();
112}
113
114public static Context getContext() {
115    return mContext;
116}