How to Keep selected value and Fetched value in same dropdownbox in jsp???

i ve fetched value from database and show them in dropdown box after i select the value from dropdown i submit tht value by using this.form.submit(). thn finally the dropdown box show the selected value.. but i want to show the selected value and the fetched value also.. anyone help me...

Here is my Code

Expand|Select|Wrap|Line Numbers

 <%@ page language="java" contentType="text/html; charset=ISO-8859-1"

    pageEncoding="ISO-8859-1"%>

            <%@ page import="java.sql.*" %>

        <%@page import="java.util.Date"%>

                <%@ page import="java.math.*" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head><h3>Invoice Details</h3>

<body>

<%

String name=request.getParameter("bname");

//System.out.println("name"+name);

String size=request.getParameter("bsize");

//System.out.println("size"+size);

String qty=request.getParameter("quantity");;

Date date=new Date();
 
String availablequantity=(String)request.getAttribute("quantity");

//System.out.println("quantity"+availablequantity);

String invoice=request.getParameter("invoice");
 
String newqty=(String)request.getAttribute("up1");

//System.out.println(invoice);

try{
 
    Class.forName("org.postgresql.Driver");

    Connection con=DriverManager.getConnection("jdbc:postgresql://192.168.1.2:5432/tlsagencies","ihisblank","ihisblank");

    Statement s1=con.createStatement();

    Statement s2=con.createStatement();

    Statement s3=con.createStatement();

    Statement s4=con.createStatement();

    Statement s5=con.createStatement();

    Statement s6=con.createStatement();

    Statement s7=con.createStatement();

    Statement s8=con.createStatement();

    Statement s9=con.createStatement();

    Statement s10=con.createStatement();

    Statement s11=con.createStatement();
 
    String x="Select Size";

    //System.out.println("qwadsasdasd"+x);
 
    ResultSet r1=s1.executeQuery("select brandname from brandlist");

    %>

<form action="Table.jsp" method="get"><table><div><tr><td>BrandName:</td><td><select name="bname" onchange="this.form.submit()" id="bname">

<%if(name!=null)

{

%>

<option value="<%=name %>"><%=name %></option>

<%

}

%>

<%if(name==null)

    {%>

    <option value="0">Select Brand</option>

    <%

    while(r1.next())

    {
 
    %>

<option value="<%=r1.getString("brandname") %>"><%=r1.getString("brandname") %></option>

<%

}

    }

    %>
 
</select></td></tr></div>

<div><tr><td>BrandSize:</td><td><select name="bsize" onchange="this.form.submit()" id="bsize">

<% if((size!=null)&&(name!=null))

{

%>

<option value="<%=size %>"><%=size %></option>

<% 

}
 
 if((size==null)||(name!=null))

 {
 
    ResultSet r2=s2.executeQuery("select brandlist_seq from brandlist where brandname='"+name+"'");

    if(size==null){

    %>

<option name="0">Select Size</option>

                        <%

    }

    while(r2.next())

    {

        request.setAttribute("bseq", r2.getString("brandlist_seq"));
 
        ResultSet r3=s3.executeQuery("select sizelist_seq from stockdtl where brandlist_seq='"+r2.getString("brandlist_seq")+"'");

        while(r3.next())

        {

            request.setAttribute("sizeseq", r3.getString("sizelist_seq"));

            ResultSet r4=s4.executeQuery("select brandsize from sizelist where sizelist_seq='"+r3.getString("sizelist_seq")+"'");
 
            while(r4.next())

            {

                String bsize=r4.getString("brandsize");

    //    request.setAttribute("brandsize", bsize);

                %>

                <option value="<%=bsize %>"><%=bsize %></option>

            <%}

            }

            }

            }

            %>

</select></td></tr></div>

<%if((size==null)||(size.equals(x)))

{

    %>

    <div><tr><td>Available Quantity:</td><td><input type="text" name="quantity" value="<%=qty%>" id="quantity" readonly></td></tr></div>

    <%
 
}
 
else

{

ResultSet r5=s5.executeQuery("select brandlist_seq from brandlist where brandname='"+name+"'");

while(r5.next())

{

    request.setAttribute("bseq", r5.getString("brandlist_seq"));

}

ResultSet r6=s6.executeQuery("select sizelist_seq from sizelist where brandsize='"+size+"'");

while(r6.next())

{

    request.setAttribute("sseq", r6.getString("sizelist_seq"));

}

String brandseq=(String)request.getAttribute("bseq");

String sizeseq=(String)request.getAttribute("sseq");
 
//System.out.println(brandseq);

//System.out.println(sizeseq);

ResultSet r7=s7.executeQuery("select quantity from stockdtl where brandlist_seq='"+brandseq+"' and sizelist_seq='"+sizeseq+"'");

while(r7.next())

{

    String availablequantity1=r7.getString("quantity");

    //System.out.println(availablequantity1);
 
    request.setAttribute("quantity", r7.getString("quantity"));
 
    %>
 
<div><tr><td>Available Quantity:</td><td><input type="text" name="quantity" value="<%=availablequantity1%>" id="quantity" readonly></td></tr></div>

<%}
 
}
 
%>

<div><tr><td>Invoice Quantity:</td><td><input type="text" name="invoice"></td></tr></div>

<tr><td></td><td><input type="submit" value="submit"></td></tr>

</table></form>

<%if((invoice!=null)&&(invoice!=""))

    {

String brandseq=(String)request.getAttribute("bseq");

String sizeseq=(String)request.getAttribute("sseq");

//System.out.println(brandseq);

//System.out.println(sizeseq);

ResultSet r=s11.executeQuery("select quantity from stockdtl where brandlist_seq='"+brandseq+"' and sizelist_seq='"+sizeseq+"'");

while(r.next())

{

    String quant=r.getString("quantity");

    request.setAttribute("quantity", quant);

}

String qq=(String)request.getAttribute("quantity");

//System.out.println("new"+qq);
 
    ResultSet r8=s8.executeQuery("select stock_seq from stockdtl where brandlist_seq='"+brandseq+"' and sizelist_seq='"+sizeseq+"'");

    while(r8.next())

    {

        int is=s9.executeUpdate("INSERT INTO invoicedtl(stock_seq, created_date, invoice_qty)  VALUES ('"+r8.getString("stock_seq")+"','"+date+"','"+invoice+"');");
 
    }

    //int update=((Integer.parseInt)availablequantity)-((Integer.parseInt)invoice);

//    Integer.valueOf(availablequantity)-(Integer.valueOf(invoice));
 
int qt=Integer.parseInt(qq);
 
//System.out.println("qty"+availablequantity);

int in=Integer.parseInt(invoice);

int newqt=qt-in;

//System.out.println(newqt);

String updatedquantity=Integer.toString(newqt);

request.setAttribute("up1", updatedquantity);
 
//System.out.println(updatedquantity);
 
//    int iss=s10.executeUpdate("UPDATE stockdtl  SET quantity='"+updatedquantity+"'   WHERE brandlist_seq='"+brandseq+"' and sizelist_seq='"+sizeseq+"';");
 
    }
 
    %>
 
<%

}

catch(Exception e)

{

}%>
 
</body>

</html>

Attached Files

new.txt (6.1 KB, 255 views)

Jun 12 '15 #1

Subscribe Post Reply

1320

chaarmann

785

Expert 512MB

I do not understand. How can you show "fetched" value (whatever that is) and selected value? You can only show one value! If you want to show two values at the same time, then you need a list and not a dropdown box!
Like that:

Expand|Select|Wrap|Line Numbers

 <select multiple>

  <option selected>entry1</option>

  <option>entry2</option>

  <option selected>entry3</option>

  <option>entry4</option>

</select>

Jun 15 '15 #2

by: Lisa | last post by:

I have a drop down that defaults to "select" after the page refreshes. How do I keep the selected value in the dropdown field... I've tried EVERYTHING and nothing works! :( <script...

ASP / Active Server Pages

Drop Down refresh keep selected value

by: Patrick | last post by:

Hello, I have a drop down list that when a value is selected the page refreshes itself but the selected value changes back to the default value. I would like to keep the selected value after the...

Javascript

returning the selected value of a listbox control inside a user control - please urgent!

by: Moe Sizlak | last post by:

Hi There, I am trying to return the value of a listbox control that is included as a user control, I can return the name of the control but I can't access the integer value of the selected item,...

ASP.NET

unable to get selected value of listbox control when clicking button?

by: Joey | last post by:

Hi There, I am trying to get the selected value of a listbox when I click a button, everything works ok and I can bind the list and when I have a basic page and click a button to invoke a sub it...

ASP.NET

selected value databinding for DropDownBox in gridview is Disabled

by: CorporateCoder | last post by:

Hi, I am trying to bind the selected value of a databound dropdown box in a databound gridview control to the value being displayed in the template column the dropdown box has been added to. ...

ASP.NET

Problem with retrieving the selected value in a dropdown list

by: yasodhai | last post by:

Hi, I used a dropdown control bind to a datagrid. <EditItemTemplate> <asp:DropDownList ID="FldType_edit" Runat="server" DataSource='< %#GetFieldType()%>' DataTextField="Type" />...

ASP.NET

Js function to change respecive cell value onchange selected value of dropdown value

by: tarunkhatri | last post by:

Hi. I have a javascript function to change the value of the cell on chnage event of a dropdown list.My code is workin but the problem is that the value of the cell is chaning but not respective to...

Javascript

How to fill listbox with multiple selected value from SQL database

by: polluxsoftech | last post by:

HI, I have 1 listbox named lbCountry i have inserted each selected value from listbox into database by following code: For iLoop = 0 To lbCountry.Items.Count - 1 ' item selected Dim i...

ASP.NET

how to use view state to keep selected value in user control?

by: ahmedelbahar66 | last post by:

how to use view state to keep selected value of dropdownlist in user control displayed in masterpage. when postback occur thae selected value of dropdownlist is cleared i dont know the reason !

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

How to Keep selected value and Fetched value in same dropdownbox in jsp???

Similar topics