JSP通过JDBC与Oracle相-JSP教程,Jsp/Servlet

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

}