Java

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);

} %>

Edit User
IP Address
Subnet Mask
Aggregated Switch
Allocated Hostname
VLAN ID
Headend Name
Date Issued
Remarks

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.