my problem is i'm able to get the multiple student with the text box where a user can put up his monthly attendance. how do i insert the info in database...
the snapshot of the code is here...
here I'm getting the roll no. along with the text box..
Expand|Select|Wrap|Line Numbers
- 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>
- <% while(rs.next())
- {
- %>
- <%
- stu_roll = rs.getString("roll_no");
- %>
- <tr bordercolor="#CC3366">
- <td>
- <%
- out.println(stu_roll);
- %>
- </td>
- <td>
- <input type="text" name="att" />
- </td>
- </tr>
- <%
- }
- con.close();
- }
- catch(SQLException e)
- {
- out.println("Exception in SQL" + e);
- }
- %>