DaniWeb Forum Index > Web Development > JSP

Unsure how to save to database dynamic Textfield values

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2006

Posts: 15

Reputation: shaun09 is an unknown quantity at this point

Solved Threads: 0

shaun09

Offline

Newbie Poster

Unsure how to save to database dynamic Textfield values

Oct 17th, 2006

I'm trying to create a list to record student grades into the database. I'm able to pull out the names from the database and create a table with textfields in it to input the data into.

This is the code i'm using

for(int i = 0; rst2.next(); i++){
.......
<th scope="col"><input name="ca1_<%=i%>" type="text" id="exam1" size="7" /></th>
...

I'm using jsp and mysql

My database fields are exam1, exam2, exam3, exam4

Thank you so much for your help.

•

Join Date: Oct 2006

Posts: 15

Reputation: shaun09 is an unknown quantity at this point

Solved Threads: 0

shaun09

Offline

Newbie Poster

Re: Unsure how to save to database dynamic Textfield values

Oct 18th, 2006

This is what i've tried.

for(int i = 0; rst2.next(); i++){
String ca1 = request.getParameter("ca1_<%=i%>");
String query2 = "INSERT into results(ca1) values ('"+ca1+"')";
stm2.executeUpdate(query2);
}

The error as follows..

String not terminated at end of line.
String ca1 = request.getParameter("ca1_<%=i

•

Join Date: Feb 2006

Posts: 2,467

Reputation: masijade has much to be proud of

Solved Threads: 267

masijade

Offline

Nearly a Posting Maven

Re: Unsure how to save to database dynamic Textfield values

Oct 18th, 2006

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
String ca1 = request.getParameter("ca1_<%=i%>");
String ca1 = request.getParameter("ca1_<%=i%>");

should this not be

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
String ca1 = request.getParameter("ca1_" + i);
String ca1 = request.getParameter("ca1_" + i);

Assuming the parameter names are ca1_0, ca1_1, ca1_2, etc.

At this point in the code you are already inside a scriptlet tag (at least I assume you are), so additional scriptlet tags are nothing but syntax errors.

Java Programmer and Sun Systems Administrator

----------------------------------------------

Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan

•

Join Date: Oct 2006

Posts: 15

Reputation: shaun09 is an unknown quantity at this point

Solved Threads: 0

shaun09

Offline

Newbie Poster

Re: Unsure how to save to database dynamic Textfield values

Oct 18th, 2006

Thank you it worked. Now i have another problem. Lets say i want to save all the information as a single string in the database instead of it going into another row. Here is my code. I'm using checkbox now.

for(int i = 0; rst2.next(); i++){
if(request.getParameter("ca1_"+i) !=null){
Childic = rst2.getString("Childic") ;
String query2 = "INSERT into results(ca1) values ('"+Childic+"')";
stm2.executeUpdate(query2);
}
else{

}
}

Thank you so very much for your help.

•

Join Date: Feb 2006

Posts: 2,467

Reputation: masijade has much to be proud of

Solved Threads: 267

masijade

Offline

Nearly a Posting Maven

Re: Unsure how to save to database dynamic Textfield values

Oct 18th, 2006

If what you mean, is that you want to concatenate all values into one string and then insert that then change

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
for(int i = 0; rst2.next(); i++){ 
  if(request.getParameter("ca1_"+i) !=null){
    Childic = rst2.getString("Childic") ;
    String query2 = "INSERT into results(ca1) values ('"+Childic+"')";
    stm2.executeUpdate(query2);
  } else {
    // whatever it is you want here
  }
}
for(int i = 0; rst2.next(); i++){ 
  if(request.getParameter("ca1_"+i) !=null){
    Childic = rst2.getString("Childic") ;
    String query2 = "INSERT into results(ca1) values ('"+Childic+"')";
    stm2.executeUpdate(query2);
  } else {
    // whatever it is you want here
  }
}

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
for(int i = 0; rst2.next(); i++){ 
  if(request.getParameter("ca1_"+i) !=null){
    Childic = Childic + rst2.getString("Childic") ;
  } else {
    // whatever it is you want here
  }
}
String query2 = "INSERT into results(ca1) values ('"+Childic+"')";
stm2.executeUpdate(query2);
for(int i = 0; rst2.next(); i++){ 
  if(request.getParameter("ca1_"+i) !=null){
    Childic = Childic + rst2.getString("Childic") ;
  } else {
    // whatever it is you want here
  }
}
String query2 = "INSERT into results(ca1) values ('"+Childic+"')";
stm2.executeUpdate(query2);

•

Join Date: Oct 2006

Posts: 15

Reputation: shaun09 is an unknown quantity at this point

Solved Threads: 0

shaun09

Offline

Newbie Poster

Re: Unsure how to save to database dynamic Textfield values

Oct 18th, 2006

Thank you for your help. But there seems to be a problem. It saves to database as

Right now it saves as
A - 1st record
AB - 2nd record
ABC - 3rd record

I want it to be

A B C - 1st record

Thank you for your help.

•

Join Date: Oct 2006

Posts: 15

Reputation: shaun09 is an unknown quantity at this point

Solved Threads: 0

shaun09

Offline

Newbie Poster

Re: Unsure how to save to database dynamic Textfield values

Oct 18th, 2006

Got it working. This the code.

rst2 = stm1.executeQuery("select * from students");
String Childic = "";

for(int i = 0; rst2.next(); i++){
if(request.getParameter("ca1_"+i) !=null){
Childic += " " + rst2.getString("Childic") ;
}
String query2 = "INSERT into results(ca1) values ('"+Childic+"')";
stm2.executeUpdate(query2);

Thank you to all who viewed and helped.