Inserting single column values of database table into multiple columns of jtable and do comparison

[Narendra kodli]

Hello all,

I am struck ed in inserting single column values of database table into multiple columns of jtable and doing comparison for selecting greater values in each row.

Is their any query that splits column values. here i am attaching the code please give me the solution.

public void disp( final String n, final String p, final String f, final String t){	
    	
    	try{
    		
    	 rs1=st.executeQuery("SELECT factname,monval FROM tsi where frm='"+p+"'"); //IN('"+p+"',"+"'"+f+"',"+"'"+t+"')");
         	     
    	      	    while(rs1.next())
    	      	    {
    	      	    a = rs1.getString("factname");
    	      	  b= rs1.getString("monval");
    	      	//c= rs.getString("mon");
    	      	        rows1++;
    	      	     
    	      	    }System.out.println(rows1);
    	      	    
    	      	  
    	      	rs2=st.executeQuery("SELECT monval FROM tsi where frm='"+f+"'");
    	      	 while(rs2.next())
 	      	    {
    	      		b= rs2.getString("monval");
    	      		rows2++;
 	      	    }System.out.println(rows2);/*//
    	      	 data2=new Object[rows2][1];int i2=0;
 	      	 rs2=st.executeQuery("SELECT monval FROM tsi where frm='"+f+"'");
 	      	for(int i1=0;i1<rows2;i1++)
      	    {
      	    rs2.next();
 	      		i2++;;
      	    for(int j1=0;j1<1;j1++)
      	    {
      	    	data2[i1][j1]=rs2.getString(j1+1);
      	    	//data2[i1][j1]=i2;
      	    }
      	    }//System.out.println(i2);
 	      	*/rs3=st.executeQuery("SELECT monval FROM tsi where frm='"+t+"'");
	      	 while(rs3.next())
      	    {
	      		b= rs3.getString("monval");
	      		rows3++;
      	    }System.out.println(rows3);/*//
	      	 data3=new Object[rows3][1];int i3=0;
      	rs3=st.executeQuery("SELECT monval FROM tsi where frm='"+t+"'");
      	for(int i1=0;i1<rows3;i1++)
 	    {i3++;
 	    rs3.next();
 	    for(int j1=0;j1<1;j1++)
 	    {
 	    	data3[i1][j1]=rs3.getString(j1+1);
 	    	//data3[i1][j1]=i3;
 	    }
 	    }//System.out.println(i3);
*/ 	      
    	      	data1=new Object[rows1][6];
	      	     int i=0;
    	      	rs1=st.executeQuery("SELECT factname,monval FROM tsi where frm='"+p+"'");
    	      	  //rs.next();
    	      	    for(int i1=0;i1<rows1;i1++)
    	      	    {
    	      	    	i++;
    	      	    rs1.next();
    	      	    for(int j1=0;j1<6;j1++)
    	      	    {
    	      	    if(j1==0){
    	      	    	data1[i1][j1]=i;
    	      	    }else if(j1==1){ 
    	      	    	data1[i1][j1]=rs1.getString(j1);
    	      	    }else if(j1==2){
    	      	    	data1[i1][j1]=rs1.getString(j1);
    	      	    }else if((j1==3)){//&&(i1<rows2)){
    	      	    	//data1[i1][j1]=data2[i1][0];
    	      	    	rs2=st.executeQuery("SELECT monval FROM tsi where frm='"+f+"'");
    	      	    	 for(int i2=0;i1<rows2;i1++)
    	      	    	 {
    	      	    		rs2.next();
    	      	    		 for(int j2=0;j1<1;j1++){
    	      	    			data1[i1][j1]=rs2.getString(j2+1);
    	      	    			break;
    	      	    		 }break;
    	      	    	 }
    	      	    	
    	      	    }else if((j1==4)){//&&(i1<rows3)){
    	      	    	//data1[i1][j1]=data3[i1][0];
    	      	    	rs2=st.executeQuery("SELECT monval FROM tsi where frm='"+t+"'");
   	      	    	 for(int i2=0;i1<rows3;i1++)
   	      	    	 {
   	      	    		rs2.next();
   	      	    		 for(int j2=0;j1<1;j1++){
   	      	    			data1[i1][j1]=rs2.getString(j2+1);
   	      	    			break;
   	      	    		 }break;
   	      	    	 }
    	      	    }else{
    	      	    	//int difference =rs1.getString(j1).compareTo(rs1.getString(j1));

    	      	    	}
    	      	    }
    	      	    }
    	      	    
    	 }
    	catch (Exception e) {
            System.err.println("Unable to find and load driver11");
            System.exit(1);
          }
    	
    	
    	System.out.print(rows1+""+rows2+""+rows3);
    	
		final JTable table=new JTable(data1,Colheads);
		table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); 
  		TableColumn column = table.getColumnModel().getColumn(0);
  	  column.setPreferredWidth(50);
  	   		int i=1;
  	   		while(i<6){
  	   		column = table.getColumnModel().getColumn(i);
  	  	  column.setPreferredWidth(150);
  	  	  i++;
  	   		}
  		
		table.setEnabled(false);
		int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS;
	    int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS;
			panel.setBackground(Color.pink);
	  		frame1.add(panel);	

	  	   JScrollPane jsp=new JScrollPane(table,v,h);

[Michael Dunn]

and what do you expect us to do with those 125 lines of code?

here's a very simple way of getting a solution to your problem:
1) create a new program
2) just a JTable in a JScrollPane in a JFrame
3) table has 2 rows, 2 columns
4) fill the 4 cells with 'comparable' data
5) hard-code some data to simulate the resultset (array, arraylist, whatever)

now try to add the hard-coded data to the table and do your comparison.

if you can't get that to work, you will have a very short/compilable/runnable
program to post. also post what it is doing vs what you want it to do