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??
anindo87 0 Newbie Poster
hkansal 0 Newbie Poster
use JSP expressions:
<option><%=varName %></option>or scriptlets:
<option><% out.print(varName); %></option>expressions are advised
anindo87 0 Newbie Poster
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....
kvprajapati 1,826 Posting Genius Team Colleague
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 Team Colleague Featured Poster
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
anindo87 0 Newbie Poster
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>
<input type="submit" name="Submit" value="Submit" onclick="check()" />
</p>
<p>
</p>
<div id="mydivtag" ></div>
<p> </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.....
kvprajapati 1,826 Posting Genius Team Colleague
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>"; anindo87 0 Newbie Poster
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
Close the connection.
rs.close(); // release the result
st.close();
cn.close(); CoSIS1 0 Newbie Poster
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
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
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
anindo87,
Post your latest code (page). Wrap the source code with bb code tags.
anindo87 0 Newbie Poster
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>
<input type="submit" name="Submit" value="Submit" onclick="check()" />
</p>
<p>
</p>
<div id="mydivtag" ></div>
<p> </p>
</form>
</body>
<%
con.close();
rs.close();
</html> kvprajapati 1,826 Posting Genius Team Colleague
Use input type button:
<input type="button" name="submit" value="Submit" onclick="check()" /> anindo87 0 Newbie Poster
hello adatapost......thanx for the reply.....the question s solved....thanx very much....
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.