Statement stmt = conn.createStatement();
rset = stmt.executeQuery(sql);
}catch(SQLException e1) {
System.err.println("error: " + e1.getMessage());
}
return rset;
}
}
编译后将JspJdbc.class文件放入mywebweb-infjspbeans目录下。在下面的jsp文件中调用beans，jspdb.jsp内容如下:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Database in Jsp</title>
</head>
<body>
<%@ page language="java" import="java.sql.*,oracle.jdbc.driver.*" errorPage="errorpage.jsp" %>
<jsp:useBean id="jspdatabase" scope="page" class="JspJdbc" />
<%
ResultSet rset = jspdatabase.executeQuery("SELECT * FROM emp");
out.println("<table><tr><th>number</th><th>name</th></tr>");
while (reset.next()) {
out.println("<tr><td>"+rset.getInt("eptno")+"</td>");
out.println("<td>"+rset.getString("enameeptno")+"</td></tr>");
}
rest.close();
out.println("</table>");
%>
</body>
</html>
其中用于显示异常的errorpage.jsp内容为：
<html>
<body bgcolor="red">
<%@ page isErrorPage="true" %>
<h1> The exception <%= exception.getMessage() %>
</body>
</html>
重新启动Web server使新创建的java beans生效，如果与数据服务器连接正常，则在浏览器地址中输入
http://localhost:8080/myweb/jspdb.jsp
将显示查询结果。
通过上面的介绍，相信大家对Jsp有所了解。要进一步了解Jsp技术可访问下面的站点：
http://java.sun.com/products/jsp
