[JDBC] dbcpTest.jsp

<%@ page language="java" contentType="text/html; charset=EUC-KR"
    pageEncoding="EUC-KR"
    import="javax.naming.*,javax.sql.*, java.sql.*"%>
<%
 Context ctx=new InitialContext();
 
 Context envCtx=(Context)ctx.lookup("java:comp/env");
 out.println("envCtx: "+envCtx+"<br>");
 
 DataSource ds
 =(DataSource)envCtx.lookup("jdbc/myoracle");
 out.println("ds: "+ds+"<br>");

 Connection con=ds.getConnection();
 out.println("커넥션 성공: "+con+"<br>");
 
 String sql="select * from tabs";
 Statement st=con.createStatement();
 ResultSet rs=st.executeQuery(sql);
%>
<center>
<hr color=green>
<h3>MyStruts계정의 테이블 목록</h3>
<hr color=green>
<%
 while(rs.next()){
  String tn=rs.getString(1);
  String type=rs.getString(2);
  out.println("<li>"+tn+": "+type+"</li>");
 }//while------
 if(rs!=null) rs.close();
 if(st!=null) st.close();
 if(con!=null) con.close();
 
%>
</center>