Mit ESP8266 und LM75 Temperaturdaten erfassen (Seite 3)

$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 44
Server version: 5.5.40-0+wheezy1 (Debian)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.01 sec)

create database Temperatur;
use Temperatur;
create table Temperatur (ts timestamp, temp int);
GRANT ALL ON Temperatur.* TO 'user'@'localhost' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;

import com.sun.jersey.api.container.httpserver.HttpServerFactory;
import com.sun.net.httpserver.HttpServer;
import javax.ws.rs.*;
import javax.ws.rs.core.MediaType;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
@Path( "setTemp" )
public class SetTemp {
  static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
  static final String DB_URL = "jdbc:mysql://localhost/Temperatur";
  static final String USER = "user";
  static final String PASS = "pass";
  Connection conn = null;
  Statement stmt = null;
    @GET @Produces( MediaType.TEXT_PLAIN )
    public String setTemp() {
      System.out.println("normal");
      return "Saved";
    }
    @GET @Produces( MediaType.TEXT_PLAIN )
    @Path( "temp/{temp}" )
    public String setTemp( @PathParam("temp") String temp) {
      try {
        Class.forName(JDBC_DRIVER);
        conn = DriverManager.getConnection(DB_URL, USER, PASS);
        stmt = conn.createStatement();
        String sql;
        sql = "INSERT INTO Temperatur values (now()," + temp + ")";
        stmt.executeUpdate(sql);
        System.out.println(temp);
        stmt.close();
        conn.close();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
      return "Saved: " + temp;
    }
  public static void main(String[] args) throws Exception {
    HttpServer server = HttpServerFactory.create( "http://localhost:8080/rest" );
    server.start();
    System.out.println("Zum Beenden bitte [Eingabe] drücken");
    System.in.read();
    server.stop( 0 );
  }
}