jsp code for a drop down box to retrive value from database

Home Answers Viewqa JSP-Servlet jsp code for a drop down box to retrive value from database

Abinesh

jsp code for a drop down box to retrive value from database
2 Answer(s) a year and 2 months ago
Posted in : JSP-Servlet

my project needs to get the value from database in to the drop down box..... pls give me code for that ..... tan q

View Answers

April 4, 2012 at 3:25 PM

1)login.jsp:

<html>
<script>
function validate(){
var username=document.form.user.value;
var password=document.form.pass.value;
if(username==""){
 alert("Enter Username!");
  return false;
}
if(password==""){
 alert("Enter Password!");
  return false;
}
return true;
}
</script>
<form name="form" method="post" action="check.jsp" onsubmit="javascript:return validate();">
<table>
<tr><td>Username:</td><td><input type="text" name="user"></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass"></td></tr>
<tr><td>Select Company: </td><td>
<select name="com">
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from login");
           while(rs.next()){
           %>

<option value="<%=rs.getString("company")%>"><%=rs.getString("company")%></option>
<%
           }
%>
</select>
</td></tr>
<tr><td></td><td><input type="submit" value="Login"></td></tr>
</table>
</form>
</html>

2)check.jsp:

<%@page import="java.sql.*"%>
<%
try{
String user=request.getParameter("user");
String pass=request.getParameter("pass");
String com=request.getParameter("com");
 Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from login where username='"+user+"' and password='"+pass+"'and company='"+com+"'");
           int count=0;
           while(rs.next()){
           count++;
          }
          if(count>0){
           out.println("welcome "+user);
           }
          else{
           response.sendRedirect("login.jsp");
          }
        }
    catch(Exception e){
    System.out.println(e);
}
%>

April 8, 2012 at 10:58 AM

this code is not running exactly... i am getting a blank page while running check.jsp and the value of company is not fetched ..the dropdown is shown empty ... thanks in advance ...

jsp code for a drop down box to retrive value from database
jsp code for a drop down box to retrive value from database my project needs to get the value from database in to the drop down box..... pls give me code for that ..... tan q 1)login.jsp: <html> <script>

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

dependent drop down box - JSP-Servlet
dependent drop down box haloo sir Please give me the solution how to extract data from dependent drop down box with page refresh...; window.location.replace("http://localhost:8080/examples/jsp/dependentDropdown.jsp?id="+cid+"&&value

jsp login code ... when username , drop down box and password is correct
value is correct.... the drop down box values should be retrieved from database...jsp login code ... when username , drop down box and password is correct ....... the value is retrieved from database into combo box..... but the validation

Login With Drop Down
using the drop down box and the Username and passwords must match with the Database...Login With Drop Down Hi all, I am doing a project using JSP. My... the departments. Now, my intention is to select the department from the drop down

JSP Dependent Drop Down Menu
JSP Dependent Drop Down Menu Hey Guy/Gals! I need someone help to guide me in creating a drop down menu, where the first menu affects the second...; The given code will help you to create a dependent dropdown box. 1

how to retrieve the id value itself from the access database to drop down listbox in jsp
how to retrieve the id value itself from the access database to drop down listbox in jsp how to retrieves the id which is an int datatype, from access database to drop down list box in jsp...plz send the code for that.....plz

dynamic drop down list
on the value chosen from the previous. want code in javascript and jsp, Can you help...dynamic drop down list I want to create 2 drop down list, where it takes value from database and the two list are dependent..means if I select

Drop down list from database
Drop down list from database Hi, Can I know how do we get the drop down list from database? Eg: select country--select state--select district--so... * from country"); while(rs.next()){ %> <option value="<

how to import values from database to the drop down box
how to import values from database to the drop down box hi iam... employee page i kept a drop down box for employee Ids i want all employee IDs will display in the drop down box please help me with the code

Drop down and radio button value on edit action
Drop down and radio button value on edit action HI, I have a title field and a payment type field for title i have used drop down with values... i get the value from the database for title and radio button selected

jsp drop down-- select Option
jsp drop down-- select Option how to get drop down populated... code populate the second dropdown on selecting the value from the first...) in database and try the following code: <%@page import="java.sql.*"%> <html>

drop down box - JSP-Servlet
drop down box when i enter some letter in the input box,the corresponding words of that particular letter must be displayed below as a list from the data base in the same input box as drop down. Thanks&Regards, VijayaBabu.M

insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql can... data into database using an drop down box .....as i m using eclipse as jdbc...=conn.createStatement(); ResultSet rs=st.executeQuery("select name from

store values of drop down list box in database
store values of drop down list box in database how to store values of drop down list box in oracle database in jsp?I have information inserting form where i have date of birth as drop down list box

Login With Drop Down, Having Departments in different table
is to select the department from the drop down box and then login to the page. I have a drop down list box with Customs and Accounts..A Username and a Password field.Now want to login to the page by selecting the drop down box. Suppose

Dependant & dynamic drop down list
Dependant & dynamic drop down list I don't know this should be in this or AJAX forum. I have one dynamic drop down list from data base (working...`)); This will select only ONE row (country) from first drop down. In my case

dynamic drop down list box - Java Beginners
dynamic drop down list box hi all , I want to dynamically populate a drop down box from an sql query in a servlet program, using only html & javascript. Is this possible without some kind of server side code? If so, please

dynamic drop down
into the designation drop down (use jsp+javascript+servlet) reply soon 1...dynamic drop down I have created 2 drop downs in jsp.1...; <select onchange="showDesig(this.value)"> <option value="none

Ajax drop down and textbox
Ajax drop down and textbox hie frnds I have a dropdown menu in the 3 options(1,2,3) are there if i choose 1 then I should get 1 text box if i select... menu consisting of options 1,2,3. When the user select any option from

Dependent drop down list
dependent drop down list is used my code is successful but when i select class from first drop down list all the data get lossed means the value entered in fields before drop down list get blank.what can i do for this? This is the code

Get values in drop down list
Get values in drop down list Pls provide me jsp code to get values in drop down list from another table's field. my project has customer... in drop down box in front end..... pls provide me code.. thanx

how to set a value of dynamic number of drop down lists on a jsp page and access it value on another jsp page
how to set a value of dynamic number of drop down lists on a jsp page... number of drop down lists(depending upon number of books in that category) on jsp... ,rating2......number of buks in that category(and each drop down list has value

to update drop down list value when selected from website
to update drop down list value when selected from website hi help me, i want to insert value into db when i select from a drop down list, this is my code, <div id="age"> Age <select name='NEW'> <option

Drop Down reload in IE
Drop Down reload in IE Hi i was using two drop down box..One... from the 2nd drop down then the 1st drop down ( which is date) automatically loads to 1 which is first value..This is the problem im facing in IE but it works

retrive data from database?
retrive data from database? hellow i have a database sheet name... from db1 and enter value in text box according there name,rollno and save..... now i want retrive sn,roll no and name and textbox like

Dependant & dynamic drop down list - Follow up
Dependant & dynamic drop down list - Follow up Thanks for your answer. As per your answer This will select only ONE row (country) from first drop...){ System.out.println(e); } %> For the above code, we have created two database tables

data should not repeat in the drop down list when it is loading dynamically from database
the whole department field from the data base (i.e in the drop down list...data should not repeat in the drop down list when it is loading dynamically from database hi friends the below code is working correctly

how can retrive value from combo box in servlet?
how can retrive value from combo box in servlet? i have a jsp page with combobox. And i want to get value from combox to servlet

Pls provide me jsp code to get values in drop down list from another table's field....
Pls provide me jsp code to get values in drop down list from another table's... in customer registration page and should be shown in drop down box in front end..... pls provide me code.. thanx

view data from database using drop down list
view data from database using drop down list hi i want to view the data from database by selecting a value in a drop down list. for an example drop down list have picture element.when click it select pictures from the database

To retrive data from database - Struts
To retrive data from database How to get values ,when i select a select box in jsp and has to get values in textbox automatically from database? eg... come to jsp page automatically from database

displaying section in the jsp based on the sected value in drop down - Java Beginners
displaying section in the jsp based on the sected value in drop down Hi friend, i have one problem in my jsp. i.e i have to display section on the jsp based on the selected value in the drop down list using java script code

By dropdownlist retrive data from database and show in textbox in jsp.
By dropdownlist retrive data from database and show in textbox in jsp. Hello Sir, I am doing project in jsp.I have to retrive data from database, when I select value from dropdownlist, and that data I want to show in textbox

List Box - JSP-Servlet
List Box sir i am developing webb application.am using drop down list box.on selecting one value in list box,i will retrieve values from database... box related to list box 1 value. Hi Friend, To run this code we

jsp login code when username , password and dropdown box value is correct...
jsp login code when username , password and dropdown box value is correct........ but in the drop down box ... i need to get the values from backend... value(i.e)company name should match.... pls provide code.... thanx 1

Drop-down text selection in jsp/html
Drop-down text selection in jsp/html Hi, I am trying to create JSP page where I have two drop-downs. There are two-sets of data - First set.... Now the first dropdown will have all the values. The second drop-down depends upon

populating text box using jsp code
populating text box using jsp code Sir, How to populate related values in a text box after selecting value from drop down list using JSP and mysql.... Please give an example using jsp code only. dependentDropdown.jsp

How to retrive an inmage from database and displaying it in imgae box - Swing AWT
How to retrive an inmage from database and displaying it in imgae box ...? I want to retrive an image from database and to display it in a small imagebox...(); f.setTitle("Display Image From database"); Image image = f.getToolkit

Drop Down Box
Drop Down Box In a Drop Down box I want to show the user All the Country In the World. And when he type A-z,then each of the type Show those country which start with those word. Like I For-India

insert and retrive image from sql server database in jsp
insert and retrive image from sql server database in jsp what is the code to insert and retrive an image from sql server database in jsp

Select functionality of drop down list - Struts
Select functionality of drop down list Hi, I have to write a code(in struts application) in which if user select HIDE from the drop down list... have Drop down list having element Test1,Test2,Test3,HIDE and one Text msg box

data should not repeat in the drop down list when it is loading dynamically from database
data should not repeat in the drop down list when it is loading dynamically from database selDept.jsp <%@page import="java.sql.*"%>...; <option value="none">Select</option> <

code for insert the value from jsp to access database
code for insert the value from jsp to access database code for insert the value from jsp to access database

Latest
Frameworks
Category