001.package com.example.boonmapi.myapplication;
002.
003.import android.annotation.SuppressLint;
004.import android.os.Bundle;
005.import android.os.StrictMode;
006.import android.support.v7.app.AppCompatActivity;
007.import android.util.Log;
008.import android.view.View;
009.import android.widget.Button;
010.import android.widget.EditText;
011.import android.widget.ListView;
012.import android.widget.SimpleAdapter;
013.
014.import java.sql.Connection;
015.import java.sql.DriverManager;
016.import java.sql.ResultSet;
017.import java.sql.SQLException;
018.import java.sql.Statement;
019.import java.util.ArrayList;
020.import java.util.HashMap;
021.import java.util.List;
022.import java.util.Map;
023.
024.
025.public class MainActivity extends AppCompatActivity {
026.
027. Button EXECUTAR;
028. EditText ValorBusca;
029. ListView Lista;
030. Connection connect;
031. SimpleAdapter AD;
032.
033. private void declarar(){
034. EXECUTAR = (Button) findViewById(R.id.btn_buscar);
035. ValorBusca =(EditText)findViewById(R.id.txt_buscar);
036. Lista =(ListView)findViewById(R.id.list_output);
037.
038. }
039. private void inicializer() {
040. declarar();
041. ValorBusca.setText("SELECT TOP 10 * FROM ES_LOG");
042. connect = CONN("boonmapi","031981209","DB_MAEJOPHRAE","PAKPOOM\\SQLEXPRESS");
043. }
044.
045. @SuppressLint("NewApi")
046. public Connection CONN (String user,String pass,String DB,String server) {
047.
048.
049. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
050. StrictMode.setThreadPolicy(policy);
051. Connection conn = null;
052. String ConnURL = null;
053.
054. try {
055. Class.forName("net.sourceforge.jtds.jdbc.Driver");
056. ConnURL = "jdbc:jtds:sqlserver://" + server + ";" + "databaseName=" + DB + ";user=" + user + ";password=" + pass + ";"+ "ssl=false";057. conn = DriverManager.getConnection(ConnURL);
058.
059.
060. } catch (SQLException se) {
061. Log.e("ERRO", se.getMessage());
062. } catch (ClassNotFoundException e) {
063. Log.e("ERRO", e.getMessage());
064. } catch (Exception e) {
065. Log.e("ERRO", e.getMessage());
066. }
067. return conn;
068. }
069.
070.
071. public void QuerySQL(String COMANDOSQL){
072.
073. try {
074.
075. Statement stmt = connect.createStatement();
076.
077.
078.
079. ResultSet rs = stmt.executeQuery(COMANDOSQL);
080.
081. List<Map<String,String>> data = null;
082.
083. data =new ArrayList<Map<String, String>>();
084.
085. while (rs.next()){
086. Map<String,String> datanum = new HashMap<String, String>();
087. datanum.put("A", rs.getString("USERNAME"));
088. datanum.put("B", rs.getString("DATA"));
089. data.add(datanum);
090. System.out.println( rs.getString("DATA"));
091. }
092. String[] from = {"A","B"};
093. int[] views={R.id.txt_titulo,R.id.txt_conteudo};
094. AD = new SimpleAdapter(this,data,R.layout.modelo,from,views);
095. Lista.setAdapter(AD);
096.
097. }catch (Exception e){
098. Log.e("ERRO",e.getMessage());
099. System.out.println(COMANDOSQL );
100. }
101.
102. }
103. @Override
104. protected void onCreate(Bundle savedInstanceState) {
105. super.onCreate(savedInstanceState);
106. setContentView(R.layout.activity_main);
107.
108. inicializer();
109.
110. EXECUTAR.setOnClickListener(new View.OnClickListener() {
111. @Override
112. public void onClick(View v) {
113. QuerySQL(ValorBusca.getText().toString());
114.
115. }
116. });
117. }
118.}
Quote:
