Writing data to database

[Mayura Hayat]

Hello
i have a jsp page which takes in the details from the user like the name, age, gender,etc.
how do i insert data for more then 1 user into the database at the same time i.e just by a single click.???
i'm not using servlet.

please please help.

[Bear Bibeault]

Mayura Hayat wrote:how do i insert data for more then 1 user into the database at the same time i.e just by a single click.?

What do you mean by more than one user? How can more than one user be submitting data?

i'm not using servlet.

Why not? A servlet should be used to process the data.

[Mayura Hayat]

i think i was not quiet clear when i posted the question.
well i'm doing a project on flight reservation. what i want to ask was that when the user login he is able to book ticket for more den 1 person.
so i have provided textboxes to add the relevant info. about more people i.e if he is to book two tickets he needs to enter the data i.e name age gender for two people.

At Backend(oracle 10g XE) i want to add this data to the database.. but unable to do it.

how do i acheive this on the single submit.???

please help..
Thank you in Advance.

[Ulf Dittmer]

What does "unable to do it" mean, exactly? What does your code currently do? And as Bear said, a servlet is the way to handle a form submission like this.

[Mayura Hayat]

unable to do it means that i'm unable to add the data to database...
my code accepts the data or rather insert the data just for one person into the database ... but not for more then one person.
Yes taking his advice i'm using scriplets..

i'm new to jsp.

Any help will be useful. please.

[Ulf Dittmer]

I don't think we'll be able to give any more advice without seeing the relevant code excerpts (that get the data from the form submission and store it to the DB).

[Bear Bibeault]

Mayura Hayat wrote:
Yes taking his advice i'm using scriplets..

Who said anything about scriptlets? Scriptlets should not be used!

You should be submitting the form to a servlet.

[Amit Ghorpade]

Mayura Hayat wrote:insert the data just for one person into the database ... but not for more then one person.

If you are able to successfully insert one record, then one possible deduction I can make is that you are using request.getParameter() for reading multiple values.

[Mayura Hayat]

Amit you are right.
m i doing it the wrong way.? can you tell me the correct way to do it?

[Swastik Dey]

Could you show us your code snippet.

[Mayura Hayat]

flightbook.jsp:

<form id="frmfbook" method="post" action="flightBookprocess.jsp">
            <table border="1" height="800">
             <tr>
                    <td>
                   <table border="1" width="980" height="180">
                            <tr>
                                <th colspan="3" align="left">
                                    Passenger Details
                                </th>
                            </tr>
                            <tr>
                                <td width="100" align="center">
                                    <label>Sr.No</label>
                                </td>
                                <td align="center" width="400">
                                    <label>Name</label>
                                </td>
                                <td align="center">
                                    <label>Age</label>
                                </td>
                                <td align="center" width="200">
                                    <label>Gender</label>
                                </td>
                                
                         </tr>
                            <tr>
                                      
                                <td align="center">
                                    <label><!%= i%></label>
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrnm">
                                </td>
                                <td align="center">
                                   <input type="text" name="txtpsngrage">
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrsex">
                                </td>
                                
                             </tr>   
                            <tr>
                                      
                                <td align="center">
                                    <label><!%= i%></label>
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrnm">
                                </td>
                                <td align="center">
                                   <input type="text" name="txtpsngrage">
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrsex">
                                </td>
                            </tr>   
                        </table>                                     
                    </td>
                </tr>
                  
                        <tr>
                    <td>
                        <table border="1" width="980" height="150">
                            <tr>
                                <th colspan="4" align="left">
                                    Child Details
                                </th>
                            </tr>
                            <tr>
                                <td width="100" align="center">
                                    <label>Sr.No</label>
                                </td>
                                <td align="center" width="400">
                                    <label>Name</label>
                                </td>
                                <td align="center">
                                    <label>Age</label>
                                </td>
                                <td align="center" width="200">
                                    <label>Gender</label>
                                </td>
                            </tr>
                            <tr>
                                <td align="center">
                                    <label name="1">1</label>
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrnm">
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrage">
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrsex">
                                </td>
                            </tr>
                            <tr>
                                <td align="center">
                                    <label name="2">2</label>
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrnm">
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrage">
                                </td>
                                <td align="center">
                                    <input type="text" name="txtpsngrsex">
                                </td>
                            </tr>
                        </table>
                    </td>
                    
                </tr>
                <tr>
                    <td>
                        <table width="980">
                          <tr>
                                <td align="right">
                                    <input type="submit" name="subgo" value="Go" 
                                           style="width: 80px; height: 30px; color: navy">
                                             
                                
                                    <input type="reset" name="rst" value="Reset" 
                                           style="width: 80px; height: 30px; color: navy">
                                       
                                
                                    <input type="submit" name="subplnagn"
                                              value="Replan" style="width: 80px; height: 30px; color: navy">
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
        </table>
        </form>

flightBookprocess.jsp:

 <%// String spsngr= request.getParameter("subadd");%>     
        <%
        try{
            String s=request.getParameter("subgo");
                    
            if(s.equals("Go")){
                if(request.getParameter("txtpsngrnm") != null){
                
                  
                                String pname[]= request.getParameterValues("txtpsngrnm");
                                for(int j=0;j<= pname.length;j++){
                              //  int psage= Integer.parseInt(request.getParameter("txtpsngrage"));
                                // String pgender[] = request.getParameterValues("txtpsngrsex");
              %>

// here it displays the value entered into the textboxes(trying
// to insert just the names 1st) but inserting in DB not happening.
              <%= pname[j] %>


              <%
                   stmt.executeQuery("insert into fbook(fbid,fname) values('"+j+"','"+pname[j]+"')");
                //stmt.executeQuery("insert into fbook(fbid,fpname,fpage,fpgender)values("+ j +
                 //",'"+ pname +"',"+ psage +",'"+pgender+"')");                            
                
                }
                
                %>
            <jsp:forward page="fbeforepay.jsp"/>
            <%                }
                                                 }
                       }
        catch(Exception e){}
               
        
             %>

i'm new to jsp any suggestion will be taken.
Thank You in advance.

[Swastik Dey]

for(int j=0;j<= pname.length;j++){

Is it not leading to ArrayIndexOutOfBoundsException?

Should it not be?

for(int j=0;j<pname.length;j++){

[Mayura Hayat]

hey thank you all especially swastik... it worked.. i was struggling with this thing for a long time.
data successfully entered into the database ... :) ohhh!! that's Christmas!!

Thank you once again all.
and i'm sorry for the inconvenience caused.