----- Original Message -----
From: "Biren Patnaik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 08, 2000 7:45 AM
Subject: Re: How to access data from multiple selection of CheckBoxes
> Hi Xing,
> Thanx for ur kind contribution to my problems.I m sending u the detail
> code (HTML,JSP AND JAVA BEANS File).Please check it do some modifications
> for geeting the result.My main problem is
> How can I pass parameters in ORACLE depending on the selection of Check
> boxes
> <TEST1.HTML---BEGIN--->
> <html>
>
> <head>
> <title>TABLE1</title>
>
> </head>
>
> <body>
>
> <form method="POST" action="TEST2.jsp">
> <p><select name="D1" size="4" multiple>
> <option selected value="1996">1996</option>
> <option value="1997">1997</option>
> <option value="1998">1998</option>
> <option value="1999">1999</option>
> </select></p>
> <p><input type="checkbox" name="C1" value="ON">TABLE1</p>
> <p><input type="checkbox" name="C2" value="ON">TABLE2</p>
> </form>
> </body>
> </html>
> <----END TEST1.HTML--->
>
> <---BEGIN TEST2.JSP ---->
> <html>
> <head>
> <title>
> Database Search
> </title>
> </head>
> <body background="background8.jpg" bgcolor="#FFFFFF"
> bgproperties="fixed">
>
> <%@ page language="java" import="java.sql.*" %>
>
>
> <jsp:useBean id="db" scope="request" class="TEST3" />
>
> <jsp:setProperty name="db" property="*" />
>
> <%! int numColumns;
> ResultSet rs = null;
> ResultSetMetaData rsmd = null;
> %>
>
> <center>
> <h2>Results From Year</h2>
> <h2><%= request.getParameter("D1") %></h2>
> <hr>
> <br><br>
> <table border="1" bgcolor="#cccc99" bordercolor="#003366">
> <tr>
>
> <%
> String sql1 = request.getParameter("D1");
> String sql2 = request.getParameter("C1");
> String sql3 = request.getParameter("C2");
>
> try {
> db.connect();
> } catch (ClassNotFoundException e) {
> throw new ServletException("Database drivers not available", e);
> } catch (SQLException e) {
> throw new ServletException("Database URL is wrong", e);
> }
>
> try {
>
> <----Here is my main problem for passing parameters into java beans
> program- How can I pass parameters in ORACLE depending on the selection of
> Check boxes ---->
>
>
> rs = db.execSQL(sql1,sql2,sql3);
> } catch (SQLException e) {
>
> }
>
> try {
> rsmd = rs.getMetaData();
> numColumns = rsmd.getColumnCount();
>
> for (int column = 1; column <= numColumns; column++) {
> %>
>
> <th><%= rsmd.getColumnName(column) %></th>
>
> <%
> }
> %>
>
> </tr>
>
> <%
> while (rs.next()) {
> %>
>
> <tr>
>
> <%
> for (int column = 1; column <= numColumns; column++) {
> %>
>
> <td><%= rs.getString(column) %></td>
>
> <% } %>
>
> </tr>
>
> <% }
> rs.close();
> db.close();
> } catch (SQLException e) {
> throw new ServletException("Database error. The query worked, " +
> "but the display didn't", e);
> }
> %>
>
> </table>
> </center>
> </body>
> </html>
> <----END TEST2.JSP---->
>
> <----BEGIN TEST3.JAVA----->
> package com.wrox.jspexamples;
>
> import java.sql.*;
> import java.io.*;
>
> public class TEST3 {
>
> String dbURL,action;
>
> private Connection dbCon;
>
> public TEST3() {
> super();
> }
>
> public boolean connect() throws ClassNotFoundException, SQLException {
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> dbCon =
> DriverManager.getConnection("jdbc:odbc:prjct1","scott","tiger");
> return true;
> }
>
> public void close() throws SQLException {
> dbCon.close();
> }
>
> public ResultSet execSQL(String sq1,String sq2) throws SQLException {
> Statement s = dbCon.createStatement();
>
> //Problem arises here how to pass parameters
>
> ResultSet r = s.executeQuery("SELECT * FROM AOP_SP WHERE SIN_YR =
> '"+sq1+"' OR SIN_YR ='"+sq2+"'");
> return (r == null) ? null : r;
> }
> public void setAction( String pageAction )
> { action = pageAction; }
>
> public String getAction() { return action; }
>
> public int getDbDriver() {
> return 0;
> }
>
> public void setDbDriver(String newValue) {
>
> }
>
>
> }
>
>
> Please answer
> Awaiting ur reply
> Biren
>
>
> On Thu, 8 Jun 2000, Xing Guohong wrote:
>
> > Hi Berin, the example I gave last time is just an example. Now I know
your
> > definite request. I provide the two files to you.
> > --file1.jsp begin
> > <html>
> > <%@ page language="java"%>
> > <form name="test" method="post" action="file2.jsp">
> > <input type="checkbox" name="test" value="aaa">aaa:
> > <input type="checkbox" name="test" value="bbb">bbb:
> > <input type="checkbox" name="test" value="ccc">ccc:
> > <input type="checkbox" name="test" value="ddd">ddd:
> > <input type="submit" name="retrive" value="retrieve">
> > </form>
> > </html>
> > --file1.jsp end
> >
> > --file2.jsp begin
> > <html>
> > <%@ page language="java"%>
> > <%! String str;%>
> > <%
> > str = request.getParameter("test");
> > %>
> > <%=str%>
> > </html>
> > --file2.jsp end
> >
> > After creating the two files, invoke file1.jsp in your browse and
check
> > the checkboxes you want, push the retrieve button then you will get the
> > result you expect. Analyse the string you get and then access the db
> > according to the analysis result. About the accessing to oracle, If you
> > want, I will give your another example.
> > Hope this helps. Any question, contact me.
> >
> > xgh
> >
> > ----- Original Message -----
> > From: Biren Patnaik
> > To: [EMAIL PROTECTED]
> > Sent: Wednesday, June 07, 2000 11:04 PM
> > Subject: Re: How to access data from multiple selection of CheckBoxes
> >
> >
> > Hi xgh,
> > Thanx a lot for ur quick reply to my question.But ur solution did not
help
> > me solving my problem.Can u please send me any examples of accessing
data
> > from Oracle database by multiple selection of CheckBoxes.How can I
retrive
> > data from multiple tables by selecting multiple CheckBoxes.How will I
pass
> > CheckBoxes parameter in my JSP.
> > Awaiting ur reply
> > Biren
> >
> >
> > On Wed, 7 Jun 2000, Xing Guohong wrote:
> >
> > > The follow is an example:
> > > --begin
> > > <html>
> > > <%@ page language="java"%>
> > > <script language="JavaScript">
> > > <!--
> > > function display()
> > > {
> > > var ftest = document.test;
> > > var len = ftest.elements.length;
> > > var i = 0;
> > > var str = "You chose ";
> > > for(i = 0 ; i < len; i++)
> > > {
> > > if(ftest.elements[i].name == "test")
> > > {
> > > if(ftest.elements[i].checked)
> > > {
> > > str += ftest.elements[i].value;
> > > str += " ";
> > > }
> > > }
> > > }
> > > alert(str);
> > > }
> > > file://-->
> > > </script>
> > > <form name="test">
> > > <input type="checkbox" name="test" value="aaa">aaa:
> > > <input type="checkbox" name="test" value="bbb">bbb:
> > > <input type="checkbox" name="test" value="ccc">ccc:
> > > <input type="checkbox" name="test" value="ddd">ddd:
> > > <input type="button" name="ok" value="test"
> > onClick="javascript:display();">
> > > </form>
> > > </html>
> > > --end
> > >
> > > If you submit the page to another page that get the checkbox info, try
> > > request.getParameter("test") in that page.
> > >
> > > xgh
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: Biren Patnaik
> > > To: [EMAIL PROTECTED]
> > > Sent: Wednesday, June 07, 2000 08:06 PM
> > > Subject: How to access data from multiple selection of CheckBoxes
> > >
> > >
> > > Hi,
> > > Can anyone please suggest me how to generate data from multiple
selection
> > > of Check Boxes.
> > > I m describing my problems as below.
> > > I have got one List Boxes.There are 4 items in List Boxes.They are all
> > > Numeric.They are 1997,1998,1999,2000 all are values for Year.
> > > I have 4 Check Boxes,They are D1,D2,D3,D4.D1 is a column name of table
> > > tab1,Like that D2 is a column name of table tab2,like of D3 and D4.
> > > year is one of the column name of tab1,tab2,tab3 and tab4 table.
> > > My problem is If I select 1997 from List Boxes and select D1,D2,D3
from
> > > Check Boxes,I should get records generated from tab1,tab2,tab3 for the
> > > year 1997
> > > I will appreciate for any kinds of solution.
> > > Thanks in advance
> > > Biren
> >
> >
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
