i want to retrive data from database in combobox use JSP?

Hi Rahul,

RelatedCombo.jsp

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

<%
 String st=request.getParameter("s1");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:dsn1","system","pintu");
Statement stmt=con.createStatement();
Statement stmt1=con.createStatement();
ResultSet rs=stmt.executeQuery("select distinct job from employee");
%>

Select any Job

SELECT
<%
  while(rs.next())
   {
    String x=rs.getString("job");
   %>
           if(st !=null && st.equals(x))
   out.println("selected");
      %>
    ><%=x%>
<%
   }
   %>


  <%
     if(st !=null)
       {
   ResultSet rs1=stmt1.executeQuery("select * from employee where job='"+st+"'");
  %>

 
<%
  while(rs1.next())
  {
       String EmployeeId=rs1.getString("empid");
       String EmployeeName=rs1.getString("empname");
       int Salary=rs1.getInt("sal");
 
   %>
   
   
   
   
   
 <%
    }//end of while
 %>

Emp Id	Emp Name	Salary
<%=EmployeeId%>	<%=EmployeeName%>	<%=Salary%>

<%
   } //end of if
 %>

Refer

http://www.c-sharpcorner.com/uploadfile/satyapriyanayak/display-related-data-from-database-through-jsp/



Thanks
If this post helps you mark it as answer