jsp连接oracle的疑问
ctk 2004-03-10 03:39:08 环境是:
win2000 server
tomcat5.0
jdk1.4
oracle8.1.7程序开发环境,jdbc已经安装,class12.zip已经在classpath中设置
文件放在tomcat_home\webapps\root目录下,通过jdbc-odbc方式可以正常运行,但
如果是以ORACLE-THIN方式连接,则不能连接上,下面是代码:
<%@page language="java" import="java.sql.*"%>
<html>
<head>
<title> hi </title>
</head>
<body>
<%
String MM_ora7_DRIVER = "oracle.jdbc.driver.OracleDriver";
String MM_ora7_STRING = "jdbc:oracle:thin:@134.141.29.58:1521:ora7";
/*采用该方式可以连接*/
// String MM_ora7_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
// String MM_ora7_STRING = "jdbc:odbc:ora";
/*------------------*/
try{
Class.forName( MM_ora7_DRIVER ).newInstance();
Connection conn = DriverManager.getConnection( MM_ora7_STRING , "zz" , "qq" );
String sql = "select tname from tab";
Statement stmp = conn.createStatement( );
ResultSet rs = stmp.executeQuery( sql );
String first_name ;
while ( rs.next( ) ) {
first_name = rs.getString( "tname" );
out.print( first_name + "<br>" );
}
}
catch(Exception e){
e.printStackTrace();
}
%>
</body>
</html>