|
![]() |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
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); } 返回类别: 教程 上一教程: JAVASERVER PAGE(JSP)简介 下一教程: JAVA中的异步网络编程 您可以阅读与"JSP通过JDBC与ORACLE相连"相关的教程: · JSP数据库操作例程-数据分页显示-JDBC 2.0-ORACLE · java通过JDBC访问Oracle的2个非常 · 通过JDBC连接ORACLE数据库的十大技巧 · JSP中调用ORACLE存储过程的小例子 · 在Win2000中安装JSP访问Oracle |
![]() ![]() |
快精灵印艺坊 版权所有 |
首页![]() ![]() ![]() ![]() ![]() ![]() ![]() |