Advertisement
Guest User

Untitled

a guest
Mar 21st, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.29 KB | None | 0 0
  1. @Override
  2. protected void onCreate(Bundle savedInstanceState) {
  3. super.onCreate(savedInstanceState);
  4. setContentView(R.layout.activity_main);
  5.  
  6. submitButton = (Button) findViewById(R.id.submitButton);
  7.  
  8. submitButton.setOnClickListener(new View.OnClickListener() {
  9. public void onClick(View v) {
  10. Toast.makeText(MainActivity.this,"This works",Toast.LENGTH_LONG).show();
  11.  
  12. service = (LocationManager) getSystemService(Context.LOCATION_SERVICE);
  13. checkPermission();
  14.  
  15. criteria = new Criteria();
  16.  
  17. String provider = service.getBestProvider(criteria, false);
  18.  
  19. if (provider != null & !provider.equals("")) {
  20. Location location = service.getLastKnownLocation(provider);
  21. service.requestLocationUpdates(provider, 2000, 1, MainActivity.this);
  22.  
  23. if (location != null) {
  24. onLocationChanged(location);
  25. } else {
  26. Toast.makeText(MainActivity.this, "location not found", Toast.LENGTH_LONG).show();
  27. }
  28.  
  29. } else {
  30. Toast.makeText(MainActivity.this, "Provider is null", Toast.LENGTH_LONG).show();
  31. }
  32.  
  33. selectionEvent = eventSpinner.getSelectedItem().toString();
  34.  
  35. insertThread.start();
  36.  
  37. }
  38. });
  39.  
  40. sqlThread.start();
  41. }
  42.  
  43. Thread sqlThread = new Thread(){
  44. public void run(){
  45.  
  46. alertHandler = new Handler(Looper.getMainLooper());
  47.  
  48. try{
  49.  
  50. Class.forName("org.postgresql.Driver");
  51.  
  52. String url = "localhost:5432";
  53. Connection conn = DriverManager.getConnection(url,"arodriguez","alejandro2017");
  54.  
  55. String statementSQL = "SELECT * FROM incidencias";
  56. Statement statement = conn.createStatement();
  57. ResultSet resultSet = statement.executeQuery(statementSQL);
  58. while(resultSet.next()){
  59. tiposIncidencias.add(resultSet.getString(2));
  60. naturalezaIncidencias.add(resultSet.getString(3));
  61. }
  62.  
  63. alertHandler.post(new Runnable() {
  64. @Override
  65. public void run() {
  66. addDefaultItemsOnTypeSpinner();
  67. addDefaultItemsOnEventSpinner();
  68. }
  69. });
  70.  
  71. String statementSQL2 = "INSERT INTO arodriguez.prueba (description,x,y) VALUES ('"+selectionEvent+"',"+latitude+","+longitude+")";
  72. Statement s = null;
  73. s = conn.createStatement();
  74. s.executeUpdate(statementSQL2);
  75.  
  76. conn.close();
  77.  
  78. } catch (SQLException se){
  79. Toast.makeText(MainActivity.this,se.toString(),Toast.LENGTH_LONG).show();
  80.  
  81. } catch (ClassNotFoundException e){
  82. Toast.makeText(MainActivity.this,e.toString(),Toast.LENGTH_LONG).show();
  83. } catch (Exception ex){
  84. Log.d("Error",ex.toString());
  85. }
  86. return;
  87. }
  88. };
  89.  
  90. Thread insertThread = new Thread(){
  91.  
  92. public void run(){
  93.  
  94. alertHandler = new Handler(Looper.getMainLooper());
  95.  
  96. try{
  97.  
  98. alertHandler.post(new Runnable() {
  99. @Override
  100. public void run() {
  101. Toast.makeText(MainActivity.this,selectionEvent,Toast.LENGTH_LONG).show();
  102. }
  103. });
  104.  
  105. Class.forName("org.postgresql.Driver");
  106.  
  107. String url = "jdbc:postgresql://localhost:5432/sde";
  108. Connection conn = DriverManager.getConnection(url,"arodriguez","alejandro2017");
  109.  
  110. String statementSQL = "INSERT INTO arodriguez.prueba (description,x,y) VALUES ('"+selectionEvent+"',"+latitude+","+longitude+")";
  111. Statement statement = null;
  112. statement = conn.createStatement();
  113. statement.executeUpdate(statementSQL);
  114.  
  115. conn.close();
  116.  
  117. }catch (SQLException se){
  118. Log.d("Error",se.toString());
  119. } catch (ClassNotFoundException e){
  120. Log.d("Error",e.toString());
  121. } catch (Exception ex){
  122. Log.d("Error",ex.toString());
  123. }
  124. return;
  125. }
  126. };
  127.  
  128. String statementSQL = "INSERT INTO arodriguez.prueba (description,x,y) VALUES ('"+selectionEvent+"',"+latitude+","+longitude+")";
  129. Statement statement = null;
  130. statement = conn.createStatement();
  131. statement.executeUpdate(statementSQL);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement