JNDI配置数据源

一.web容器的配置

    不同的web容器的配置都略有不同，具体见相关的官方文档:
    Tomcat 6: [url]http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html[/url]
    example: [url]http://icansoft.blog.51cto.com/268543/49993[/url]

    Jetty 6:  [url]http://docs.codehaus.org/display/JETTY/JNDI[/url]
                  [url]http://docs.codehaus.org/display/JETTY/DataSource+Examples[/url]

    Resin 3: [url]http://www.caucho.com/resin-3.1/examples/db-jdbc/index.xtp[/url]
                    [url]http://www.caucho.com/resin-3.1/doc/database-tags.xtp[/url]

 

二.Web.Xml配置

< resource-ref >
     < description >Admin connect to DB </ description >
     < res-ref-name >jdbc/honghu_admin </ res-ref-name >
     < res-type >javax.sql.DataSource </ res-type >
     < res-auth >Container </ res-auth >
</ resource-ref >

resource-ref是可以多个的。

三.SqlBean类

package ucshop.common;

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

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class SqlBean {
   private static DataSource dataSource;
    
   static {
    init();
  }
    
   /*
    * 私有构造函数,不能显式new实例,确保只有一个实例
    */
   private SqlBean() {  }
    
   private static void init() {
     try {
      Context initContext = new InitialContext();
      dataSource = (DataSource)initContext.lookup( "java:comp/env/jdbc/ucshop");
    } catch(NamingException nameEx) {
      System.out.println( "lookup失败");
      nameEx.printStackTrace();
    }
  }
    
   /**
    * 打开数据库连接
    * @return 数据库连接,失败则为null
    */
   public synchronized static Connection getConnection(){
     try {
       return (dataSource != null)? dataSource.getConnection(): null;
    } catch (SQLException sqlEx) {
      System.out.println( "连接失败");
      sqlEx.printStackTrace();
    }
     return null;
  }
    
   /**
    * 关闭数据库连接
    * @param conn
    * @param statement
    */
   public static void closeConnection(Connection conn, Statement  statement, ResultSet resultSet) {
     try{
       if (resultSet != null){
        resultSet.close();
        resultSet = null;
      }
        
       if (statement != null){
        statement.close();
        statement = null;
      }
        
      if(conn != null){
        conn.close();
        conn = null;
      }
    } catch(SQLException sqlEx) {
      System.out.println( "关闭数据库连接出错");
      sqlEx.printStackTrace();
    } finally {
       try{
         if (resultSet != null){
          resultSet.close();
          resultSet = null;
        }
        
         if (statement != null){
          statement.close();
          statement = null;
        }

        if(conn != null){
          conn.close();
          conn = null;
        }
      } catch(SQLException sqlEx) {
        System.out.println( "关闭数据库连接还是出错");
        sqlEx.printStackTrace();
      }
    }
  }

}

 

 

转自:http://icansoft.blog.51cto.com/268543/113379