get column value from column name

[Yudi Ono]

hi..
i want to retrieve column field value after i retrieve column name, but i don't know what to do..

here's my code

  
                                String sql_select = "select * from "+rs2.getString("mtab_table_name")+"";
    	    			String sql_where = " where 1 = 1 ";
                                Statement exec = conn.createStatement();
    	    			String a_rs3 = ""+ sql_select +""+ sql_where +" ";
    	    			logger.info(a_rs3);    	    						
    	 			ResultSet a_rs2 = exec.executeQuery(" "+ sql_select +""+ sql_where +" ");
    	 			String column_name = "";
    	 			String column_value = "";    	    						
    	 			ResultSetMetaData rsColumns = a_rs2.getMetaData();                           
       
    	        	    			int count = rsColumns.getColumnCount();
    	        	    			System.out.println("jumlah kolom =" + count);
    	        	    			
    	    						
    	    						if(count != 0)
    	        	    			{
    	        	    			for(int i=1; i<= count; i++)
    	        	    			{	
    	        	    				System.out.println(column_name);
    	        	    			
    	    						if (column_name.equals(""))
    	        	    					
    	        	    					{
    	        	    					  	column_name = rsColumns.getColumnName(i);
    	        	    					} else 
    	        	    					{ 	
    	        	    						column_name  = column_name +","+  rsColumns.getColumnName(i);
    	        	    					}
    	        	    			  }
    	        	    			
    	        	    			}
  

please help..

regards

Yudi

[Balu Sadhasivam]

Is it all the column in the same table or different tables ?

#  if (column_name.equals(""))  
#                                               
#                                             {  
#                                                 column_name = rsColumns.getColumnName(i);  
#                                             } else   
#                                             {     
#                                                 column_name  = column_name +","+  rsColumns.getColumnName(i);  
#                                             }  
#                                       }  

you can use column_name as string in SELECT statement for the table , query the databae . and you get the required columns only,

"SELECT  " + column_name + " from table" + " where ..."