<%@page contentType="text/html; charset=iso-8859-2"%>
<%@page import="java.sql.*"%>
<html>
<head><title>Datab�ze - pou�it� ConnBean</title></head>
<body>
<table border="1">
<tr><td>id</td><td>firstname</td><td>lastname</td><td>email</td></tr>
<jsp:useBean id="cbean" class="patrny.sql.ConnBean" scope="session">
<jsp:setProperty name="cbean" property="driver" value="org.gjt.mm.mysql.Driver"/>
<jsp:setProperty name="cbean" property="URL" value="jdbc:mysql://localhost/employee?useUnicode=true&characterEncoding=iso-8859-2"/>
<jsp:setProperty name="cbean" property="user" value="user"/>
<jsp:setProperty name="cbean" property="password" value="password"/>
</jsp:useBean>
<%
/* Statement je objekt, kter� n�m umo��uje odes�lat sql p��kaz na server a z�sk�vat odpov��. */
Statement stmt = cbean.getConnection().createStatement();
/* Odesl�n� SELECT p��kazu na server, vrac� ResultSet co� je vlastn� tabulka dat.
Pokud je sql p��kaz UPDATE, INSERT nebo DELETE pou�ijte metodu executeUpdate, vrac� int.
Metoda execute se d� pou��t pro oboj�. */
ResultSet rs = stmt.executeQuery("SELECT * FROM employee ORDER BY id");
/* Generov�n� tabulky */
while(rs.next()) { %>
<tr><td><%= rs.getString(1) %></td><td><%= rs.getString(2) %></td>
<td><%= rs.getString(3) %></td><td><%= rs.getString(4) %></td></tr><%="\n"%>
<% }
/* Uzav�eme v�echny objekty, kter� jsme vytvo�ili.
Ale neuzav�r�me Connection, proto�e se zav�e samo a� vypr�� platnost session. */
rs.close();
stmt.close();
%>
</table>
</body>
</html>