How to pass scriptlet value from JSP to Servlet

Question

I am trying to develop simple shopping cart application. So I have simple database table in Derby DB. From there I retrieved data to a table in JSP. Now i want to transfer that values to servlet. And this is my part of code:

ItemList.JSP

<%
String id = request.getParameter("userId");
String driverName = "org.apache.derby.jdbc.EmbeddedDriver";
String connectionUrl = "jdbc:derby://localhost:1527/";
String dbName = "CartDB";
String userId = "aaa";
String password = "aaa";
try {
Class.forName(driverName);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
%>
<table id="customers">
<%
try{
connection = DriverManager.getConnection(connectionUrl+dbName, userId, password);
statement=connection.createStatement();
String sql ="SELECT * FROM electronics_catagory";
resultSet = statement.executeQuery(sql);
while(resultSet.next()){
%>
<tr>
<td class="white">
<img src="<%=resultSet.getString("image") %>" style="width:300px;height:230px;" alt="product image">
</td>
<td class="white">
Product Name : <%=resultSet.getString("name")%><br>
<span class="smallText">Description : <%=resultSet.getString("description") %></span>
</td>
<td class="white">price <br/> <%=resultSet.getString("price") %></td>
<td class="white">Required QTY : <br> <input type="text" name="qty"></td>
<td class="white">
<form action="#" method="post">
<button class="button"><span>Add to WishList</span></button>
</form>
</td>
</tr>
<%
}
} catch (Exception e) {
e.printStackTrace();
}
%>
</table>

So anyone have any idea how to pass this values (ex:- <%= resultSet.getString("price") %>) to servlet?

Answer 1

If your servlet is mapped on your doGet, you can do it like this (without a form):

<a class="button" href="../YourServletUrl?price=<%=resultSet.getString("price") %>"><span>Add to WishList</span></a>

Then in the doGet method of your servlet, get it like you normally get any form parameter:

String price = request.getParameter("price");