Database values to JTextArea

import java.sql.*;
import javax.sql.*;
import oracle.jdbc.rowset.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
class QueryDemo extends JFrame implements ActionListener
{
JLabel l1,l2,l3;
JTextField jf1;
JTextArea j1;
Button b1,b2;
static Connection con=null;
static Statement stmt=null;
QueryDemo()
{
setTitle(“QueryExecutor-by Kamlesh Mishra”);
setSize(500,400);
FlowLayout f=new FlowLayout();
setLayout(f);
getContentPane().setBackground(Color.lightGray);
l1=new JLabel(“Enter any Query”);
jf1=new JTextField(40);
add(l1); add(jf1);
l2=new JLabel(“Result”);
j1=new JTextArea(5,40);
add(l2); add(j1);
b1=new Button(“Execute”);
add(b1);
b2=new Button(“Clear”);
add(b2);
setVisible(true);
b1.addActionListener (this);
b2.addActionListener (this);
}
public void actionPerformed(ActionEvent ae)
{
if(ae.getSource()==b1)
{
try
{
Class.forName(“oracle.jdbc.driver.OracleDriver”);
con = DriverManager.getConnection(“jdbc:oracle:thin:@localhost:1521:orcl”,”scott”,”tiger”);
String query=jf1.getText();
stmt = con.createStatement();
System.out.println(query);
boolean status = stmt.execute(query);
if( status == false )
{
// Get the update count
int num = stmt.getUpdateCount() ;
j1.setText(num + ” rows affected”);

}
else
{
// Get the result set and the metadata
ResultSet  rs = stmt.getResultSet() ;
ResultSetMetaData md = rs.getMetaData() ;
// Loop through the result set
while( rs.next() )
{
for( int i = 1; i <= md.getColumnCount(); i++ )
{
j1.append( rs.getString(i) + ” ” +” “) ;
}//for loop–end
j1.append(“\n” ) ;
// Close the result set, statement and the connection

}//else
rs.close() ;
stmt.close();
con.close();
}//while

}//try
catch (Exception e)
{
j1.setText(e.toString());

}

}//if
if(ae.getSource()==b2)
{
j1.setText(” “);
jf1.setText(” “);
}
}
}//BCL—QueryDemo
class  QueryExecutor
{
public static void main(String[] args)
{
QueryDemo d=new QueryDemo();
}
}

Screens: