Ad:

JSP Discussion Thread
Unsolved
Views: 16378

Mar 30th, 2006

inserting multiple selection from checkbox in to one column

Expand Post »

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

Similar Threads

How do I populate multiple column list box? in Visual Basic 4 / 5 / 6
Store multiple selection from pagination info into single array in PHP
How to store multiple selection? in VB.NET
Adding a checkbox column dynamically in C#

muthumari

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

20 posts
since Mar 2006

Permalink

Mar 30th, 2006

Re: inserting multiple selection from checkbox in to one column

With a prepared statement and multiple executes.

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

Mar 30th, 2006

Re: inserting multiple selection from checkbox in to one column

Quote 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).

muthumari

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

20 posts
since Mar 2006

Permalink

Mar 30th, 2006

Re: inserting multiple selection from checkbox in to one column

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

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.

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

Mar 30th, 2006

Re: inserting multiple selection from checkbox in to one column

Quote originally posted by masijade ...

No What I meant was using the JDBC prepared statement. here an example:
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

muthumari

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

20 posts
since Mar 2006

Permalink

Mar 30th, 2006

Re: inserting multiple selection from checkbox in to one column

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

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:

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();

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

Oct 15th, 2009

-1

Re: inserting multiple selection from checkbox in to one column

multiple checkbox & textfield insert in Oracle9i using Jsp

alokranjan.java

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2009

Permalink

Oct 15th, 2009

-1

Re: inserting multiple selection from checkbox in to one column

Click to Expand / Collapse Quote 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?

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 871

Code tags enforcer

Offline

6,653 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: can some one help me

Next Thread in JSP Forum Timeline: problem in importing package

DaniWeb Message

Cancel Changes

User Name
Password