inserting multiple selection from checkbox in to one column
Please support our JSP advertiser: Programming Forums
 |
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
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
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
----------------------------------------------
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
Re: inserting multiple selection from checkbox in to one column •
•
•
•
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).
No What I meant was using the JDBC prepared statement. here an example:
of course replacing checkbox, table, and field with the real things.
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.
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
----------------------------------------------
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
•
•
•
•
Originally Posted by masijade
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
Are you using jdk 1.5 or an earlier version. If you are not using 1.5 then the following lines
must be changed:
to:
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(); 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
----------------------------------------------
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
|
Similar Threads
Other Threads in the JSP Forum
- Store multiple selection from pagination info into single array (PHP)
- How to store multiple selection? (VB.NET)
- How do I populate multiple column list box? (Visual Basic 4 / 5 / 6)
- Adding a checkbox column dynamically (C#)
Other Threads in the JSP Forum
- Previous Thread: How to get Array type members' value from a class
- Next Thread: creating a .exe file of a web application
•
•
•
•
Views: 10087 | Replies: 5 | Currently Viewing: 1 (0 members and 1 guests)
Linear Mode
