I hav only one recordset value.....but still i get Invalid cursor state error....how to solve it?

Question

here is my code......wen i give condition in query i get only one record set ....code:
Connection con;
Statement st;
try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcD…
con=DriverManager.getConnection("jdbc:od…
st=con.createStatement();
ResultSet rs;
try
{
System.out.println(empid.getText());
String myq="select * from employee where empid='"+empid.getText()+"'";
System.out.println(myq);
rs=st.executeQuery(myq);

String ei = rs.getString(1);
System.out.println(ei);
}

Answer 1

You are missing rs.next(); Try adding it here

rs=st.executeQuery(myq);
rs.next(); //<------add here
String ei = rs.getString(1);
System.out.println(ei);

Sign in to vote!