Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //PESQUISAR POR LEIL�O
- public String search_auction(long code) throws RemoteException {
- //é o code do artigo
- int check = 0;
- String resultado;
- String concat = "";
- int i = 0;
- Statement myStmt;
- try {
- myStmt = myConn.createStatement();
- ResultSet myRs = myStmt.executeQuery("SELECT ID_AUCTION, CODE, TITLE\n"
- + "FROM auction\n"
- + "WHERE CODE =" + BigInteger.valueOf(code));//results set
- myRs.next();
- while (!myRs.isLast()) {
- concat += ", items_" + i + "_id: " + myRs.getInt("ID_AUCTION") + ", items_" + i + "_code: " + myRs.getBigDecimal("CODE") + ", title: " + myRs.getString("TITLE");
- i++;
- myRs.next();
- }
- concat += ", items_" + i + "_id: " + myRs.getInt("ID_AUCTION") + ", items_" + i + "_code: " + myRs.getBigDecimal("CODE") + ", title: " + myRs.getString("TITLE");
- check = 1;
- myRs.close();
- } catch (SQLException e) {
- check = 0;
- e.printStackTrace();
- }
- if (check == 1) {
- //alterar com os resultados da query sql
- resultado = "type: search_auction , items_count: " + (i + 1) + concat;
- } else {
- resultado = "type: search_auction, items_count: 0";
- }
- return resultado;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement