Forum:

How to set check/unckeck Checkbox using database value

Greenhorn

Posts: 4

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi everyone

I am displaying a jsp page with 3 columns 1> complaint_no, 2>user_id, 3>attend_yn.
The 3rd col. attend_yn will be checkbox.
When user logs in he will see complaints assigned to him, he will select one or more complaint_no which he will attend.

My problem is how to handle checkbox value.
The value of attend_yn='A' when checked by user and attend_yn='N' when user doesn't select any or deselect existing selected complaint.

I want to show the checkbox checked when attend_yn='A' and unchecked when attend_yn='N'.

<body>
<form name="form1" method="post" action="../ui/AttendOKUIB.jsp?login_id=<%=login_id%>" ONSUBMIT="return onSubmit(this)">
  <table width="112%" border="0" align="center" bgcolor="#999999" nosave cellpadding="0" cellspacing="1" bordercolor="#B9B9FF">
<tr> 
 
  <th width="403" height="23"><b>Complaint No</b></th>
  <th width="286" height="23">U<b>ser</b></th>
  <th width="373" height="23"><b>Select</b></th>
 
</tr>
<%
    DBConnectionOra dbc = new DBConnectionOra();
    Connection con = dbc.getConnectionOra();
    Statement stmt = con.createStatement();
    String query = null; 
    
    query = "select comp_no, user_id, attend_yn from  crs_cmpeng  b.user_id like " + "'"+ u1 +"'"  +  " a ORDER BY 1";
    
ResultSet rs = stmt.executeQuery(query);
 
while(rs.next()) {
%>

For checkbox "attendchk" how to set value 'A' and checked as retrieved from database and value to 'N' and unchecked .

I am able to loop through complaint_no but without values of checkbox as 'A' or 'N' I cannot update database.

In AttendOKUIB.jsp I have some code as

Hope I am clear
Please advice

Tushar
[ December 26, 2008: Message edited by: Tushar tej ]

Sunil Kumar

Ranch Hand

Posts: 81

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Check the value in the scriplet

Here i am assuming that the only value other than A would be N
If that is not the case, i hope you got the idea and can change the above code as per you data points
[ December 26, 2008: Message edited by: Sunil Kumar ]

Sunil Kumar
> Think Witty <

Bear Bibeault

Sheriff

Posts: 67747

173

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Better yet, step out of 2001 and avoid scriptlets by using the JSTL and EL.

For conditionals you can use the JSTL's <c:if> action, or the EL's ternary operator (?).
[ December 26, 2008: Message edited by: Bear Bibeault ]

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Tushar tej

Greenhorn

Posts: 4

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
Sunil bhai thanks every much you solved my problem.

Hi,
Bear Bibeault still learning JSP and will also look into JSTL and EL.

My good luck I found this forum.
Thanks both of you.

Tushar
[ December 26, 2008: Message edited by: Tushar tej ]

Bear Bibeault

Sheriff

Posts: 67747

173

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If you are just learning JSP, I'd suggest learning the right and modern way of doing things right off the bat and to be sure and avoid scriptlets entirely.

[Asking smart questions] [About Bear] [Books by Bear]

Bauke Scholtz

Ranch Hand

Posts: 2458

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Add this to your web.xml to force yourself into a scriptletless way:

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?