import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import android.widget.TextView;

import com.mysql.jdbc.exceptions.jdbc4.CommunicationsException;


public class MainActivity extends AppCompatActivity {
    /*String protocolo = "jdbc:mysql://";
        String lineaUser = "user="+user;
        String lineaPass = "password="+pass;
        String urlConexion = protocolo + host + "/" + dbName +"?"+ lineaUser +"&"+ lineaPass;  */
    private static final String url = "jdbc:mysql://10.31.75.60:3306/pruebaAndroid?";
    private static final String user = "user=usuario"+"&";
    private static final String pass = "password=123456";
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        try {
            testDB();
        } catch (CommunicationsException e) {
            e.printStackTrace();
        }
    }

    public void testDB() throws CommunicationsException{
        TextView tv = (TextView)this.findViewById(R.id.text_view);
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(url, user, pass);
            /* System.out.println("Databaseection success"); */

            String result = "Database connection success\n";
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("select * from registroPersonas;");
            ResultSetMetaData rsmd = rs.getMetaData();

            while(rs.next()) {
                result += rsmd.getColumnName(1) + ": " + rs.getInt(1) + "\n";
                result += rsmd.getColumnName(2) + ": " + rs.getString(2) + "\n";
                result += rsmd.getColumnName(3) + ": " + rs.getString(3) + "\n";
            }
            tv.setText(result);
        }
        catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
            tv.setText(e.toString());
        }

    }
}