怎么用javabean查询数据库
曾经用jsp写了这样一个页面:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>OracleSelect</title>
</head>
<body>
<%!
String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl" ;
String DBUSER = "system" ;
String DBPASSWORD = "zz47" ;
Connection conn = null ;
Statement stmt = null ;
ResultSet rs;
String name="原始赋值";
%>
<%
try
{
Class.forName(DBDRIVER) ;
// 连接时必须填写用户名及密码
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
// 创建表的SQL语句
String sql = "SELECT * FROM STUDENT" ;
stmt = conn.createStatement() ;
rs=stmt.executeQuery(sql) ;
//name=rs.getString(1);
out.print(name+"<br>");
out.print("学生表查询:"+"<br>");
out.print("<table width=580 border=1 height=100>");
out.print("<tbody>"+"<tr>");
out.print("<td align=center>"+" "+"姓名"+"</td>");
out.print("<td align=center>"+" "+"学号"+"</td>");
out.print("<td align=center>"+" "+"性别"+"</td>");
out.print("<td align=center>"+" "+"电话"+"</td>"+"</tr>");
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+" "+rs.getString(1)+"</td>");
out.print("<td>"+" "+rs.getString("NUM")+"</td>");
out.print("<td>"+" "+rs.getString("SEX")+"</td>");
out.print("<td>"+" "+rs.getString("TEL")+"</td>"+"</tr>");
}
out.print("<tr>");
out.print("<td>"+" "+"</td>");
out.print("<td>"+" "+"</td>");
out.print("<td>"+" "+"</td>");
out.print("<td>"+" "+"</td>"+"</tr>");
out.print("</tbody>"+"</table>"+"<br>");
stmt.close() ;
conn.close() ;
}
catch(Exception e)
{
out.println("SQL异常!") ;
}
%>
</body>
</html>
用它虽然可以轻松的查询数据库,但近日接触了正规的三层结构和JSF框架,想把它改成JSF模式的,或者说能不能告诉我怎么用javabean进行查询数据库,再把查询的结果传给类似list类型的对象,然后再在一个前台的jsp页面输出啊,麻烦那位老师大侠帮忙写个小例子呗,学生十分感谢!!