import android.annotation.SuppressLint;
import android.os.Bundle;
import android.os.StrictMode;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;
import android.widget.GridView;
import android.widget.SimpleAdapter;
import android.widget.Toast;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class GridViewActivity extends AppCompatActivity {

    GridView gridview;
    ArrayList<String> arrayList;

    String ip, db, un, passwords;
    Connection connect;
    PreparedStatement stmt;
    ResultSet rs;

    @Override

    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_grid_view);

        ip = "MyServerIP";
        un = "MyUserId";
        passwords = "MyPass";
        db = "Mydb";

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

        connect = CONN(un, passwords, db, ip);
        String query = "select user,password from Usertbl";


        try {

            connect = CONN(un, passwords, db, ip);
            Statement statement = connect.createStatement();
            rs = statement.executeQuery(query);
            List<Map<String, String>> data = null;
            data = new ArrayList<Map<String, String>>();

            while (rs.next()) {

                Map<String, String> datanum = new HashMap<String, String>();
                datanum.put("A", rs.getString("user"));
                datanum.put("B", rs.getString("password"));

                data.add(datanum);
            }

            String[] from = { "A", "B" };
            int[] views = { R.id.txtcountry, R.id.txtcontinent };
            final SimpleAdapter ADA = new SimpleAdapter(GridViewActivity.this,data, R.layout.activity_grid_view, from, views);

            gridview.setAdapter(ADA);

        } catch (SQLException e) {
            e.printStackTrace();

        }

    }

    @SuppressLint("NewApi")

    private Connection CONN(String _user, String _pass, String _DB,String _server) {

        StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();

        StrictMode.setThreadPolicy(policy);
        Connection conn = null;
        String ConnURL = null;

        try {

            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            ConnURL = "jdbc:jtds:sqlserver://MyServerIP:MyPort;databaseName=Mydb;instance=MySqlServer;user=MyUserId;password=MyPass";
            conn = DriverManager.getConnection(ConnURL);

            if (conn == null){
                Toast.makeText(GridViewActivity.this,"Database Connection failed",Toast.LENGTH_LONG).show();
            }
            else {
                Toast.makeText(GridViewActivity.this,"Database Connection Success",Toast.LENGTH_LONG).show();
            }

        } catch (SQLException se) {

            Log.e("ERRO", se.getMessage());

        } catch (ClassNotFoundException e) {

            Log.e("ERRO", e.getMessage());

        } catch (Exception e) {

            Log.e("ERRO", e.getMessage());

        }

        return conn;

    }

}