Advertisement
Guest User

Untitled

a guest
Feb 8th, 2017
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.71 KB | None | 0 0
  1. <permission
  2. android:name="info.android.permission.MAPS_RECEIVE"
  3. android:protectionLevel="signature" />
  4.  
  5. <uses-permission android:name="info.android.permission.MAPS_RECEIVE" />
  6. <uses-permission android:name="android.permission.INTERNET" />
  7. <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
  8. <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
  9. <uses-permission android:name="android.permission.ACCESS_COARSE_LOCATION" />
  10. <uses-permission android:name="android.permission.ACCESS_FINE_LOCATION" />
  11. <uses-permission android:name="com.google.android.providers.gsf.permission.READ_GSERVICES"/>
  12.  
  13. package example.com.myapplication;
  14.  
  15. import java.sql.Connection;
  16. import java.sql.DriverManager;
  17. import android.os.StrictMode;
  18.  
  19. public class MainActivity extends AppCompatActivity {
  20.  
  21. private static final String DEFAULT_DRIVER = "oracle.jdbc.driver.OracleDriver";
  22. private static final String DEFAULT_URL = "jdbc:oracle:thin:@192.168.0.1:1521:xe";
  23. private static final String DEFAULT_USERNAME = "system";
  24. private static final String DEFAULT_PASSWORD = "oracle";
  25.  
  26. private Connection connection;
  27.  
  28. @Override
  29. protected void onCreate(Bundle savedInstanceState) {
  30. super.onCreate(savedInstanceState);
  31. setContentView(R.layout.activity_main);
  32.  
  33. if (android.os.Build.VERSION.SDK_INT > 9) {
  34. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  35. StrictMode.setThreadPolicy(policy);
  36. }
  37.  
  38. TextView tv = (TextView) findViewById(R.id.hello);
  39.  
  40.  
  41. try {
  42. this.connection = createConnection();
  43. e.Log("Connected");
  44. Statement stmt=connection.createStatement();
  45.  
  46. ResultSet rs=stmt.executeQuery("select * from cat");
  47. while(rs.next()) {
  48. System.out.println("hello : " + rs.getString(1));
  49. }
  50. connection.close();
  51. }
  52. catch (Exception e) {
  53. e.Log(""+e);
  54. e.printStackTrace();
  55. }
  56. }
  57.  
  58. public static Connection createConnection(String driver, String url, String username, String password) throws ClassNotFoundException, SQLException {
  59.  
  60. Class.forName(driver);
  61. return DriverManager.getConnection(url, username, password);
  62. }
  63.  
  64. public static Connection createConnection() throws ClassNotFoundException, SQLException {
  65. return createConnection(DEFAULT_DRIVER, DEFAULT_URL, DEFAULT_USERNAME, DEFAULT_PASSWORD);
  66. }
  67. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement