1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88
| <%
String url = "jdbc:mysql://localhost/etap";
String login = "root";
String passwd = "root";
java.sql.Connection cn = null;
java.sql.Statement st = null;
try {
Class.forName("com.mysql.jdbc.Driver");
cn = DriverManager.getConnection(url, login, passwd);
st = cn.createStatement();
String queryString = "Select * FROM banque";
ResultSet res = st.executeQuery(queryString);
out.println("<body background='im.png' >");
out.println( "<table border= 1>" );
ResultSetMetaData resMeta = (ResultSetMetaData) res.getMetaData();
int nbCols = resMeta.getColumnCount();
out.println( "<tr>" );
for( int i = 1; i <= nbCols; i++ )
{
String el = resMeta.getColumnLabel( i );
out.println( "<th>" + el + " </th>" );
}
String mod ="Modifier";
String supp="Supprimer";
out.println( "<th>" + mod+ " </th>" );
out.println( "<th>" +supp + " </th>" );
out.println( "</tr>" );
while( res.next() )
{
out.println( "<tr >" );
for( int i = 1; i <= nbCols; i++ )
{
String el = res.getString( i );
out.println(
"<td>" + el + " </td>");
}
out.println("<form action=''>");
out.println( "<TD>" + "<input type=\"button\" value=\"Modfier\" />");
out.println("</form>");
out.println("<form action=''>") ;
out.println( "<TD>" + "<input type=\"button\" value=\"Supprimer\" />");
out.println("</form>") ;
out.println( "</tr>" );
}
out.println( "</table><br/>" );
//out.println ( "Requête: " + queryString + "<br/>" );
out.print("<br>");
out.print("<table>");
out.print("<tr>");
out.print("<td>");
out.print("<form action='ajou_Banque_ETAP.jsp'>");
out.print(" <input type='submit' value='Ajouter une nouvelle Banque' style='width: 200px; height: 50px'/>");
out.print("</form>");
out.print("</td>");
out.print("</tr>");
out.print("</table>");
}
catch( SQLException ex )
{
System.out.println ( "<p><pre>" );
while( ex != null )
{
out.println( "Message : " + ex.getMessage () );
out.println( "Etat : " + ex.getSQLState () );
out.println( "Code d'erreur : " + ex.getErrorCode () );
ex = ex.getNextException();
}
out.println ( "</pre></p>" );
} finally {
out.close();
}
%> |
Partager