Capture temperature data with the ESP8266 and the LM75 Sensor

$ sudo apt-get update
$ sudo apt-get upgrade
$ sudo apt-get install oracle-java7-jdk

$ 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 itsaffiliates. 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 Temperature;
use Temperature;
create table Temperature (ts timestamp, temp int);
GRANT ALL ON Temperature.* TO 'user'@'localhost' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;

01 import com.sun.jersey.api.container.httpserver.HttpServerFactory;
02 import com.sun.net.httpserver.HttpServer;
03 import javax.ws.rs.*;
04 import javax.ws.rs.core.MediaType;
05 import java.sql.Connection;
06 import java.sql.DriverManager;
07 import java.sql.Statement;
08 @Path( "setTemp" )
09 public class SetTemp {
10   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
11   static final String DB_URL = "jdbc:mysql://localhost/Temperatur";
12   static final String USER = "user";
13   static final String PASS = "pass";
14   Connection conn = null;
15   Statement stmt = null;
16   @GET @Produces( MediaType.TEXT_PLAIN )
17   public String setTemp() {
18   System.out.println("normal");
19   return "Saved";
20   }
21   @GET @Produces( MediaType.TEXT_PLAIN )
22   @Path( "temp/{temp}" )
23   public String setTemp( @PathParam("temp") String temp) {
24   try {
25   Class.forName(JDBC_DRIVER);
26   conn = DriverManager.getConnection(DB_URL, USER, PASS);
27   stmt = conn.createStatement();
28   String sql;
29   sql = "INSERT INTO Temperature values (now()," + temp + ")";
30   stmt.executeUpdate(sql);
31   System.out.println(temp);
32   stmt.close();
33   conn.close();
34   }
35   catch (Exception e) {
36   e.printStackTrace();
37   }
38   return "Saved: " + temp;
39   }
40   public static void main(String[] args) throws Exception {
41   HttpServer server = HttpServerFactory.create( "http://localhost:8080/rest" );
42   server.start();
43   System.out.println("To end please press [Enter] ");
44   System.in.read();
45   server.stop( 0 );
46   }
47 }