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>
editData.jsp
<%@ page language="java" import="java.util.*;"%> <%@ page language="java" import="java.sql.*"%> <%! String IPAddress=""; String SubnetMask=""; String AggregatedSwitch=""; String AllocatedHostname=""; String VLANID; String HeadendName=""; String DateIssued=""; String Remarks="";
%>
<%
if(request.getAttribute("AggregatedSwitch")!=null && request.getAttribute("AggregatedSwitch")!="") {
//IPAddress=request.getParameter(toString()); //SubnetMask=request.getParameter(toString()); //AggregatedSwitch=request.getParameter(toString()); //AllocatedHostname=request.getParameter(toString()); //VLANID=request.getParameter(toString()); //HeadendName=request.getParameter(toString()); //DateIssued=request.getParameter(toString()); //Remarks=request.getParameter(toString()); //out.println(id);
} %>
This is not working please correct me if anythg is wrong. Tanks in advance Lissy.
Ads