Forum:

Radio Button,Check Boxes

rose hegde

Ranch Hand

Posts: 40

posted 13 years ago

Using Jsp and java i am inserting records in database through a form consisting of text fields,radio buttons and check boxes.The records r inserted successfully and displayed using jsp page.Now i want to modify a particular record where in i get all the values of the particular record stored in text fields but i dont know how to retrieve the status of radio buttons and check boxes stored in database through jsp.
Pls Help

Mathias Nilsson

Ranch Hand

Posts: 107

posted 13 years ago

I don't know you the form looks like when you are adding an item.
But let's say you have a form that looks like this

In the servlet you use request.getParameter to retrive the data entered.
When inserted into a database you normaly have an identity key. That means that a row in the table must be unique to retrive the data.
Here's an example table

TABLE Interrest
InterrestId | Name    | WantEmail | Interrest
1             Test      1           Java
2             Mathias   1           C++
When you have selected a specific record, let's say the record with interrestId 2 then you know the name , If the user wants email and the interrest. To Show this on the page use a servlet or a JSP ( compiled to servlet ).
Here's an example in how to make the checkbox checked 
[CODE]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled</title>
</head>
<body>

<%
// Get the Data
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ).newInstance();
Connection connection = DriverManager.getConnection( "jdbc :-o	 dbc:nsab" , "" , "" );
PreparedStatement ps = connection.prepareCall( SQL );
String SQL = "SELECT * FROM Interrest WHERE InterrestId = ?"
ps.setInt( 1 , Integer.parseInt( request.getParameter( "InterrestId" ) ) );
ResultSet result = ps.executeQuery();

String CHECKED = "";

if( result.next ){
// No need to loop since we know
// There is only one record

String interrest = result.getString( "Interrest" )

%>
<%
// Do this for all interrests
if( interrest.toLowerCase() == "java" ){
CHECKED = "Checked"
}else{
CHECKED = ""
}
%>
 Interrest<br>
<input type="radio" name="Topic" value="Java" <%= CHECKED %>> - Java<br>
<input type="radio" name="Topic" value="C++"> - C++<br>
<input type="radio" name="Topic" value="C"> - C<br>
<%

}

</body>
</html>

// Mathias

SCJP2 , MCP( 70-229 ) , Preparing For SCWDC

rose hegde

Ranch Hand

Posts: 40

posted 13 years ago

for text field value to modify , i get the value when i write in jsp--
<input name="txtlename" type="text" id="txtlenam" value="<%=leaveHandler.getleaverecord(Integer.parseInt(i),1)%>" >
but when i write the same for radio button or check it does not happen...
<input type="checkbox" name="carried" value="<%=leaveHandler.getleaverecord(Integer.parseInt(i),4)%>">
Pls help

Mathias Nilsson

Ranch Hand

Posts: 107

posted 13 years ago

Have you viewed the source to see if doesn't have a value?
Right click the browser and select view source. Scroll down to the
checkbox.
If it has a value then it has nothing to do with CHECKED.

SCJP2 , MCP( 70-229 ) , Preparing For SCWDC

rose hegde

Ranch Hand

Posts: 40

posted 13 years ago

When i see source it has a value but it does not display in form.

Radio Button,Check Boxes

Similar Threads