Guest User

Untitled

a guest
Jul 11th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. import android.support.v7.app.AppCompatActivity;
  2. import android.os.Bundle;
  3. import android.util.Log;
  4. import java.io.IOException;
  5. import java.sql.Connection;
  6. import java.sql.DriverManager;
  7. import java.sql.ResultSet;
  8. import java.sql.SQLException;
  9. import java.sql.Statement;
  10.  
  11. public class MainActivity extends AppCompatActivity {
  12.  
  13. @Override
  14. protected void onCreate(Bundle savedInstanceState) {
  15. super.onCreate(savedInstanceState);
  16. setContentView(R.layout.activity_main);
  17. String instanceConnectionName = "instance_connection_name";
  18. String databaseName = "databasename";
  19. String username = "root";
  20. String password = "password";
  21. try {
  22. Class.forName("com.mysql.jdbc.GoogleDriver");
  23. } catch (ClassNotFoundException e) {
  24. e.printStackTrace();
  25. Log.v("test",e.toString());
  26. }
  27. String jdbcUrl = String.format(
  28. "jdbc:mysql://google/%s?cloudSqlInstance=%s"
  29. + "&socketFactory=com.google.cloud.sql.mysql.SocketFactory&useSSL=false",
  30. databaseName,
  31. instanceConnectionName);
  32.  
  33. Connection connection = null;
  34. try {
  35. connection = DriverManager.getConnection(jdbcUrl, username, password);
  36. } catch (SQLException e) {
  37. e.printStackTrace();
  38. Log.v("test",e.toString());
  39. }
  40. //[END doc-example]
  41.  
  42. try (Statement statement = connection.createStatement()) {
  43. ResultSet resultSet = statement.executeQuery("SHOW TABLES;");
  44. while (resultSet.next()) {
  45. Log.v("test",resultSet.toString());
  46. }
  47. } catch (SQLException e) {
  48. e.printStackTrace();
  49. }
  50. }
  51. }
Add Comment
Please, Sign In to add comment