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

1319

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

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

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

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

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

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

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

Similar topics