急呀！！！！！！我用JSP读取ORACLE的数据，显示速度太慢了，谁能帮帮我?

来源：百度知道 编辑：UC知道 时间：2024/06/06 00:54:34
本人初学JSP ORACLE，对很多都不懂！今天我遇到这样一个怪现象，JSP读取ORACLE数据时网页进度到一半左右就一直不动了！等了半天后，又不报错，又不显示结果，真是急死人了！望贵人指点，不胜感激！

HTML code
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
}
catch(Exception ex)
{
System.out.print("加载出错！");
}

String url="jdbc:oracle:thin:@localhost:1521:orcl";
//orcl为你的数据库的SID
String user="scott";
String password="orcl2010";
System.out.print("user is: " + user + "manager is:" + password);
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn= DriverManager.get

try this:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
} catch (Exception ex) {
System.out.print("加载出错！");
}

String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//orcl为你的数据库的SID
String user = "scott";
String password = "orcl2010";
System.out.print("user is: " + user + "manager is:" + password);
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
String sql = "select * from test";

ResultSet rs = null;
try {
rs = stmt.executeQuery(sql)