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
| <%@ page import="java.sql.*" %>
<% Class.forName("com.mysql.jdbc.Driver"); %>
<HTML>
<HEAD>
<TITLE>Fetching Data From a Database</TITLE>
</HEAD>
<BODY>
<H1>Fetching Data From a Database</H1>
<%
Connection connection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/cdgcapitall", "root", "root");
Statement statement = connection.createStatement();
ResultSet resultset =
statement.executeQuery("select * from service ") ;
if(!resultset.next()) {
out.println("Sorry, could not find that publisher. ");
} else {
%>
<TABLE BORDER="1">
<TR>
<TH>nom</TH>
<TH>date</TH>
<TH>etat</TH>
</TR>
<% do { %>
<TR>
<TD> <%= resultset.getString(1) %> </TD>
<TD> <%= resultset.getString(2) %> </TD>
<TD> <%= resultset.getString(3) %> </TD>
<TD><a href="/display_service.jsp?service_id=<%= resultset.getString(4) %>">Open</a> </TD>
</TR>
<% } while(resultset.next()); %>
</TABLE>
<BR>
<%
}
%>
</BODY>
</HTML> |
Partager