suresh Rajan

Greenhorn

+ Follow

news 3 Posts 3 Threads

since Dec 11, 2008

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by suresh Rajan

JTable display problem

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);
}
}
}
}

15 years ago

JDBC and Relational Databases

Display Problem in JTable

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);
}
}
}
}

15 years ago

Swing / AWT / SWT

no applet displayed

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]

15 years ago

Swing / AWT / SWT