JSP is connected to Oracle through JDBC

JSPPassJDBCAndOracleConnect

I. environment variables (system variables)

Java_home = C: jdk1.3
Tomcat_home = C: tomcat-3.2.3
Classpath = D: oracleora81jdbclibclasses12.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. JDBC. Driver. oracledriver ";
String sconnstr = "JDBC: oracle: 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 ");
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 (":" +"
");
// Out. println ("+ Rs. getstring (" answers ") + ");
}
Rs. Close ();

}
Catch (exception E)
{
Out. println (E );
}