•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 401,707 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,947 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our JSP advertiser: Lunarpages JSP Web Hosting
Views: 7626 | Replies: 5
 |
•
•
Join Date: Mar 2006
Posts: 20
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
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
•
•
Join Date: Feb 2006
Posts: 1,375
Reputation:
Rep Power: 8
Solved Threads: 120
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
•
•
Join Date: Mar 2006
Posts: 20
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
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).
•
•
Join Date: Feb 2006
Posts: 1,375
Reputation:
Rep Power: 8
Solved Threads: 120
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
•
•
Join Date: Mar 2006
Posts: 20
Reputation:
Rep Power: 3
Solved Threads: 0
Newbie Poster
•
•
•
•
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
•
•
Join Date: Feb 2006
Posts: 1,375
Reputation:
Rep Power: 8
Solved Threads: 120
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
|
•
•
•
•
•
•
•
•
DaniWeb JSP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- 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
