<%@ page session="true" %>
Rates of questions for different categories are:
<%
Statement st3=conn.createStatement();
ResultSet rs3=st3.executeQuery("select categorieName ,rateUSD ,rateINR from Categories");
%>
| Category Name | Rate in US$ (Normal) | Rate in INR (Normal) | Rate in US$ (Urgent) | Rate in INR (Urgent) |
<%
while(rs3.next()){
String categorieName=rs3.getString(1);
String categorieNameRemove=categorieName.replace('-',' ');
double rateUSD=rs3.getDouble(2);
double rateINR=rs3.getDouble(3);
int intrateUSD= (int)rateUSD;
int intrateINR= (int)rateINR;
double rateUSDUrgent=rateUSD*2.0;
double rateINRUrgent=rateINR*2.0;
int intrateUSDUrgent= (int)rateUSDUrgent;
int intrateINRUrgent= (int)rateINRUrgent;
%>
| <% out.print(categorieNameRemove); %> | <% out.print(intrateUSD);%> | <% out.print(intrateINR);%> | <% out.print(intrateUSDUrgent);%> | <% out.print(intrateINRUrgent);%> |
<%
}
%>