2 jsp buttons

[Tracy Zoller]

I am outputting to the screen rows of data followed by 2 buttons, edit and delete. When the edit button is clicked the user should be asked if they want to edit the existing record or if they want to add a new record. If they choose to edit the existing record, the page will be forwarded to a screen where the user can edit data, if they choose to add a new record, the page will be forwarded to a screen where the user can enter a new record.
For the delete button, the user should be asked "Are you sure you want to delete this record?" If yes, record will be dumped into a deleted records table in the database. If no, keep focus on initial screen. Can anyone help me with this? I am desperate. Thanks in advance. My code is as follows:

 <% while ((rsEmployer_hasData)&&(Repeat1__numRows-- != 0)) { %>
  <TR>
    <TD width="50%"><%=(((rsEmployer_data = rsEmployer.getObject("EMPLOYER"))==null || rsEmployer.wasNull())?"":rsEmployer_data)%></TD>
    <TD width="12%"><%=(((rsEmployer_data = rsEmployer.getObject("USERID"))==null || rsEmployer.wasNull())?"":rsEmployer_data)%></TD>
    <TD width="23%"><%=(((rsEmployer_data = rsEmployer.getObject("STARTWORKDATE"))==null || rsEmployer.wasNull())?"":rsEmployer_data)%></TD>
    <TD width="6%"><input name="Edit" type="submit" id="Edit" value="Edit"></TD>
    <TD width="9%"><input name="Delete" type="submit" id="Delete" value="Delete"></TD>
  </TR>
  <%
  Repeat1__index++;
  rsEmployer_hasData = rsEmployer.next();
}
%>
</TABLE>

<%
String Edit = request.getParameter("Edit");
String Delete =request.getParameter("Delete");
if(Edit != null){
%>
<jsp:forward page="/editEmployer.jsp" />
<%

} 
if(Delete != null){
%>
<jsp:forward page="/deleteEmployer.jsp" />
<%
}
%>

[Yuriy Fuksenko]

remove underscore in ONCLICK:
<input name="Delete" type="button" id="Delete" value="Delete" on_click="if(confirm('Are you sure?')) this.form.submit();">

[David O'Meara]

OK then.
Firstly, is it possible to make a part of the data a link? That way each record has a link that can be selected to act as the 'Edit' functionality. Then you no longer need the Edit button as such.

<TD><a href="/EditServlet?UID=<%=USERID%>"><%=USERID%></a></TD>
etc

In theory you can manage the delete in the same way.
Obviously this will cause each operation to be executed as a HTTP GET method. If you need to post the data, have a (single) separate form with a dummy variable. When the user clicks the links, run some JavaScript to set the UID on the dummy variable (depending on the link selected) and submit the form.
The other way to manage delete functionality is to have a checkbox for each row and a single delete button. The delete button causes all of the selected items to be submitted to the delete servlet for processing.
Hope this helps.
Dave

[Tim Holloway]

Also check out the Model 2 design approach. It's more complex than doing everything in JSPs but scales better.
You might even want to check out my Intro to Struts.