4ZjVRGjA

1package data.bas;
2
3import java.io.FileNotFoundException;
4import java.util.ArrayList;
5
6import android.app.Activity;
7import android.database.sqlite.SQLiteDatabase;
8import android.os.Bundle;
9import android.database.Cursor;
10
11public class data extends Activity {
12	
13    private String MY_DATABASE_NAME = "QueDB";
14    private String MY_DATABASE_TABLE = "Q_es";
15    
16    /** Called when the activity is first created. */
17    @Override
18    public void onCreate(Bundle savedInstanceState) {
19        super.onCreate(savedInstanceState);
20        setContentView(R.layout.main);
21        
22        
23        
24        ArrayList<String> results = new ArrayList<String>();
25        
26        SQLiteDatabase myDB = null;
27		try {
28			
29			this.createDatabase(MY_DATABASE_NAME, 1, MODE_PRIVATE, null);
30			/* Open the DB and remember it */
31			myDB = this.openDatabase(MY_DATABASE_NAME, null);
32
33			/* Create a Table in the Database. */ 
34			myDB.execSQL("CREATE TABLE IF NOT EXISTS "
35							+ MY_DATABASE_TABLE
36							+ " (question VARCHAR;");
37
38			/* Add two DataSets to the Table. */
39			myDB.execSQL("INSERT INTO "
40							+ MY_DATABASE_TABLE
41							+ " (question)"
42							+ " VALUES ('Test');");
43
44			
45		} catch (FileNotFoundException e) {
46		} finally {
47			if (myDB != null)
48				myDB.close();
49		}
50
51
52    }
53}