Advertisement
Guest User

create database

a guest
Jan 4th, 2013
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. public class Home extends Activity {
  2.  
  3. SQLiteDatabase mydatabase=null;
  4. public void onCreate(Bundle savedInstanceState) {
  5. super.onCreate(savedInstanceState);
  6. setContentView(R.layout.main);
  7.  
  8. try
  9. {
  10. mydatabase=Home.this.openOrCreateDatabase(DatabaseAndTableNames.DATABASE_NAME, MODE_PRIVATE, null);
  11. mydatabase.execSQL("CREATE TABLE IF NOT EXISTS "
  12. + your table name
  13. + " ( _id INTEGER PRIMARY KEY AUTOINCREMENT,title VARCHAR UNIQUE, colum1 VARCHAR, colum2 INT(10), colum3 VARCHAR, colum4 VARCHAR)");
  14. }catch(Exception ex){
  15. Log.e("ERROR","ERROR" ,ex);
  16. }
  17. finally
  18. {
  19. if(mydatabase!=null)
  20. mydatabase.close();
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement