package project3;

import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.net.InetAddress;
import java.net.Socket;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Scanner;
import java.sql.*;

public class ServerSockets7
{
	@SuppressWarnings("resource")
	public static void main(String[] args) throws Exception
	{
		boolean start = true;
		int x = 1;
		String lon = "/gpio/1";
		String loff = "/gpio/0";
		while (start == true)
		{
			System.out.println("Client Starting..");
			InetAddress inet = InetAddress.getByName("93.107.48.54");
			Socket socket = new Socket(inet, 2001);

			OutputStream outStream = socket.getOutputStream();
			PrintWriter p = new PrintWriter(outStream);

			System.out.println("Spare room");
				p.println("temp");
				p.flush();


			InputStream inStream = socket.getInputStream();
			Scanner input = new Scanner(inStream);
			String str = input.nextLine();
			System.out.println("From Server: " + str);
			DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
	        Date date = new Date();
	        String dateString = dateFormat.format(date);
			DateFormat timeFormat = new SimpleDateFormat("HH:mm:ss");
	        Date time = new Date();
	        String timeString = timeFormat.format(time);
	        System.out.println(time);
			try {
				Connection db = DriverManager.getConnection("jdbc:mysql://93.107.48.54:3306/comfi", "root", "Project@2017");
				Statement st = db.createStatement();
				String sql = "INSERT INTO `temperature`" + " (`date`, `time`, `temp`)" + " values (dateString, timeString, reg)";
				st.executeUpdate(sql);
				System.out.println("Data sent to database");
			}catch (Exception exc) {
				exc.printStackTrace();
			}
			Thread.sleep(15000);
		}
	}
}