package com.application.myapplication;
import android.app.Activity;
import android.os.Bundle;
import android.os.StrictMode;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import java.sql.Connection;
import java.sql.DriverManager;
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 MainActivity extends Activity {
EditText input_text;
Button run;
SimpleAdapter AD;
Connection connect;
ListView Lista;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
inicializar();
run.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
QuerySQL(input_text.getText().toString());
}
});
}
private void declarar(){
input_text= (EditText) findViewById(R.id.editText);
run= (Button) findViewById(R.id.button);
Lista= (ListView) findViewById(R.id.listView);
}
private void inicializar() {
declarar();
input_text.setText("SELECT * FROM Table_1");
connect=CONN("kavos","1841869120kavos","kavos","67.225.166.182");
}
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://"+ _server +";" + "databaseName="+_DB+";user="+_user+";password="+_pass+";";
conn= DriverManager.getConnection(ConnURL);
} 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;
}
private void QuerySQL(String COMANDOSQL){
ResultSet res;
try {
Statement statement=connect.createStatement();
res=statement.executeQuery(COMANDOSQL);
List<Map<String,String>> data=null;
data=new ArrayList<Map<String, String>>();
while (res.next()){
Map<String,String> datanum=new HashMap<String,String>();
datanum.put("A",res.getString("name"));
datanum.put("B",res.getString("fimeli"));
data.add(datanum);
}
String from[]={"A","B"};
int views[]={R.id.name,R.id.family};
AD=new SimpleAdapter(this,data,R.layout.model,from,views);
Lista.setAdapter(AD);
}catch (Exception e){
Log.e("ERRO",e.getMessage());
}
}
}