Submit button click action to JSP without a form.

May 14, 2013 09:49:59

There's a remove button for each table row. When the user clicks remove, the row in which the remove button is clicked should be deleted.

How do I get the onclick action to work ? =/

I tried using the 'hidden' input tag method, but I guess I messed up ..

<body>
table border="1">
<tr>
<td>Title</td>
<td>Act</td>
<td>Release Date</td>
<td>Description</td>
<td>Genres</td>
<td>Time Slots</td>
<td>Actions</td>
</tr>
<%
//Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");
//Define Connection URL
String connURL = "jdbc:mysql://localhost/assignment?user=root&password=rootlah213";
//Establish connection to URL
Connection conn = DriverManager.getConnection(connURL);
PreparedStatement pstmt;
pstmt = conn.prepareStatement("Select * from showdb");
ResultSet rs = pstmt.executeQuery();
while(rs.next()){
out.println("<tr>");
out.println("<td>" + rs.getString("show") + "</td>");
out.println("<td>" + rs.getString("Act") + "</td>");
out.println("<td>" + rs.getString("Release_Date") + "</td>");
out.println("<td>" + rs.getString("Description") + "</td>");
out.println("<td>" + rs.getString("Genre") + "</td>");
out.println("<td>" + rs.getString("Time_Slots") + "</td>");
out.println("<td> <input type='hidden' name='hidden' value='"+rs.getString("movie")+"'> <input type='button' name='removed' value='Remove'> <input type='button' name='edit' value='Edit'> </td>");
out.println("</tr>");
}
String getmov = request.getParameter("hidden");
if(request.getParameter("hidden") != null) {
PreparedStatement pstmt2;
pstmt2 = conn.prepareStatement("Delete from show_db where show=?");
pstmt2.setString(1, getmov);
pstmt2.executeUpdate();
}
%>
</table>

May 14, 2013 10:37:43

Why are you using scriptlet to perform DB access and data retrieval? Use JSPs purely to bring up the view part of your web application. Read Bear's response in this thread. Also read this arcticle by Bear.

A berm makes a great wind break. And we all like to break wind once in a while. Like this tiny ad:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com