getting and storing dropdown list in database in jsp

Home Answers Viewqa JSP-Servlet getting and storing dropdown list in database in jsp

aayushi saxena

getting and storing dropdown list in database in jsp
2 Answer(s) a year and 7 months ago
Posted in : JSP-Servlet

i have a drop down list to select book from database. i'm able to retrieve dropdown list from database. but unable to store the selected value in database table. please help ASAP else my boss will kill me :P :D

View Answers

November 1, 2011 at 11:34 AM

1)select.jsp:

<html>
<form method="post">
Select Programming Language:
<select name="lang">
<option value="C/C++">C/C++</option>
<option value="C#">C#</option>
<option value="Java">Java</option>
<option value="Perl">Perl</option>
<option value="Python">Python</option>
</select><br>
<input type="submit" value="Submit"><br>
</form>
</html>

2)insert.jsp:

<%@page import="java.sql.*"
<%
String selectedValue=request.getParameter("lang");
out.println("Selected Value is: "+selectedValue);
Class.forName("com.mysql.jdbc.Driver").newInstance();  
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  

Statement st=con.createStatement();
int i=st.executeUpdate("insert into data(language) values('"+selectedValue+"')");
out.println("Data is inserted successfully");

%>

November 1, 2011 at 11:39 AM

thanx for the quick response. i tried just lyk this. but it storing null value in the database. :\ what to do????

getting and storing dropdown list in database in jsp
getting and storing dropdown list in database in jsp i have a drop down list to select book from database. i'm able to retrieve dropdown list from... lyk this. but it storing null value in the database. :\ what to do

getting values from dropdown list
getting values from dropdown list I am having a dropdown list which... the database) My question is when i select a particular value it should be pass to the action. My action is getting called however, i am not sure how to pass

DropDown list
DropDown list how to get mysql database values into dropdown usign java servlet and ajax? Here is a jsp code that displays the database values into dropdown list. 1)country.jsp: <%@page import="java.sql.*"%>

jsp- database dependent dropdown list
jsp- database dependent dropdown list i want 2 dropdown list 1... suppose class a the corresponding section dropdown list should retrieve the section respective to that class from database. please help by providing the code in jsp

3 dropdown list from the database using JSP
3 dropdown list from the database using JSP Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP

how to add data dynamically from database into a dropdown list in a jsp
how to add data dynamically from database into a dropdown list in a jsp hi friends i am doing a project in jsp and oracle as my database.In my... in storing them into the database,this registration form contains name

JSP Get Data Into Dropdown list From Database
JSP Get Data Into Dropdown list From Database In this section we will discuss about how to fetch data dynamically into the dropdown list in JSP... data from the database and set it into the dropdown list in JSP using MySQL

struts dropdown list
struts dropdown list In strtus how to set the dropdown list values from database ? I have a ArrayList object and set this object in dropdown jsp page using struts ? please send me jsp code... sample code: **Action

dropdown list in jsp
dropdown list in jsp hai, i have static dropdown list.. i want to get the selected value in string variable without jsp regards asha

storing csv into oracle database
storing csv into oracle database i want jsp code for storing csv file into oracle database

getting problem in storing & retrieving value in database
getting problem in storing & retrieving value in database Hello everyone i am doing a project where my back end is ms access & i want to store value like 5353250214 so if i store it as long int in access it wont take it &

jsp -sevlet connecting to database using dropdown
jsp -sevlet connecting to database using dropdown How can I get my dropdown list from oracle database and then submit it to another table in JSP. I... to the database and fetches an array of strings from a database table and then sends

Uploading a Software and storing in the database
Uploading a Software and storing in the database I want to upload a software(may be of maximum 20mb) through JSP, and store it in the database. The coding present in the site for uploading and storing in the database

dropdown list in jsf
dropdown list in jsf I want to add a list box to display the country... then in the second list box it will display the states related to India only and the flow... with and without using database

Retrieval of Dropdown list
Retrieval of Dropdown list Hi frnds... Am having problem with the below code... I have retrieved data from the mysql database into dropdownlist ... for eg, let A1,A2,A3,A4 be the values in dropdown.. if i click A1

Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP
Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other... to create 3 drop dropdown list each depend on the other and get the options from the database using JSP. like country,state,city..please guide me

getting html list in a array
getting html list in a array hi i want to get html unordered list in a array using jsp

dropdown list and text fields in php
dropdown list and text fields in php How could I use php to populate text fields by selecting a name of a business from dropdown list? Those text... number, description, and opening times from a mysql database. If you can, post

dropdown in struts - Struts
dropdown in struts how to populate a drop down from database entries in struts application when i have the workflow as jsp->acton->Business... write the query (in which file)to get the list from database and how and where

inserting dropdown values into database table
inserting dropdown values into database table hi i want to insert dropdown values into a database table by using jsp

Dropdown menus onchange atribute
from database and store it into dropdown list. On selecting the value from... the data from database and stored it into dropdown list. On selecting the value from... down list from database? I want to select a type of vehicle from a drop down

dropdown box
dropdown box i need to have country,state and city in drop down box using ajax and use db2 database Have a look at the following link: JSP dependent dropdown

List
List getting values from a form and make a list of them and store them into database

creating dropdown lists in jsp
creating dropdown lists in jsp i want to create two dropdown list which are dependent that is the first box choice have to evaluate the second boxs options

DropDown Department Login
DropDown Department Login Hi all, I am doing a project using JSP. My Issue is..... I have two departments name Customs and Accounts in the database... a drop down list consisting of Customs and Accounts. I have user accounts of both

jsp dropdown - JSP-Servlet
jsp dropdown in my table there are 3 fields named orderid ,itemname, itemqty. i want code that fetch orderid in dropdown... on select dropdown get all items list of that orderid... there are multiple items at one orderid

jsp dropdown - JSP-Servlet
jsp dropdown print dropdown selected value in same page without refreshing page in jsp.... Hi Friend, Try the following code: 1... to use this textbox value to fetch values from database

dropdown
dropdown I have a dropdown having 2 options-"Open"& "closed".When i select "open" option the related rows of data are retrieved from database and same with the other option.My database is Mysql and coding in PHP

getting dropdown values using apache commons in servlet
getting dropdown values using apache commons in servlet i want to get dropdown values in my program in order to merge the string to my file path so...); } i tried to debug and i am getting the wright file path but while proceeding

creating list in dropdown using struts - Struts
creating list in dropdown using struts creating list in dropdown using struts : In action class list.add(new LabelValueBean("ID","Name")); In Jsp * Select Item Select In Form : getter

Dropdown Checkbox list
Dropdown Checkbox list This tutorial explains how to create jquery Dropdown Checkbox list in JSP. This example is created in eclipse IDE and run... jquery Dropdown Checkbox list. The application directory structure should look like

store dropdown box values in database server
store dropdown box values in database server how to store dropdown box values in database server in jsp

DropDown Menu
DropDown Menu Hello, i have a program that can view,add,delete... me draw to your my mind my program.. in my homepage which i have a dropdown menu that has the list of Page 1- Page 5. if i select page 1 it will display only

how to use dropdown list in JSP and display value in same page
how to use dropdown list in JSP and display value in same page I have a Dropdown list with some values say "A", "B" and "C" When the user selects... in the same page Value selected = C How can we do this in a JSP page

Inserting values into a database table of selected DropDown in jsp.
Inserting values into a database table of selected DropDown in jsp. http://www.roseindia.net/answers/viewqa/Ajax/15250-DropDown-in-ajax+jsp.html Thank you for this program, it helped me alot to learn. I have done it. now i want

jsp dropdown refresh - JSP-Servlet
jsp dropdown refresh Sir Thank u for your jsp code for dependent dropdown list, i used it in different table for data extraction but the probleam during data extraction when i select first drop down its refresh then 2nd

dropdown - JSP-Servlet
dropdown i want to use dropdown select value in query-string in same page.. Using selected 'name' want to fetch details of that person from database.. without using Ajax... Hi Friend, Try the following code

How to access Contacts from gmail using LDAP in JSP dropdown list
How to access Contacts from gmail using LDAP in JSP dropdown list HI, I am creating a JSP page in which i have to make a dropdown box, and access gmail contacts in that drop downlist using LDAP. Can any one plz help me out

jsp code for storing login and logout time to an account
jsp code for storing login and logout time to an account I need simple jsp code for extracting and storing login and logout time in a database table...://www.roseindia.net/jsp/loginstatus.shtml

retrive the data from access database to drop down list box in jsp
retrive the data from access database to drop down list box in jsp hai, im new to jsp now im using the jsp along with access database.in table i load all the data's i need to retrive the data from database to dropdown list box

Storing and Reading data
Storing and Reading data Hello, I'm developing a GUI application... = new JFrame("Getting Cell Values in JTable"); JPanel panel = new JPanel(); String... that inserts jtable data to database. import javax.swing.*; import javax.swing.table.

jsp
to use two dropdown list. in first dropdown list i am getting data from sql server database. in second dropdown list i want to get data according to selection made in first dropdown list and it will also come from ms-access database

storing details in database on clicking submit button - JSP-Servlet
storing details in database on clicking submit button I am using JSP... database on clicking submit button. I am unable to do this.Can u tell me how to code...? JSP Page Name

help to select a value from the dropdown list
help to select a value from the dropdown list I have a html file...;/html> I also have a jsp file called SearchIndex.jsp which is shown below <jsp:useBean id="sessionBean" scope="session" class="com.spl.hms.SessionBean

dropdown - JSP-Servlet
dropdown i want to use dropdown select value in query-string in same page.. Using selected 'name' want to fetch details of that person from database.. Hi Friend, Try the following code: 1)ajaxExample.jsp

DropDown in ajax+jsp
DropDown in ajax+jsp I have four dropdown if i select first dd... dropdown. You can create the fourth one similarly. For the above code, we have used 3 database tables: 1)country CREATE TABLE `country

Getting Null pointer Exception in the jsp page
Getting Null pointer Exception in the jsp page I have developed this jsp page to store the data in database.While storing the value of check box in database I am getting null pointer exception in the following code

Latest
Frameworks
Category