Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.teststore10;
- import java.sql.DriverManager;
- import java.sql.*;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- import android.os.AsyncTask;
- import android.widget.TextView;
- import androidx.appcompat.app.AppCompatActivity;
- import android.os.Bundle;
- import org.w3c.dom.Text;
- public class MainActivity extends AppCompatActivity {
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- TextView textview = (TextView)findViewById(R.id.textview);
- }
- private class MyClass extends AsyncTask<Void, Void, Void> {
- @Override
- protected void onPreExecute() {
- super.onPreExecute();
- }
- @Override
- protected Void doInBackground(Void... params) {
- return null;
- }
- @Override
- protected void onPostExecute(Void result) {
- super.onPostExecute(result);
- }
- }
- // Формирование строки подключения
- Statement statement = null;
- String instanceName = "178.217.172.237\\isubase ";
- String databaseName = "Web";
- String userName = "sa";
- String pass = "iko++904891";
- String connectionUrl = "jdbc:sqlserver://%1$s;databaseName=%2$s;user=%3$s;password=%4$s;";
- String connectionString = String.format(connectionUrl, instanceName, databaseName, userName, pass);
- //
- try {
- Class.forName("net.sourceforge.jtds.jdbc.Driver");
- // Подключение к базе данных
- Connection conn = DriverManager.getConnection(connectionString);
- // Отправка запроса на выборку и получение результатов
- statement = conn.createStatement();
- String result = "Есть соединение";
- ResultSet rs = statement.executeQuery("SELECT Параметры,цена2 FROM Товар");
- ResultSetMetaData rsmd = rs.getMetaData();
- // Обход результатов выборки
- while (rs.next()) {
- result+=rs.getString("Параметры") + "\n";
- }
- //textview.setText(result);
- // Закрываем соединение
- rs.close();
- statement.close();
- conn.close();
- } catch (SQLException | ClassNotFoundException ex) {
- ex.printStackTrace();
- textview.setText(ex.toString());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement