koobas.hobune.stream
How to read a database (sqlite) on Android?
Hi! I'm trying to make a script to connect and read the database, but on Android, I can only connect to it, when I want to read the data, nothing happens. What can it be? Here the script:
public Text constatus;
public Text valor;
public Text dispositivo;
public Text caminhot;
public Text acao;
private string caminho;
public SqliteConnection conexao;
void Start () {
//conectarDataBase ();
//LerDados ();
}
public void conectarDataBase(){
acao.text = "Ação: Conectar database";
try {
if (Application.platform != RuntimePlatform.Android) { //windows
caminho = Application.dataPath + "/alho.db";
dispositivo.text = "Dispositivo: " + Application.platform.ToString();
caminhot.text = "Local: " + caminho;
} else {
caminho = Application.persistentDataPath + "/alho.db";
if (File.Exists (caminho) == false) {
WWW load = new WWW ("jar:file//" + Application.dataPath + "!/assets/" + "alho.db");
while (!load.isDone) {
}
File.WriteAllBytes (caminho, load.bytes);
}
dispositivo.text = "Dispositivo: " + Application.platform.ToString();
caminhot.text = "Local: " + caminho;
}
conexao = new SqliteConnection ("URI=file:" + caminho);
conexao.Open ();
constatus.text = "Conexão: " + conexao.State.ToString ();
} catch{
constatus.text = "Falha ao abrir db";
}
}
public SqliteCommand comando;
public SqliteDataReader leitor;
public void LerDados(){
acao.text = "Ação: Ler database";
comando = conexao.CreateCommand ();
string sql = "SELECT valor FROM tabela";
comando.CommandText = sql;
leitor = comando.ExecuteReader ();
while (leitor.Read ()) {
int valorr = leitor.GetInt32 (0);
valor.text = "Valor: " + valorr.ToString ();
}
leitor.Close();
conexao.Close ();
comando.Dispose ();
}
public void fecharconexao(){
acao.text = "Ação: Desconectar database";
conexao.Close ();
constatus.text = "Conexão: " + conexao.State.ToString ();
}
