retrieve data from databse in edit text box in android and want to display simple dropdown items in one line
// All Static variables
    // Database Version
    private static final int DATABASE_VERSION = 2;

    // Database Name
    private static final String DATABASE_NAME = "android_ap.db";

    // Login table name
    private static final String TABLE_LOGIN = "login";
    // Login Table Columns names
    private static final String KEY_ID = "_id";
    private static final String KEY_NAME = "name";
    private static final String KEY_PASSWORD = "password";
    private static final String TABLE_PARTY="party_master";
    private static final String KEY_PID="party_id";
    private static final String KEY_PNAME="party_name";
    private static final String KEY_ROUTE_NAME="route_name";
    private static final String KEY_ROUTE_NUM="RootNo";

    private static final String KEY_CONTACT_PERSON="contect_person";
    private static final String KEY_CELL_NUM="cell_no";


    private static final String CREATE_LOGIN_TABLE = "CREATE TABLE " + TABLE_LOGIN + "("
            + KEY_ID + " INTEGER PRIMARY KEY,"
            + KEY_NAME + " TEXT NOT NULL,"
            + KEY_PASSWORD + " TEXT NOT NULL);";
    private static final String CREATE_PARTY_TABLE = "CREATE TABLE " + TABLE_PARTY + "("
            + KEY_PID + " INTEGER PRIMARY KEY,"
            + KEY_PNAME + " TEXT NOT NULL,"
            + KEY_ROUTE_NAME + " TEXT NOT NULL);";


    public LoginDB(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }


    // Creating Tables
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_LOGIN_TABLE);
        db.execSQL(CREATE_PARTY_TABLE);
        }


    // Upgrading database
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // Drop older table if existed
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_LOGIN);
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_PARTY);

        // Create tables again
        onCreate(db);
    }


    /**
     * Storing user details in database
     * */
    public void addUser(String name, String password) {
        SQLiteDatabase db = this.getWritableDatabase();

        ContentValues values = new ContentValues();
        values.put(KEY_NAME, name); // Name
        values.put(KEY_PASSWORD, password); // password

        // Inserting Row
        db.insert(TABLE_LOGIN, null, values);
        db.close(); // Closing database connection
    }

    public void add_party_master(String party_name, String route_name) {
        SQLiteDatabase db = this.getWritableDatabase();

        ContentValues values = new ContentValues();
        values.put(KEY_PNAME, party_name); // Party Name
        values.put(KEY_ROUTE_NAME, route_name); // Route Name

        // Inserting Row
        db.insert(TABLE_PARTY, null, values);
        db.close(); // Closing database connection
    }


    /**
     * Getting user data from database
     * */
    public HashMap<String, String> getUserDetails(String party_name,String route_name,String RootNo, String contect_person,String cell_no){
        HashMap<String,String> user = new HashMap<String,String>();
        String selectQuery = "SELECT  * FROM " + TABLE_PARTY;

        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);
        // Move to first row
        cursor.moveToFirst();
        if(cursor.getCount() > 0){
            user.put("party_name", cursor.getString(1));
            user.put("route_name", cursor.getString(2));
            user.put("RootNo", cursor.getString(3));
            user.put("contect_person", cursor.getString(4));
            user.put("cell_no", cursor.getString(5));
        }
        cursor.close();
        db.close();
        // return user
        return user;
    }

    public ArrayList<String>  getUserRecords(String route_name){
        //HashMap<String,String> userNew = new HashMap<String,String>();
        ArrayList<String> a=new ArrayList<String>();
        String selectQuery = "SELECT  * FROM " + TABLE_PARTY;

        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(selectQuery, null);
        // Move to first row
        cursor.moveToFirst();
        if(cursor.getCount() > 0){
            //userNew.put("party_name", cursor.getString(1));
        //  userNew.put("route_name", cursor.getString(2));
        //  userNew.put("RootNo", cursor.getString(3));
       //   userNew.put("contect_person", cursor.getString(4));
        //  userNew.put("cell_no", cursor.getString(5));

        a.add(cursor.getString(1));
        }
        cursor.close();
        db.close();
        // return user
        return a;
    }


    /**
     * Getting user login status
     * return true if rows are there in table
     * */
    public int getRowCount() {
        String countQuery = "SELECT  * FROM " + TABLE_LOGIN ;
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(countQuery, null);
        int rowCount = cursor.getCount();
        db.close();
        cursor.close();

        // return row count
        return rowCount;
    }
    public int getRowCount_party() {
        String countQuery = "SELECT  * FROM " + TABLE_PARTY ;
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor curs = db.rawQuery(countQuery, null);
        int rowCount_p = curs.getCount();
        db.close();
        curs.close();

        // return row count
        return rowCount_p;
    }


    /**
     * Re crate database
     * Delete all tables and create them again
     * @param pas1
     * @param username1
     * */

        public int getAllname(String username1, String password1)
      {
       SQLiteDatabase db=this.getReadableDatabase();
       Cursor cur=db.rawQuery("SELECT KEY_NAME from "+TABLE_LOGIN +"WHERE KEY_NAME = '" +username1+"' and KEY_PASSWORD = '"+password1+"'",null);
       int rowCount = cur.getCount();
        db.close();
        cur.close();
        return rowCount;
      }
        public String getroot() throws SQLException
          {
           SQLiteDatabase db=this.getReadableDatabase();
           Cursor cur=db.rawQuery("SELECT * from "+ TABLE_PARTY + "WHERE route_name=?",null);
           cur.getString(cur.getColumnIndex("route_name"));
           db.close();
           cur.close();
        return getroot();
          }


      public boolean Login(String username, String password) throws SQLException
        {
          SQLiteDatabase db=this.getReadableDatabase();
           Cursor mCursor = db.rawQuery("SELECT * FROM " + TABLE_LOGIN + " WHERE name=? AND password=?", new String[]{username,password});
            if (mCursor != null) {
                if(mCursor.getCount() > 0)
                {
                    return true;
                }
            }
         return false;
        }

      public int rootnm(String[] route_name) throws SQLException
        {
          SQLiteDatabase db=this.getReadableDatabase();
           Cursor mnCursor = db.rawQuery("SELECT * FROM " + TABLE_PARTY + " WHERE route_name=? ", new String[] {});
            if (mnCursor != null) {
                if(mnCursor.getCount() > 0)
                {
                    db.getSyncedTables();
                }
            }
            return 0;

        }

      public Cursor queueAll(){
          String[] columns = new String[]{KEY_PID, KEY_ROUTE_NAME};
          SQLiteDatabase db = null;
        Cursor cursor123 = db.query(TABLE_PARTY, columns,
            null, null, null, null, null);

          return cursor123;
          }

      public Cursor retrieveRecords()
      {
        Cursor c = null;
        SQLiteDatabase db = null;
        c = db.rawQuery("select DISTICT route_name from party_master", null);
       return c;
      }

      private Cursor query(String selection, String[] selectionArgs, String[] columns) {
            /* The SQLiteBuilder provides a map for all possible columns requested to
             * actual columns in the database, creating a simple column alias mechanism
             * by which the ContentProvider does not need to know the real column names
             */
            SQLiteQueryBuilder builder = new SQLiteQueryBuilder();
            builder.setTables(TABLE_PARTY);

            SQLiteOpenHelper db = null;
            Cursor cursor = builder.query(db.getReadableDatabase(),
                    columns, selection, selectionArgs, null, null, null);

            if (cursor == null) {
                return null;
            } else if (!cursor.moveToFirst()) {
                cursor.close();
                return null;
            }
            return cursor;
        }

      public Cursor getWord(String route_name1, String[] columns) {
            String selection = "route_name = ?";
            String[] selectionArgs = new String[] {route_name1};

            return query(selection, selectionArgs, columns);

            /* This builds a query that looks like:
             *     SELECT <columns> FROM <table> WHERE rowid = <rowId>
             */
        }

      String[] rt = new String[]{KEY_ROUTE_NAME};



    public void resetTables(){
        SQLiteDatabase db = this.getWritableDatabase();
        // Delete All Rows
        db.delete(TABLE_LOGIN, null, null);
        db.delete(TABLE_PARTY, null, null);
        db.close();
    }

}

private EditText etroute;
private EditText etshop;
private Button btnAddItem;
private Button btnOkRoute;
private Button btnOkShop;
public SQLiteDatabase db;


/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.additem);

    LoginDB lg =new LoginDB(AddItemActivity.this);

  // String[] route_name = lg.retrieveRecords();

String[] route = lg.rt ;

    ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,
            android.R.layout.simple_dropdown_item_1line, route);
         AutoCompleteTextView textView = (AutoCompleteTextView)
            findViewById(R.id.route);

         textView.setThreshold(0);
         textView.setAdapter(adapter);

 // Get the EditText and Button References
     etroute = (EditText)findViewById(R.id.route);
     etshop = (EditText)findViewById(R.id.shop);

     db =openOrCreateDatabase("DATABASE_NAME", MODE_PRIVATE, null);
     db.execSQL("CREATE TABLE IF NOT EXISTS TABLE_PARTY (KEY_ROUTE_NAME TEXT);");
     Cursor c1=db.rawQuery("SELECT * FROM TABLE_PARTY", null);
     if (c1.moveToNext())
       etroute.setText(c1.getString(0));


     etshop = (EditText)findViewById(R.id.shop);
     btnAddItem = (Button)findViewById(R.id.add_item);
     btnOkRoute = (Button)findViewById(R.id.btn_ok_route);
     btnOkShop = (Button)findViewById(R.id.btn_ok_shop);


     btnOkRoute.setOnClickListener(new OnClickListener() {
         @Override
         public void onClick(View v) {
             String route_name = etroute.getText().toString();

         }
     });

     btnOkShop.setOnClickListener(new OnClickListener() {
         @Override
         public void onClick(View v) {
             String party_name = etshop.getText().toString();

         }
     });

     btnAddItem.setOnClickListener(new OnClickListener() {
         @Override
         public void onClick(View v) {
             String route_name = etroute.getText().toString();
             String party_name = etshop.getText().toString();

             {
                     Toast.makeText(AddItemActivity.this, "Record Successfully Inserted", 2000).show();
                    }
              db.close();
         }
     });


}