明輝手游網(wǎng)中心：是一個免費(fèi)提供流行視頻軟件教程、在線學(xué)習(xí)分享的學(xué)習(xí)平臺！

JSP通過JDBC與Oracle相連

發(fā)表時間：2024-01-21 來源：明輝站整理相關(guān)軟件相關(guān)文章人氣：

[摘要]JSP通過JDBC與Oracle相連一、環(huán)境變量(系統(tǒng)變量)JAVA_HOME = C:\JDK1.3TOMCAT_HOME = C:\TOMCAT-3.2.3ClassPath = D:\Oracle\Ora81\jdbc\lib\classes12.zip(JDBC驅(qū)動程序)二、測試程序<...

JSP通過JDBC與Oracle相連

一、環(huán)境變量(系統(tǒng)變量)

JAVA_HOME = C:\JDK1.3
TOMCAT_HOME = C:\TOMCAT-3.2.3
ClassPath = D:\Oracle\Ora81\jdbc\lib\classes12.zip(JDBC驅(qū)動程序)

二、測試程序

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