<%@ page import="java.sql.*,javax.sql.*,java.io.*,java.net.*,java.util.Date,java.lang.*,java.util.*, java.lang.reflect.Array,java.lang.Class, com.rbs.pool.ConnectionPool"%> <% Connection conn = null; Statement stmt = null; CallableStatement oCst = null; ResultSet oRset = null; PreparedStatement oPst = null; String oWidth = ""; String oHeight = ""; String oFilename = ""; String oAuthor = ""; String oCopyright = ""; String oLegend = ""; String oText = ""; if( request.getParameter( "width" ) != null && request.getParameter( "width" ).length() > 0 ) oWidth = request.getParameter("width"); if( request.getParameter( "height" ) != null && request.getParameter( "height" ).length() > 0 ) oHeight = request.getParameter("height"); if( request.getParameter( "file" ) != null && request.getParameter( "file" ).length() > 0 ) oFilename = URLDecoder.decode(request.getParameter("file")); /* if( request.getParameter( "author" ) != null && request.getParameter( "author" ).length() > 0 ) oAuthor = URLDecoder.decode(request.getParameter("author")); if( request.getParameter( "copyright" ) != null && request.getParameter( "copyright" ).length() > 0 ) oCopyright = URLDecoder.decode(request.getParameter("copyright"));*/ int oId = Integer.parseInt(oFilename.substring(0,oFilename.indexOf(".") )); try { conn = ConnectionPool.getConnection("poolInternet"); String oSql1 = "select nvl(author,' '), nvl(copyright,' '), nvl(ANNOTATION_V,' ') from components where id=?"; oPst = conn.prepareStatement(oSql1); oPst.setInt(1,oId); oRset = oPst.executeQuery(); if (oRset.next()) { oAuthor = oRset.getString(1); oCopyright = oRset.getString(2); oText = oRset.getString(3); } oRset.close(); oPst.close(); } catch (Exception erroConexao) { String erro = erroConexao.toString(); out.print(erroConexao + "
"); } finally { ConnectionPool.releaseConnection("poolInternet", conn); } if (oText.trim().length() > 0) { while ( oText.indexOf("#lt;br#lg;") > 0 ) oText = oText.substring(0,oText.indexOf("#lt;br#lg;")) + "
" + oText.substring(oText.indexOf("#lt;br#lg;")+ 10); } %>

<%= oText%> Foto: <%= oAuthor %><%if (oCopyright.trim().length() > 0) { out.println("/" + oCopyright); }%>

Enviar p/ amigo      Imprimir      Fechar