multiple data insert????

From:

mak <mak1084@gmail.com>

Newsgroups:

comp.lang.java.programmer

Date:

Wed, 20 Feb 2008 23:55:16 -0800 (PST)

Message-ID:

<0e39c85b-040e-4087-9f62-5e181a6b58de@34g2000hsz.googlegroups.com>

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......