<%@ page contentType="text/html;EUC-KR" language="java" %>
<%@ page import="java.util.Hashtable,
javax.naming.Context,
javax.naming.InitialContext,
javax.sql.DataSource,
java.sql.Connection,
java.sql.ResultSet,
java.sql.PreparedStatement,
oracle.xml.sql.query.OracleXMLQuery"%>
<%
out.print( "start
" );
Hashtable env = new Hashtable();
DataSource m_obj_DataSource = null;
Connection m_obj_Connection = null;
PreparedStatement obj_PreparedStatement = null;
ResultSet obj_ResultSet = null;
OracleXMLQuery obj_OracleXMLQuery = null;
String str_return = "";
out.print( "1
" );
try
{
env.put(Context.INITIAL_CONTEXT_FACTORY, "com.ibm.websphere.naming.WsnInitialContextFactory");
Context obj_Context = new InitialContext(env);
m_obj_DataSource = (javax.sql.DataSource) obj_Context.lookup( "jndi/cos_pool_02" );
m_obj_Connection = (java.sql.Connection)m_obj_DataSource.getConnection();
out.print( "2
" );
String sql = "";
sql += " select ";
sql += " user_id ";
sql += " , group_id ";
sql += " , cursor( ";
sql += " select user_id, group_id from user_info where user_id='online1004' ";
sql += " ) as intable ";
sql += " from user_info where user_id='online1004' ";
obj_PreparedStatement = m_obj_Connection.prepareStatement( sql );
obj_ResultSet = obj_PreparedStatement.executeQuery();
obj_OracleXMLQuery = new OracleXMLQuery( m_obj_Connection, obj_ResultSet );
out.print( "3
" );
obj_OracleXMLQuery.setEncoding("EUC-KR");
obj_OracleXMLQuery.useLowerCaseTagNames();
obj_OracleXMLQuery.useNullAttributeIndicator(true);
str_return = obj_OracleXMLQuery.getXMLString();
out.print( "4
" );
obj_OracleXMLQuery.close();
obj_ResultSet.close();
obj_PreparedStatement.close();
m_obj_Connection.close();
out.print( "5
" );
}
catch( Exception e )
{
str_return = "Exception e\n"+e.toString();
}
finally
{
try
{
if( obj_OracleXMLQuery!=null ) obj_OracleXMLQuery.close();
if( obj_ResultSet!=null ) obj_ResultSet.close();
if( obj_PreparedStatement!=null ) obj_PreparedStatement.close();
if( m_obj_Connection!=null ) m_obj_Connection.close();
}
catch( Exception ignored )
{
str_return = "Exception ignored\n"+ignored.toString();
}
}
%>
Simple jsp page
<%=str_return%>