<select name="status" id="status" onChange="getStatusDetails(this);">
<option value="S">Stop user</option>
<option value="N">New user</option>
<option value="R">Replace user</option>
</select>
It is insert into database
Now retrieve ::
select *from (select rownum sl_no,process_id,req_by_id,user_id,area_exec_id,area_id,user_new_replacement_status,decode(user_new_replacement_status,'S','Stop user','N','New user','Replace user') userStatusLevel,start_from_dt,stop_from_dt,instruction_by,instruction_by_name,designation,instruction_date_time from ms_system_user_process order by entry_time desc) where sl_no<11 order by 1
executiveInfo.setUser_new_replacement_status(rs.getString("user_new_replacement_status"));
executiveInfo.setUserStatusLevel(rs.getString("userStatusLevel"));
Jsp page ::
<td><div style="float:left;width:50px;height:auto;display:none;"><s:property value='user_new_replacement_status'/></div>
<div style="float:left;width:120px;height:auto;"><s:property value='userStatusLevel'/></div>
</td>
DB ::
<option value="S">Stop user</option>
<option value="N">New user</option>
<option value="R">Replace user</option>
</select>
It is insert into database
Now retrieve ::
select *from (select rownum sl_no,process_id,req_by_id,user_id,area_exec_id,area_id,user_new_replacement_status,decode(user_new_replacement_status,'S','Stop user','N','New user','Replace user') userStatusLevel,start_from_dt,stop_from_dt,instruction_by,instruction_by_name,designation,instruction_date_time from ms_system_user_process order by entry_time desc) where sl_no<11 order by 1
executiveInfo.setUser_new_replacement_status(rs.getString("user_new_replacement_status"));
executiveInfo.setUserStatusLevel(rs.getString("userStatusLevel"));
Jsp page ::
<td><div style="float:left;width:50px;height:auto;display:none;"><s:property value='user_new_replacement_status'/></div>
<div style="float:left;width:120px;height:auto;"><s:property value='userStatusLevel'/></div>
</td>
DB ::
No comments:
Post a Comment