/**
* copy this code either in JSP or in  
* servlet this pice of code is for JSP
* make sure that u have proper driver.
**/
<% 
try{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	Connection con;

	con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
	System.out.println(con);
	Statement stmt = con.createStatement();
	ResultSet rs = stmt.executeQuery("select * from Emp");

/**
* to display the results in list box
* i haven't compiled and tested this   
* code  u can get some errors here,but * this is one of the way to do. 
**/

while rs.next(){
for (i=0; i< rs.getFetchSize(); i++;){
out.println(""+
" ");
}
}
	con.close();
	}catch(Exception e) { out.println(" exception occurred");
}

%>


reachme@ynroy.com  
                          
          
          
          

          	

    
            	Report
              	| 
              	Quote This
		        
		          
		         |
		        Send private message
              	| 
              	Reply
              
              	
	          	|
	              Print
          		
              	
            
  
          
          
            
        
        
  
        
      

          
    	

    		

          		
Re: How to retieve values from database
          	
        
          
        
          
            
            

            
            	
            
           		

       				Posted By:
		          		 
		          		John_Zukowski
		            	 
		            	

		            	Posted On:
		            	 
		            	Wednesday, March 28, 2001 09:51 PM
                
            
   
                     
            
Accessing a database is covered in the JDBC FAQ. Displaying in a dropdown list is basic HTML.
  
                          
          
          
          

          	

    
            	Report
              	| 
              	Quote This
		        
		          
		         |
		        Send private message
              	| 
              	Reply
              
              	
	          	|
	              Print
          		
              	
            
  
          
          
          
  
        
        
  
        
      
  

    

          
  




	
				
			
			
			

				
		
	   	
	
	

         
    
    

	

	

	

		
	
	

	



	
	

	

	



	

		About |
		Sitemap |
		Contact