databaseconnection.java

一个简易的网上书店（jsp+sqlservler+struts）。

package com.webshop.db;
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
/**
 * @author w
 *
 * To change this generated comment edit the template variable "typecomment":
 * Window>Preferences>Java>Templates.
 * To enable and disable the creation of type comments go to
 * Window>Preferences>Java>Code Generation.
 */

public class DatabaseConnection {
	public static Connection getConnection() throws SQLException,NamingException
	{
		try
		{
			
			Context initCtx = new javax.naming.InitialContext(); 
            Context envCtx = (Context) initCtx.lookup("java:comp/env"); 
            DataSource ds = (DataSource)envCtx.lookup("jdbc/eshop"); 
  
			return ds.getConnection();
		}
		catch(SQLException e)
		{
			throw e;
		}
		catch(NamingException e)
		{
			throw e;
		}
		
	}

}