JSP通过JDBC与Oracle相连 (转)-优快云博客

本文详细介绍了如何使用JSP和JDBC驱动连接Oracle数据库的方法。包括设置环境变量、配置ClassPath以及具体的Java代码示例，演示了如何创建连接、执行查询并获取结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

JSP通过JDBC与Oracle相连 (转)[@more@]

JSP通过JdbC与 ORACLE相连

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

Java_HOME = C:jdk1.3
tomcat_HOME = C:TOMCAT-3.2.3
ClassPath = D:OracleOra81JDBClibclasses12.zip(JDBC驱动程序)

二、测试程序

sql.*,javax.sql.* ,javax.naming.*"%>

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(":"+"
");
//out.println(" + rs.getString('answers') + ");
}
rs.close();

}
catch(Exception e)
{
out.println(e);
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10752043/viewspace-962108/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10752043/viewspace-962108/