JSP通过JDBC与Oracle相连

　　一、环境变量(系统变量)

　　JAVA_HOME = C:JDK1.3
　　TOMCAT_HOME = C:TOMCAT-3.2.3
　　ClassPath = D:OracleOra81jdbclibclasses12.zip(JDBC驱动程序)

　　二、测试程序

　　<%@ 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.executeQuery("create table aaa(aaa int)");
　　//stmt.executeUpdate("insert into bbb values(456)");

　　rs = stmt.executeQuery("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);
　　}