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); }