java.sql.SQLException: Closed Resultset: next

Discussion in 'Programming' started by nandhakumar, Sep 28, 2012.

  1. #1
    I GOT A ERROR ,Any body will be solve program.,
    I have use two tables 1. REGNOSS 2. ATTENTRY10

    REGNOSS in all attributes insert into ATTENTRY10 table . how to



    String dates=request.getParameter("dates");
    System.out.println(dates);
    String dayorder=request.getParameter("dayorder");
    String h1="P";String h2="P";String h3="P";String h4="P";String h5="P";

    String query="select * from regnoss";
    PreparedStatement ps=conentry.prepareStatement(query);
    ResultSet rs=null;
    rs=ps.executeQuery();
    String sture = null;
    Statement st=null;
    st=conentry.createStatement();
    String que=null;
    while(rs.next())
    {
    String ques=rs.getString(1);

    que="insert into attentry10 (sturegno,dates,dayorder,h1,h2,h3,h4,h5)values('"+rs.getString(2)+"''"+dates+"','"+dayorder+"','"+h1+"','"+h2+"','"+h3+"','"+h4+"','"+h5+"')";
    pw.println(que);

    st.close();
    rs.close();
    conentry.close();
    }
     
    nandhakumar, Sep 28, 2012 IP