Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import android.support.v7.app.AppCompatActivity;
- import android.os.Bundle;
- import android.util.Log;
- import java.io.IOException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class MainActivity extends AppCompatActivity {
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- String instanceConnectionName = "instance_connection_name";
- String databaseName = "databasename";
- String username = "root";
- String password = "password";
- try {
- Class.forName("com.mysql.jdbc.GoogleDriver");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- Log.v("test",e.toString());
- }
- String jdbcUrl = String.format(
- "jdbc:mysql://google/%s?cloudSqlInstance=%s"
- + "&socketFactory=com.google.cloud.sql.mysql.SocketFactory&useSSL=false",
- databaseName,
- instanceConnectionName);
- Connection connection = null;
- try {
- connection = DriverManager.getConnection(jdbcUrl, username, password);
- } catch (SQLException e) {
- e.printStackTrace();
- Log.v("test",e.toString());
- }
- //[END doc-example]
- try (Statement statement = connection.createStatement()) {
- ResultSet resultSet = statement.executeQuery("SHOW TABLES;");
- while (resultSet.next()) {
- Log.v("test",resultSet.toString());
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment