Hello Miao: Assuming that cardnumber is of type string and balance is defined as number type in your DB, try this:
String updatebalance ="Update dsnuser set balance=" + (balance+damount) + " where cardnumber='"+cardnumber+"'"; If balance is defined as a string, do this: String updatebalance ="Update dsnuser set balance='" + (balance+damount) + "' where cardnumber='"+cardnumber+"'"; Syed PS. FYI, I haven't tested this code. =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
