JSP通过JDBC与Oracle相连

jsp通过jdbc与oracle相连

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

java_home = c:\jdk1.3
tomcat_home = c:\tomcat-3.2.3
classpath = d:\oracle\ora81\jdbc\lib\classes12.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);
}