5wMGnuKA

1Inserting into Databse through Edittext Field in android
2import java.util.ArrayList;
3import android.app.Activity;
4import android.os.Bundle;
5import android.view.View;
6import android.view.View.OnClickListener;
7import android.widget.Button;
8import android.widget.EditText;
9import android.widget.TableLayout;
10import android.widget.TableRow;
11import android.widget.TextView;
12import android.widget.RemoteViews.ActionException;
13import android.widget.Toast;
14import android.content.ContentValues;
15import android.content.Intent;
16import android.database.sqlite.SQLiteDatabase;
17
18public class InterviewActivity extends Activity {
19    @Override
20    public void onCreate(Bundle savedInstanceState) {
21
22        super.onCreate(savedInstanceState);
23        setContentView(R.layout.welcomeactivity);
24            }
25
26    public void onQuestionClicked(View view) {
27        EditText Q = (EditText)findViewById(R.id.Questiont);
28        EditText A = (EditText)findViewById(R.id.Answert);    
29
30        Q.setVisibility(View.VISIBLE);
31        A.setVisibility(View.INVISIBLE);
32
33        Toast.makeText(this, "Enter your Question here", Toast.LENGTH_LONG).show();
34        }
35    public void onAnswerClicked(View view) {
36        EditText Q = (EditText)findViewById(R.id.Questiont);
37        EditText A = (EditText)findViewById(R.id.Answert);    
38
39        A.setVisibility(View.VISIBLE);
40        Q.setVisibility(View.INVISIBLE);
41
42        Toast.makeText(this, "Enter your Answer here", Toast.LENGTH_LONG).show();
43        }
44
45    public void onSave(View view) {
46        EditText Q = (EditText)findViewById(R.id.Questiont);
47        EditText A = (EditText)findViewById(R.id.Answert);    
48
49        String q = Q.getText().toString();
50        String a = A.getText().toString();
51
52        Toast.makeText(this,"Question :"+" " + q + "n" +
53                "Answer :"+" " + a, Toast.LENGTH_LONG).show();
54
55            }
56
57
58    public void onCancel(View view) {
59        finish();
60    }
61}
62	
63package com.ques.ans;
64
65import android.content.ContentValues;
66import android.content.Context;
67import android.database.sqlite.SQLiteDatabase;
68import android.database.sqlite.SQLiteDatabase.CursorFactory;
69import android.database.sqlite.SQLiteOpenHelper;
70
71public class trying extends SQLiteOpenHelper{
72
73    public static final String DB_NAME = "save.db";
74    public static final int DB_VERSION=2;
75    public static final String TABLE="qnadb";
76    public static final String SNO = "Sno";
77    public static final String QUESTION = "Question";
78    public static final String ANSWER = "Answer";   
79
80    public trying(Context context) {
81        super(context,DB_NAME, null, DB_VERSION);
82        // TODO Auto-generated constructor stub
83    }
84
85    @Override
86    public void onCreate(SQLiteDatabase db) {
87        String sql = "create table TABLE (SNO integer autoincrement primary key not null, QUESTION text , ANSWER text);";
88        // TODO Auto-generated method stub
89        db.execSQL(sql);
90    }
91
92    @Override
93    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
94        db.execSQL("DROP TABLE IF EXISTS " + TABLE);
95        onCreate(db);
96        }
97
98    public void onsaving(String q,String a) {
99        SQLiteDatabase db=this.getWritableDatabase();
100
101         ContentValues cv=new ContentValues();
102           cv.put(SNO, 1);
103           cv.put(QUESTION, q);
104           cv.put(ANSWER, a);
105           db.insert(TABLE,null, cv);
106
107
108                             db.close();
109    }
110}
111	
112ContentValues cv = new ContentValues();
113   cv.put(QUESTION, q);
114   cv.put(ANSWER, a);
115   db.insert(TABLE, null, cv);
116	
117String sql = "create table TABLE (SNO integer autoincrement primary key not null, QUESTION text , ANSWER text);";
118	
119public static final String TABLE = "qnadb";
120	
121String sql = "create table qnadb (SNO integer autoincrement primary key not null, QUESTION text , ANSWER text);