paulofernandesjr 6 de nov. de 2009
posta o que você já fez, lista a tabela você sabe né?
Raizquadrada 9 de nov. de 2009
Abaixo o código:
<%
UserBean currentUser = ( UserBean ) session . getAttribute ( "currentSessionUser" );
Connection conn = ConectionDB . getConnection ();
Statement stmt = null ;
ResultSet rs = null ;
String MailQuery = "CALL proc_mail('" + currentUser . getHeroname () + "')" ;
try {
stmt = conn . createStatement ();
rs = stmt . executeQuery ( MailQuery );
}
catch ( Exception e ){ out . println ( e );}
%>
<table border= "1" style= "background-color:black;color:white;font-size:small" >
<!-- column headers -->
<tr>
<th>
From
</th>
<th>
Subject
</th>
<th>
Date
</th>
</tr>
<!-- column data -->
<tr>
<td>
<% try {
rs . beforeFirst ();
while ( rs . next ()){
out . println ( rs . getString ( "herofrom" )); %> <br> <%
}
}
catch ( Exception e ){ out . println ( e );}
%>
</td>
<td>
<% try {
rs . beforeFirst ();
while ( rs . next ()){
out . println ( rs . getString ( "mailsub" )); %> <br> <%
}
}
catch ( Exception e ){ out . println ( e );}
%>
</td>
<td>
<% try {
rs . beforeFirst ();
while ( rs . next ()){
out . println ( rs . getString ( "dtmail" )); %> <br> <%
}
}
catch ( Exception e ){ out . println ( e );}
%>
</td>
</tr>
</table>
paulofernandesjr 10 de nov. de 2009
que medo desse código
cara tenta estruturar melhor o seu código no servlet e na tela você itera a lista com JSTL usando um c:foreach
mas com esse código você pode fazer assim
<%
UserBean currentUser = ( UserBean ) session . getAttribute ( "currentSessionUser" );
Connection conn = ConectionDB . getConnection ();
Statement stmt = null ;
ResultSet rs = null ;
String MailQuery = "CALL proc_mail('" + currentUser . getHeroname () + "')" ;
try {
stmt = conn . createStatement ();
rs = stmt . executeQuery ( MailQuery );
}
catch ( Exception e ){ out . println ( e );}
%>
<table border= "1" style= "background-color:black;color:white;font-size:small" >
<!-- column headers -->
<tr>
<th>
From
</th>
<th>
Subject
</th>
<th>
Date
</th>
</tr>
<!-- column data -->
<% try
{
while ( rs . next ()){
out . println ( "<tr> \n " );
out . println ( "<td> \n " );
out . println ( rs . getString ( "herofrom" ));
out . println ( "</td> \n " );
out . println ( "<td> \n " );
out . println ( "<a href=" window . open ( 'pagina.jsp?subject="+rs.getString("mailsub")+"' "> \n " );
out . println ( rs . getString ( "mailsub" ));
out . println ( "</a> \n " );
out . println ( "</td> \n " );
out . println ( "<td> \n " );
out . println ( rs . getString ( "dtmail" ));
out . println ( "</td> \n " );
out . println ( "</tr> \n " );
}
}
catch ( Exception e ){
out . println ( e );
}
%>
</table>
essa página.jsp terá que fazer uma consulta recebendo o id do email de preferencia
no caso eu passei o subject, porque não sei o id
qualquer coisa posta ai
abraço
Raizquadrada 10 de nov. de 2009
Já consegui aqui, obrigado pela ajuda.
