package org.apache.jsp;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public final class test_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {

  private static final javax.servlet.jsp.JspFactory _jspxFactory =
          javax.servlet.jsp.JspFactory.getDefaultFactory();

  private static java.util.List<java.lang.String> _jspx_dependants;

  private javax.el.ExpressionFactory _el_expressionfactory;
  private org.apache.tomcat.InstanceManager _jsp_instancemanager;

  public java.util.List<java.lang.String> getDependants() {
    return _jspx_dependants;
  }

  public void _jspInit() {
    _el_expressionfactory = _jspxFactory.getJspApplicationContext(getServletConfig().getServletContext()).getExpressionFactory();
    _jsp_instancemanager = org.apache.jasper.runtime.InstanceManagerFactory.getInstanceManager(getServletConfig());
  }

  public void _jspDestroy() {
  }

  public void _jspService(final javax.servlet.http.HttpServletRequest request, final javax.servlet.http.HttpServletResponse response)
        throws java.io.IOException, javax.servlet.ServletException {

    final javax.servlet.jsp.PageContext pageContext;
    javax.servlet.http.HttpSession session = null;
    final javax.servlet.ServletContext application;
    final javax.servlet.ServletConfig config;
    javax.servlet.jsp.JspWriter out = null;
    final java.lang.Object page = this;
    javax.servlet.jsp.JspWriter _jspx_out = null;
    javax.servlet.jsp.PageContext _jspx_page_context = null;


    try {
      response.setContentType("text/html");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			null, true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("<html><head><title>Oracle JDBC Test</title></head>\r\n");
      out.write("<body>\r\n");
		
Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		ResultSetMetaData md = null;
		try{		
			Context initCtx=new InitialContext();
//»ñµÃJNDI³õÊ¼»¯ÉÏÏÂÎÄÐÅÏ¢£¬¼´»ñÈ¡Ä¿Â¼ÉÏÏÂÎÄµÄÒýÓÃ
			DataSource ds=(DataSource)initCtx.lookup("java:comp/env/jdbc/hap");
//¶¨Î»Êý¾ÝÔ´jdbc/plm
			if(ds!=null){
					out.println("get DataSource");
				  out.println(ds.toString());
					conn=ds.getConnection();
				if(conn!=null){
					out.println("create connection sucess!");
					stmt=conn.createStatement();
					out.println("createStatement Success!");
					rs=stmt.executeQuery("select * from sys_service");
					md=rs.getMetaData();
					out.println("<table border=1>");
					out.println("<tr>");
					for(int i=0;i<md.getColumnCount();i++){
					out.println("<td>"+md.getColumnName(i+1)+"</td>");
					}
					while(rs.next()){
					out.println("<tr>");
					out.println("<td>"+rs.getString(1)+"</td>");
					out.println("<td>"+rs.getString(2)+"</td>");
					out.println("<td>"+rs.getString(3)+"</td>");
					out.println("<td>");
					}
					out.println("</table>");
					}}
		}catch(Exception e){
			out.println(e.toString());
			System.out.println(e.toString());
		}

      out.write("\r\n");
      out.write("</body>\r\n");
      out.write("</html>\r\n");
    } catch (java.lang.Throwable t) {
      if (!(t instanceof javax.servlet.jsp.SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          try { out.clearBuffer(); } catch (java.io.IOException e) {}
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}
