bWcLsLVS

1package data.bas;
2
3
4import android.app.Activity;
5import android.database.sqlite.SQLiteDatabase;
6import android.os.Bundle;
7import android.widget.TextView;
8import android.database.Cursor;
9
10public class data extends Activity {
11	
12    private String MY_DATABASE_NAME = "QueDB";
13    private String MY_DATABASE_TABLE = "Q_es";
14    
15    /** Called when the activity is first created. */
16    @Override
17    public void onCreate(Bundle savedInstanceState) {
18        super.onCreate(savedInstanceState);
19        setContentView(R.layout.main);
20        
21        
22        SQLiteDatabase myDB = null;
23		try {
24
25			this.openOrCreateDatabase(MY_DATABASE_NAME, MODE_PRIVATE, null);
26			
27			/* Create a Table in the Database. */ 
28			myDB.execSQL("CREATE TABLE IF NOT EXISTS "
29							+ MY_DATABASE_TABLE
30							+ " (question VARCHAR;)");
31
32			/* Add two DataSets to the Table. */
33			myDB.execSQL("INSERT INTO "
34							+ MY_DATABASE_TABLE
35							+ " (question)"
36							+ " VALUES ('Test');");
37			
38			
39			Cursor cur;
40			cur = myDB.rawQuery("select * from Q_es;", null);
41			String cepe = cur.toString();
42			
43			final TextView TexTen =  (TextView) findViewById(R.id.Textfelt);
44			TexTen.append(cepe);
45		} 
46		
47		
48		finally {
49			if (myDB != null)
50				myDB.close();
51		}
52
53
54    }
55}