<%@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);*/ //=================================================================================== //======= 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[][] ShowJobDesc(String categoryid,String jobnum) { String[][] jobDetail={{"jobTitle",""}, {"jobLocation",""}, {"jobSummary",""}, {"jobresponsibility",""},}; Statement stmt = null; ResultSet rs = null; try { stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = stmt.executeQuery("SELECT * FROM HMR02 WHERE category_id='"+categoryid+"' AND job_num='"+jobnum+"'"); if(!rs.next()) { jobDetail[0][1]="no"; jobDetail[1][1]="no"; jobDetail[2][1]="no"; jobDetail[3][1]="no"; } else { //rs.beforeFirst(); String job_title,job_location,summary,responsibility; job_title=job_location=summary=responsibility=""; job_title=rs.getString("job_title"); job_location=rs.getString("job_location"); summary=rs.getString("summary"); responsibility=rs.getString("responsibility"); jobDetail[0][1]=job_title; jobDetail[1][1]=job_location; jobDetail[2][1]=summary; jobDetail[3][1]=responsibility; } } 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 jobDetail; } %> <% String PageName=""; PageName=java.net.URLEncoder.encode("中籍英語教師與職員招募《教學研究職缺》","big5"); String peCategoryId,peJobNum,categoryDesc,jobDesc,jobTitle,jobLocation,JobDesc,JobTerm,apply,returnTo; peCategoryId=peJobNum=categoryDesc=jobDesc=jobTitle=jobLocation=JobDesc=JobTerm=apply=returnTo=""; /*String[][] categoryArray={{"行政管理","adm"}, {"美術設計","des"}, {"財務會計","fin"}, {"人力資源","hum"}, {"行銷企劃","mar"}, {"資訊管理","mis"}, {"教學研究","rnd"}, {"業務推廣","sal"}, {"專兼任老師","tea"}};*/ String[][] categoryArray=ShowCategoryArray(); if(request.getParameter("cateid")!=null) peCategoryId=request.getParameter("cateid"); if(request.getParameter("jobid")!=null) peJobNum=request.getParameter("jobid"); if(categoryArray!=null) { for(int i=0;i"+categoryArray[i][0]+"職務介紹"; } for(int i=0;i"+categoryArray[i][0]+"職缺"; } for(int i=0;i返回"+categoryArray[i][0]+"職缺"; } } String[][] jobDetail=ShowJobDesc(peCategoryId,peJobNum); if(jobDetail.length==4) { jobTitle=jobDetail[0][1]; jobLocation=jobDetail[1][1]; JobDesc=jobDetail[2][1]; JobTerm=jobDetail[3][1]; } /*String requestURL=""; if(request.getHeader("REFERER")!=null) requestURL=request.getHeader("REFERER"); */ apply=""; %> 中籍英語教師與職員招募《教學研究職缺》| HESS EDUCATIONAL ORGANIZATION
   
<%=jobTitle%>
工作地點 / <%=jobLocation%>
職務代碼 / #<%=peJobNum%>
<%=apply%>
工作介紹
  <%=JobDesc%>
工作條件
  <%=JobTerm%>
<%=returnTo%>
轉寄此頁   列印此頁   TOP