<%@ page contentType="text/html;charset=EUC-KR"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%@ page import="javax.transaction.*"%>
<%
Context ctx = null;
DataSource ds = null;
Connection con = null;
Statement st = null;
ResultSet rs = null;
UserTransaction tx = null;
String sql = "select * from tab";
try{
ctx = new InitialContext();
tx = (UserTransaction)ctx.lookup("javax.transaction.UserTransaction");
tx.begin();
ds = (javax.sql.DataSource)ctx.lookup("oraXA92");
con = ds.getConnection();
st = con.createStatement();
rs = st.executeQuery(sql);
while(rs.next()){
out.println(rs.getString(1) + " " + rs.getString(2));
}
tx.commit();
}catch(Exception e){
out.println(e.toString());
}finally{
if(rs!=null)try{rs.close();}catch(Exception e){}
if(st!=null)try{st.close();}catch(Exception e){}
if(con!=null)try{con.close();}catch(Exception e){}
}
%>