public class MainActivity extends Activity {

                AutoCompleteTextView txtSearch;
                PeopleAdapter adapter;
                List<People> mList;
                TextView idd;
                ImageView imgspn;

                @Override
                protected void onCreate(Bundle savedInstanceState) {
                    super.onCreate(savedInstanceState);
                    setContentView(R.layout.activity_main);

                    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
                    StrictMode.setThreadPolicy(policy);

                    mList = retrievePeople();

                    txtSearch = (AutoCompleteTextView) findViewById(R.id.txt_search);
                    txtSearch.setThreshold(1);
                    adapter = new PeopleAdapter(this, R.layout.activity_main, R.id.lbl_name, mList);
                    txtSearch.setAdapter(adapter);

                    idd = (TextView) findViewById(R.id.idd);
                    imgspn = (ImageView) findViewById(R.id.imgspn);
                    imgspn.setVisibility(View.INVISIBLE);

                    txtSearch.setOnItemClickListener(new OnItemClickListener() {
                        @Override
                        public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
                            String Name = mList.get(position).getId();
                            idd.setText(Name);
                            // Toast.makeText(MainActivity.this,Name
                            // ,Toast.LENGTH_LONG).show();
                        }
                    });

                }

                private List<People> retrievePeople() {
                    List<People> list = new ArrayList<People>();
                    try {
                        Class.forName("com.mysql.jdbc.Driver");
                        Connection con = (Connection) DriverManager.getConnection("jdbc:mysql://182.160.119.77:3306/hrms", "root",
                                "W1nd0wsL1ve");
                        Statement st = (Statement) con.createStatement();
                        ResultSet rs = (ResultSet) st.executeQuery(
                                "select name,designation_name,id from umdlv_users ut,t_designation td where ut.designation_id = td.designation_id");
                        while (rs.next()) {

                            list.add(new People(rs.getString(1), rs.getString(2), rs.getString(3)));
                        }
                        rs.close();
                        st.close();
                        con.close();
                    } catch (Exception e) {
                    }
                    return list;
                }
            }
</pre>