Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Java Databases > how do i insert...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 3651 of 3747
Post > Topic >>

how do i insert into databse?

by mak1084@[EMAIL PROTECTED] Feb 16, 2008 at 06:14 AM

i'm creating a an web application on attendance,  in which a user
after selecting the subject and month he gets all the student info
who
has taken that subject.

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...at the same time after filling the info.

the snapshot of the code is here...
here I'm getting the roll no. along with the text box..

[code]
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>&nbsp;

                                                                <%
                                                                          
     }

 
con.close();
                                                                          
     }
 
catch(SQLException e)
 
{
 
out.println("Exception in SQL" + e);
                                                                          
     }
                                                                %>
[/code]




 2 Posts in Topic:
how do i insert into databse?
mak1084@[EMAIL PROTECTED]  2008-02-16 06:14:22 
Re: how do i insert into databse?
Robert Kochem <robert@  2008-02-16 15:49:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed May 14 23:55:14 CDT 2008.