/*
* Copyright (c) 1998-2011 Caucho Technology -- all rights reserved
*
* This file is part of Resin(R) Open Source
*
* Each copy or derived work must preserve the copyright notice and this
* notice unmodified.
*
* Resin Open Source is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* Resin Open Source is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE, or any warranty
* of NON-INFRINGEMENT. See the GNU General Public License for more
* details.
*
* You should have received a copy of the GNU General Public License
* along with Resin Open Source; if not, write to the
* Free SoftwareFoundation, Inc.
* 59 Temple Place, Suite 330
* Boston, MA 02111-1307 USA
*
* @author Scott Ferguson
*/
package com.caucho.jstl.el;
import com.caucho.el.Expr;
import com.caucho.util.L10N;
import javax.el.ELContext;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.jstl.core.Config;
import javax.servlet.jsp.tagext.TagSupport;
import javax.sql.DataSource;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.SQLException;
import java.util.Properties;
import java.util.logging.Logger;
public class SqlSetDataSourceTag extends TagSupport {
private static final Logger log
= Logger.getLogger(SqlSetDataSourceTag.class.getName());
private static final L10N L = new L10N(SqlSetDataSourceTag.class);
private Expr _dataSource;
private Expr _url;
private Expr _driver;
private Expr _user;
private Expr _password;
private String _var;
private String _scope;
/**
* Sets the JSP-EL expression for the dataSource.
*/
public void setDataSource(Expr dataSource)
{
_dataSource = dataSource;
}
/**
* Sets the JSP-EL expression for the URL.
*/
public void setUrl(Expr url)
{
_url = url;
}
/**
* Sets the JSP-EL expression for the driver.
*/
public void setDriver(Expr driver)
{
_driver = driver;
}
/**
* Sets the JSP-EL expression for the user.
*/
public void setUser(Expr user)
{
_user = user;
}
/**
* Sets the JSP-EL expression for the password.
*/
public void setPassword(Expr password)
{
_password = password;
}
/**
* Sets the variable name.
*/
public void setVar(String var)
{
_var = var;
}
/**
* Sets the scope.
*/
public void setScope(String scope)
{
_scope = scope;
}
public int doStartTag() throws JspException
{
try {
String var = _var;
if (var == null)
var = Config.SQL_DATA_SOURCE;
ELContext env = pageContext.getELContext();
DataSource dataSource = null;
if (_dataSource != null) {
Object ds = _dataSource.evalObject(env);
dataSource = SqlQueryTag.getDataSource(pageContext, ds);
}
else {
dataSource = openDataSource(_driver.evalString(env),
_url.evalString(env),
_user != null ? _user.evalString(env) : null,
_password != null ? _password.evalString(env) : null);
}
CoreSetTag.setValue(pageContext, var, _scope, dataSource);
return SKIP_BODY;
} catch (Exception e) {
throw new JspException(e);
}
}
public static DataSource openDataSource(String driverClass, String url,
String user, String password)
throws Exception
{
ClassLoader loader = Thread.currentThread().getContextClassLoader();
Class cl = Class.forName(driverClass, false, loader);
Driver driver = (Driver) cl.newInstance();
return new DataSourceAdapter(driver, url, user, password);
}
public static class DataSourceAdapter implements DataSource {
private Driver _driver;
private String _url;
private String _user;
private String _password;
public DataSourceAdapter(Driver driver, String url,
String user, String password)
{
_driver = driver;
_url = url;
_user = user;
_password = password;
}
public Connection getConnection(String user, String password)
throws SQLException
{
Properties props = new Properties();
props.put("user", user);
props.put("password", user);
return _driver.connect(_url, props);
}
public Connection getConnection()
throws SQLException
{
Properties props = new Properties();
if (_user != null)
props.put("user", _user);
if (_password != null)
props.put("password", _password);
return _driver.connect(_url, props);
}
public void setLogWriter(PrintWriter out)
{
}
public PrintWriter getLogWriter()
{
return null;
}
public void setLoginTimeout(int timeout)
{
}
public int getLoginTimeout()
{
return -1;
}
public <T> T unwrap(Class<T> iface) throws SQLException {
throw new UnsupportedOperationException("Not supported yet.");
}
public boolean isWrapperFor(Class<?> iface) throws SQLException {
throw new UnsupportedOperationException("Not supported yet.");
}
}
}