ansaurus

Question

displaying data from database in to text box

Answer 1

A:

This is very dirty but you can add hidden INPUT tags in your form:

<INPUT type="hidden" name="p1" value="<%=rs.getString(1)%>">
<INPUT type="hidden" name="p2" value="<%=rs.getString(2)%>">

BTW: you should close your statement when no longer needed, otherwise you may use too much resources on the server.

Maurice Perry 2010-04-19 13:55:44

Answer 2

+2 A:

You're passing it as a request parameter with the name pcatid:

<FORM action="EditPcat.jsp?pcatid=p">

But you're trying to obtain it as a request parameter with the name p:

<%String s=request.getParameter("p"); %>

Align the names out.

That said, you tagged this question with servlets, but you aren't using servlets at all. This code is honestly said a disaster. Scriptlets are a poor practice and the JDBC code is leaking resources. Raw Java code belongs in Java classes, not in JSP files. Use taglibs like JSTL to control the page flow and use EL (Expression Language) to access backend data. Go through those tutorials to get it right.

Kickoff example:

public void doGet(HttpServletRequest request, HttpServletResponse response) {
    List<Project> projects = projectDAO.list();
    request.setAttribute("projects", projects);
    request.getRequestDispatcher("projects.jsp").forward(request, response);
}

and

<table>
    <c:forEach items="${projects}" var="project">
        <tr>
            <td>${project.id}</td>
            <td>${project.name}</td>
        </tr>
    </c:forEach>
</table>

BalusC 2010-04-19 13:57:59

ansaurus

tags:

views:

answers:

displaying data from database in to text box

related questions