import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;

public class JdbcTesta extends Applet {

Label lb1 = new Label( "Userid" );
TextField tf1 = new TextField( 15 );
Label lb2 = new Label( "Password" );
TextField tf2 = new TextField( 15 );
Button bt1 = new Button("Execute Sql");
Button bt2 = new Button("Reset Sql");
Button bt3 = new Button("Reset Result Set");
Button bt4 = new Button("Reset All");
Label lb3 = new Label( "Sql Code" );
String sql = "select col_name " +
"from dbname.tbname " +
"where partition_nbr = '09' " + 
"and col_name = 'ED5197782';";
TextArea ta1 = new TextArea( sql,  05 ,  40 , TextArea.SCROLLBARS_BOTH );
Label lb4 = new Label( "Result Set" );
TextArea ta2 = new TextArea( "",  05 ,  40 , TextArea.SCROLLBARS_BOTH );

public void init() { 

Panel p0 = new Panel();
p0.setLayout( new BorderLayout() ); 

Panel p1 = new Panel(); 
p1.setLayout( new GridLayout(  2 ,  4 ) ) ;
p1.add( lb1 );
p1.add( tf1 );
p1.add( lb2 );
p1.add( tf2 ); tf2.setEchoChar('*');
bt1.addActionListener( new ActionListener() {
public void actionPerformed(ActionEvent e) {
boolean editTF;
editTF = false;
editTF = editTFInput();
if ( editTF ) {
executeSql();
} else {
showStatus("Invalid input - Try Again ...");
} // end of if
} // end of actionPerformed method
} ); // end of anaonymous class 'ActionListener'
p1.add( bt1 ); 
bt2.addActionListener( new ActionListener() {
public void actionPerformed(ActionEvent e) {
ta1.setText("");
showStatus("Reset Sql ...");
} // end of actionPerformed method
} ); // end of anaonymous class 'ActionListener' 
p1.add( bt2 ); 
bt3.addActionListener( new ActionListener() {
public void actionPerformed(ActionEvent e) {
ta2.setText("");
showStatus("Reset Result Set ...");
} // end of actionPerformed method
} ); // end of anaonymous class 'ActionListener'
p1.add( bt3 );
bt4.addActionListener( new ActionListener() {
public void actionPerformed(ActionEvent e) {
ta1.setText("");
ta2.setText("");
showStatus("Reset All ...");
} // end of actionPerformed method
} ); // end of anaonymous class 'ActionListener' 
p1.add( bt4 ); 
p0.add( p1, BorderLayout.NORTH );

Panel p2 = new Panel(); 
p2.setLayout( new GridLayout(  4 ,  4  ) ) ;
p2.add( lb3 );
p2.add( ta1 );
p2.add( lb4 );
p2.add( ta2 );
p0.add ( p2, BorderLayout.CENTER );

this.add( p0 ); 

} // end of init

public boolean editTFInput() {
boolean editTF;
editTF = true;
/*if ( tf1.getText().length() != 7 ) { editTF = false; }
if ( tf2.getText().length() < 6 || tf2.getText().length() > 8 ) {
editTF = false; }*/
return editTF;
} // end if method editTFInput

public void executeSql() {
try {

String userid, password;
Vector queryResults = new Vector();
int accum1 =  0 ;
int accum2 =  0 ;

showStatus("Loading JDBC Driver ..." );
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");

showStatus("Connecting To jdbc:db2 :DSNP ..." );
userid = tf1.getText().trim().toUpperCase();
password = tf2.getText().trim().toUpperCase();
Connection con = 
DriverManager.getConnection("jdbc:db2 :DSNP", userid, password );
...