reading checkbox combobox values

Ranch Hand

Posts: 225

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi

i am designing a web portal

i need that what checkbox & combo box are selected they hould be shown on a new page & should also be inserted in database

I have created only a single jsp file which is coded as

<%@ page language="java" pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%> 
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
 <%@ page import="ams.database.database" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %> 
<html> 
	<head>
		<title>JSP for MappingForm form</title>
	</head>
	<body>
	<%
	response.setHeader("Expires", "Sat, 6 May 1995 12:00:00 GMT");
	response.setHeader("Cache-Control","no-cache");
	response.setHeader("Pragma","no-cache");
	response.setHeader("Cache-Control","no-store, no-cache, must-revalidate");
	response.addHeader("Cache-Control", "post-check=0, pre-check=0");
	response.setHeader("Cache-Control", "max-stale=0"); 
%>

<%
 Connection connection = new database().getConnection();
 Statement statement = null;
 Statement s=null;
 ResultSet rs = null;
 ResultSet rst=null;
 statement = connection.createStatement();
 // sql query to retrieve values from the secified table.
 String QueryString = "SELECT * from ams_division;";
 String Query="Select * from sec_code;";
 rs = statement.executeQuery(QueryString);
 rst=s.executeQuery(Query);
 
%>
		
		Module to Map Different Sections With the Divisions
		 
		Select the division 
		 
		 <%
 while (rs.next()) {
 %>
 <html:select property="division">
 <option value="-1">--- Select ---</option> 
 <option > <%=rst.getString(2)%></option>
 
 </html:select><html:errors property="division"/> 
		Check the Sections of above selected division
		 
			<html:checkbox property="section"/>    <%=rst.getString(1)%>   <%=rst.getString(2)%>   <%=rst.getString(3)%> 
			 
			<html:submit/>
				<%} %> 
		
			
	</body>
</html>

thank you

Anbarasu Aladiyan

Ranch Hand

Posts: 182

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

For combobox, you can set the name, id attribute values as "someconstant"+id_from_db.
For checkbox, you can name as same for all checkboxes and set value attribute as id_from_dn. So you can get the selected checkbox in the "Array" form, which will have all the selected checkboxes values (ie.. ids_from_db).

Anbarasu Aladiyan

Ranch Hand

Posts: 182

I like...

posted 14 years ago