Citation :
<%@page import="java.sql.*,java.text.*"%>
<%!
private Connection conn;
private static final DateFormat df = new SimpleDateFormet("dd/MM/yyyy" );
public void jspInit() {
Class.forName("blabla" );
this.conn = DriverManager.getConnection("jdbc:tabase:", "toto", "toto" );
}
private static String encodeHTML(String s) {
// pas le courage ...
// ca encode les caractères '<', '>' et '&' // avec le carctère unicode correspondant
}
%>
<%
Statement stat = this.conn.createStatement();
ResultSet rs = stat.executeQuery("SELECT * FROM gestNote ORDER BY date " );
%>
<html> <body> <table> <% while (rs.next()) { %>
<tr> <td><%= encodeHTML(rs.getString("name" )} %>/></td> <td><%= df.format(rs.getDate("date" )) %></td> </tr> <tr> <td colspan="2"><%= encodeHTML(rs.getString("note" )) %></td> </tr> <% } %>
</table> </body> </html>
|