Advertisement
Guest User

Untitled

a guest
Jul 17th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.38 KB | None | 0 0
  1. No suitable driver found for jdbc:mysql://localhost:3306/database
  2.  
  3. import java.net.DatagramPacket;
  4. import java.net.DatagramSocket;
  5. import java.net.InetAddress;
  6. import java.io.*;
  7. import java.net.*;
  8. import java.sql.*;
  9. import java.sql.Connection;
  10. import java.sql.DriverManager;
  11. import java.sql.SQLException;
  12.  
  13. /**
  14. * Write a description of class serverUDP here.
  15. *
  16. * @author (your name)
  17. * @version (a version number or a date)
  18. */
  19. public class serverUDP
  20. {
  21. // instance variables - replace the example below with your own
  22. private static final String USERNAME="root";
  23. private static final String PASSWORD="";
  24. private static final String CONN_STRING="jdbc:mysql://localhost:3306/database";
  25.  
  26. public static void main(String args[]) throws Exception{
  27.  
  28.  
  29. DatagramSocket serverSocket = new DatagramSocket(9876);
  30.  
  31. byte[] receiveData = new byte[1024];
  32. byte[] sendData = new byte[1024];
  33.  
  34. DatagramPacket receivePacket = new DatagramPacket(receiveData, receiveData.length);
  35.  
  36. serverSocket.receive(receivePacket);
  37. int receivedLength = receivePacket.getLength();
  38.  
  39. InetAddress IPAdress = receivePacket.getAddress();
  40. int port = receivePacket.getPort();
  41. System.out.println("Pacote Recebido de: t Endereço IP = " + IPAdress + "; Porto = " + port);
  42.  
  43. String sendMsg = "Ok";
  44. sendData = sendMsg.getBytes();
  45. DatagramPacket sendPacket = new DatagramPacket(sendData, sendMsg.length(), IPAdress, port);
  46. serverSocket.send(sendPacket);
  47. //System.out.println("SEND MESSAGE = "+ sentenceReceived + "; Length: " + receivedLength + "n");
  48. System.out.println("buuu");
  49. int[] receiveDataInt;
  50. int value;
  51. Server server = new Server();
  52. receiveDataInt = server.convertToInt(receiveData, receivedLength);
  53.  
  54. value = receiveDataInt[receivedLength-1]*256+receiveDataInt[receivedLength-2];
  55.  
  56.  
  57.  
  58. }
  59.  
  60. public void insertValue(double value){
  61.  
  62. Connection conn = null;
  63.  
  64.  
  65. try{
  66.  
  67. conn = DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD);
  68. System.out.println("Connected!");
  69.  
  70. Statement stmt = (Statement) conn.createStatement();
  71. String insert = "INSERT INTO valores(value) " + "VALUES ("+value+") ";
  72.  
  73. stmt.executeUpdate(insert);
  74. }catch(SQLException e){
  75.  
  76. System.err.println(e);
  77.  
  78. }
  79.  
  80. }
  81.  
  82.  
  83.  
  84. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement