<%@ page contentType="test/html",charset="GBK"%>
<%@ page import "java.sql.*"%>
<%!
   public static final String dirver="Oracle.jdbc.driver.OracleDriver";
   public static final String url="jdbc:oracle:thin:@localhost:database";
   public static final String user="scott";
   public static final String password="472312";
        
 %>
 <%
   Connection con=null;
   Statement rstm=null;
   Resultset rs=null;
  %>
 <%
   try{
   Class.forName(dirver);
   con=DriverManager.getConnection();
   String sql="select userid,name,password from tuser";
   rstm=con.createStatement();
   rs=rstm.execucteQuery(sql);
  %>
  <center>
  <table>
     <tr>
       <td>userid</td>
       <td>name</td>
       <td>password</td>
     </tr>
 
  
<%
while(rs.next()){
%>
     <tr>
       <td><%=rs.getString(1)%></td>
       <td><%=rs.getString(2)%></td>
       <td><%=rs.getString(3)%></td>
     </tr>
<%
}
%>
<%catch(Exception e) %>
<%
{
%>
<%
  rs.close();
  rstm.close();
  con.close();
 %>
 <%
 }
 %>
</table>
</center>

没有呀少呀