multiple data insert????

[mak]

Hi Friends,
I'm facing a serius problem...in 2 days i have to submit my project
and i'm stuck here..please help me...

I'm getting some values from the database from one table say roll_no
on one page....and then on that page i'm putting some values in front
of that roll_no.
Now I want to store the all data in a another table..
P.S. roll no. are not fixed and that is it can any thing from 1 - 60

here is my code.

<select size="1" name="subject" style="font-family: Arial; font-size:
10px; color:#0B333C"></select>
<--some value -->
<select size="1" name="month" style="font-family: Arial; font-size:
10px; color:#0B333C"></select>
<--some value-->
<select size="1" name="year" style="font-family: Arial; font-size:
10px; color:#0B333C"></select></tr>
<tr>
<td><input type="submit" value="SUBMIT" name="action"/>
 <table  width="800" border="4" cellpadding="1" cellspacing="1">
	<td>
 		<table  width="800" border="2" bordercolor="#FFFFFF"
cellpadding="0" cellspacing="0">
	 		 <tr>	<td align="right">

			</tr>
			<td>
					<%!	String stu_roll;%>
					<%
					String getsub1 = request.getParameter("subject");
					String getmonth = request.getParameter("month");
					String getyear = request.getParameter("year");
					%>
					<%
					try
					{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					Connection con = DriverManager.getConnection("jdbc:odbc:lala");
					Statement stmt = con.createStatement();
					String str1 = "select roll_no from student where sem_id = (select
sem_id from subject where course_id ='bsc_it' and sub_id =
'"+getsub1+"')";
					ResultSet rs  = stmt.executeQuery(str1);
					%>
					<table  align="center" width="" cellpadding="0" cellspacing="0"
border="1" cellspacing="1" cellpadding="1">
					 <tr>
					<td><input type="text"  value="Total Lecture" readonly=""/></td>
					<td><input type="text" name="total_att" maxlength="2"></td>
					 </tr>
					 <tr>
					<td><input type="text" value="Student roll no." readonly="" /></
td>
					 </tr>
					  <%
					int no = 0;
					while(rs.next())
					{
					stu_roll = rs.getString("roll_no");
					no = no + 1;
					%>
					 <tr bordercolor="#CC3366">
					<td>
					<input type="text" name="roll<%=no %>" value="<%= stu_roll %>"
readonly=""/>
					</td>
					 <td align="center" style="color:#0052A4 ">:</td>
					<td>
					 <input type="text"  name="att<%=no %>" />
					  <input type="hidden" name="no" value="<%=no %>" />
					</td>
					</tr>


					<%
							}

					%>

second page from where i'm inserting.

								<%!
										int no1 = request.getParameter("no");
										int i;
								%>
								<%
										for(i=1;i<no1;i++)
										{
								%>
								<%
										String getsub1 = request.getParameter("subject");
										String getmonth = request.getParameter("month");
										String getyear = request.getParameter("year");
										String getatt = request.getParameter("att"+i);
										String stu_roll = request.getParameter("roll"+i);
								%>

 <%


										try
										{
											Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
											Connection con =
DriverManager.getConnection("jdbc:odbc:lala");
											PreparedStatement ps=con.prepareStatement("insert into
attendance values(?,?,?,?,?,?)");

											ps.setString(1,stu_roll);
											ps.setString(2,getsub1);
											ps.setString(3,getmonth);
											ps.setString(4,getyear);
											ps.setString(5,getatt);
											ps.setString(6,"10");

											ps.executeUpdate();
%>

please help me......