mysql实现号码池_java web Tomcat 实现mysql 数据池配置 数据池配置成功

数据库连接程序:packagecom.mclovin.mvc.dbc;importjava.sql.*;importjavax.sql.*;importjavax.naming.*;publicclassDatabaseConnection{privateConnectionconn=null;privatestaticfi...

数据库连接程序:

package com.mclovin.mvc.dbc;

import java.sql.*;

import javax.sql.*;

import javax.naming.*;

public class DatabaseConnection{

private Connection conn = null ;

private static final String DSNAME = "java:comp/env/jdbc/mclovin" ;

public DatabaseConnection() throws Exception{

try{

Context ctx = new InitialContext();

DataSource ds = (DataSource) ctx.lookup(DSNAME);

this.conn = ds.getConnection();

}catch(Exception e){

e.printStackTrace() ;

}

}

public Connection getConnection(){

return this.conn ;

}

public void close() throws Exception{

if(this.conn != null){

try{

this.conn.close();

}catch(Exception e){

throw e ;

}

}

}

}

编译成功,但运行*.java测试程序的时候,就出报错:

javax.naming.noinitialcontextexception

请教如何解决此问题.

编写的jsp测试程序可以运行

String DSNAME ="java:comp/env/jdbc/mclovin" ;

Context ctx = new InitialContext();

DataSource ds = (DataSource) ctx.lookup(DSNAME);

Connection conn = ds.getConnection();

%>

conn.close();

%>

展开