Thread: can u help me

can u help me

From
JACOB SIBI
Date:
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@hotmail.com

jacob