Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- E/AndroidRuntime: FATAL EXCEPTION: main
- Process: com.example.benni.seminarfacharbeitgartenbewaesserungv_2, PID: 22645
- java.lang.NullPointerException: Attempt to invoke virtual method 'android.text.Editable android.widget.EditText.getText()' on a null object reference
- at com.example.benni.seminarfacharbeitgartenbewaesserungv_2.WerteAendernActivity$1.onClick(WerteAendernActivity.java:50)
- at android.view.View.performClick(View.java:6261)
- at android.widget.TextView.performClick(TextView.java:11185)
- at android.view.View$PerformClick.run(View.java:23752)
- at android.os.Handler.handleCallback(Handler.java:751)
- at android.os.Handler.dispatchMessage(Handler.java:95)
- at android.os.Looper.loop(Looper.java:154)
- at android.app.ActivityThread.main(ActivityThread.java:6776)
- at java.lang.reflect.Method.invoke(Native Method)
- at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1518)
- at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1408)
- package com.example.benni.seminarfacharbeitgartenbewaesserungv_2;
- import android.support.v7.app.AppCompatActivity;
- import android.os.Bundle;
- import android.view.View;
- import android.widget.Button;
- import android.widget.EditText;
- import android.widget.TextView;
- import android.widget.Toast;
- import java.sql.*;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class WerteAendernActivity extends AppCompatActivity {
- EditText etIP;
- EditText et_minwert;
- EditText et_maxwert;
- String Textauslesen;
- String maxTextauslesen;
- String minTextauslesen;
- private Button connectBtn;
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_werte_aendern2);
- etIP = (EditText) findViewById(R.id.etIP);
- connectBtn = (Button) findViewById(R.id.connectBtn);
- connectBtn.setOnClickListener(new View.OnClickListener() {
- @Override
- public void onClick(View view) {
- connectToDataBase();
- etIP.getText().toString();
- et_maxwert.getText().toString();
- maxwerteaendern();
- et_minwert.getText().toString();
- minwerteaendern();
- }
- });
- }
- Connection con = null;
- //private static String dbHost = "192.168.40.148"; // Hostname
- String dbPort = "3306"; // Port -- Standard: 3306
- String dbName = "wasserwerte"; // Datenbankname
- String dbUser = "App"; // Datenbankuser
- String dbPass = "fruitcake"; // Datenbankpasswort
- // Method to connect to the database
- private void connectToDataBase() {
- try {
- Class.forName("com.mysql.jdbc.Driver"); // Datenbanktreiber für JDBC Schnittstellen laden.
- // Verbindung zur JDBC-Datenbank herstellen.
- con = DriverManager.getConnection("jdbc:mysql://" + Textauslesen + ":" + dbPort + "/" + dbName + "?" + "user=" + dbUser + "&" + "password=" + dbPass);
- // Statement createStatement();
- // SQLiteDatabase wasserwerte =
- } catch (ClassNotFoundException e) {
- Toast.makeText(getApplicationContext(), "Treiber nicht gefunden", Toast.LENGTH_SHORT).show();
- e.printStackTrace();
- } catch (SQLException e) {
- Toast.makeText(getApplicationContext(), "Error! See Exception logs", Toast.LENGTH_SHORT).show();
- // The logs will be displayed in the Logcat window in Android Studio
- e.printStackTrace();
- }
- }
- private void maxwerteaendern() {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Statement stmt = con.createStatement();
- stmt.executeQuery("UPDATE moistvalues SET max_moist = " + maxTextauslesen + " WHERE ID = 2;");
- } catch (ClassNotFoundException e) {
- Toast.makeText(getApplicationContext(), "Treiber nicht gefunden", Toast.LENGTH_SHORT).show();
- e.printStackTrace();
- } catch (SQLException e) {
- Toast.makeText(getApplicationContext(), "Error! See Exception logs", Toast.LENGTH_SHORT).show();
- // The logs will be displayed in the Logcat window in Android Studio
- e.printStackTrace();
- }
- }
- private void minwerteaendern() {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Statement stmt = con.createStatement();
- stmt.executeQuery("UPDATE moistvalues SET min_moist = " + minTextauslesen + " WHERE ID = 2;");
- } catch (ClassNotFoundException e) {
- Toast.makeText(getApplicationContext(), "Treiber nicht gefunden", Toast.LENGTH_SHORT).show();
- e.printStackTrace();
- } catch (SQLException e) {
- Toast.makeText(getApplicationContext(), "Error! See Exception logs", Toast.LENGTH_SHORT).show();
- // The logs will be displayed in the Logcat window in Android Studio
- e.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment