dynamic insertion an deletion

[mehak]

hey... i have a problem..I am working on a problem management system..my code for a particular jsp page is as follows in this page i want to show the admin the already present records in the table named problem..and a submit solution button besides every row..whenever the admin clicks on the submit button that particular row should be deleted from this table and stored in another table named solution along with the solution which the admin has to enter.


<table width="205%" border="0">
<tr >
<td width="105%" bgcolor="#FFFFFF"><table width="100%" height="100" border="1">
<tr>
<th width="5%" scope="row">EMPLOYEE NUMBER</th>
<td width="5%">EMPLOYEE NAME</td>
<td width="3%">MODULE NAME</td>
<td width="4%">PHONE NUMBER</td>
<td width="6%">EMAIL</td>
<td width="8%">PROBLEM DESCRIPTION</td>
<td width="5%">PROBLEM DATE</td>
<td width="5%">PROBLEM ID</td>
<td width="5%">SOLUTION</td>

</tr>
<% String login_name=(String)request.getAttribute("login");
String cmd;
System.out.println(login_name);

if(login_name.equals("mehak"))
{
cmd="select * from problem where area='Hospitality'";
}
else if(login_name.equals("nipun"))
{
cmd="select * from problem where area='Gate Pass'";
}
else
{
cmd="select * from problem where area='Document Tracker'";
}
PreparedStatement psmt=con.prepareStatement(cmd);
ResultSet rs=psmt.executeQuery();

while(rs.next())
{
%>



<tr>
<th width="5%" scope="row"><%=rs.getString(1) %></th>
<td width="5%"><%=rs.getString(2) %></td>
<td width="3%"><%=rs.getString(4) %></td>
<td width="4%"><%=rs.getString(5) %></td>
<td width="4%"><%=rs.getString(6) %></td>
<td width="6%"><%=rs.getString(7) %></td>
<td width="8%"><%=rs.getString(8) %></td>
<td width="5%"><%=rs.getInt(9) %></td>
<% System.out.println(rs.getRow());%>

<td width="5%">
<form id="submit1" name="submit1" method="post" action="solution.jsp">
<select name="resolve">
<option value=<%rs.getRow(); %>>resolve</option>
</select>
<input type="submit" name="submit" id="resolve" value="submit"/>
</form>

</td>

</tr>
<% } %>
</table></td>

Thanx in advance

[Tolls]

And?
What's your problem?

(Apart from doing business logic ina JSP...that is, that db code should not be in there)

[mehak]

i want that whenever the submit button is pressed that row should be deleted from the problem table and inseted into solution table.....

[Tolls]

So.
Write some code that does that.