Advertisement
Guest User

search_auction

a guest
Oct 26th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. //PESQUISAR POR LEIL�O
  2. public String search_auction(long code) throws RemoteException {
  3. //é o code do artigo
  4.  
  5. int check = 0;
  6. String resultado;
  7. String concat = "";
  8. int i = 0;
  9. Statement myStmt;
  10. try {
  11. myStmt = myConn.createStatement();
  12.  
  13. ResultSet myRs = myStmt.executeQuery("SELECT ID_AUCTION, CODE, TITLE\n"
  14. + "FROM auction\n"
  15. + "WHERE CODE =" + BigInteger.valueOf(code));//results set
  16.  
  17. myRs.next();
  18. while (!myRs.isLast()) {
  19. concat += ", items_" + i + "_id: " + myRs.getInt("ID_AUCTION") + ", items_" + i + "_code: " + myRs.getBigDecimal("CODE") + ", title: " + myRs.getString("TITLE");
  20. i++;
  21. myRs.next();
  22. }
  23.  
  24. concat += ", items_" + i + "_id: " + myRs.getInt("ID_AUCTION") + ", items_" + i + "_code: " + myRs.getBigDecimal("CODE") + ", title: " + myRs.getString("TITLE");
  25. check = 1;
  26. myRs.close();
  27. } catch (SQLException e) {
  28. check = 0;
  29. e.printStackTrace();
  30. }
  31.  
  32. if (check == 1) {
  33. //alterar com os resultados da query sql
  34. resultado = "type: search_auction , items_count: " + (i + 1) + concat;
  35. } else {
  36. resultado = "type: search_auction, items_count: 0";
  37. }
  38. return resultado;
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement