public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (contextPath == null || "".equals(contextPath)) { if (isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath is null and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath = ? and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (contextPath == null || "".equals(contextPath)) { if (isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath is null and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath = ? and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (contextPath == null || "".equals(contextPath)) { if (isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath is null and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath = ? and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (_dbAdaptor == null) throw new IllegalStateException("No DB adaptor"); if (contextPath == null || "".equals(contextPath)) { if (_dbAdaptor.isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+getTableName()+ " where "+getIdColumn()+" = ? and "+ getContextPathColumn()+" is null and "+ getVirtualHostColumn()+" = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+getTableName()+ " where "+getIdColumn()+" = ? and "+getContextPathColumn()+ " = ? and "+getVirtualHostColumn()+" = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (_dbAdaptor == null) throw new IllegalStateException("No DB adaptor"); if (contextPath == null || "".equals(contextPath)) { if (_dbAdaptor.isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+getTableName()+ " where "+getIdColumn()+" = ? and "+ getContextPathColumn()+" is null and "+ getVirtualHostColumn()+" = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+getTableName()+ " where "+getIdColumn()+" = ? and "+getContextPathColumn()+ " = ? and "+getVirtualHostColumn()+" = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (contextPath == null || "".equals(contextPath)) { if (isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath is null and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath = ? and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (contextPath == null || "".equals(contextPath)) { if (isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath is null and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath = ? and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (contextPath == null || "".equals(contextPath)) { if (isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath is null and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath = ? and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }
public PreparedStatement getLoadStatement (Connection connection, String rowId, String contextPath, String virtualHosts) throws SQLException { if (contextPath == null || "".equals(contextPath)) { if (isEmptyStringNull()) { PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath is null and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, virtualHosts); return statement; } } PreparedStatement statement = connection.prepareStatement("select * from "+_sessionTable+ " where sessionId = ? and contextPath = ? and virtualHost = ?"); statement.setString(1, rowId); statement.setString(2, contextPath); statement.setString(3, virtualHosts); return statement; } }