<%@ 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( "author" ) != null && request.getParameter( "author" ).length() > 0 ) oAuthor = request.getParameter("author"); if( request.getParameter( "legend" ) != null && request.getParameter( "legend" ).length() > 0 ) oLegend = request.getParameter("legend"); if( request.getParameter( "file" ) != null && request.getParameter( "file" ).length() > 0 ) oFilename = URLDecoder.decode(request.getParameter("file")); int oId = Integer.parseInt(oFilename.substring(0,oFilename.indexOf(".") )); if (oAuthor.length() ==0 && oLegend.length() ==0 ) { try { conn = ConnectionPool.getConnection("poolInternet"); String oSql1 = "select nvl(author,' '),nvl(description, ' '),nvl(copyright,' ') 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(3); oLegend = oRset.getString(2); } oRset.close(); oPst.close(); } catch (Exception erroConexao) { String erro = erroConexao.toString(); out.print(erroConexao + "
"); } finally { ConnectionPool.releaseConnection("poolInternet", conn); } //try...finally } // if %>

<%if (!oAuthor.trim().equals("") ){ %> <%}%> <%= oLegend%> Foto(s): <%= oAuthor %>

Enviar p/ amigo      Imprimir      Fechar