dataaccess.java

来自「《精通JSP编程 》源代码(赵强那本) 很有用的源代码」· Java 代码 · 共 37 行

package jnestore.javabeans;


import javax.naming.*;
import javax.naming.spi.*;
import javax.sql.*;
import java.sql.*;


public class DataAccess {

       
    private final String DATASOURCE = "java:comp/env/jdbc/jnestore";

    
    public Connection getConnection() {
        Connection con = null;
        try {
            Context ctx = new InitialContext();
            DataSource ds = (DataSource) ctx.lookup(DATASOURCE);

            con = ds.getConnection();
            System.out.println("connect succeed");

        } catch (Exception e) {
            System.out.println("Connection to pool failed! - " + e);
        } finally {
            return con;

        }

    }

   

}