loading data from sql server database in a drop down menu using jsp

Question

anindo87 0 Newbie Poster

14 Years Ago

hello evryone.
please someone help me. I want to load the data frm sql server database at the button click...how to load the data using resultset rs.getString("column name") in the <option></option> tag using JSP codes??

jsp

5 Contributors
15 Replies
457 Views
1 Week Discussion Span
Latest Post 14 Years Ago Latest Post by anindo87

All 15 Replies

hkansal 0 Newbie Poster

14 Years Ago

use JSP expressions:

<option><%=varName %></option>

or scriptlets:

<option><% out.print(varName); %></option>

expressions are advised

kvprajapati 1,826 Posting Genius

14 Years Ago

anindo87, ...but i'v tried ths code....it isn't working.... hkansal has wrote an expression for you. Post your source code. Use BB code tags.

peter_budo 2,532 Code tags enforcer

14 Years Ago

hello evryone.
please someone help me. I want to load the data frm sql server database at the button click...how to load the data using resultset rs.getString("column name") in the <option></option> tag using JSP codes??

The answer can be found in sticky post of JSP section

kvprajapati 1,826 Posting Genius

14 Years Ago

HTML tag - </select> must be placed outside the while loop.

show.innerHTML = "<label><select name='select'><% while(rs.next()){%><option><%= rs.getString(1) %></option><option><%= rs.getString(2) %></option><option><%= rs.getString(3).substring(0,10) %></option><%}}catch(Exception ex){out.print("Exception is:- "+ex);}%></select></label>";

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

anindo87 0 Newbie Poster · Answer 1 · 2009-07-11T09:19:54+00:00

use JSP expressions:
<option><%=varName %></option>
or scriptlets:
<option><% out.print(varName); %></option>
expressions are advised

thanx so much for taking interest...but i'v tried ths code....it isn't working....

anindo87 0 Newbie Poster · Answer 2 · 2009-07-11T22:32:05+00:00

as suggested by adatapost here i'm posting the code which i used...

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<% 
		Connection con=null;
		ResultSet rs=null;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:p_portal");
			Statement stat=con.createStatement();
			String sql="select * from message_box where name='anindo'";
			rs=stat.executeQuery(sql);
			%>
<script language="javascript">
function check()
{
	var show=document.getElementById("mydivtag");
	show.innerHTML = "<label><select name=select><% while(rs.next()){%><option><%= rs.getString(1) %></option><option><%= rs.getString(2) %></option><option><%= rs.getString(3).substring(0,10) %></option></select></label><%}}catch(Exception ex){out.print("Exception is:- "+ex);}%>";
}
</script>
</head>
<body>
<form id="form1" name="form1" method="post" action="try.jsp">
  <label></label>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <input type="submit" name="Submit" value="Submit" onclick="check()" />
	  </p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
   

   </p>
  <div id="mydivtag" ></div>
  <p>&nbsp;</p>
</form>
</body>
</html>

i have used p_portal as the dsn and the database table message_box described as below..

name varchar 50
from varchar 50
subject varchar 1000
date datetime 8

i hope the code will make the things very clear.....

anindo87 0 Newbie Poster · Answer 3 · 2009-07-12T20:53:20+00:00

hello adatapost...

i'v modified the code....but still there's a problem

when i'm clicking the button......a drop down menu wid the loaded data is appearing but as soon as the page is fully loaded the drop down menu disappears....i'm not getting hold of this problem....

kvprajapati 1,826 Posting Genius Team Colleague · Answer 4 · 2009-07-13T06:47:48+00:00

Close the connection.

rs.close();  // release the result
  st.close();
  cn.close();

CoSIS1 0 Newbie Poster · Answer 5 · 2009-07-14T11:19:44+00:00

indeed , am not using MVC structure but i have done what you want before, you can take a look

<select name="select" size="1" >
<%
 String sql = "select *from  table ";

   Vector v1=database.jdbcMultipleRowQuery(sql);
	for(int i=0;i<v1.size();i++){
	Vector  v2 = (Vector)v1.elementAt(i);
for(int j=0;j<v2.size();j++){

out.print("<option>"+v2.get(0)+"</ption>");		
		
}
}
%>

it may help

anindo87 0 Newbie Poster · Answer 6 · 2009-07-15T09:48:44+00:00

indeed , am not using MVC structure but i have done what you want before, you can take a look

<select name="select" size="1" >
<%
 String sql = "select *from  table ";

   Vector v1=database.jdbcMultipleRowQuery(sql);
	for(int i=0;i<v1.size();i++){
	Vector  v2 = (Vector)v1.elementAt(i);
for(int j=0;j<v2.size();j++){

out.print("<option>"+v2.get(0)+"</ption>");		
		
}
}
%>

it may help

thanx CoSIS1 i'l use this code....i guess this will work.....

anindo87 0 Newbie Poster · Answer 7 · 2009-07-15T10:05:36+00:00

hello adatapost.....its i closed the connection but still the same problem s occurring........when the page s fully loading the drop down menu disappers.......what xactly s the problem???

kvprajapati 1,826 Posting Genius Team Colleague · Answer 8 · 2009-07-15T10:12:27+00:00

anindo87,
Post your latest code (page). Wrap the source code with bb code tags.

anindo87 0 Newbie Poster · Answer 9 · 2009-07-18T10:32:52+00:00

hello adatapost...this s the code

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
     <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
     <html xmlns="http://www.w3.org/1999/xhtml">
     <head>
     <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
     <title>Untitled Document</title>
     <%
      Connection con=null;
      ResultSet rs=null;
      try
      {
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          con=DriverManager.getConnection("jdbc:odbc:p_portal");
          Statement stat=con.createStatement();
          String sql="select * from message_box where name='anindo'";
         rs=stat.executeQuery(sql);
         %>
      <script language="javascript">
       function check()
       {
          var show=document.getElementById("mydivtag");
          show.innerHTML = "<label><select name=select><% while(rs.next()){%><option><%= rs.getString(1) %></option><option><%= rs.getString(2) %></option><option><%= rs.getString(3).substring(0,10) %></option></select></label><%}}catch(Exception ex){out.print("Exception is:- "+ex);}%>";
       }
        </script>
        </head>
        <body>
        <form id="form1" name="form1" method="post" action="try.jsp">
        <label></label>
      <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <input type="submit" name="Submit" value="Submit" onclick="check()" />
      </p>
      <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      </p>
      <div id="mydivtag" ></div>
      <p>&nbsp;</p>
      </form>
       </body>
	   <%
	    con.close();
		rs.close();
      </html>

kvprajapati 1,826 Posting Genius Team Colleague · Answer 10 · 2009-07-18T10:39:05+00:00

Use input type button:

<input type="button" name="submit" value="Submit" onclick="check()" />

anindo87 0 Newbie Poster · Answer 11 · 2009-07-20T17:13:34+00:00

hello adatapost......thanx for the reply.....the question s solved....thanx very much....

loading data from sql server database in a drop down menu using jsp

Recommended Answers Collapse Answers

All 15 Replies

Recommended Answers