使用jsp与JavaBean实现数据展示-优快云博客

jsp代码：

<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %> <jsp:useBean id="jb" scope="page" class="bean.JavaBeanJSP"/> <%! ResultSet rs; %> <html> <head> <title>HelloBean</title> <meta http-equiv="Content-Type" content="text/html;charset=gb2312"> </head> <body> <center> <br><br><br> <table border="1" borderColorDark="#ffffec" borderColorLight="#5e5e00" cellPadding="1" cellSpacing="0" width=50%> <tr><th>empno</th><th>ename</th><th>job</th></tr> <% try { rs=jb.getResultSet(); while(rs.next()) { %> <tr> <td><%= rs.getString(1)%></td> <td><%= rs.getString(2)%></td> <td><%= rs.getString(3)%></td> </tr> <% } } catch (SQLException se) { se.printStackTrace(); } finally { try { if(rs!=null) rs.close(); } catch(SQLException se) { se.printStackTrace(); } } %> </table> </center> </body> </html>

java代码

package bean; import java.sql.*; public class JavaBeanJSP{ private Connection con; private Statement stmt; private ResultSet rs; public ResultSet getResultSet() { try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection ct = DriverManager.getConnection ("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","scott","tiger"); Statement sm = ct.createStatement(); rs = sm.executeQuery("select * from emp"); } catch(SQLException se) { se.printStackTrace(); } catch(Exception e) { e.printStackTrace(); } return rs; } }

部署：

webapps
--------JavaBeanTest
--------------------WEB-INF
-------------------------------classes
--------------------------------------bean
------------------------------------------JavaBeanJSP.class
--------------------javabean.jsp

javabean 复习