<%@ page import="java.sql.*"%>
   
   
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();   
String url=url="jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.105)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.106)(PORT = 1521))(LOAD_BA
LANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oral)))";  --实例名
String user="admin";
String password="admin";
Connection conn= DriverManager.getConnection(url,user,password);   
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   
String sql="select * from content";   
ResultSet rs=stmt.executeQuery(sql);   
while(rs.next()) {%>    
2：<%=rs.getString(2)%>   
<%}%>   
<%out.print("ok");%>   
<%rs.close();   
stmt.close();   
conn.close();   
%>