۱۳۹۳/۱۱/۲۷, ۰۹:۲۸ ق.ظ
کد پیاچپی:
public class Main extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
String DATABASE_NAME = "db.db";
String TABLE_NAME = "dbtb";
try{
SQLiteDatabase db = openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE,null);
db.execSQL("CREATE TABLE IF NOT EXISTS "+ TABLE_NAME +" (id INTEGER PRIMARY KEY NOT NULL, name TEXT, email TEXT);");
db.close();
}catch(Exception e){
Toast.makeText(getApplicationContext(), "Error in creating table" , Toast.LENGTH_LONG).show();
}
try {
String destPath = "/data/data/" + getPackageName() +
"/databases";
File f = new File(destPath);
if (!f.exists()) {
f.mkdirs();
f.createNewFile();
//---copy the db from the assets folder into
// the databases folder---
CopyDB(getBaseContext().getAssets().open("mydb"),
new FileOutputStream(destPath + "/MyDB"));
}
} catch (FileNotFoundException e) {
Toast.makeText(getApplicationContext(), "FileNotFoundException" , Toast.LENGTH_LONG).show();
} catch (IOException e) {
Toast.makeText(getApplicationContext(), "FileNotFoundException" , Toast.LENGTH_LONG).show();
}
try{
SQLiteDatabase db = openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE,null);
Cursor allrows = db.rawQuery("SELECT * FROM "+ TABLE_NAME, null);
if(allrows.moveToFirst()==false){ Toast.makeText(getApplicationContext(),"?", Toast.LENGTH_LONG).show();}
if(allrows.moveToFirst()){
do{
String ID = allrows.getString(0);
String NAME = allrows.getString(1);
String CITY = allrows.getString(2);
// Show values with Toast
Toast.makeText(getApplicationContext(), ID, Toast.LENGTH_LONG).show();
Toast.makeText(getApplicationContext(), NAME, Toast.LENGTH_LONG).show();
Toast.makeText(getApplicationContext(), CITY, Toast.LENGTH_LONG).show();
}
while(allrows.moveToNext());
}
db.close();
}catch(Exception e){
Toast.makeText(getApplicationContext(), "Error", Toast.LENGTH_LONG).show();
}
}//oncreate
public void CopyDB(InputStream inputStream,
OutputStream outputStream) throws IOException {
//---copy 1K bytes at a time---
byte[] buffer = new byte[1024];
int length;
while ((length = inputStream.read(buffer)) > 0) {
outputStream.write(buffer, 0, length);
}
inputStream.close();
outputStream.close();
}
}
وقتی اجرا میکنم دیتابس خونده نمی شه
لطفا راهنمایییم کنید مشکل از کجاست؟