<%@ page language="" name="description">

Hi I need help to edit values in database into jsp page textboxes,
This is my code:
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=userList.get(0).toString();
SubnetMask=userList.get(1).toString();
AggregatedSwitch=userList.get(2).toString();
AllocatedHostname=userList.get(3).toString();
VLANID=userList.get(4).toString();
HeadendName=userList.get(5).toString();
DateIssued=userList.get(6).toString();
Remarks=userList.get(6).toString();
//out.println(id);
} %>
editData.java
import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.util.*;
public class EditData extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
System.out.println("MS Access Connect Example.");
Connection conn = null;
String IPAddress = request.getParameter("IPAddress").toString();
String SubnetMask = request.getParameter("SubnetMask").toString();
String AggregatedSwitch = request.getParameter("AggregatedSwitch").toString();
String AllocatedHostname = request.getParameter("AllocatedHostname").toString();
int VLANID = Integer.parseInt(request.getParameter("VLANID").toString());
String HeadendName = request.getParameter("HeadendName").toString();
String DateIssued = request.getParameter("DateIssued").toString();
String Remarks = request.getParameter("Remarks").toString();
Statement stmt;
String url = "jdbc:odbc:Driver={Microsoft Access Driver "
+ "(*.mdb, *.accdb)};DBQ=C:\\Database\\Databaseip.accdb";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
out.println(request.getRequestURI());
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url);
System.out.println("Connected to the database");
ArrayList al = null;
ArrayList userList = new ArrayList();
String query = "UPDATE ip_address SET IPAddress='" + IPAddress + "',SubnetMask='" + SubnetMask + "',AggregatedSwitch='" + AggregatedSwitch + "',AllocatedHostname='" + AllocatedHostname + "',VLANID='" + VLANID + "',HeadendName='" + HeadendName + "',DateIssued='" + DateIssued + "',Remarks='" + Remarks + "'";
stmt = conn.createStatement();
int i = stmt.executeUpdate(query);
System.out.println("query" + query);
if (i > 0) {
response.sendRedirect("adminHome.jsp");
}
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
}
}
Please help me, my code is not working, correct me if anythg wrong ,
Its urgent
Thanks in advance Lissy.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.