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(); }