<%@page language="java" contentType="text/html;charset=big5"%> <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> <%@page import="java.sql.*,java.util.*,javax.naming.*,javax.sql.*"%> <%! Connection con = null; public void jspInit() { try { //======= Use ServletContext Object to get Global Parameter,and it setting on web.xml /*String JDBCDriver = getServletContext().getInitParameter("JDBCDriver"); String ConnectionUrl = getServletContext().getInitParameter("MSSqlURL"); String userName = getServletContext().getInitParameter("userName"); String password = getServletContext().getInitParameter("password"); Class.forName(JDBCDriver); con = java.sql.DriverManager.getConnection(ConnectionUrl,userName,password);*/ //=================================================================================== //======= Use ServletContext Object to get Global Parameter,and it setting on web.xml String JDBCDriver = getServletContext().getInitParameter("MySql_JDBCDriver"); String ConnectionUrl = getServletContext().getInitParameter("MySql_URL"); String userName = getServletContext().getInitParameter("MySql_userName"); String password = getServletContext().getInitParameter("MySql_password"); Class.forName(JDBCDriver); con = java.sql.DriverManager.getConnection(ConnectionUrl,userName,password); //=================================================================================== //======= JDNI [Connection Pooling] Must setting server.xml & web.xml ======= /*Context initContext = new InitialContext(); Context envContext = (Context)initContext.lookup("java:comp/env"); DataSource ds = (DataSource)envContext.lookup("jdbc/hostudy"); con = ds.getConnection();*/ //=========================================================================== } catch(Exception ex) { System.out.println(ex.toString()); } } public void jspDestroy() { try { con.close(); } catch(Exception ex) { System.out.println(ex.toString()); } } public String[][] ShowCategory(String categoryid) { String[][] rsCategory={{"Category",""}, {"CategoryTitle",""}, {"CategoryDesc",""}, {"CategoryDetail",""}}; StringBuffer sbCT = new StringBuffer(); StringBuffer sbCD = new StringBuffer(); StringBuffer sbCDT = new StringBuffer(); Statement stmt = null; ResultSet rs = null; try { stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery("SELECT * FROM HMR01 WHERE category_id='"+categoryid+"'"); if(!rs.next()) { rsCategory[0][1]="Sorry!No content."; rsCategory[1][1]="Sorry!No content."; rsCategory[2][1]="Sorry!No content."; } else { //rs.beforeFirst(); String category_id,category,category_desc,category_detail,category_icom,category_img; category_id=category=category_desc=category_detail=category_icom=category_img=""; category_id=rs.getString("category_id"); category=rs.getString("category"); category_desc=rs.getString("category_desc"); category_detail=rs.getString("category_detail"); category_icom=rs.getString("category_icom"); category_img=rs.getString("category_img"); sbCT.append(""); if(category_detail.indexOf("&")!=-1) { sbCD.append(category_desc+"

"); String[] categoryDetailArray = category_detail.split("&"); for(int i=0;i"); sbCD.append("

"+categoryDetailArray[i]+"

"); } //sbCD.append(category_desc+"

"+category_detail.substring(0,100)+"

"); //sbCD.append(category_detail.substring(100,130)+"

"+category_detail.substring(130)+"

"); } else { sbCD.append(category_desc+"
"+category_detail); } sbCDT.append(""); rsCategory[0][1]=category; rsCategory[1][1]=sbCT.toString(); rsCategory[2][1]=sbCD.toString(); rsCategory[3][1]=sbCDT.toString(); } } catch(SQLException e) { e.printStackTrace(); //out.println("Error Trace in getConnection() : " + e.getMessage()); } finally { try { stmt.close(); rs.close(); } catch(Exception ex) { System.out.println(ex.toString()); } } return rsCategory; } public String OtherCategory(String categoryid) { String rsCategory=""; StringBuffer sbOT = new StringBuffer(); Statement stmt = null; ResultSet rs = null; try { stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery("SELECT category_id,category FROM HMR01 WHERE category_id<>'"+categoryid+"'"); if(!rs.next()) { rsCategory="Sorry!No content about other category."; } else { rs.beforeFirst(); String category_id,category; category_id=category=""; sbOT.append(""); while(rs.next()) { category_id=rs.getString("category_id"); category=rs.getString("category"); sbOT.append(""); } sbOT.append("
"); sbOT.append(""); sbOT.append("
"); sbOT.append(""+category+"
"); rsCategory=sbOT.toString(); } } catch(SQLException e) { e.printStackTrace(); //out.println("Error Trace in getConnection() : " + e.getMessage()); } finally { try { stmt.close(); rs.close(); } catch(Exception ex) { System.out.println(ex.toString()); } } return rsCategory; } %> <% String PageName=""; PageName=java.net.URLEncoder.encode("中籍英語教師與職員招募《教學研究職務介紹》","big5"); String peCategoryId,Category,CategoryTitle,strCategory,CategoryDetail,otherCategory; peCategoryId=Category=CategoryTitle=strCategory=otherCategory=""; String[][] rsCategory = {{"categoryTitle",""}, {"categoryDesc",""}, {"categoryDetail",""}}; peCategoryId=request.getParameter("cateid"); rsCategory=ShowCategory(peCategoryId); Category=rsCategory[0][1]; CategoryTitle=rsCategory[1][1]; strCategory=rsCategory[2][1]; CategoryDetail=rsCategory[3][1]; otherCategory=OtherCategory(peCategoryId); %> 中籍英語教師與職員招募《教學研究職務介紹》| HESS EDUCATIONAL ORGANIZATION
   
首頁 || 菁英招募 / 中籍英語教師職員 / <%=Category%>職務介紹
<%=otherCategory%>
<%=CategoryTitle%>
<%=CategoryDetail%>
<%=strCategory%>
轉寄此頁   列印此頁   TOP