package simpleTest.database;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.Toast;

public class DBtest extends Activity {
    
    private static final String DATABASE_NAME = "myDatabase.db";
    private static final String DATABASE_TABLE = "mainTable";
    private static final String DATABASE_CREATE = "create table " + DATABASE_TABLE + " ( _id integer primary key autoincrement," +
    "column_one text not null);";
    
    SQLiteDatabase myDatabase;
    
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        
            

        myDatabase = openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null);
        try {
            myDatabase.execSQL(DATABASE_CREATE);
            } catch (SQLException ex){
                Toast.makeText(getBaseContext(), "error...", 
                        Toast.LENGTH_SHORT).show();
            }
    }
}