package com.example.kubil.sqlconn;

import android.os.StrictMode;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.annotation.SuppressLint;
import android.content.Intent;
import android.os.AsyncTask;
import android.os.StrictMode;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ProgressBar;
import android.widget.Toast;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.sql.*;

import static com.example.kubil.sqlconn.R.id.editText;
import static com.example.kubil.sqlconn.R.id.textView;

public class sorgu extends AppCompatActivity {

    Button button;
    TextView textad;
    TextView textsoyad;
    TextView texttc;
    EditText sorgu;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_sorgu);
        button = (Button) findViewById(R.id.button);
        textad= (TextView) findViewById(R.id.textView5);
        textsoyad=(TextView)findViewById(R.id.textView6);
        texttc=(TextView)findViewById(R.id.textView7);
        sorgu=(EditText) findViewById(R.id.editText);
        button.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
                sorgu();
            }
        });
    }
    public void sorgu(){


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

            Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();

            String connectionUrl = "jdbc:sqlserver://169.254.160.96:1433;databaseName=adnroid;user=android;password=zckrbnkd;";;
            Connection con = DriverManager.getConnection(connectionUrl);

            Statement statement = con.createStatement();
            String queryString = "select name from sys.databases";
            ResultSet rs = statement.executeQuery(queryString);
            String ad="";
            String soyad="";
            String tc="";
            while (rs.next()) {
                ad=rs.getString("ad");
                soyad=rs.getString("soyad");
                tc=rs.getString("tcno");
            }
            textad.setText(ad);
            textsoyad.setText(soyad);
            texttc.setText(tc);
            sorgu.setText("");

        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Hata: " + e.getMessage());
        }



    }
}