Main Activity

<?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>

Items

<?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:orientation="vertical"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:gravity="center"
android:background="@color/colorTexto"
android:paddingBottom="4dp"
android:paddingLeft="4dp"
android:paddingRight="4dp"
android:paddingTop="4dp"
android:weightSum="1">

<TextView
android:id="@+id/txtHs_Salida"
android:layout_width="fill_parent"
android:layout_height="30dp"
android:background="@android:color/holo_green_light"
android:gravity="center"
android:text="Sorteo 00:00 XX"
android:textAppearance="@style/TextAppearance.AppCompat"
android:textColor="@color/colorTexto"
android:textSize="22dp"
android:textStyle="bold"
tools:ignore="HardcodedText,SpUsage"
android:layout_below="@+id/txtFecha"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true" />

<TextView
android:id="@+id/txtRs_Bus"
android:layout_width="fill_parent"
android:layout_height="100dp"
android:gravity="center"
android:text="Resultado"
android:textAppearance="@style/TextAppearance.AppCompat"
android:textSize="22dp"
tools:ignore="HardcodedText,SpUsage"
android:layout_alignTop="@+id/txtImg"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:layout_toLeftOf="@+id/txtImg"
android:layout_toStartOf="@+id/txtImg" />

<ImageView
android:id="@+id/txtImg"
android:layout_width="100dp"
android:layout_height="100dp"
app:srcCompat="@drawable/icon"
tools:ignore="ContentDescription,RtlHardcoded"
android:layout_marginTop="13dp"
android:layout_below="@+id/txtHs_Salida"
android:layout_alignParentRight="true"
android:layout_alignParentEnd="true"
android:layout_marginRight="15dp"
android:layout_marginEnd="15dp" />

<TextView
android:id="@+id/txtFecha"
android:layout_width="fill_parent"
android:layout_height="30dp"
android:gravity="center"
android:text="00/00/0000"
android:textAppearance="@style/TextAppearance.AppCompat"
android:textSize="16dp"
android:layout_alignParentTop="true"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true" />
</RelativeLayout>

Java


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 Esperen...", 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;}

}