Guest User

Untitled

a guest
Feb 16th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. @Override
  2. public void dataEventOccurred(UsbPipeDataEvent upde) {
  3. boolean empty = data[1] == 2;
  4. boolean overweight = data[1] == 6;
  5. boolean negative = data[1] == 5;
  6. boolean grams = data[2] == 2;
  7. int scalingFactor = data[3];
  8. double DozenEggs = 144.0;
  9. double OneEgg = 0.2;
  10. int AverageSellingUnitWeight = (data[4] & 0xFF) + (data[5] << 8);
  11.  
  12.  
  13. if (empty) {
  14. System.out.println("EMPTY");
  15. } else if (overweight) {
  16. System.out.println("OVERWEIGHT");
  17. } else if (negative) {
  18. System.out.println("NEGATIVE");
  19. } else if(AverageSellingUnitWeight == DozenEggs) {
  20. //then we have a dozen eggs in the fridge.
  21. //add 6 eggs to Fridge table in the database.
  22. {
  23. try {
  24. // create a mysql database connection
  25. String myDriver = "com.mysql.cj.jdbc.Driver";
  26. String myUrl = "jdbc:mysql://localhost:3306/smartfridge?autoReconnect=true&useSSL=false;";
  27. Class.forName(myDriver);
  28. Connection conn = DriverManager.getConnection(myUrl, "root", "admin");
  29.  
  30.  
  31. // the mysql insert statement
  32. String query = " insert into fridge (name, UnitOfSale, ContentsQuantity, department, AverageSellingUnitWeight)"
  33. + " values (?, ?, ?, ?, ?)";
  34.  
  35. // create the mysql insert preparedstatement
  36. PreparedStatement preparedStmt = conn.prepareStatement(query);
  37. preparedStmt.setString(1, "Eggs");
  38. preparedStmt.setInt(2, 1);
  39. preparedStmt.setInt(3, 6);
  40. preparedStmt.setString(4, "Milk, Butter & Eggs");
  41. preparedStmt.setDouble(5, DozenEggs);
  42.  
  43. // execute the preparedstatement
  44. preparedStmt.execute();
  45.  
  46. conn.close();
  47. } catch (Exception e) {
  48. e.printStackTrace();
  49. }
  50. }
  51. }
Add Comment
Please, Sign In to add comment