1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

java.sql.SQLException: Closed Resultset: next

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

0
  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