check boxes retrieving problem

[mallikarjun dontamsetti]

Actually i am not sure weather i have to ask this question in jsp or JDBC forum please help me... with this problem

I am using jstl in jsp and to display the data which is already in database and my problem is there are some check boxes are ther in jsp those have to display the data when page is loaded. The related column in DB is STD_COURSE which has courses like java,.net,c,cpp...multiple in a single column,I don't have any idea how to get and chck which one is checked.....


my code is

editstudent.jsp

          <tr>
          <td align="right"><span class="mandatarycolor">*</span>Courses:</td>
          <td width="100%"><div > 
            <c:choose>
                <c:when items="${view.STD_COURSE=="java"}"
              <input type="checkbox"  name="c1" id="c1"  value="java" checked="checked"/>Java 
                    <input type="checkbox"  name="c2" id="c2"  value="net"/>.Net
                  <input type="checkbox"  name="c3" id="c3"  value="c"/>C</div>
                </c:when>
             <c:when items="${view.STD_COURSE=="c"}"
              <input type="checkbox"  name="c1" id="c1"  value="java" />Java 
                    <input type="checkbox"  name="c2" id="c2"  value="net" />.Net
                  <input type="checkbox"  name="c3" id="c3"  value="c" checked="checked"/>C</div>
                </c:when>
            <div>3500        3000     500
            </div>
            </td>   
            </tr>
            //here also same stuff----------------------------------<c:when> thing
            <tr>
            <td></td>
           <td  ><div> <input type="checkbox"  name="c4" id="c4"  value="cpp"/>C++ 
                    <input type="checkbox"  name="c5" id="c5"  value="oracle"/>Oracle
                    <input type="checkbox"  name="c6" id="c6"  value="network"/>NetWork</div>
            <div>1000        3000     5000
            </div>
            </td>   
            </tr> 
           
            <tr>
            <td></td>
             <td><div> <input type="checkbox"  name="c7" id="c7"  value="sap"/>SAP 
                    <input type="checkbox"  name="c8" id="c8"  value="web"/>Web
                    <input type="checkbox"  name="c9" id="c9"  value="testingtool"/>TestingTool</div>
            <div>10000        2500     3000
            </div>
            </td>   
            </tr> 

my query is

select STD_SNO,STD_FIRSTNAME,STD_MIDDLENAME,STD_LASTNAME,STD_GENDER,to_char(STD_DOB),STD_QUALIFICATION,STD_COURSE,STD_FEE,STD_ADD1,STD_ADD2,STD_ADD3,STD_CITY,STD_STATE,STD_ZIP from STUDENT_MALLI where STD_SNO="+eid

my problem is how to get data when different courses are there ?
The code i have written is not working if the first condition is true then it is not displaying boxes in next tr

[Madhan Sundararajan Devaki]

Is the table containing STD_COURSE a master/reference/read-only table?

Ideally, you should have the following tables, STUDENT_MASTER, COURSE_MASTER and STUDENT_COURSE_MAPPING.

STUDENT_MASTER = Student Details + Student ID
COURSE_MASTER = Course Details + Course ID
STUDENT_COURSE_MAPPING = Student ID + Course ID

Now, the STUDENT_COURSE_MAPPING table will contain Student ID, Course ID rows, for each student mapped to multiple courses.

Query this table to find the courses mapped and then in your front-end select/un-select the checkboxes appropriately.

[mallikarjun dontamsetti]

Thanks for reply Madhan Sundararajan Devaki
I solved it
my code is

 <c:set var="tmpstr" value="${view.STD_COURSE}"/>
    <c:set var="condition" value="1"/>
    <tr>
        <td align="right" valign="top"><span class="mandatarycolor">*</span>Courses:</td>
        <td >
            <table width="100%" border="0" >
            <tr>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop=="Java"}'>
                            <c:set var="condition" value="0"/>
                            <input type="checkbox"  name="checkbox" id="checkbox" checked="checked" value="Java" onClick="calculate(this,'4000');" />Java <br />4000
                        </c:if>
                    </c:forEach>
                    <c:if test='${condition==1}'>
                        <input type="checkbox"  name="checkbox" id="checkbox" value="Java" onClick="calculate(this,'4000');" />Java <br />4000
                    </c:if>
                </td>
                <c:set var="condition" value="1"/>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop==".Net"}'>
                            <c:set var="condition" value="0"/>
                            <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'4000');" checked="checked" value=".Net"/>.Net <br />4000
                        </c:if>
                    </c:forEach>
                    <c:if test='${condition==1}'>
                        <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'4000');" value=".Net"/>.Net <br />4000
                    </c:if>
                </td>
                 <c:set var="condition" value="1"/>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop=="C"}'>
                            <c:set var="condition" value="0"/>
                            <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'1500');" checked="checked" value="C"/>C  <br />1500
                        </c:if>
                    </c:forEach>
                    <c:if test='${condition==1}'>
                         <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'1500');" value="C"/>C  <br />1500
                    </c:if>
                </td>
            </tr>
            <tr>
                 <c:set var="condition" value="1"/>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop=="SAP"}'>
                            <c:set var="condition" value="0"/>
                            <input type="checkbox"  name="checkbox" id="checkbox" checked="checked" onClick="calculate(this,'8000');"  value="SAP"/>SAP <br />8000
                        </c:if>
                    </c:forEach>
                    <c:if test='${condition==1}'>
                        <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'8000');"  value="SAP"/>SAP <br />8000
                    </c:if>
                </td>
                <c:set var="condition" value="1"/>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop=="Oracle"}'>
                            <c:set var="condition" value="0"/>
                            <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'2000');" checked="checked" value="Oracle"/>Oracle <br />2000
                        </c:if>
                    </c:forEach>
                    <c:if test='${condition==1}'>
                        <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'2000');"  value="Oracle"/>Oracle <br />2000
                    </c:if>
                </td>
                <c:set var="condition" value="1"/>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop=="C++"}'>
                            <c:set var="condition" value="0"/>
                            <input type="checkbox"  name="checkbox" id="checkbox" checked="checked" onClick="calculate(this,'1800');" value="C++"/>C++ <br />1800
                        </c:if>
                    </c:forEach>
                    <c:if test='${condition==1}'>
                        <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'1800');" value="C++"/>C++ <br />1800
                    </c:if>
                </td>
            </tr>
            <tr>
                <c:set var="condition" value="1"/>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop=="Network"}'>
                            <c:set var="condition" value="0"/>
                            <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'4000');" checked="checked" value="Network"/>Network <br />4000
                        </c:if>
                    </c:forEach>
                   <c:if test='${condition==1}'>
                        <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'4000');"  value="Network"/>Network <br />4000
                   </c:if>
                </td>
                <c:set var="condition" value="1"/>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop=="VC++"}'>
                            <c:set var="condition" value="0"/>
                             <input type="checkbox"  name="checkbox" id="checkbox" checked="checked" onClick="calculate(this,'4000');" value="VC++"/>VC++ <br />4000
                        </c:if>
                    </c:forEach>
                    <c:if test='${condition==1}'>
                        <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'4000');" value="VC++"/>VC++ <br />4000
                    </c:if>
                </td>
                <c:set var="condition" value="1"/>
                <td>
                    <c:forEach items='${fn:split(tmpstr,",")}' var="loop">
                        <c:if test='${loop=="Web Technologies"}'>
                            <c:set var="condition" value="0"/>
                            <input type="checkbox"  name="checkbox" id="checkbox" checked="checked" onClick="calculate(this,'1500');" value="Web Technologies"/>Web Technologies  <br />1500
                        </c:if>
                    </c:forEach>
                     <c:if test='${condition==1}'>
                        <input type="checkbox"  name="checkbox" id="checkbox" onClick="calculate(this,'1500');" value="Web Technologies"/>Web Technologies  <br />1500
                    </c:if>
               
                </td>
</tr>

Now my problem is i have to check the each time(repeat the c:forEach loop) i don't want that is there any simple way for comparring the string