import java.net.DatagramPacket;
import java.net.DatagramSocket;
import java.net.InetAddress;
import java.io.*;
import java.net.*;
import com.mysql.jdbc.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
 * Write a description of class serverUDP here.
 *
 * @author (your name)
 * @version (a version number or a date)
 */
public class servidorUDP
{
    // instance variables - replace the example below with your own
    private static final String USERNAME="root";
    private static final String PASSWORD="";
    private static final String CONN_STRING="jdbc:mysql://localhost:3306/database";

    public static void main(String args[]) throws Exception{

    	insertValue(1);

        DatagramSocket serverSocket = new DatagramSocket(9850);

        byte[] receiveData = new byte[1024];
        byte[] sendData = new byte[1024];

        DatagramPacket receivePacket = new DatagramPacket(receiveData, receiveData.length);

        serverSocket.receive(receivePacket);
        int receivedLength = receivePacket.getLength();

        InetAddress IPAdress = receivePacket.getAddress();
        int port = receivePacket.getPort();
        System.out.println("Pacote Recebido de: \t Endereço IP = " + IPAdress + "; Porto = " + port);

        String sendMsg = "Ok";
        sendData = sendMsg.getBytes();
        DatagramPacket sendPacket = new DatagramPacket(sendData, sendMsg.length(), IPAdress, port);
        serverSocket.send(sendPacket);
        //System.out.println("SEND MESSAGE = "+ sentenceReceived + "; Length: " + receivedLength + "\n");
        System.out.println("buuu");
        int[] receiveDataInt;
        int value;
        Server server = new Server();
        receiveDataInt = server.convertToInt(receiveData, receivedLength);

        value = receiveDataInt[receivedLength-1]*256+receiveDataInt[receivedLength-2];





    }

    public static void insertValue(double value){

       Connection conn = null;

        try{

            conn = DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD);
            System.out.println("Connected!");

            Statement stmt = (Statement) conn.createStatement();
            String insert = "INSERT INTO valores(id,value) " + "VALUES (1, 2) ";

            stmt.executeUpdate(insert);
        }catch(SQLException e){

            System.err.println(e);

        }

    }



    }