<%@page contentType="text/html; charset=iso-8859-2"%>
<%@page import="java.sql.*"%>
<html>
<head><title>Datab�ze - pou�it� �ist� java.sql</title></head>
<body>
<table border="1">
<tr><td>id</td><td>firstname</td><td>lastname</td><td>email</td></tr>
<%
/* Nat�hneme driver do pam�ti.
Volat newInstance() se sice ofici�lne nemus�, ale vy�e�� to rozd�ly mezi jvm.
*/
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
/* Z�sk�me p�ipojen� k datab�zi.
getConnection(URL, u�ivatel, heslo);
URL:
jdbc:mysql - protokol
localhost - server
employee - datab�ze
useUnicode - mm.mysql jdbc driver z�kladn� nepou��v� unicode, co� se n�m nehod�, mus�me ho zapnout.
characterEncoding - k�dov�n� dat(windows�ci pou�ijte windows-1250)
*/
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/employee?useUnicode=true&characterEncoding=iso-8859-2", "user", "password");
/* Statement je objekt, kter� n�m umo��uje odes�lat sql p��kaz na server a z�sk�vat odpove�. */
Statement stmt = conn.createStatement();
/* Odesl�n� SELECT p��kazu na server, vrac� ResultSet co� je vlastn� speci�ln� 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. */
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>