JSP is connected to Oracle through JDBC

Jsp (preferred for SUN Enterprise Applications) is connected to Oracle (large website database platform) through JDBC

I. environment variables (system variables)

JAVA_HOME = C: JDK1.3
Tomcat (a very useful JSP running platform) _ HOME = C: omcat (a very useful JSP running platform)-3.2.3
ClassPath = D: oracle(large-scale website data warehouse platform )ora81jdbclibclasses12.zip (JDBC driver)

Ii. Test Procedure

<% @ Page language = "java" import = "java. io. *, java. SQL. *, javax. SQL. *, javax. naming. *" %>
<% @ Page contentType = "text/html; charset = gb2312" %>
<%
String sDBDriver = "Oracle (large website database platform). jdbc. driver. Oracle (large website database platform) Driver ";
String sConnStr = "jdbc: Oracle (large website database platform): thin: @ 192.168.0.58: 1521: ORCL ";

Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
Try
{
Class. forName (sDBDriver );
Conn = DriverManager. getConnection (sConnStr, "veh_admin", "Oracle (large website database platform )");
Stmt = conn. createStatement ();
// Stmt.exe cuteQuery ("create table aaa (aaa int )");
// Stmt.exe cuteUpdate ("insert into bbb values (456 )");

Rs = stmt.exe cuteQuery ("select * from veh_xzqj ");
While (rs. next ()){
Out. println ("" + rs. getInt (1) + "");
Out. println (":" + "<br> ");
// Out. println ("+ rs. getString (answers) + ");
}
Rs. close ();

}
Catch (Exception e)
{
Out. println (e );
}