2) Can someone interpret, what does this line means?
A) A result set contains the results of a SQL query. The results are kept in a set of rows, one of which is designated the current row. A row must be made current before data can be retrieved from it. The result set maintains a reference to the current row called the cursor.
The cursor is positioned before the first row when a result set is created. When a result set's next() method is called, the cursor moves to the first row of the result set and that row becomes the current row.
You can also specify the name of the column
"HELPING HANDS ARE BETTER THAN PRAYING LIPS........................."
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"
I also prefer column name instead of column number. It gives more readability to your code.
And the above line can be interpreted as, You are fetching value of first column which seems to be of String type and storing it into sPinNo(in addition to what ujjwal mentioned).