Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Class.forName("com.mysql.jdbc.Driver"); // driver
- private static Connection con;
- private static Statement st;
- private static ResultSet rs;
- static List<String> CPU_INTEL;
- con = DriverManager.getConnection("jdbc:mysql://reykez.pl:3306/reykez_-----" , "reykez_--------" , "root----");
- st = con.createStatement();
- rs = st.executeQuery("select * from CPU_AMD");
- while(rs.next()) {
- CPU_AMD.add(rs.getString("NAME"));
- CPU_AMD_MORELE.add(rs.getString("MORELEprice"));
- CPU_AMD_XKOM.add(rs.getString("XKOMprice"));
- }
- // A TUTAJ WYSYLANIE
- private static Connection connect = null, con = null;
- private static Statement statement = null, st = null;
- private static PreparedStatement preparedStatement = null;
- private static ResultSet resultSet = null;
- Class.forName("com.mysql.jdbc.Driver"); // driver
- connect = DriverManager.getConnection("jdbc:mysql://reykez.pl:3306/reykez_-----" , "reykez_-------" , "root----"); // połączenie z bazą
- statement = connect.createStatement();
- System.out.println("Connected"); // informacja ze smiga
- resultSet = statement.executeQuery("select * from CPU_AMD");
- while(resultSet.next()) {
- //getPriceFromMorele(resultSet.getString("MORELE"));
- //getPriceFromXkom(resultSet.getString("XKOM"));
- 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