Pete,I've tried implementing the code you gave, but I don't know if I'm doing it right:
This is Upload1.jsp
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form action="add.jsp" method="post">
<%
Product_ID = request.getParameter("product");
ResultSet product = null;
if (Product_ID != null)
{
product = /* get the product from the database */
%>
<input type="hidden" name="Product_ID" value="<%=Product_ID%>">
<%
}
%>
<table width="763" border="1" cellpadding="2" cellspacing="1" bordercolor="#99CCFF" bgcolor="#d2e2fb">
<tr align="left">
<td colspan="3"><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong><font size="3">Add
Product<font color="#d2e2fb">h</font></font><font color="#d2e2fb">hhhhhhhhhhhhhhhhhhhhyyyyyyyyyyyyyyyyyyyyyyhhhhhhhhhh</font><%=new java.util.Date()%></strong></font></td>
</tr>
<tr>
<td width="156"><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong>Product
ID:</strong></font></td>
<td width="590" colspan="2"><input type="text" name="Product_ID" value="<%= ((product!=null)?"rs.getString("Product_ID"):"")%>"> size="11"></td>
</tr>
<tr>
<td><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong>Product Price:</strong></font></td>
<td width="590" colspan="2"><input type="text" name="Product_Price" size="11"></td>
</tr>
</table>
<table width="763" height="140" border="1" cellpadding="2" cellspacing="1"bordercolor="#99ccff" bgcolor="#d2e2fb">
<tr>
<td width="156" height="136"><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong>Current
Product Picture:</strong></font></td>
<td width="253"><img src="coin.jpeg" width=250 height=130 align="middle"></td>
<td width="330"><table width="303" border="0"bordercolor="#124fb1" cellspacing="1" cellpadding="2">
<tr>
<td width="297" align="left"><font color="#d2e2fb">ss</font> <select name="Country">
<option selected>English</option>
<option>Scottish</option>
<option>Irish</option>
<option>French</option>
<option>German</option>
<option>Spanish</option>
<option>Italian</option>
<option>Other European</option>
<option>USA</option>
<option>Canada</option>
<option>Australia</option>
<option>Other World</option>
<option>Ancient</option>
</select> <font color="#d2e2fb">jjjjj</font><strong><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif">Suffix</font></strong>
<input type="text" name="Suffix" size="10"> </td>
</tr>
</table>
<table width="302" border="0" bordercolor="#124fb1" cellspacing="1" cellpadding="2">
<tr>
<td width="148" align="left"> <font color="#d2e2fb">ssssssssssiii</font>
<select name="Grade">
<option selected>Grade</option>
<option>FDC</option>
<option>EF</option>
<option>VF</option>
<option>F</option>
<option>Fair</option>
<option>Poor</option>
</select></td>
<td width="143"><strong><font color="#d2e2fb" size="2" face="Arial, Helvetica, sans-serif">iiii</font><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif">Year</font></strong>
<input type="text" name="Year" size="10"> </td>
</tr>
<tr>
<td height="27" align="left"><strong>
<select name="Type">
<option selected>Type</option>
<option>Hammered Silver</option>
<option>Hammered Gold</option>
<option>Gold</option>
<option>Crown</option>
<option>Double Florin</option>
<option>Half Crown</option>
<option>Florin</option>
<option>Shilling</option>
<option>Sixpence</option>
<option>Groat</option>
<option>Threepence</option>
<option>Penny</option>
<option>Half Penny</option>
<option>Farthing</option>
<option>Maundy</option>
<option>Tokens</option>
<option>Modern Proof Sets</option>
<option>Other</option>
</select>
</strong></td>
<td align="left"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="763" border="1" cellpadding="2" cellspacing="1" bordercolor="#99ccff" bgcolor="#d2e2fb">
<tr>
<td width="155"><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong>New
Product Picture:</strong></font></td>
<td width="591"><input type="file" value="Browse" size="80"></td>
</tr>
<tr>
<td><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong>Product
Category:</strong></font></td>
<td><input type="text" name="Product_Category" size="65"></td>
</tr>
<tr>
<td height="43"><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong>Product
Brief Desc:</strong></font></td>
<td><textarea name="Product_Brief_Desc" rows ="2" cols="68"></textarea></td>
</tr>
<tr>
<td height="139"><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong>Product
Full Desc:</strong></font></td>
<td bgcolor="#d2e2fb"><textarea name="Product_Full_Desc" rows ="8" cols="68"></textarea></td>
</tr>
<tr>
<td><font color="#373c7d" size="2" face="Arial, Helvetica, sans-serif"><strong>Product
Status:</strong></font></td>
<td align="left" valign="baseline"><align ="right"><select name="Product_Status">
<option selected>ACTIVE</option>
<option>INACTIVE</option>
<option>SOLD</option>
<option>SHOWCASE</option>
</select></td>
</tr>
</table>
<table width="763" border="1" cellspacing="1" cellpadding="2"bordercolor="#99ccff" bgcolor="#d2e2fb">
<tr>
<td width="753" colspan="2"align="center"><input type="Submit" value="Submit"/><input type="reset" value="Reset"/></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</form>
</body>
</html>
This is Add.jsp
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java"
import="java.sql.*, java.io.*, java.util.*"
errorPage="error.jsp" %>
<jsp:useBean id="coin" class="com.project.databases.Coins"/>
<html>
<head>
<title>Add Coins</title>
</head>
<body>
<%
int id = Integer.parseInt(request.getParameter("Product_ID"));
float price = Float.parseFloat(request.getParameter("Product_Price"));
String country = request.getParameter("Country");
String type = request.getParameter("Type");
String grade = request.getParameter("Grade");
int year = Integer.parseInt(request.getParameter("Year"));
String suffix = request.getParameter("Suffix");
String productCategory = request.getParameter("Product_Category");
String productBriefDesc = request.getParameter("Product_Brief_Desc");
String productFullDesc = request.getParameter("Product_Full_Desc");
String productStatus = request.getParameter("Product_Status");
coin.connect();
coin.addCoins(id, price, country, type, grade, year, suffix, productCategory, productBriefDesc, productFullDesc, productStatus);
coin.disconnect();
%>
The new coin has been added. <br />
Click <a href="coinlist.jsp">Here</a> To Go Back.
</body>
</html>