DaniWeb Forum Index > Web Development > JSP

inserting multiple selection from checkbox in to one column

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

•

Join Date: Mar 2006

Posts: 20

Reputation: muthumari is an unknown quantity at this point

Solved Threads: 0

muthumari

Offline

Newbie Poster

inserting multiple selection from checkbox in to one column

Mar 30th, 2006

Hi,

Hoe to insert multiple selection from checkbox(from jsp) in to one column of the table(sql server database ).

Anyone can you help me?

Thanx

•

Join Date: Feb 2006

Posts: 2,415

Reputation: masijade has much to be proud of

Solved Threads: 256

masijade

Offline

Nearly a Posting Maven

Re: inserting multiple selection from checkbox in to one column

Mar 30th, 2006

With a prepared statement and multiple executes.

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: Mar 2006

Posts: 20

Reputation: muthumari is an unknown quantity at this point

Solved Threads: 0

muthumari

Offline

Newbie Poster

Re: inserting multiple selection from checkbox in to one column

Mar 30th, 2006

•

Originally Posted by masijade

With a prepared statement and multiple executes.

Hi,
Thanx for your reply . I know, how to retreive the checkbox value(using prepared statement with request.getParameteVales("checkboxname")).

But, It will return an array of values.
I don't know about how to insert this array of values into single column of the table(sqlserver database).

•

Join Date: Feb 2006

Posts: 2,415

Reputation: masijade has much to be proud of

Solved Threads: 256

masijade

Offline

Nearly a Posting Maven

Re: inserting multiple selection from checkbox in to one column

Mar 30th, 2006

No What I meant was using the JDBC prepared statement. here an example:

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
String[] vals = request.getParameterValues("checkbox");
try {
  PreparedStatement pStmt = conn.prepareStatement("Insert into table (field) values (?)");
  for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();
  }
} catch .....
String[] vals = request.getParameterValues("checkbox");
try {
  PreparedStatement pStmt = conn.prepareStatement("Insert into table (field) values (?)");
  for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();
  }
} catch .....

of course replacing checkbox, table, and field with the real things.

•

Join Date: Mar 2006

Posts: 20

Reputation: muthumari is an unknown quantity at this point

Solved Threads: 0

muthumari

Offline

Newbie Poster

Re: inserting multiple selection from checkbox in to one column

Mar 30th, 2006

•

Originally Posted by masijade

No What I meant was using the JDBC prepared statement. here an example:
Help with Code Tags

JSP Syntax (Toggle Plain Text)
String[] vals = request.getParameterValues("checkbox");
try {
  PreparedStatement pStmt = conn.prepareStatement("Insert into table (field) values (?)");
  for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();
  }
} catch .....
String[] vals = request.getParameterValues("checkbox"); try { PreparedStatement pStmt = conn.prepareStatement("Insert into table (field) values (?)"); for (String val : vals) { pStmt.setString(1, val); pStmt.execute(); } } catch .....
of course replacing checkbox, table, and field with the real things.

Hi i have one error in this line:

pStmt.setString(1, val);

The error is ; expected.
I haven't any idea about this

Can you help me

•

Join Date: Feb 2006

Posts: 2,415

Reputation: masijade has much to be proud of

Solved Threads: 256

masijade

Offline

Nearly a Posting Maven

Re: inserting multiple selection from checkbox in to one column

Mar 30th, 2006

Are you using jdk 1.5 or an earlier version. If you are not using 1.5 then the following lines
must be changed:

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
  for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();
  for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();

to:

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
  for (int i = 0; i < vals.length; i++) {
    pStmt.setString(1, vals[i]);
    pStmt.execute();
  for (int i = 0; i < vals.length; i++) {
    pStmt.setString(1, vals[i]);
    pStmt.execute();

•

Join Date: Oct 2009

Posts: 1

Reputation: alokranjan.java is an unknown quantity at this point

Solved Threads: 0

alokranjan.java alokranjan.java is offline

Offline

Newbie Poster

-1

Oct 15th, 2009

multiple checkbox & textfield insert in Oracle9i using Jsp

•

Join Date: Dec 2004

Posts: 4,206

Reputation: peter_budo has much to be proud of

Solved Threads: 486

peter_budo peter_budo is online now

Online

Code tags enforcer

-1

Oct 15th, 2009

•

Originally Posted by alokranjan.java

multiple checkbox & textfield insert in Oracle9i using Jsp

It is bad enough that you reopened old thread you did not even provided proper description of whatever you up to. Do you mind to correct your mistake?

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group