Advertisement
Guest User

Untitled

a guest
Jul 8th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1.  
  2. public boolean CheckGE(Client clientToSave, String DB, String input, String whatisit, boolean PRINTGEUPDATE) {
  3. boolean sold = false;
  4. try {
  5.  
  6. Connection C = DriverManager.getConnection("jdbc:mysql://localhost/access","root","ascent");
  7. Statement Stmt = C.createStatement();
  8. ResultSet RS = stmt.executeQuery("SELECT * " +
  9. "FROM "+DB+" WHERE seller=\""+input+"\" AND itemstatus=\""+whatisit+"\" AND itemid AND id");
  10. while (RS.next()) {
  11. String str1 = RS.getString("seller");
  12. String str2 = RS.getString("itemid");
  13. String str3 = RS.getString("price");
  14. String str4 = RS.getString("id");
  15. String str5 = RS.getString("itemstatus");
  16. if(str1.equalsIgnoreCase(input)){
  17. if(PRINTGEUPDATE){
  18. clientToSave.sendMessage("@dbl@Check your grand exchange it has been updated!");
  19. }
  20. sold = true;
  21. }
  22. }
  23. RS.close();
  24. Stmt.close();
  25. C.close();
  26. }
  27. catch (SQLException E) {
  28. System.out.println("SQLException: " + E.getMessage());E.printStackTrace();
  29. System.out.println("SQLState: " + E.getSQLState());
  30. System.out.println("VendorError: " + E.getErrorCode());
  31. return false;
  32. }
  33. return sold;
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement