Forum:

JSP form with four inputs and one submit button

Ranch Hand

Posts: 47

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Everyone,

I need help to solve this problem, i want to search database based on 4 inputs, 2- form inputs and 2- selectboxes and one submit button in a JSP page....I am stuck here....please can anybody plzzz help me out :) , Just give me some idea or simple sample code would be great. This is very urgent for me.

Thanks in advance
Lissy.

Bear Bibeault

Sheriff

Posts: 67752

173

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

This doesn't seem to have much to do with JSP. Once the form is on the browser, it's just HTML.

The form action should address a servlet that can collect the submitted information and pass it to a model class that can perform the database manipulations.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

lisy jessica

Ranch Hand

Posts: 47

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks for the quick reply.....got some idea..will try.

Thanks
Lissy.

Deepak Bala

Bartender

Posts: 6663

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Do post a specific problem if you have one. We can move the post appropriately based on the area you need help in.

SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks

lisy jessica

Ranch Hand

Posts: 47

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

I tried this but not able to get it, I need to retrieve data from db based on 2 form inputs and 2 selectboxes with one submit button... here is my code

AutoAssign.jsp

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<HTML>
    <HEAD>
        <TITLE>Carrier Ethernet </TITLE>
    </HEAD>
    <BODY bgcolor="#99CCFF">
        <p> </p>
                <center>
        <td align="right" width=37> <strong><img title="Go back" src="Undo.gif" width="20" height="20" onClick="javascript:history.back()" style="vertical-align:middle;" onMouseOver="this.style.cursor='hand';"></strong>

<td align="right" width=38> <strong><img title="Print it" src="Print.gif" width="20" height="20" onClick="javascript:window.print()" style="vertical-align:middle;" onMouseOver="this.style.cursor='hand';">
        </strong>
        </center>
      <center><font size="+3" color="black"><br>Auto-Assigned IP Address</font></center>
        <FORM name="addform" method="post" action="retrieve.jsp">
            <TABLE ALIGN="center" style="background-color: #efefef;" WIDTH="30%" >
                <TR>
                    <TH width="50%">CABINET/EXCHANGE/TER</TH>
                    <TD width="50%"><INPUT TYPE="text" NAME="CABINET/EXCHANGE/TER"></TD>
                </TR>
           <TR>
                    <TH width="70%">FACING EXCHANGE</TH>
                    <td width="80%">
                        <center><select name="FACING EXCHANGE" value="FACING EXCHANGE"><option value=""> <---------Select---------> </option>
                        <option>AM</option>
                        <option>AR</option>
                        <option>BD03</option>
                        <option>BPN</option>
                        <option>ES2A</option>
                        <option>JW03</option>
                        <option>OC</option>
                        <option>TP</option>
                            </select>
                        </center></td>
                <TR>
                    <TH width="70%">EQUIPMENT TYPE</TH>
                    <td width="80%">
                        <center><select name="EQUIPMENT TYPE" value="EQUIPMENT TYPE"><option value=""> <----------Select---------> </option>
                                <option>PTN950</option>
                                <option>PTN1900</option>
                                <option>PTN3900</option>
                                <option>PTN910</option>
                            </select>
                        </center></td>
                </TR>
              <TR>
                    <TH width="50%">Remarks</TH>
                    <TD width="50%"><INPUT TYPE="text" NAME="Remarks"></TD>
                </TR>
                <TR>
                    <TH></TH>
                    <TD width="50%"><INPUT TYPE="submit" VALUE="submit">
                    <input type = "reset" name="Reset" value="Reset"><br> </TD>
                </TR>
            </TABLE>
        </FORM>
    </BODY>
</HTML>

retrieve.jsp

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%>
<HTML>
    <HEAD>
        <script language="javascript">
function editRecord(Cabinet){
window.location.href="editValueServlet?Cabinet="+Cabinet;
  }
function deleteRecord(Cabinet){
window.location.href="deleteData?Cabinet="+Cabinet;
  }
</script>
    </HEAD>
    <BODY bgcolor="#99CCFF">
        <p> </p>
<center>
<td align="right" width=37> <strong><img title="Go back" src="Undo.gif" width="20" height="20" onClick="javascript:history.back()" style="vertical-align:middle;" onMouseOver="this.style.cursor='hand';"></strong>

<td align="right" width=38> <strong><img title="Print it" src="Print.gif" width="20" height="20" onClick="javascript:window.print()" style="vertical-align:middle;" onMouseOver="this.style.cursor='hand';">
        </strong>
</center>
<H1 align="center">Carrier Ethernet</H1>
        <%
                    Connection connection = DriverManager.getConnection("jdbc:odbc:Database4");
                    ResultSet resultset;
                    Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
                    String Cabinet = request.getParameter("Cabinet");
                    String FacingExchg = request.getParameter("FacingExchg");
                    String EquipmentType = request.getParameter("EquipmentType");
                     String Remarks = request.getParameter("Remarks");
                    resultset = statement.executeQuery("SELECT Cabinet,FacingExchg,EquipmentType,NEID,IPAddress,LSR,VLANID,Remarks FROM carr_ethernet WHERE Cabinet='"+Cabinet+"' AND FacingExchg='"+FacingExchg+"' AND EquipmentType='"+EquipmentType+"'AND Remarks='"+Remarks+"'");
                        if (!resultset.next()) {
                        out.println("<br>");
                        out.println("<table align=\"center\" font=\"16\">");
                        out.println("<tr><th>Sorry, Could not find data</th></tr>");
                        out.println("</table>");

} else {
        %>
        <TABLE cellpadding="15" border="1" style="background-color: white" align="center">
            <TR>
                <TH>Cabinet</TH>
                <TH>Facing Exchange</TH>
                <TH>Equipment Type</TH>
                <TH>NE ID</TH>
                <TH>IP Address</TH>
                <TH>LSR</TH>
                <TH>VLAN</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>
                <TD><input type="button" name="delete" value="Delete" style="background-color:#ff0000;font-weight:bold;color:#ffffff;" onClick="deleteRecord('<%=resultset.getString(1)%>');"></TD>
            </TR>
            <%                        resultset.next();
                                    } while (resultset.isAfterLast() != true);

</TABLE>
        <BR>
        <%
                    }
        %>
    </BODY>
</HTML>

This code is not working...when i enter the values and click submit ...it gives me "sorry couldn't find data"...Please anyone lookinto my code and tell me ..where the prob is...I am really stuck. I even tried with servlet...but same output(Sorry couldn't find data). Please help me.

Thanks in advance
Lissy.

Stefan Evans

Bartender

Posts: 1845

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Standard responses
1 - Don't use scriptlet code in JSP. Java code belongs in servlets/beans.
2 - The JDBC-ODBC bridge driver is

. I suggest getting a real database, with a supported JDBC driver (MySQL, Oracle, MSSql...)
3 - When constructing sql statements with strings, you leave yourself open to sql injection attack. Instead your sql should use prepared statements to pass in the users values.

Specific to this code.
- You need to match up the names of your controls with the request parameters you are looking for.

For instance you have:

CABINET/EXCHANGE/TER <> Cabinet

The control "name" and the request parameter being retrieved must match.
I would suggest renaming the input components on AutoAssign.jsp to match what you have in the getParameter() calls in retrieve.jsp.

Suggested debugging steps
- print out the values of the search fields on your results page so that you can see they came through correctly.
- print out the sql generated to execute. Try running it on your database, and see what you get. Fiddle with it until you get sql that works, and then try translating the changes back to your code.

Things to think about
- are all your search parameters necessarily used to run the query? Particularly the remarks column will restrict the results too much I would think.
- consider writing the query logic into a java class. This code sample is based on patterns from 10 years ago. We've come a long way since then.

lisy jessica

Ranch Hand

Posts: 47

posted 13 years ago