ربط jsp مع mysql

أخي لنحاول معا فهم وتنفيذ الدرس الموجود على الرابط

http://www.jsptut.com/Sql.jsp

اخي انحلت تمام معي بهذه الطريقة

Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/jsp_test?user=root&password="; 
conn = DriverManager.getConnection(url);
statement = conn.createStatement();

أخي هل وضعت هذا الكود ضمن scriptlet أم ضمن javaBean

لا ضمن الصفحة هذا الكود كامل

<%@ page contentType="text/html; charset=windows-1256" language="java" import="java.sql.*" errorPage="</span>" %>
<%
request.setCharacterEncoding("windows-1256");
response.setContentType("text/html; charset=utf-8");
Connection conn = null;
Statement statement = null;
ResultSet rs = null;

try
{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/jsp_test?user=root&password="; 
conn = DriverManager.getConnection(url);
statement = conn.createStatement();

out.println("Connection Done!<br>");

rs = statement.executeQuery("SELECT * FROM dept");
while (rs.next()) {
out.println(rs.getString("deptid") + " **** " + rs.getString("deptname")+"<br>");
}

rs.close();



}
catch(SQLException e)
{
out.println("SQLException: " + e.getMessage() + "<BR>");
while((e = e.getNextException()) != null)
out.println(e.getMessage() + "<BR>");
}
catch(ClassNotFoundException e)
{
out.println("ClassNotFoundException: " + e.getMessage() + "<BR>");
}
finally
{
if(conn != null)
{
try
{
conn.close();
}
catch (Exception ignored) {}
}
}
%>