Guest User

Untitled

a guest
Dec 1st, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.17 KB | None | 0 0
  1. E/AndroidRuntime: FATAL EXCEPTION: main
  2. Process: com.example.benni.seminarfacharbeitgartenbewaesserungv_2, PID: 22645
  3. java.lang.NullPointerException: Attempt to invoke virtual method 'android.text.Editable android.widget.EditText.getText()' on a null object reference
  4. at com.example.benni.seminarfacharbeitgartenbewaesserungv_2.WerteAendernActivity$1.onClick(WerteAendernActivity.java:50)
  5. at android.view.View.performClick(View.java:6261)
  6. at android.widget.TextView.performClick(TextView.java:11185)
  7. at android.view.View$PerformClick.run(View.java:23752)
  8. at android.os.Handler.handleCallback(Handler.java:751)
  9. at android.os.Handler.dispatchMessage(Handler.java:95)
  10. at android.os.Looper.loop(Looper.java:154)
  11. at android.app.ActivityThread.main(ActivityThread.java:6776)
  12. at java.lang.reflect.Method.invoke(Native Method)
  13. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1518)
  14. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1408)
  15.  
  16. package com.example.benni.seminarfacharbeitgartenbewaesserungv_2;
  17.  
  18. import android.support.v7.app.AppCompatActivity;
  19. import android.os.Bundle;
  20. import android.view.View;
  21. import android.widget.Button;
  22. import android.widget.EditText;
  23. import android.widget.TextView;
  24. import android.widget.Toast;
  25.  
  26. import java.sql.*;
  27.  
  28. import java.sql.Connection;
  29. import java.sql.DriverManager;
  30. import java.sql.SQLException;
  31.  
  32. public class WerteAendernActivity extends AppCompatActivity {
  33.  
  34.  
  35. EditText etIP;
  36. EditText et_minwert;
  37. EditText et_maxwert;
  38.  
  39. String Textauslesen;
  40. String maxTextauslesen;
  41. String minTextauslesen;
  42.  
  43. private Button connectBtn;
  44.  
  45.  
  46. @Override
  47. protected void onCreate(Bundle savedInstanceState) {
  48. super.onCreate(savedInstanceState);
  49.  
  50. setContentView(R.layout.activity_werte_aendern2);
  51.  
  52. etIP = (EditText) findViewById(R.id.etIP);
  53.  
  54. connectBtn = (Button) findViewById(R.id.connectBtn);
  55. connectBtn.setOnClickListener(new View.OnClickListener() {
  56.  
  57.  
  58. @Override
  59. public void onClick(View view) {
  60.  
  61. connectToDataBase();
  62. etIP.getText().toString();
  63.  
  64. et_maxwert.getText().toString();
  65. maxwerteaendern();
  66.  
  67. et_minwert.getText().toString();
  68. minwerteaendern();
  69.  
  70. }
  71. });
  72. }
  73.  
  74. Connection con = null;
  75. //private static String dbHost = "192.168.40.148"; // Hostname
  76. String dbPort = "3306"; // Port -- Standard: 3306
  77. String dbName = "wasserwerte"; // Datenbankname
  78. String dbUser = "App"; // Datenbankuser
  79. String dbPass = "fruitcake"; // Datenbankpasswort
  80.  
  81.  
  82. // Method to connect to the database
  83. private void connectToDataBase() {
  84. try {
  85. Class.forName("com.mysql.jdbc.Driver"); // Datenbanktreiber für JDBC Schnittstellen laden.
  86.  
  87. // Verbindung zur JDBC-Datenbank herstellen.
  88. con = DriverManager.getConnection("jdbc:mysql://" + Textauslesen + ":" + dbPort + "/" + dbName + "?" + "user=" + dbUser + "&" + "password=" + dbPass);
  89. // Statement createStatement();
  90. // SQLiteDatabase wasserwerte =
  91.  
  92. } catch (ClassNotFoundException e) {
  93. Toast.makeText(getApplicationContext(), "Treiber nicht gefunden", Toast.LENGTH_SHORT).show();
  94. e.printStackTrace();
  95. } catch (SQLException e) {
  96. Toast.makeText(getApplicationContext(), "Error! See Exception logs", Toast.LENGTH_SHORT).show();
  97. // The logs will be displayed in the Logcat window in Android Studio
  98. e.printStackTrace();
  99. }
  100. }
  101.  
  102. private void maxwerteaendern() {
  103. try {
  104.  
  105. Class.forName("com.mysql.jdbc.Driver");
  106. Statement stmt = con.createStatement();
  107. stmt.executeQuery("UPDATE moistvalues SET max_moist = " + maxTextauslesen + " WHERE ID = 2;");
  108.  
  109. } catch (ClassNotFoundException e) {
  110. Toast.makeText(getApplicationContext(), "Treiber nicht gefunden", Toast.LENGTH_SHORT).show();
  111. e.printStackTrace();
  112. } catch (SQLException e) {
  113. Toast.makeText(getApplicationContext(), "Error! See Exception logs", Toast.LENGTH_SHORT).show();
  114. // The logs will be displayed in the Logcat window in Android Studio
  115. e.printStackTrace();
  116. }
  117. }
  118.  
  119.  
  120. private void minwerteaendern() {
  121. try {
  122.  
  123. Class.forName("com.mysql.jdbc.Driver");
  124. Statement stmt = con.createStatement();
  125. stmt.executeQuery("UPDATE moistvalues SET min_moist = " + minTextauslesen + " WHERE ID = 2;");
  126.  
  127. } catch (ClassNotFoundException e) {
  128. Toast.makeText(getApplicationContext(), "Treiber nicht gefunden", Toast.LENGTH_SHORT).show();
  129. e.printStackTrace();
  130. } catch (SQLException e) {
  131. Toast.makeText(getApplicationContext(), "Error! See Exception logs", Toast.LENGTH_SHORT).show();
  132. // The logs will be displayed in the Logcat window in Android Studio
  133. e.printStackTrace();
  134. }
  135. }
  136.  
  137. }
Add Comment
Please, Sign In to add comment