databaseconnection.java

用户可以添加商品

package product.db;
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;

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/product"); 
  
			return ds.getConnection();
		}catch(SQLException e){
			throw e;
		}catch(NamingException e){
			throw e;
		}
		
	}

}