mainactivity

package com.example.max.tpswitchapp;

import android.app.ActionBar;
import android.os.Bundle;
import android.os.StrictMode;
import android.support.design.widget.FloatingActionButton;
import android.support.design.widget.Snackbar;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.View;
import android.view.Menu;
import android.view.MenuItem;
import android.view.Window;
import android.view.WindowManager;
import android.widget.Button;
import android.widget.EditText;

import com.example.max.tpswitchapp.R;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        this.getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN);

        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);
        getSupportActionBar().hide();

        if (android.os.Build.VERSION.SDK_INT > 9) {
            StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
            StrictMode.setThreadPolicy(policy);
        }

        final EditText connString = (EditText)findViewById(R.id.editText);
        connString.setText("192.168.1.135:3306/sakila");
        final EditText queryString = (EditText)findViewById(R.id.editText2);
        final EditText userString = (EditText)findViewById(R.id.editText3);
        final EditText passString = (EditText)findViewById(R.id.editText4);

        Button bt = (Button)findViewById(R.id.button);
        bt.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                //new SQLActivity().execute("192.168.1.135", "3306", "sakila", "testUser", "test", "actor");
                new SQLActivity().execute(connString.getText().toString(),
                                        queryString.getText().toString(),
                                        userString.getText().toString(),
                                        passString.getText().toString());
            }
        });


        /*
        FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
        fab.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                new SQLActivity().execute("192.168.1.135", "3306", "sakila", "testUser", "test", "actor");

                /*
                String url = "jdbc:mysql://192.168.1.135:3306/test";
                //String url = "jdbc:mysql://192.168.1.115:3306/test";
                try {
                    Class.forName("com.mysql.jdbc.Driver").newInstance();
                } catch (ClassNotFoundException e) {
                    e.printStackTrace();
                    System.out.println(" Exception:" + e);
                } catch (IllegalAccessException e) {
                    e.printStackTrace();
                    System.out.println(" Exception:" + e);
                } catch (InstantiationException e) {
                    e.printStackTrace();
                    System.out.println(" Exception:" + e);
                }

                try {
                    Connection conn = DriverManager.getConnection(url, "testUser", "test");
                    if(!conn.isClosed())
                        System.out.println("Holyshit");

                    Statement st = conn.createStatement();

                    //st.executeUpdate("UPDATE info SET value=69 WHERE id=5");
                    //ResultSet res = st.executeQuery("SELECT * FROM actor WHERE actor_id=1");
                    //res.next();
                    //System.out.println(res.getRowId(1).toString());
                } catch (SQLException e) {
                    e.printStackTrace();
                    System.out.println(" Exception:" + e);
                }


        });
        */
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.menu_main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();

        //noinspection SimplifiableIfStatement
        if (id == R.id.action_settings) {
            return true;
        }

        return super.onOptionsItemSelected(item);
    }
}