java applet to MS Access Database connection/query problem

Hello!
Basically, I’m trying to retrieve info from a database and display it in a TextArea of an applet.
For now, I’ve
1. An applet, consists of a button and txtArea.
2. When button is “hit”,
an instance of class Item1 is created with a connection variable passed to Item1’s constructor.
With this, a driver and connection to the specified database is established.
3. Database info is retrieved using the getItem( ) method declared in class Item1( of return type  “class ItemInfo”).
4. The whole purpose of class ItemInfo is to store the results of the query for display later in TextArea.
5. Prior to all this, the ODBC connection is created with Data Source Name = ProductODBC and
database = c:\….\Product.mdb (Note: Table name is Item).

This is my final year project, and master students working in the same lab as me do not intend to use JSDK2.1
And I was told that what I’ve got here is basically similar to theirs! And it should make it.
I’ve no problem compiling but the query result is not displayed in the textArea.

Following are the codes for applet,class Item1 and class ItemInfo

----------------------------------------
----------------------------------------
//~start of code for java applet~
import java.applet.Applet;
import java.awt.event.*;
import java.awt.*;
import java.sql.*;

public class Applet1 extends Applet implements ActionListener
 {
// Attribute for database.
private Connection sybaseConn;
private ItemInfo itemInfo;

// Attribute for GUI.
TextArea text;
Button button;

// Attribute in txtArea.
String t;
float cost;
String desc;  
String imgURL;
int productID;
int qtyOnHand;

public void init()
{

t = System.getProperty("line.separator");

button = new Button("Click!");
add(button);

text = new TextArea(5,20);
text.setEditable(false);
add(text);
}

public void actionPerformed(ActionEvent e)
{
if(e.getSource() == button)
{
// Create the instance of the Item class.
Item1 item = new Item1(sybaseConn);

// Retrieve item details for the current row
// from ProductODBC, Item table.

try{itemInfo = item.getItem();}
catch (SQLException ez)
{text.setText("Read failed:" + ez.getMessage());}

cost = itemInfo.Cost;
desc = itemInfo.Desc;
imgURL = itemInfo.ImgURL;
productID = itemInfo.ProductID;
qtyOnHand = itemInfo.QtyOnHand;


text.append(cost + t + desc + t + imgURL
+ t + productID + qtyOnHand );
}
}
}
//~end of code for java applet~
----------------------------------------
----------------------------------------
//~start of code for class Item1~
import java.sql.*;

public class Item1
{
private Connection conn;

// Item constructor starts: store a local copy of the
  // Connection object create statements for use later
public Item1 (Connection c)
{

conn = c;

// Make ODBC-JDBC bridge driver
try {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (java.lang.ClassNotFoundException z)
{System.err.println("Class not found: " + z.getMessage());}

// Make connection.
try{conn = DriverManager.getConnection("jdbc:odbc:ProductODBC");}
catch (SQLException e)
{System.err.println("Database connection failed:"
+ e.getMessage());}
   
}


// Method for getting a single item record with this ID
// Note: this method maps the returned data onto a
// ItemInfo container object
public ItemInfo getItem ()
throws SQLException
{

// Create the select statement and get results
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT *FROM Item");
rs.next();

// Create a ItemInfo container object
ItemInfo info = new ItemInfo ();

// Populate the ItemInfo object
info.ProductID = rs.getInt    (1);
info.ImgURL    = rs.getString (2);
info.Desc      = rs.getString (3);
info.Cost      = rs.getFloat  (4);
info.QtyOnHand = rs.getInt    (5);

return (info);
   }


}
//~end of code for class Item1~
----------------------------------------
----------------------------------------
//~start of code for class ItemInfo~
public class ItemInfo {
int ProductID;
String ImgURL;
String Desc;
float Cost;
int QtyOnHand;
}
//~end of code for class ItemInfo~
----------------------------------------
----------------------------------------