-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDatabaseHelper.java
More file actions
72 lines (58 loc) · 1.6 KB
/
Copy pathDatabaseHelper.java
File metadata and controls
72 lines (58 loc) · 1.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
package dao;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
/** Classe Android para utilizar a classe SQLHelper
* @author Arthur Assuncao
* @license Creative Commons3 <http://creativecommons.org/licenses/by-sa/3.0/deed.pt_BR>
* @see SQLHelper
*/
public class DatabaseHelper {
private SQLHelper sqlHelper;
private SQLiteDatabase db;
private static final String NOME_BANCO = "database";
private static final int VERSAO = 1;
private static DatabaseHelper banco;
private static final String[] DATABASE_TABLES = {
"Teste"
};
private static final String[] DATABASE_TABELAS_REMOVIDAS = {
};
private static final String[] DATABASE_CREATE = new String[]{
"CREATE TABLE IF NOT EXISTS Teste (" +
"codigo VARCHAR(25), " +
"nome VARCHAR(50), " +
"email VARCHAR(20), " +
"PRIMARY KEY (codigo)" +
");" +
""
};
private DatabaseHelper(Context context) {
// cria o SQLHelper
sqlHelper = new SQLHelper(context, NOME_BANCO, VERSAO, DATABASE_TABLES, DATABASE_CREATE, DATABASE_TABELAS_REMOVIDAS);
//abre o banco de dados para escrita e leitura
db = sqlHelper.getWritableDatabase();
}
public synchronized static DatabaseHelper getInstance(Context context){
if(banco == null || !banco.db.isOpen()){
banco = new DatabaseHelper(context);
}
return banco;
}
public synchronized boolean isOpen(){
if(db != null && db.isOpen()){
return true;
}
return false;
}
public synchronized void fechar(){
if(sqlHelper != null){
sqlHelper.close();
}
if(db != null && db.isOpen()){
db.close();
}
}
public synchronized SQLiteDatabase getDb() {
return db;
}
}