How to retreive data by using combo box value

Hello friend ,

i am using only one form. U are using html form and jsp form. So get the values from html. So u r using

if(request.getParameter("cid")!=null){
cid=Integer.parseInt(request.getParameter("cid"));

I am using only a single jsp with html .. So i cannot use request.getParameter. If i am using null value only displayed...

Your code is here..

<%@ page language="java" %>
<%@ page import="java.sql.*" %>

<%!
Connection conn = null;
ResultSet rs =null;
Statement st=null;
String query="";
int cid;
%>
<%
if(request.getParameter("cid")!=null){
cid=Integer.parseInt(request.getParameter("cid"));
}else {
cid=0;
}
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root";, "root");
st = conn.createStatement();
rs = st.executeQuery("select * from student");
%>
<html>
<head>
<script type="text/javascript">

function view(){
var cid=document.getElementById("student").selectedIndex;
window.location.replace("http://localhost:8080/examples/jsp/combo.jsp?cid="+cid);
}
</script>
</head>
<body>
<select id="student" onchange="view(this)">
<option value="0">--Please Select--</option>
<% while(rs.next()){ %>
<option value='<%=rs.getInt("id")%>'><%=rs.getInt("id")%></option>
<%}%>
</select>
<%
rs = st.executeQuery("select * from student where id='"+cid+"'");
%>
<%
String name="";
while(rs.next()){
name=rs.getString("name");
}%>
<input type="text" value="<%=name%>">
</body>
</html>

My code is here...

<td width="100">
<select name="productid">

<%

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Airworld");
query=con.prepareStatement("select * from Productdetails where productid='?'");

rs=query.executeQuery();
while(rs.next())
{
pid=rs.getString(1);
pname=rs.getString(2);

%>

<option><% out.println(pid); %></option> //// Here I can print combo box values.

<%
System.out.println("Product Id=" +pid);

}

rs.close();
query.close();
%>

</select>

</td>
<% /* productid = request.getParameter("productid").toString();
query=con.prepareStatement("select * from Productdetails where productid= ( '" +productid+ "')");
ResultSet rs1;
rs1=query.executeQuery();
while(rs1.next())
{
pname = rs1.getString(2);

}*/
if(!request.getParameter("productid").equals("null")) // If i am using i got null pointer exception.. because i am not using post method.
{
productid=request.getParameter("productid");
}

query=con.prepareStatement("select * from Productdetails where productid='"+productid+"'");

rs=query.executeQuery();

while(rs.next())
{
pname =rs.getString(2);
}

%>

<td width="541"><input type="text" width="525" name="productname" value="<% out.println(pname);%>" /></td>

Pl response me...

View Answers

How to retreive data by using combo box value

Questions by Category