File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes inserting checkbox in database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "inserting checkbox in database" Watch "inserting checkbox in database" New topic

inserting checkbox in database

Deepak Chawla
Ranch Hand

Joined: Nov 19, 2003
Posts: 50
I have a checkbox in the form, i want that when i hit submit, it should insert its information in database. can anyone tell me how to do that.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63858

What have you tried on your own? What code have you written and where are you having problems?

[Asking smart questions] [About Bear] [Books by Bear]
Deepak Chawla
Ranch Hand

Joined: Nov 19, 2003
Posts: 50
That's what i am trying to ask because i know i can insert other fields in database but do i have to create a field in database for that checkbox and also how that field will recognize a check.
ANy sugesstions???
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
It's up to you to determine how you want to represent a checkbox value in your DB. The key is storing the appropriate value and interpreting the value correctly when it's retrieved from the database to be displayed on the screen. Some people use 1/0, on/off to indicate checked/unchecked.

So much trouble in the world -- Bob Marley
I agree. Here's the link:
subject: inserting checkbox in database
jQuery in Action, 3rd edition