Android - Buscador Por Fechas

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout

    xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:app="http://schemas.android.com/apk/res-auto"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:orientation="vertical"

    android:background="#d1d1d1d1"

    tools:context="com.prueba.Buscador_Por_Fechas">

    <android.support.design.widget.AppBarLayout

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:theme="@style/AppTheme.AppBarOverlay"

        android:id="@+id/appBarLayout3">

        <android.support.v7.widget.Toolbar

            android:id="@+id/toolbar"

            android:layout_width="match_parent"

            android:layout_height="?attr/actionBarSize"

            android:background="?attr/colorPrimary"

            app:popupTheme="@style/AppTheme.PopupOverlay"

            />

    </android.support.design.widget.AppBarLayout>

    <GridView

        android:id="@+id/txtGrid"

        android:layout_width="fill_parent"

        android:layout_height="357dp"

        android:layout_gravity="center"

        android:animationCache="true"

        android:isScrollContainer="false"

        android:numColumns="1"

        android:paddingBottom="6dp"

        android:paddingLeft="6dp"

        android:paddingRight="6dp"

        android:paddingTop="6dp"

        android:stretchMode="columnWidth"

        android:textFilterEnabled="false"

        android:verticalSpacing="6dp"

        tools:layout_editor_absoluteX="8dp"

        tools:layout_editor_absoluteY="8dp"

        android:layout_alignParentLeft="true"

        android:layout_alignParentStart="true"

        android:layout_alignParentBottom="true"

        android:layout_below="@+id/txtFec"></GridView>

    <EditText

        android:id="@+id/txtFec"

        android:layout_width="match_parent"

        android:layout_height="40dp"

        android:layout_alignParentLeft="true"

        android:layout_alignParentStart="true"

        android:layout_below="@+id/appBarLayout3"

        android:hint="Ingrese Fecha de Búsqueda"

        android:onClick="mostrarCalendario"

        android:singleLine="true" />

</RelativeLayout>

import android.app.AlertDialog;

import android.app.DatePickerDialog;

import android.app.Dialog;

import android.app.DialogFragment;

import android.app.ProgressDialog;

import android.content.Context;

import android.os.AsyncTask;

import android.os.Bundle;

import android.support.v7.app.ActionBar;

import android.support.v7.app.AppCompatActivity;

import android.support.v7.widget.Toolbar;

import android.view.LayoutInflater;

import android.view.View;

import android.view.ViewGroup;

import android.widget.BaseAdapter;

import android.widget.DatePicker;

import android.widget.EditText;

import android.widget.GridView;

import android.widget.ImageView;

import android.widget.TextView;

import android.widget.Toast;

import com.squareup.picasso.Picasso;

import java.io.PrintWriter;

import java.io.StringWriter;

import java.io.Writer;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.text.DateFormat;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Calendar;

import java.util.Date;

import java.util.List;

import java.util.Locale;

public class Buscador_Por_Fechas extends AppCompatActivity {

    private int año;

    private int mes;

    private int dia;

    EditText txtFec;

    private static final int TIPO_DIALOGO =0;

    private static DatePickerDialog.OnDateSetListener sFecha;

    private ArrayList<E2_Lista> itemArrayList;

    private Buscador_Por_Fechas.MyAppAdapter myAppAdapter;

    private GridView txtGrid;

    private  boolean success= false;

    private static final String DB_URL = "jdbc:mysql:// ";

    private static final String USER = "";

    private static final String PASS = "";

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.buscador_por_fechas);

        txtGrid = (GridView) findViewById(R.id.txtGrid);

        txtFec = (EditText) findViewById(R.id.txtFec);

        Calendar calendario = Calendar.getInstance();

        año = calendario.get(Calendar.YEAR);

        mes = calendario.get(Calendar.MONTH);

        dia = calendario.get(Calendar.DAY_OF_MONTH);

        sFecha= new DatePickerDialog.OnDateSetListener(){

           @Override

            public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {

               año = year;

               mes = monthOfYear;

               dia = dayOfMonth;

               mostrarFecha();

           }

        };

        itemArrayList = new ArrayList<E2_Lista>();

        Buscador_Por_Fechas.SyncData orderData = new Buscador_Por_Fechas.SyncData();

        orderData.execute("");

        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);

        setSupportActionBar(toolbar);

        ActionBar actionBar = getSupportActionBar();

        actionBar.setDisplayHomeAsUpEnabled(true);

    }

   @Override

    protected Dialog onCreateDialog(int id){

        switch (id){

            case 0:

                return  new DatePickerDialog(this, sFecha, año, mes, dia);

        }

        return null;

    }

   public void mostrarCalendario(View control){

        showDialog(TIPO_DIALOGO);

    }

    public void mostrarFecha(){

        txtFec.setText(año+"-"+twoDigits(mes+1)+"-"+twoDigits(dia));

        Buscador_Por_Fechas.SyncData orderData = new Buscador_Por_Fechas.SyncData();

        orderData.execute("");

    }

    private String twoDigits(int n) {

        return (n<=9) ? ("0"+n) : String.valueOf(n);

    }

    private class SyncData extends AsyncTask<String, String, String>

    {

        String msg = "Internet/DB Credentials/Windows FireWall, Error!";

        ProgressDialog progress;

        @Override

        protected void onPreExecute()

        {

            progress = ProgressDialog.show(Buscador_Por_Fechas.this, "Cargando Resultados!","Por Favor Espere\n...", true);

        }

        @Override

        protected String doInBackground(String... strings)

        {

            try

            {

                Class.forName("com.mysql.jdbc.Driver");

                Connection conn = DriverManager.getConnection(DB_URL, USER, PASS); //Connection Object

                if (conn == null) {

                    success = false;

                }

                else{

                    final String txtFec=getIntent().getStringExtra("C.res_fec");

                    String query = " select hora, bus, imgurl, fecha from rutas where fecha = '"+txtFec+" ' ";

                    Statement stmt = conn.createStatement();

                    ResultSet rs = stmt.executeQuery(query);

                    if (rs != null)

                    {

                        while (rs.next())

                        {

                            try{

                                itemArrayList.add(

                                        new E2_Lista(

                                                rs.getString("hora"),

                                                rs.getString("bus"),

                                                rs.getString("imgurl"),

                                                rs.getString("fecha")));

                            }catch (Exception ex){

                                ex.printStackTrace();

                            }

                        }

                        msg = "";

                        success = true;

                    }else{

                        msg ="";

                        success = false;

                    }

                    rs.close();

                    stmt.close();

                    conn.close();

                }

                conn.close();

            }catch (Exception e)

            {

                e.printStackTrace();

                Writer writer = new StringWriter();

                e.printStackTrace(new PrintWriter(writer));

                msg = writer.toString();

                success = false;

            }

            return msg;

        }

        @Override

        protected void onPostExecute(String msg)

        {

            progress.dismiss();

            Toast.makeText(Buscador_Por_Fechas.this, msg + "", Toast.LENGTH_LONG).show();

            if(success == false)

            {

            }

            else{

                try{

                    myAppAdapter = new Buscador_Por_Fechas.MyAppAdapter(itemArrayList, Buscador_Por_Fechas.this);

                    txtGrid.setChoiceMode(GridView.CHOICE_MODE_MULTIPLE);

                    txtGrid.setAdapter(myAppAdapter);

                }catch (Exception ex)

                {

                }

            }

        }

    }

    public  class MyAppAdapter extends BaseAdapter

    {

        public class  ViewHolder

        {

            TextView txtHs_Salida;

            TextView txtRs_Bus;

            ImageView txtImg;

            TextView txtFecha;

        }

        public List<E2_Lista> rutList;

        public Context contex;

        ArrayList<E2_Lista> arrayList;

        private MyAppAdapter(List<E2_Lista> apps, Context context)

        {

            this. rutList = apps;

            this.contex = context;

            arrayList = new ArrayList<E2_Lista>();

            arrayList.addAll(rutList);

        }

        @Override

        public int getCount(){return rutList.size();}

        @Override

        public  Object getItem(int position){return animtradList.get(position);}

        @Override

        public long getItemId(int position){return 0;}

        @Override

        public View getView(final int position, View convertView, ViewGroup parent)

        {

            View rowView = convertView;

            Buscador_Por_Fechas.MyAppAdapter.ViewHolder viewHolder= null;

            if (rowView == null)

            {

                LayoutInflater inflater = getLayoutInflater();

                rowView = inflater.inflate(R.layout.items, parent, false);

                viewHolder = new Buscador_Por_Fechas.MyAppAdapter.ViewHolder();

                viewHolder.txtHs_Salida= (TextView) rowView.findViewById(R.id.txtHs_Salida);

                viewHolder.txtRs_Bus= (TextView) rowView.findViewById(R.id.txtRs_Bus);

                viewHolder.txtImg= (ImageView) rowView.findViewById(R.id.txtImg);

                viewHolder.txtFecha= (TextView) rowView.findViewById(R.id.txtFecha);

                rowView.setTag(viewHolder);

            }

            else

            {

                viewHolder = (Buscador_Por_Fechas.MyAppAdapter.ViewHolder) convertView.getTag();

            }

            viewHolder.txtHs_Salida.setText(animtradList.get(position).getHs_Salida());

            viewHolder.txtRs_Bus.setText(animtradList.get(position).getRs_Bus());

            Picasso.with(contex).load("http://"+ rutList.get(position).getImgUrl()).into(viewHolder.txtImg);

            Picasso.with(contex).load("http://"+ rutList.get(position).getImgUrl()).error(R.drawable.error).into(viewHolder.txtImg);

            viewHolder.txtFecha.setText(rutList.get(position).getFecha());

            return rowView;

        }

    }

}

Clase E2_Lista

public class E2_Lista {

    public String txtHs_Salida;

    public String txtRs_Bus;

    public String txtImg;

    public String txtFecha;

    public E2_Lista() {

    }

    public E2_Lista(

            String Hs_Salida,

            String Rs_Bus,

            String ImgUrl,

            String Fecha

    ) {

        this.txtHs_Salida = Hs_Salida;

        this.txtRs_Bus = Rs_Bus;

        this.txtImg = ImgUrl;

        this.txtFecha = Fecha;

    }

    public String getHs_Salida () {return txtHs_Salida;}

    public String getRs_Bus() {return txtRs_Bus;}

    public String getImgUrl() {return txtImg;}

    public String getFecha() {return txtFecha;}

}

String query = " select hora, bus, imgurl, fecha from rutas where fecha = '"+txtFec.gettext()+" ' ";

String query = " select hora, bus, imgurl, fecha from rutas where date(fecha) = '"+txtFec.gettext()+" ' ";