Google Android - это несложно

Код: Выделить всё

package com.example.bomba;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.concurrent.ExecutionException;
import java.util.concurrent.TimeUnit;

import com.squareup.picasso.Picasso;

import android.app.Activity;
import android.content.Context;
import android.content.Intent;
import android.os.AsyncTask;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.ImageView;
import android.widget.ListView;
import android.widget.AdapterView.OnItemClickListener;

public class Galery extends Activity{
	ImageView qq;
	Picasso pic;
	static ImageAapter adapter;

	private Context context;	
		public static final String[] imagesUrls = {
			"http://bomba.vn.ua/sites/default/files/styles/200x200/public/_dsc0072.jpg?itok=ORAFJotr",
			"http://bomba.vn.ua/sites/default/files/styles/200x200/public/_dsc0104.jpg?itok=Peitxl1w",
			
		};
		
		final String LOG_TAG = "myLogs";
		ListView mLvImages;
		ImageView img;
		Button btn;
		@Override
		protected void onCreate(Bundle savedInstanceState) {
			super.onCreate(savedInstanceState);
			setContentView(R.layout.galery);
		    mLvImages = (ListView) findViewById(R.id.lvImages);
		    img =(ImageView)findViewById(R.id.bigimg);
		    img.setVisibility(View.INVISIBLE);
		    adapter =null;
		    String[] str = null;
		    Intent intent = getIntent();
			 String dbqeru = intent.getStringExtra("dbqeru");
			 MyTask mt = new MyTask();
		     mt.execute(dbqeru);
		     try {
				 str= mt.get();
			} catch (InterruptedException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (ExecutionException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		    
			 if (str != null) {
				 ImageAapter adapter = new ImageAapter(this, str);
			      mLvImages.setAdapter(adapter);
				
			      
			    }
			 
			 mLvImages.setOnItemClickListener(new OnItemClickListener() {
			   

				@Override
				public void onItemClick(AdapterView<?> parent, View view,
						int position, long id) {
					img.setVisibility(View.VISIBLE);
					mLvImages.setVisibility(View.INVISIBLE);
					pic.with(context).load(imagesUrls[position]).into(img);
				
					 Log.d(LOG_TAG, "itemClick: position = " + position + ", id = "
					            + id);
					 Log.d(LOG_TAG, imagesUrls[position]); 
					}
			 });
			 img.setOnClickListener(new OnClickListener() {
					@Override
					public void onClick(View v) {
						img.setVisibility(View.INVISIBLE);
						mLvImages.setVisibility(View.VISIBLE);
					}
				});
			
		}


	class ImageAapter extends ArrayAdapter<String> {

	    LayoutInflater mInflater;
	    Picasso mPicasso;
	    
	    public ImageAapter(Context context, String[] imagesurls) {
	    	super(context, R.layout.list_item, imagesurls);
		      mInflater = LayoutInflater.from(context); 
		      mPicasso = Picasso.with(context);
		    }
	    @Override
	    public View getView(int position, View convertView, ViewGroup parent) {
	      View view = convertView;
	      if (view == null) {
	        view = mInflater.inflate(R.layout.list_item, parent, false);
	      }
	      ImageView imageView = (ImageView) view.findViewById(R.id.imageView);
	      mPicasso.load(getItem(position)).resizeDimen(R.dimen.image_size, R.dimen.image_size). centerInside().into(imageView);
	      return view;
	      
	    }
	   
	}

	}
class MyTask extends AsyncTask<String, Void, String[]> {
	 final String LOG_TAG = "myLogs";
 @Override
 protected void onPreExecute() {
   super.onPreExecute();
  
 }

 protected String[] doInBackground(String... params) {
	String[] photo_arr = null;
   try {
     TimeUnit.SECONDS.sleep(1);
     try { 
         
         Class.forName("com.mysql.jdbc.Driver"); 
         Log.d(LOG_TAG, "--- Driver is conected!!! ---"); 
     } catch (ClassNotFoundException e) { 
         Log.d(LOG_TAG, "--- Driver is NOT conected!!! ---"); 
         Log.d(LOG_TAG,e.toString()); 
         e.printStackTrace(); 
         return null; 
     } 
     Connection conn = null; 
    
     
      
     String url1 = "jdbc:mysql://sql5.freesqldatabase.com:3306/sql578111"; 
    String name = "sql578111"; 
     String password = "vH3!fG9%"; 
     int i=0;
    String ss;
     try { 
         conn = DriverManager.getConnection(url1, name, password); 
        // Toast.makeText(this, "есть подключение к БД", Toast.LENGTH_SHORT).show(); 
         Statement stmt = conn.createStatement();
         ResultSet rs = stmt.executeQuery("SELECT big FROM photo_travhol");
        rs.next();
        ss=rs.getString("big");
        photo_arr[0]=ss;
        Log.d(LOG_TAG,rs.getString("big"));
         Log.d(LOG_TAG,"есть подключение к БД");      
       //  while(rs.next()){
       // 	 photo_arr[i]=rs.getString("big");
       // 	 i++;
     //    }
       //  rs.next();
    	// photo_arr[i]=rs.getString("big");
       // Log.d(LOG_TAG,rs.getString("big"));
         Log.d(LOG_TAG,"есть подключение к БД"); 
        
     } catch (java.sql.SQLException e) { 
          
         Log.d(LOG_TAG,e.toString()); 
       //  Toast.makeText(this, "ошибка подключения к БД", Toast.LENGTH_SHORT).show(); 
         Log.d(LOG_TAG,"ошибка подключения к БД");
     } 

     if (conn == null) { 
       //  Toast.makeText(this, "нет данных БД", Toast.LENGTH_SHORT).show(); 
     	 Log.d(LOG_TAG,"нет данных БД");
     } else { 
      //   Toast.makeText(this, "есть данные!", Toast.LENGTH_SHORT).show(); 
     	 Log.d(LOG_TAG,"есть данные!");
     } 
     
     
   } catch (InterruptedException e) {
     e.printStackTrace();
   }
   
return photo_arr;
 }

 @Override
 protected void onPostExecute(String[] result) {
   super.onPostExecute(result);
  
 }


}