Populate textbox fields when selections made in combo box

I have a jsp page

these are three formfields
itemsr : --it is a combobox
itemtype : --textfield
itemname : --textfield

to itemsr i have to populate from itemtable(database mysql) and by on change event when the option is changed in itemsr the corresponding itemtype and itemname from the itemtable should be displayed inside the textfield.
I want detail code of it

Nov 7 '07 #1

Subscribe Post Reply

3608

acoder

16,027

Expert Mod 8TB

You can't expect someone to do all the work for you.

Post what code you have so far and we can suggest changes.

This has already been asked a number of times. You have two choices: either you want to load everything during page load and use arrays to store the data which is populated dynamically onchange, or you use AJAX to retrieve the data each time from the server.

Nov 7 '07 #2

vidyagopal

this is my code

Expand|Select|Wrap|Line Numbers

 <body>

            <html:form action="/pur">
 
            itemsr : <html:select  property="itemsr">

                       <%try{

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection con=DriverManager.getConnection("jdbc:odbc:dsn2","root","root");

            Statement st=con.createStatement();

            String sq="select it_sr from bs_invent_items";
 
            ResultSet rs1= st.executeQuery(sq);
 
        while(rs1.next()){

             String s1=rs1.getString(1);

          out.println("<option>"+s1+"</option>");    

          }

           rs1.close();
 
           st.close();

            con.close();
 
        }

        catch(Exception e)

        {

            System.out.println(e);

        }          

             %>

             </html:select><br/> 
 
            itemtype : <html:text   title="itemtype" property="itemtype"/><html:errors property="itemtype"/><br/>

            <SCRIPT type="text/javascript">

            try{

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            Connection con=DriverManager.getConnection("jdbc:odbc:dsn2","root","root");

            Statement st=con.createStatement();
 
             HttpSession ses =request.getSession(true);

  String idd = ses.getValue("id").toString();
 
            String sq="select it_type from bs_invent_items where it_sr='"+idd+"'";

            System.out.println(sq);

            ResultSet rs2= st.executeQuery(sq);
 
        while(rs2.next()){

             String s1=rs2.getString(2);
 
          }
 
           rs2.close();
 
           st.close();

            con.close();
 
        }

        catch(Exception e)

        {

            System.out.println(e);

        }   

        document.getElementById("itemtype").innerHTML = "+s1+"; 
 
            </SCRIPT>

any i have populated itemsr from the database but by onchange event when the option of the itemsr is changed ,the field itemtype should get the value from database where itemsr is that selected option.

I have taken the value of item sr throug session.session is also notworking .How to put a sessionvariable in javascript

Nov 7 '07 #3

acoder

16,027

Expert Mod 8TB

Do you have any experience or are you willing to learn AJAX?

Nov 7 '07 #4

vidyagopal

I am very new to ajax therefore i am unable to proceed further

Nov 12 '07 #5

acoder

16,027

Expert Mod 8TB

I am very new to ajax therefore i am unable to proceed further

Have a look at this simple example to get you started. If you have any problems, post again here and we'll try to solve it.

Nov 12 '07 #6

Similar topics

Odd Behavior Of Combobox and Textbox

by: Steve | last post by:

I have an unbound combobox in the form header of a continuous form. The selection in the combobox sets the where clause in a querydef which determines QryPFrmInventoryManagement. The following code...

Microsoft Access / VBA

Help in Linking Fields

by: Megan | last post by:

hi- i have a table, case, that i'm to normalize. for example, the table, case, has the following fields- caseid = primary key issue1 = number issue1desc = text issue2 = number

Microsoft Access / VBA

Populate text boxes with combo box selection

by: godber | last post by:

I need to populate text boxes for instance with employee information using their unique employee works number selected from a combo box. Can anyone help, I am told thru visual basic this can be...

Microsoft Access / VBA

user to add two fields of his choice to the query

by: commodityintelligence | last post by:

Greetings, I am merging a series of different tables into one query to export decision-making information. I have some architecture issues I need to ask for help on. I have no programming...

Microsoft Access / VBA

Data Binding to Textbox

by: Peter | last post by:

Hi, I'm trying to create a form that shows table rows in a listbox. Several comboboxes expand the foreign key fields into text values from the parent tables, and there are also some textboxes...

Visual Basic .NET

Populate Form through a series of Combo Box selections

by: Robertjb1 | last post by:

First Post - New member - I've searched the discussions available to no avail. I have, however, learned a few things in doing so. (Great Site -- Thanks) My issue is as follows: Access 2003/WinXP...

Microsoft Access / VBA

Populate 2nd Form Control and Table

by: KMEscherich | last post by:

Using Access '97 Hi there, am wondering if someone can please help me with the following: I have a master table (T_INVESTIGATION) that contains the following fields as well as other fields. ...

Microsoft Access / VBA

Auto populate a field based on selection from Combo box

by: whamo | last post by:

I have the need to populate a field based on the selection in a combo box. Starting out simple. (2) tables tbl_OSE_Info and tbl_Input; tbl_OSE_Info has three fields: Key, OSE_Name and OSE_Wt...

Microsoft Access / VBA

Populate Pull down menu from access database on selection of previous pull down menu

by: giandeo | last post by:

Hello Experts. Could you find a solution for this problem please! I have the following tables in Access Database Table Name: origin Fields Names: country, countrycode Table Name: make...

Javascript

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

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

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

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

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

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++

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