|
|
 |
<%
// Connection of JDBC
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(gbl_cnn,gbl_usr,gbl_pwd);
Statement stmt = conn.createStatement();
if (request.getParameter("service_id") == null) {
%>
<%
// ResultSet rset = stmt.executeQuery ("select distinct dr_list_cat.ID ID, dr_list_cat.E_NAME NAME from dr_list_cat, dr_list, dr_list_cat_type where dr_list.status = 'C' and dr_list_cat.id = dr_list_cat_type.DR_LIST_CAT_ID and dr_list_cat_type.DR_LIST_ID = dr_list.ID and dr_list.E_NAME is not null order by dr_list_cat.E_NAME");
ResultSet rset = stmt.executeQuery ("select ID, E_NAME NAME from dr_list_cat where id <> 4 order by E_NAME");
%>
Please select one of the following health services:
<% int menuitem=1; // ### TEMPORARY, By Samson. If you want to modify, contact me! ###
while (rset.next()) {
%>
<% if ( menuitem == 1) { %>
<% }else{ %>
-
&area=hk">
<%=rset.getString("NAME")%>
<% } %>
<% menuitem++;} %>
|  |
<% } else { %>
<%
String service_name = "";
String service_type = "";
ResultSet rset01 = stmt.executeQuery ("select E_NAME NAME, TYPE from dr_list_cat where ID = " + request.getParameter("service_id"));
while (rset01.next()) {
service_name = rset01.getString("NAME");
service_type = rset01.getString("TYPE");
}
%>
| >
<% if (!(request.getParameter("area") == null)) {
if (request.getParameter("area").equals("hk")) {
out.print("Hong Kong");
}
if (request.getParameter("area").equals("nt")) {
out.print("New Territory");
}
if (request.getParameter("area").equals("kln")) {
out.print("Kowloon");
}
}
%>
|
<% if (service_type.equals("B")) { %>
| Name |
Telephone |
Address |
<% } else {%>
Name |
Telephone |
Address |
<% } %>
<%
String color="9ECDC3";
ResultSet rset4;
String sql;
// Connection of JDBC
if (request.getParameter("area")==null) {
sql = "select A.ID ID, E_NAME NAME, HOTLINE1, E_ADDRESS ADDRESS, to_char(POST_DATE,'YY.MM.DD') POST_DATE, to_char(OFF_DATE,'YY.MM.DD') OFF_DATE from dr_list A, dr_list_cat_type B where A.id = B.dr_list_id and A.status = 'C' and B.dr_list_cat_id =" + request.getParameter("service_id") + " and area='HK' and E_NAME is not null and OFF_DATE > sysdate ";
} else {
if (request.getParameter("area").equals("nt")) {
sql = "select A.ID ID, E_NAME NAME, HOTLINE1, E_ADDRESS ADDRESS, to_char(POST_DATE,'YY.MM.DD') POST_DATE, to_char(OFF_DATE,'YY.MM.DD') OFF_DATE from dr_list A, dr_list_cat_type B where A.id = B.dr_list_id and A.status = 'C' and B.dr_list_cat_id =" + request.getParameter("service_id") + " and area='NT' and E_NAME is not null and OFF_DATE > sysdate ";
} else if (request.getParameter("area").equals("kln")) {
sql = "select A.ID ID, E_NAME NAME, HOTLINE1, E_ADDRESS ADDRESS, to_char(POST_DATE,'YY.MM.DD') POST_DATE, to_char(OFF_DATE,'YY.MM.DD') OFF_DATE from dr_list A, dr_list_cat_type B where A.id = B.dr_list_id and A.status = 'C' and B.dr_list_cat_id =" + request.getParameter("service_id") + " and area='KLN' and E_NAME is not null and OFF_DATE > sysdate ";
} else {
sql = "select A.ID ID, E_NAME NAME, HOTLINE1, E_ADDRESS ADDRESS, to_char(POST_DATE,'YY.MM.DD') POST_DATE, to_char(OFF_DATE,'YY.MM.DD') OFF_DATE from dr_list A, dr_list_cat_type B where A.id = B.dr_list_id and A.status = 'C' and B.dr_list_cat_id =" + request.getParameter("service_id") + " and area='HK' and E_NAME is not null and OFF_DATE > sysdate ";
}
}
if (service_type.equals("B")) {
sql = sql + " order by POST_DATE DESC, OFF_DATE DESC";
} else {
sql = sql + " order by E_NAME";
}
rset4 = stmt.executeQuery (sql);
%>
<% while (rset4.next()) { %>
&type=<%=request.getParameter("service_id")%>&select_hk=-1&select_kln=-1&select_nt=-1">
<%=rset4.getString("NAME")%>
|
<%=rset4.getString("HOTLINE1")%>
|
<%=rset4.getString("ADDRESS")%>
|
<%
color = color.equals("9ECDC3")?"D6F0DF":"9ECDC3";
}
%>
| > |
<% } %>
<% conn.close(); %>
|
|
<%=rset4.getString("NAME")%>