package com.android.Testreservation;
import java.io.*;
//import java.io.ObjectInputStream;
//import java.io.ObjectOutputStream;
import java.net.*;
import java.sql.*;
//import java.net.UnknownHostException;
import java.sql.Connection;
import java.util.ArrayList;
//import java.sql.DriverManager;
//import java.sql.ResultSet;
//import java.sql.SQLException;
//import java.sql.Statement;
//import java.util.ArrayList;

import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Toast;

public class Main extends Activity  {
    /** Called when the activity is first created. */    
   
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        
    findViewById(R.id.button1).setOnClickListener(new OnClickListener(){

		@Override
		public void onClick(View arg0) {
		try
			{
			String adresseIP = "127.0.0.1";
			String req="SELECT * FROM table1";
			
			//Toast.makeText(getApplicationContext(),"Requête envoyée" ,Toast.LENGTH_LONG ).show();

			Socket service = new Socket(adresseIP, 1200);
			//Toast.makeText(getApplicationContext(),"Requête envoyée" ,Toast.LENGTH_LONG ).show();
			ObjectOutputStream requete = new ObjectOutputStream(service.getOutputStream());
	        ObjectInputStream reponse = new ObjectInputStream(service.getInputStream());
	        //envoi de la requete
	        requete.writeObject(req);
	        
	       Toast.makeText(getApplicationContext(),"Requête envoyée" ,Toast.LENGTH_LONG ).show();
	      //+ Reception de la réponse
	        ArrayList<?> rep = (ArrayList<?>)reponse.readObject();   
	        String phrase ="";
	        for(int i =0; i<rep.size();i++)
	        {
	        	phrase = phrase+ rep.get(i).toString();
	        }
			}
			catch (UnknownHostException e) 
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			catch (IOException e) 
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			} 
			catch (ClassNotFoundException e) 
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			finally
			{
			}
	}
    	
    }
		);
      
      
     
    
    }
}