- Home /
how to make the build in android which can access the local database sqlite
how to make the build in android..now i cant acess the db from android build
As per the tutorial about set highscore data base in unity – https://www.youtube.com/watch?v=wV-dKxJU-0Y&list=PLX-uZVK_0K_7NmsYfe2BTOk_IamWC2kU3∈dex=4
In my unity the project works and i am able to get the database ,but when i create it on the windows and android i am not able to get the data base
my code –
connectionString = “URI=file:” + Application.dataPath + “/Oore_Nov16.sqlite”;
void start()
{
ClearDb ();
CreateDb ();
WriteToDb (“abc”,”a”,”1″,”10″);
GetFromDb ();
}
private void CreateDb()
{
using (IDbConnection dbConnection = new SqliteConnection (connectionString))
{
dbConnection.Open ();
using (IDbCommand dbCmd = dbConnection.CreateCommand ())
{ string sqlQuery = String.Format(“CREATE TABLE IF NOT EXISTS QrCodeList (code VARCHAR NOT NULL , class VARCHAR NOT NULL , id INTEGER PRIMARY KEY NOT NULL , status INTEGER NOT NULL )”); dbCmd.CommandText = sqlQuery; dbCmd.ExecuteScalar (); dbConnection.Close (); } } } private void GetFromDb() { using (IDbConnection dbConnection = new SqliteConnection (connectionString)) { dbConnection.Open (); using (IDbCommand dbCmd = dbConnection.CreateCommand ())
{
string sqlQuery = “select * from QrCodeList”;
dbCmd.CommandText = sqlQuery;
using (IDataReader reader = dbCmd.ExecuteReader ())
{
while (reader.Read ())
{
print (reader.GetString(0));
testr.text = reader.GetString (0);
}
dbConnection.Close ();
reader.Close ();
}
}
}
}
private void ClearDb()
{
using (IDbConnection dbConnection = new SqliteConnection (connectionString))
{
dbConnection.Open ();
using (IDbCommand dbCmd = dbConnection.CreateCommand ())
{
string sqlQueryForClear = “DELETE FROM QrCodeList”;
dbCmd.CommandText = sqlQueryForClear;
dbCmd.ExecuteScalar ();
dbConnection.Close ();
}
}
}
private void WriteToDb(string code, string classs,string id,string status)
{
using (IDbConnection dbConnection = new SqliteConnection (connectionString))
{
dbConnection.Open ();
using (IDbCommand dbCmd = dbConnection.CreateCommand ())
{
string sqlQuery =
String.Format(“insert into QrCodeList(code,class,id,status) values(\”{0}\”,\”{1}\”,\”{2}\”,\”{3}\”)”,code,classs,id,status);
dbCmd.CommandText = sqlQuery;
dbCmd.ExecuteScalar ();
dbConnection.Close ();
}
}
}