lissy
Hi
I am doing a simple project where i need to edit/delete values in database table using jsp or servlets, when i key in form input, am getting the database table values and at the end of each row i have edit and delete buttons, when i click edit button i need all the values in that particular row must be edited in the next jsp page textboxes and when i modify and click save button it shd save to database, same for delete i want that particular values shd display in textboxes then when i click delete the values shd delete, here is my code please can anyone help me to solve this...
my code:
retrieve.jsp <%@ page import="java.sql.*" %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%> <HTML> <HEAD> <TITLE>Fetching Data From a Database
</HEAD>
<BODY>
<H1>Fetching Data From a Database</H1>
<%
Connection connection = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver "
+ "(*.mdb, *.accdb)};DBQ=C:\\Database\\Databaseip.accdb");
ResultSet resultset;
Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
String AggregatedSwitch = request.getParameter("AggregatedSwitch");
resultset =
statement.executeQuery("SELECT * FROM ip_address WHERE AggregatedSwitch = '" + AggregatedSwitch + "'");
if (!resultset.next()) {
out.println("Sorry, could not find the data. ");
} else {
%>
<TABLE cellpadding="15" border="1" style="background-color: #ffffcc" align="center">
<TR>
<TH>IP Address</TH>
<TH>Subnet Mask</TH>
<TH>Aggregated Switch</TH>
<TH>Allocated Hostname</TH>
<TH>VLAN ID</TH>
<TH>Headend Network</TH>
<TH>Date Issued</TH>
<TH>Remarks</TH>
<TH>Edit</TH>
<TH>Delete</TH>
</TR>
<%
do {
%>
<TR>
<TD> <%= resultset.getString(1)%> </TD>
<TD> <%= resultset.getString(2)%> </TD>
<TD> <%= resultset.getString(3)%> </TD>
<TD> <%= resultset.getString(4)%> </TD>
<TD> <%= resultset.getString(5)%> </TD>
<TD> <%= resultset.getString(6)%> </TD>
<TD> <%= resultset.getString(7)%> </TD>
<TD> <%= resultset.getString(8)%> </TD>
<TD><input type="button" name="edit" value="Edit" onClick="javascript:window.location='editData.jsp';" style="background-color:#49743D;font-weight:bold;color:#ffffff;">
</TD>
<TD><input type="button" name="delete" value="Delete" onClick="javascript:window.location='deleteData.jsp';"style="background-color:#ff0000;font-weight:bold;color:#ffffff;"></TD>
</TR>
<%resultset.next();
} while (resultset.isAfterLast() != true);
%>
</TABLE>
<BR>
<%
}
%>
</BODY>