<%@ page import="java.sql.Date" %>
<%@ page import="java.util.Calendar" %>
<%@ page import="metadata.beans.*" %>
<%@ page import="utility.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.aha.data.db.OracleBean"%>
<%@ page import="java.text.SimpleDateFormat"%>
<%@ page import="oracle.sql.CLOB"%>
<%@ page import="java.text.*" %>
<%@ page import="com.aha.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="com.aha.data.db.pooling.*"%>
<%@ page import="oracle.jdbc.OracleConnection"%>
<%@ page import="oracle.jdbc.OraclePreparedStatement"%>
<%@ page import="oracle.jdbc.OracleResultSet"%>
<%
String programfocus = request.getParameter("programfocus");
programfocus = (programfocus == null)?"0":programfocus;
String dom = request.getParameter("domain");
dom = (dom == null)?"HEALTHCAREWORKFORCE":dom;
%>
Case Examples
<%@ include file="/include/header_gen.html"%>
<%
// Include the appropriate sub-headers
int prog = Integer.parseInt(programfocus);
switch (prog)
{
case 1:%>
<%@ include file="/include/bodyhead/bhid_fost_work.html"%>
<%break;
case 2:%>
<%@ include file="/include/bodyhead/bhid_fost_scheduling.html"%>
<%break;
case 3:%>
<%@ include file="/include/bodyhead/bhid_fost_usetech.html"%>
<%break;
case 4:%>
<%@ include file="/include/bodyhead/bhid_part_culture.html"%>
<%break;
case 5:%>
<%@ include file="/include/bodyhead/bhid_part_frontline.html"%>
<%break;
case 6:%>
<%@ include file="/include/bodyhead/bhid_part_rewards.html"%>
<%break;
case 7:%>
<%@ include file="/include/bodyhead/bhid_part_careerdev.html"%>
<%break;
case 8:%>
<%@ include file="/include/bodyhead/bhid_part_newemployee.html"%>
<%break;
case 9:%>
<%@ include file="/include/bodyhead/bhid_part_retention.html"%>
<%break;
case 10:%>
<%@ include file="/include/bodyhead/bhid_brod_diversity.html"%>
<%break;
case 11:%>
<%@ include file="/include/bodyhead/bhid_brod_generational.html"%>
<%break;
case 12:%>
<%@ include file="/include/bodyhead/bhid_brod_internships.html"%>
<%break;
case 13:%>
<%@ include file="/include/bodyhead/bhid_brod_growyourown.html"%>
<%break;
case 14:%>
<%@ include file="/include/bodyhead/bhid_brod_scholarships.html"%>
<%break;
case 15:%>
<%@ include file="/include/bodyhead/bhid_brod_recruitment.html"%>
<%break;
case 16:%>
<%@ include file="/include/bodyhead/bhid_coll_k12education.html"%>
<%break;
case 17:%>
<%@ include file="/include/bodyhead/bhid_coll_college.html"%>
<%break;
case 18:%>
<%@ include file="/include/bodyhead/bhid_coll_community.html"%>
<%break;
default:%>
<%@ include file="/include/bodyhead_id_fost.html"%>
<%
}
%>
<%
String dcrPath = null;
String summary = "";
OracleBean oraBean = null;
ResultSet rs = null;
try{
oraBean = new OracleBean();
String sql = "SELECT s.dcrpath, s.summary, c.instname from ce_summary s, case_examples c where s.domain = '" + dom + "' and s.categoryid = '"+programfocus+"' and s.dcrpath = c.dcrpath and s.domain = c.domain order by c.instname";
// String sql = "SELECT s.dcrpath, s.summary, c.instname, f.category from ce_summary s, case_examples c, category f where s.domain = '" + dom + "' and s.categoryid = '"+programfocus+"' and s.categoryid=f.categoryid and s.dcrpath = c.dcrpath and s.domain = c.domain order by c.instname";
// out.println(sql);
oraBean.setSQL(sql);
rs = oraBean.execute();
if(rs.next()){
int i = 1000;
do{
i++;
dcrPath = rs.getString("dcrpath");
String instname = rs.getString("instname");
Clob clob = rs.getClob("summary");
if (clob != null){
summary = DbUtil.readClob(rs.getClob("summary")).toString();
}
%>
<%=instname%>
EXECUTIVE SUMMARY
<%=summary%>
<%
}while(rs.next());
} else {
%>
| |
There are no Case Examples in this category, Please visit this page later |
|
| |
<%
}
} catch(Exception e) {
out.println("There was an error while retrieving the case example Error: "+e.toString()+"
");
e.printStackTrace();
} finally {
try{
if(rs != null)
rs.close();
if(oraBean != null)
oraBean.close();
}catch(Exception _e){
}
}
%>
<%@ include file="/include/bodyfoot_idea.html"%>
<%@ include file="/include/footer_gen.html"%>