suresh Rajan

hi experts,i have struggle for the past three days..
i cant display the oracle data through JTable...
ArrayIndexoutOfBounds error displayed.....
please help me............

import java.awt.event.*; import java.awt.*; import javax.swing.*; import java.io.*; import java.sql.*; import java.lang.*; import java.security.*; //<applet code="Calc3.class" width=700 height=600></applet> public class Calc3 extends JApplet implements ActionListener,RootPaneContainer { //String colhead[]={"name","dept"}; //String value[][]; JTable stu=new JTable(); JTextField t1; JRadioButton r1,r2; ButtonGroup bg; public void init() { r1=new JRadioButton("select"); r2=new JRadioButton("exit"); t1=new JTextField(20); bg= new ButtonGroup(); bg.add(r1); bg.add(r2); int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED; int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED; JScrollPane jsp=new JScrollPane(stu,v,h); Container c=getContentPane(); c.setLayout(new FlowLayout()); //JPanel panel=new JPanel(new BorderLayout()); c.add(r1); c.add(r2); c.add(t1); r1.addActionListener(this); c.add(jsp,BorderLayout.CENTER); setVisible(true); stu.setVisible(true); //c.add(stu); //c.add(panel); } public void actionPerformed(ActionEvent e) { System.out.println("Action Performed"); String s2=e.getActionCommand(); if(s2=="select") { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection(("Jdbc:Odbc:student"),"scott","tiger"); Statement st=con.createStatement(); int i=0; int j=0; ResultSet rs=st.executeQuery("select name,dept from student"); while(rs.next()) { i++; if(i==1) { //System.out.println("Query Executed"); //String value[][]={{"rs.getString(1)","rs.getString(2)"}}; //stu.setValueAt(rs.getString(1),j,0); stu.setValueAt(rs.getString(1),0,0); stu.setValueAt(rs.getString(2),0,1); //stu.setValueAt(rs.getString(4),j,3); System.out.println("value is"+rs.getString(2)); //System.out.println("Value inserted"); } //stu=new JTable(value,colhead); j++; } if(i==0) t1.setText("no row selected"); } catch(Exception e5) { System.out.println(e5); } } } }

hi sir...i am trying to dispay oracle data through JTable....
i have read the values from oracle...but i cant display the read
values in JTable....nothing displayed in table.......
i have attached my code for references..........

import java.awt.event.*; import java.awt.*; import javax.swing.*; import java.io.*; import java.sql.*; import java.lang.*; import java.security.*; //<applet code="Calc3.class" width=700 height=600></applet> public class Calc3 extends JApplet implements ActionListener,RootPaneContainer { JTable stu=new JTable(); JTextField t1; JRadioButton r1,r2; ButtonGroup bg; public void init() { r1=new JRadioButton("select"); r2=new JRadioButton("exit"); t1=new JTextField(20); bg= new ButtonGroup(); bg.add(r1); bg.add(r2); int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED; int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED; JScrollPane jsp=new JScrollPane(stu,v,h); Container c=getContentPane(); c.setLayout(new FlowLayout()); //JPanel panel=new JPanel(new BorderLayout()); c.add(r1); c.add(r2); c.add(t1); r1.addActionListener(this); c.add(jsp,BorderLayout.CENTER); setVisible(true); stu.setVisible(true); //c.add(stu); //c.add(panel); } public void actionPerformed(ActionEvent e) { System.out.println("Action Performed"); String s2=e.getActionCommand(); if(s2=="select") { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection(("Jdbc:Odbc:student"),"scott","tiger"); Statement st=con.createStatement(); int i=0; int j=0; ResultSet rs=st.executeQuery("select name,dept from student"); while(rs.next()) { i++; if(i==1) { System.out.println("Query Executed"); String colhead[]={"name","dept"}; String value[][]={{"rs.getString(1)","rs.getString(2)"}}; //stu.setValueAt(rs.getString(1),j,0); //stu.setValueAt(rs.getString(1),j,0); //stu.setValueAt(rs.getString(1),j,1); //stu.setValueAt(rs.getString(4),j,3); System.out.println("value is"+rs.getString(2)); stu=new JTable(value,colhead); System.out.println("Value inserted"); } j++; } if(i==0) t1.setText("no row selected"); } catch(Exception e5) { System.out.println(e5); } } } }

hi experts...i am trying to display SQL data
through JTable...when i run
appletviewer Calc3.html...then
nothing displayed in the page......
but messaged AppletStarted...........
i have attached the code for your reference..............
please do your best efffects....................
[b]import java.awt.event.*; import java.awt.*; import javax.swing.*; import java.io.*; import java.sql.*; import java.lang.*; import java.security.*; //<applet code="Calc3.class" width=700 height=600></applet> public class Calc3 extends JApplet implements ActionListener,RootPaneContainer { JTable stu=new JTable(); JTextField t1; JRadioButton r1,r2; ButtonGroup bg; String colhead[]={"id","name","dept","perc"}; public void init() { r1=new JRadioButton("select"); r2=new JRadioButton("exit"); t1=new JTextField(); bg= new ButtonGroup(); bg.add(r1); bg.add(r2); int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED; int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED; JScrollPane jsp=new JScrollPane(stu,v,h); Container c=getContentPane(); c.setLayout(new BorderLayout()); //JPanel panel=new JPanel(new BorderLayout()); c.add(r1); c.add(r2); c.add(t1); c.add(jsp,BorderLayout.CENTER); c.add(stu); //c.add(panel); } public void actionPerformed(ActionEvent e) { String s2=e.getActionCommand(); if(s2=="select") { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection(("Jdbc:Odbc:student"),"scott","tiger"); Statement st=con.createStatement(); int i=0; ResultSet rs=st.executeQuery("select * from student"); while(rs.next()) { i++; int j=0; if(i==1) { String value[][]={{"rs.getInt(0)","rs.getString(1)","rs.getString(2)","rs.getString(3)"}}; //stu.setValueAt(rs.getString(1),j,0); //stu.setValueAt(rs.getString(2),j,1); //stu.setValueAt(rs.getString(3),j,2); //stu.setValueAt(rs.getString(4),j,3); stu=new JTable(value,colhead); } j++; } if(i==0) t1.setText("no row selected"); } catch(Exception e5) { System.out.println(e5); } } } }[/b]