LeJJXj6w

1package com.example.vaishalihtalati.dictionaryapplication1;
2
3import android.database.Cursor;
4import android.database.sqlite.SQLiteDatabase;
5import android.support.v7.app.AppCompatActivity;
6import android.os.Bundle;
7import android.widget.ArrayAdapter;
8import android.widget.AutoCompleteTextView;
9import android.widget.ListView;
10import android.widget.Toast;
11
12import java.util.ArrayList;
13
14public class MainActivity extends AppCompatActivity {
15
16    SQLiteDatabase db;
17    AutoCompleteTextView et1;
18    ListView lv1;
19    @Override
20    protected void onCreate(Bundle savedInstanceState) {
21        super.onCreate(savedInstanceState);
22        setContentView(R.layout.activity_main);
23
24      et1 = (AutoCompleteTextView)findViewById(R.id.et);
25      lv1 = (ListView)findViewById(R.id.lv);
26
27
28
29        //creating a database
30        db = openOrCreateDatabase("demo",MODE_PRIVATE,null);
31
32        db.execSQL("drop table if exists word_list");
33        String sql1 = "create table if not exists word_list(word varchar(30),meaning varchar(100))";
34        db.execSQL(sql1);
35
36
37        // to check wether any data is already present or not
38        String sql2 = "select * from word_list";
39        Cursor cur = db.rawQuery(sql2,null);
40
41        if(!(cur.getCount()>0))
42        {
43            ArrayList al1 = new ArrayList();
44            al1.add("Apple");
45            al1.add("Ant");
46            al1.add("Ball");
47            al1.add("Bat");
48            al1.add("Cat");
49
50            ArrayList al2 = new ArrayList();
51            al2.add("Apple meaning");
52            al2.add("Ant meaning");
53            al2.add("Ball meaning");
54            al2.add("Bat meaning");
55            al2.add("Cat meaning");
56
57            //insert the data into the database table
58            for(int i=0;i<al1.size();i++)
59            {
60                db.execSQL("insert into word_list values('"+al1.get(i)+"','"+al2.get(i)+"')");
61            }
62
63           /* db.execSQL("insert into word_list values('"+al1.get(0)+"','"+al2.get(0)+"')");
64            db.execSQL("insert into word_list values('"+al1.get(1)+"','"+al2.get(1)+"')");
65            db.execSQL("insert into word_list values('"+al1.get(2)+"','"+al2.get(2)+"')");
66            db.execSQL("insert into word_list values('"+al1.get(3)+"','"+al2.get(3)+"')");
67            db.execSQL("insert into word_list values('"+al1.get(4)+"','"+al2.get(4)+"')");*/
68
69            Toast.makeText(this,"Insert",Toast.LENGTH_LONG).show();
70        }
71        ArrayList wordList = new ArrayList();
72        String sql3 = "select * from word_list";
73        Cursor cur1 = db.rawQuery(sql3,null);
74        while(cur1.moveToNext())
75        {
76            wordList.add(cur1.getString(0));
77
78        }
79        cur1.close();
80
81        ArrayAdapter aa = new ArrayAdapter(this,android.R.layout.simple_list_item_1,wordList);
82        //for listview
83        lv1.setAdapter(aa);
84        et1.setThreshold(1);//if we write one letter then it will show suggestions
85
86        //for auto complete text view
87        //even if we write something wrong in text view but in background the arraylist content will be there.so we need to write aaray adapter twice.
88        ArrayAdapter aa1 = new ArrayAdapter(this,android.R.layout.simple_list_item_1,wordList);
89        et1.setAdapter(aa1);
90
91
92
93
94    }
95}