Printable View
The above found to give errors... how from Access Currency field like price=Code://out.println("<input type=\"hidden\" name=\"price" + plantNo + "\" value=\"" + rs.getString(5) + "\">");
rs.getString(5)
I populate a hidden field ? How do it in MySQL ?
Servlets upon compilation(or update) needed server restart to rerun (updated) ?
if I insert
rs.getString(5) // field5 = currency field MS-Access DB
it doesn't work, but if insert
"8.9"
work in value of hidden field , where error ?
out.println("<input type=\"hidden\" name=\"price" + plantNo + "\" value=\"" + rs.getString(5) + "\">"); // "8.9"
Don't try to output HMTL from servlets like that.
Use a JSP for the presentation. After collecting the results from a helper class whose methods are called from the servlet, set the results as request attributes in the servlets and let the servlet route to a JSP. You would then retrieve these attributes in the JSP and present the values.
may problem above be in the DATA, I have:
total+=Double.parseDouble(request.getParameter("pr ice"+i))*Integer.parseInt(request.getParameter("pl antQuantity"+i));
somewhere in the doPost executed after submit form with hidden:
out.println("<input type=\"hidden\" name=\"price" + plantNo + "\" value=\"" + rs.getString(5) + "\">"); // "8.9"
As you say SOLUTION: how transfer from servlet to JSP request attributes/data ? Also how in servlet forward or transfer control to JSP...?
Please answer asap.... this is textbook problem (self solve not instructed)...
I include[attach] whole servlet, get data from:
<body>
<form action="/Webdbt/flowerpower" method="get">
<p>
<h3>Choose your favorite color and click Submit Answer!!</h3>
<select name="choiceColor">
<option value="Peach">Peach</option>
<option value="Pink">Pink</option>
...............................................
MS-ACCESS DATABASE and field:5, is of currency type. UNDER TOMCAT.