<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%><%
   Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
   String url="jdbc:oracle:thin:@192.168.210.101:1521:redant"; 
   String user="scott"; 
   String password="tiger"; 
   Connection conn= DriverManager.getConnection(url,user,password); 
   Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); %>
<html><body>
<form name="form1" method="post" action="OracleTest.jsp">
  
      <table border="1" width="100%">
        <th align='center'>EMPID</th><th align='center'>ENAME</th><th align='center'>JOB</th><th align='center'>MGR</th><th align='center'>HIREDATE</th><th align='center'>SAL</th><th align='center'>COMM</th><th align='center'>DEPTNO</th>
<%
        String sql="select * from emp"; 
ResultSet rs=stmt.executeQuery(sql); 
while(rs.next()) {
%> 
        <tr>
            <td align="center"><%=rs.getString(1)%></td>
            <td align="center"><%=rs.getString(2)%></td>
            <td align="center"><%=rs.getString(3)%></td>
    <td align="center"><%=rs.getString(4)%></td>
    <td align="center"><%=rs.getString(5)%></td>
    <td align="center"><%=rs.getString(6)%></td>
    <td align="center"><%=rs.getString(7)%></td>
    <td align="center"><%=rs.getString(8)%></td>
        </tr>
<%}%> 
      </table>
   
</form>
  
<%
        rs.close(); 
stmt.close(); 
conn.close(); 
%> 
</body> 
</html> 
这是我的代码: