<%@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.*"%> <%! int PageSize = 10; int RowCount = 0; int PageCount = 0; int range_limit = 10; int range_count = 0; int range = 0; int range_min = 0; int range_max = 0; 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/wilson"); 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[][] ShowCategoryArray() { String[][] rsCategoryArray=null; Statement stmt = null; ResultSet rs = null; int RowCount=0; try { stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery("SELECT * FROM HMR01"); if(!rs.next()) { rsCategoryArray=null; } else { rs.last(); RowCount = rs.getRow(); rsCategoryArray = new String[RowCount][2]; rs.beforeFirst(); int i=0; while(rs.next()) { rsCategoryArray[i][0]=rs.getString("category"); rsCategoryArray[i][1]=rs.getString("category_id"); i++; } } } 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 rsCategoryArray; } public String ShowCategory(String categoryid) { String rsCategory=""; StringBuffer sbCT = 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="Sorry!No content."; } else { //rs.beforeFirst(); String category_id,category,category_icom; category_id=category=category_icom=""; category_id=rs.getString("category_id"); category=rs.getString("category"); category_icom=rs.getString("category_icom"); sbCT.append(""); //sbCT.append("
"); //sbCT.append("
"); sbCT.append(""); sbCT.append(""); sbCT.append(""); /*sbCT.append("
"); sbCT.append("     "); sbCT.append("
"); */ rsCategory=sbCT.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[][] ShowJobDesc(String categoryid,String ToPage) { String rsJob[][]={{"JobList",""}, {"PageIndex",""}}; StringBuffer sbJB = new StringBuffer(); int ShowPage = 1; String PageIndex=""; Statement stmt = null; ResultSet rs = null; try { stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); String strSQL="SELECT job_title,job_num,job_location FROM HMR02 WHERE category_id='"+categoryid+"' "; strSQL+="AND online='yes' ORDER BY job_num"; rs = stmt.executeQuery(strSQL); if(!rs.next()) { rsJob[0][1]="很抱歉！目前並無相關職缺！"; rsJob[1][1]="無相關資料！"; } else { rs.last(); RowCount = rs.getRow(); PageCount = ((RowCount%PageSize)==0?(RowCount/PageSize):(RowCount/PageSize)+1); if(ToPage!=null) { ShowPage = Integer.parseInt(ToPage); if(ShowPage > PageCount) { ShowPage = PageCount; } else if(ShowPage <= 0) { ShowPage = 1; } } int row_start = ((ShowPage-1)*PageSize + 1); int row_end = row_start + (PageSize - 1); if(row_end > RowCount) { row_end = RowCount; } rs.absolute(row_start); //rs.beforeFirst(); sbJB.append(""); for(int i=1; i<=PageSize; i++) { String job_title,job_num,job_location; job_title=job_num=job_location=""; job_title=rs.getString("job_title"); job_num=rs.getString("job_num"); job_location=rs.getString("job_location"); if(i%2!=0) sbJB.append(""); sbJB.append(""); if(i%2!=0) { sbJB.append(""); } if(i%2 ==0) { sbJB.append(""); } if(i==PageSize || !rs.next()) { if(i%2!=0) sbJB.append(""); sbJB.append("
"); sbJB.append(""); sbJB.append(""); sbJB.append("
"); sbJB.append(""); sbJB.append(""); sbJB.append("
"+job_title+"
"); sbJB.append("工作地點 / "+job_location+"
職務代碼 /"); sbJB.append("#"+job_num+"
"); sbJB.append("
   
  
"); break; } } rsJob[0][1]=sbJB.toString(); //=======Change Page Start //PageIndex+="
"+ShowPage+" of "+PageCount+"  "; PageIndex+=""+row_start+" - "+row_end+" of "+RowCount+"  "; if(ShowPage == 1 ) { } if(ShowPage !=1 ) { PageIndex+=""; PageIndex+=""; PageIndex+="上一頁  "; } //=======Show Each Page Flag Start if(ShowPage <= (range_limit/2)) { range_min = 1; if(PageCount >= range_limit) { range_max = range_limit; } else { range_max = PageCount; } //PageIndex+=""; for(int j=range_min; j<=range_max; j++) { PageIndex+=""; PageIndex+= j + "  "; } //PageIndex+=""; } else { range_max = ShowPage + (range_limit/2); if(range_max > PageCount) { range_max = PageCount; } range_min = (range_max - range_limit)+1; if(range_min < 1) { range_min = 1; } //PageIndex+=""; for(int j=range_min; j<=range_max; j++) { PageIndex+=""; PageIndex+= j + "  "; } //PageIndex+=""; } //=======Show Each Page Flag End if(ShowPage == PageCount ) { } if(ShowPage != PageCount ) { PageIndex+=""; PageIndex+="下一頁
"; } //=======Change Page End rsJob[1][1]=PageIndex; } } 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 rsJob; } %> <% String PageName=""; PageName=java.net.URLEncoder.encode("中籍英語教師與職員招募《教學研究職缺》","big5"); String peCategoryId,CategoryTitle,strJob,PageIndex,categoryDesc,jobDesc,Message; peCategoryId=CategoryTitle=strJob=PageIndex=categoryDesc=jobDesc=Message=""; peCategoryId=request.getParameter("cateid"); String[][] JobPage={{"JobList",""}, {"PageIndex",""}}; /*String[][] categoryArray={{"行政管理","adm"}, {"美術設計","des"}, {"財務會計","fin"}, {"人力資源","hum"}, {"行銷企劃","mar"}, {"資訊管理","mis"}, {"教學研究","rnd"}, {"業務推廣","sal"}, {"專兼任老師","tea"}};*/ String[][] categoryArray=ShowCategoryArray(); if(categoryArray!=null) { for(int i=0;i"; if(categoryArray[i][1].equals(peCategoryId)) categoryDesc=""+categoryArray[i][0]+"職務介紹"; } for(int i=0;i 中籍英語教師與職員招募《教學研究職缺》| HESS EDUCATIONAL ORGANIZATION
   
首頁 || 菁英招募 / 中籍英語教師職員 / <%=categoryDesc%> / <%=jobDesc%>
<%=CategoryTitle%>
<%=PageIndex%>
<%=strJob%>
<%=PageIndex%>
轉寄此頁   列印此頁   TOP