/*
 *
 *  Copyright (c) 2005, Markus Meisters <markus.meisters@web.de>
 *  All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *    * Redistributions of source code must retain the above copyright notice,
 *      this list of conditions and the following disclaimer.
 *    * Redistributions in binary form must reproduce the above copyright notice
 *      , this list of conditions and the following disclaimer in the
 *      documentation and/or other materials provided with the distribution.
 *    * Neither the name of the author nor the names of its contributors may be
 *      used to endorse or promote products derived from this software without
 *      specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

/*
 * DatabaseAction.java
 *
 * Created on 4. November 2006, 16:16
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package jet.examples;

import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import jet.servlet.JetContext;
import jet.servlet.JetData;
import jet.sql.RowSetDynaClass;
import jet.sql.WebSql;

/**
 *
 * @author mmeiste10.1
 */
public class DatabaseAction {
    
    public void databaseMethod(JetContext context, JetData data) {
        
        WebSql sqltool = new WebSql();
        try{
            sqltool.setConnection( getConnection() );
            
            sqltool.prepareStatement("select id,name from test");
            RowSetDynaClass rs = sqltool.getRowSetDynaClass();
            
            //add data into data structure
            data.add("rsdata", rs.getRows());
            context.render(data, "jet.ftl.examples.pages.rsdata");
            
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            sqltool.finalize();
        }
        
        
    }
    
    private Connection getConnection() throws SQLException, NamingException{
        
        String dbcontext = "jdbc/jet";
        System.err.println( "DB-CONNECTION: " + dbcontext);
        
        Context theInitialContext = new InitialContext();
        Context datasourceContext = (Context) theInitialContext.lookup("java:comp/env");
        DataSource datasource = (DataSource)datasourceContext.lookup(dbcontext);



        if (theInitialContext != null) {
            if (datasourceContext != null) {
                datasourceContext.close();
            }
            theInitialContext.close();
        }

        if( datasource != null ){
            return datasource.getConnection();
        }else{
            throw new SQLException("datasource not initialized");
        }
    }
    
}