JavaApplication创建和使用JNDI

import java.sql.Connection;
import java.sql.SQLException;
import java.util.Hashtable;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
//import org.apache.commons.dbcp.BasicDataSource;

import org.apache.tomcat.dbcp.dbcp2.BasicDataSource;

public class DBConnector {
	static private InitialContext ic = null;
	static private DataSource ds = null;

	static private void initContext() {
		try {

			BasicDataSource bds = new BasicDataSource();
			bds.setUrl("jdbc:oracle:thin:@localhost:1521:dbname");
			bds.setDriverClassName("oracle.jdbc.OracleDriver");
			bds.setUsername("test");
			bds.setPassword("admin123");

			Hashtable<String, String> evn = new Hashtable<String, String>();
			evn.put("java.naming.factory.initial", "org.apache.naming.java.javaURLContextFactory");
			ic = new InitialContext(evn);
			ic.bind("mydbname", bds);
			ds = (DataSource) ic.lookup("mydbname");
		} catch (NamingException e) {
// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	static public Connection getConn() throws SQLException {
		if (ds == null) {
			initContext();
		}
		return ds.getConnection();
	}

}

测试类：

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class test {
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		try {
			Connection conn = DBConnector.getConn();
			System.out.println("conn = " + conn);
			String qSQL = "SELECT id,mingzi from user";
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(qSQL);

			while (rs.next()) {
				System.out.println(rs.getString("id"));
				System.out.print(" " + rs.getString("mingzi"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}