can u help me

Hi,
I have a probelm with my JDBC coding. Iam using a Java swing interface
to input data. It reads in studentID from the textField and should
output the average.The code compliles well. But i get the average as 0,
with exceptions as detailed below.

The error I get is
java.sql..SQLException:[Microsoft] [ODBC Driver Manger] Invalid cursor
state.

This is the code that creates the error.

public void FindAverageStudent()
{
int marksPE2=0;
int marksSE1=0;
int marksEA=0;
int average=0;
int TotalMarks=0;
int StudID=Integer.parseInt(StudentIDField.getText());

try
{
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(
"SELECT * FROM Student2 " + " WHERE Student_ID = '" +
StudentIDField.getText() + "'");

marksPE2=rs.getInt(4);
marksSE1=rs.getInt(5);
marksEA=rs.getInt(6);
TotalMarks=marksPE2+marksSE1+marksEA;
average=TotalMarks/3;
connection.close();
}
catch(SQLException sqlex)
{
sqlex.printStackTrace();
}
Area1.append("The average marks of the student is "+
average);
}

Hope to hear from you,

My emailid is jacobspj(at)hotmail(dot)com

jacob