JSP通过JDBC与Oracle相连

时间： 2021-07-31 作者：daque

JSP通过JDBC与Oracle相连

一、情况变量(体例变量)

java_home = c:\jdk1.3tomcat_home = c:\tomcat-3.2.3classpath = 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=utf8" %> <% 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); }

JSP通过JDBC与Oracle相连

相关推荐

推荐下载

热门阅览

最新排行