How to multiply values from different coloumn in jsp servlet

Question

I want to multiply resultSet.getInt("price") with resultSet.getInt("quantity")

And give the result in my html How can i do it? P.s im a beginner

Answer 1

Try below....

<% int price = resultSet.getInt("price");
   int qty = resultSet.getInt("quqntity");
   int value = price * qty;
%>

Result Value (price * quantity)  = <% = value %>

Please let me know if you have any further queries

Answer 2

I hope it will help...!

 <%
int grandtotal=0;
while(resultSet.next()){
int price = resultSet.getInt("price");  
int quantity = resultSet.getInt("quqntity");  
grandtotal =grandtotal+(price * quantity); 
}

%> Result=<%=grandtotal%>.