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
| <% Class.forName("com.mysql.jdbc.Driver");%>
<%@ page language="java" %>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean" %>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html" %>
<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic" %>
<% java.sql.Connection con =java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/tracivet","root","");%>
<% java.sql.Statement statement = con.createStatement(); %>
<% java.sql.ResultSet rs; %>
<HTML>
<HEAD>
<style type="text/css">
.style7
{
text-align: center;
width: 197px;
font-weight: bold;
color: #FF3399;
}
.style9
{
text-align: center;
width: 197px;
color: #0033CC;
font-weight: bold;
font-size: medium;
}
</style>
</head>
<body>
<table style="border: medium double #FF3399; width:66%;">
<tr>
<td class="style9" style="border: thin ridge #FF3399;">
Id</td>
<td class="style9" style="border: thin ridge #FF3399;">
Id_utilisateur</td>
<td class="style9" style="border: thin ridge #FF3399;">
Nom</td>
<td class="style9" style="border: thin ridge #FF3399;">
Prénom</td>
<td class="style9" style="border: thin ridge #FF3399;">
E-mail</td>
</tr>
<% rs = statement.executeQuery("SELECT * FROM personnee "); %>
<% while (rs.next()) { %>
<tr style="border-style: inherit; border-color: #FF3399">
<td class="style7" style="border: thin ridge #FF3399;">
<%= rs.getInt("id") %></td>
<td class="style7" style="border: thin ridge #FF3399;">
<%= rs.getString("id_user") %></td>
<td class="style7" style="border: thin ridge #FF3399;">
<%= rs.getString("nom_personne") %></td>
<td class="style7" style="border: thin ridge #FF3399;">
<%= rs.getString("prenom_personne") %></td>
<td class="style7" style="border: thin ridge #FF3399;">
<%= rs.getString("email_personne") %></td>
<% } %>
<% rs.close(); %>
<% statement.close(); % |
Partager