how to put database and read database from assets folder android which are created and exported in sqllite
public class DataBaseHelper extends SQLiteOpenHelper {
private SQLiteDatabase myDataBase;
private final Context myContext;
private static final String DATABASE_NAME = "YOURDBNAME";
public final static String DATABASE_PATH = "/data/data/com.your.packagename/databases/";
public static final int DATABASE_VERSION = 1;
public DataBaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
this.myContext = context;
}
//Create a empty database on the system
public void createDatabase() throws IOException
{
boolean dbExist = checkDataBase();
if(dbExist)
{
Log.v("DB Exists", "db exists");
// By calling this method here onUpgrade will be called on a
// writeable database, but only if the version number has been
// bumped
//onUpgrade(myDataBase, DATABASE_VERSION_old, DATABASE_VERSION);
}
boolean dbExist1 = checkDataBase();
if(!dbExist1)
{
this.getReadableDatabase();
try
{
this.close();
copyDataBase();
}
catch (IOException e)
{
throw new Error("Error copying database");
}
}
}
//Check database already exist or not
private boolean checkDataBase()
{
boolean checkDB = false;
try
{
String myPath = DATABASE_PATH + DATABASE_NAME;
File dbfile = new File(myPath);
checkDB = dbfile.exists();
}
catch(SQLiteException e)
{
}
return checkDB;
}
//Copies your database from your local assets-folder to the just created empty database in the system folder
private void copyDataBase() throws IOException
{
InputStream mInput = myContext.getAssets().open(DATABASE_NAME);
String outFileName = DATABASE_PATH + DATABASE_NAME;
OutputStream mOutput = new FileOutputStream(outFileName);
byte[] mBuffer = new byte[2024];
int mLength;
while ((mLength = mInput.read(mBuffer)) > 0) {
mOutput.write(mBuffer, 0, mLength);
}
mOutput.flush();
mOutput.close();
mInput.close();
}
//delete database
public void db_delete()
{
File file = new File(DATABASE_PATH + DATABASE_NAME);
if(file.exists())
{
file.delete();
System.out.println("delete database file.");
}
}
//Open database
public void openDatabase() throws SQLException
{
String myPath = DATABASE_PATH + DATABASE_NAME;
myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READWRITE);
}
public synchronized void closeDataBase()throws SQLException
{
if(myDataBase != null)
myDataBase.close();
super.close();
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
if (newVersion > oldVersion)
{
Log.v("Database Upgrade", "Database version higher than old.");
db_delete();
}
}
}
And to implement it
DataBaseHelper dbhelper = new DataBaseHelper(getApplicationContext());
db = dbhelper.getWritableDatabase();
For that:
Cursor cur;
cur_Herbs = db.rawQuery("select * from TABLENAME where name like '"
+ edit_text_name.gettext.tostring() + "'", null);
if (cur.moveToFirst()) {
do {
int name = cur.getColumnIndex("name");
int pwd= cur.getColumnIndex("pwd");
str_name = cur.getString(name).toString();
str_pwd= cur.getString(ped).toString();
if(str_name.equals(edittext_uname.gettext.tostring()and str_pwd.equals(edittext_pwd.gettext.tostring()))
{
//code for if loginn
}
} while (cur_Herbs.moveToNext());
}
Copying SQLite database from assets folder issue
The solution to my problem is this:
Since Android Studio uses the new Gradle-based build system, you should be putting assets/ inside of the source sets example myproject/src/main/assets/.
I created my own assets folder and put it where Eclipse usually puts it... which caused all these problems for me.
Related Topics
How to Execute Async Task Repeatedly After Fixed Time Intervals
How Does One Use Glide to Download an Image into a Bitmap
How to Capture the Android Device Screen Content
How to Open a Second Activity on Click of Button in Android App
How to Set Layout_Weight Attribute Dynamically from Code
Android: Taking Complete Control of Phone(Kiosk Mode), Is It Possible? How
Calling Activity Class Method from Service Class
Android Canvas: Drawing Too Large Bitmap
Android Inject_Events Permission
Finish All Activities at a Time
How to Start Service Using Alarm Manager in Android
Android How to Work with Asynctasks Progressdialog
Spinner: Get State or Get Notified When Opens
Published App on Play Store Can't Communicate with Google Maps API and Facebook API