0

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

4
Contributors
7
Replies
18
Views
11 Years
Discussion Span
Last Post by peter_budo
1

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

0

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

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.

0

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

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

0

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

for (String val : vals) {
    pStmt.setString(1, val);
    pStmt.execute();

to:

for (int i = 0; i < vals.length; i++) {
    pStmt.setString(1, vals[i]);
    pStmt.execute();
0

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?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.