If else java set sql column value -

i hope can me, novice @ java , need understand how can populate sql returned column result if statement below.

if result true need eur display value cn* else return amount field.

   if(returnt.getstring("ins_type",i).contains("a drawdown")         || returnt.getstring("ins_type",i).contains("b drawdown"))        returnt.setdouble("eur", i, -1 * str.strtodouble(returnt.getstring("cn*", i)));     else        returnt.setdouble("eur", i, returnt.getdouble("amount", i)); 

thanks, rm

i think want write column eur. need sql update statement.

update tbl set eur = case when ... ... else ... end ... 

instead of executequery, executeupdate.

btw better use bigdecimal instead of double in java, , in sql decimal safe bet have correct precision.

---

example of dumping query:

string sql = "select ins_type, amount, cn_amount, cn_quantity"     + " tbl"     + " priority > ?"; try (preparedstatement stmt = conn.preparestatement(sql)) {     stmt.setinteger(1, priority);     try (resultset returnt = stmt.executequery()) {         string instype = returnt.getstring("ins_type");         double amount = returnt.getdouble("amount");         double cnamout = returnt.getdouble("cn_amount");         double eur = instype.contains("a drawdown")                 || instype.contains("b drawdown")             ? -1 * cnamount             : amount;         // or-operator: || ; if-then-else expression: cond ? : b          system.out.println("| " + instype + " | " + eur + " |");     } // ensures returnt.closed() called you. } // ensures stmt.closed() called you.