multiple data insert????
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.
[CODE=java]
<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>
<%
}
%>[/CODE]
second page from where i'm inserting.
[CODE=java]
<%!
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();
%>
[/CODE]
please help me......