jdk1.3.*
tomcat4.0.6
oracle9i
环境是客户要求的,必须是这样的环境,
另外连接数据库的代码如下:
package utstarcom.dba;import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import eastcom.util.Debug;
public class Dbase
{
private Connection conn = null;
private DataSource ds = null; private static String dbstring ="jdbc:oracle:thin:sinic/[email protected]:1521:oracle9i";
public Dbase() {
try {
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource) envCtx.lookup("jdbc/WAPDB");
}
catch (Exception e) {
// e.printStackTrace();
Debug.println("web获取到JNDI:jdbc/WAPDB 的连接时出错");
ds = null;
} try {
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
} public Connection getConn() {
if (ds != null) {
conn = null;
try {
conn = ds.getConnection();
System.out.println("****Dbase****web从 jdbc/WAPDB 获得一个连接");
}
catch (Exception ex) {
System.out.println("web获取到JNDI:jdbc/WAPDB 的连接时出错");
} return conn;
}
else {
try {
Driver myDriver = (Driver) Class.forName(
"oracle.jdbc.driver.OracleDriver").newInstance();
conn = DriverManager.getConnection(dbstring);
System.out.println("web:从本地获得一个连接");
}
catch (Exception ex) {
System.out.println("web获取本地的连接时出错");
conn = null;
}
return conn;
}
}
}
tomcat4.0.6
oracle9i
环境是客户要求的,必须是这样的环境,
另外连接数据库的代码如下:
package utstarcom.dba;import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import eastcom.util.Debug;
public class Dbase
{
private Connection conn = null;
private DataSource ds = null; private static String dbstring ="jdbc:oracle:thin:sinic/[email protected]:1521:oracle9i";
public Dbase() {
try {
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (DataSource) envCtx.lookup("jdbc/WAPDB");
}
catch (Exception e) {
// e.printStackTrace();
Debug.println("web获取到JNDI:jdbc/WAPDB 的连接时出错");
ds = null;
} try {
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
} public Connection getConn() {
if (ds != null) {
conn = null;
try {
conn = ds.getConnection();
System.out.println("****Dbase****web从 jdbc/WAPDB 获得一个连接");
}
catch (Exception ex) {
System.out.println("web获取到JNDI:jdbc/WAPDB 的连接时出错");
} return conn;
}
else {
try {
Driver myDriver = (Driver) Class.forName(
"oracle.jdbc.driver.OracleDriver").newInstance();
conn = DriverManager.getConnection(dbstring);
System.out.println("web:从本地获得一个连接");
}
catch (Exception ex) {
System.out.println("web获取本地的连接时出错");
conn = null;
}
return conn;
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货