Advertisement
Reykez

Untitled

Dec 9th, 2018
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. Class.forName("com.mysql.jdbc.Driver"); // driver
  2.  
  3. private static Connection con;
  4. private static Statement st;
  5. private static ResultSet rs;
  6. static List<String> CPU_INTEL;
  7.  
  8. con = DriverManager.getConnection("jdbc:mysql://reykez.pl:3306/reykez_-----" , "reykez_--------" , "root----");
  9. st = con.createStatement();
  10. rs = st.executeQuery("select * from CPU_AMD");
  11. while(rs.next()) {
  12. CPU_AMD.add(rs.getString("NAME"));
  13. CPU_AMD_MORELE.add(rs.getString("MORELEprice"));
  14. CPU_AMD_XKOM.add(rs.getString("XKOMprice"));
  15. }
  16.  
  17.  
  18.  
  19. // A TUTAJ WYSYLANIE
  20.  
  21. private static Connection connect = null, con = null;
  22. private static Statement statement = null, st = null;
  23. private static PreparedStatement preparedStatement = null;
  24. private static ResultSet resultSet = null;
  25.  
  26. Class.forName("com.mysql.jdbc.Driver"); // driver
  27. connect = DriverManager.getConnection("jdbc:mysql://reykez.pl:3306/reykez_-----" , "reykez_-------" , "root----"); // połączenie z bazą
  28. statement = connect.createStatement();
  29. System.out.println("Connected"); // informacja ze smiga
  30. resultSet = statement.executeQuery("select * from CPU_AMD");
  31.  
  32. while(resultSet.next()) {
  33. //getPriceFromMorele(resultSet.getString("MORELE"));
  34. //getPriceFromXkom(resultSet.getString("XKOM"));
  35. theQuery("UPDATE " + dbName + " SET MORELEprice = " + getPriceFromMorele(resultSet.getString("MORELE")) + ", XKOMprice = " + getPriceFromXkom(resultSet.getString("XKOM")) + " WHERE ID = " + resultSet.getRow());
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement