%@ 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);
}
%>
RBS Jornais
|
|
|
|
<%= oText%> |
|
|
Foto: <%= oAuthor %><%if (oCopyright.trim().length() > 0) {
out.println("/" + oCopyright);
}%>
|
|
|
|
|