Examples of com.adito.jdbc.JDBCPreparedStatement

com.adito.jdbc.JDBCPreparedStatement

Title:

Description:

Copyright: Copyright (c) 2004

Company:
@author not attributable

        Calendar created = JDBCUtil.getCalendar(rs, "date_created");
        Calendar amended = JDBCUtil.getCalendar(rs, "date_amended");
        int realmID = rs.getInt("realm_id");
        
        if (type == WebForward.TYPE_PATH_BASED_REVERSE_PROXY || type == WebForward.TYPE_HOST_BASED_REVERSE_PROXY) {
            JDBCPreparedStatement ps2 = db.getStatement("getWebForward.reverseProxy.selectById");
            try {
                ps2.setInt(1, id);
                ResultSet rs2 = ps2.executeQuery();
                try {
                    StringBuffer paths = new StringBuffer();
                    String hostHeader = "";
                    while (rs2.next()) {
                        if (paths.length() > 0) {
                            paths.append('\n');
                        }
                        paths.append(rs2.getString("path"));
                    }
                    JDBCPreparedStatement ps3 = db.getStatement("getWebForward.reverseProxyOptions.selectById");
                    try {
                        ps3.setInt(1, id);
                        ResultSet rs3 = ps3.executeQuery();
                        try {
                            String authUsername = "";
                            String authPassword = "";
                            String preferredAuthScheme = HttpAuthenticatorFactory.BASIC;
                            boolean activeDNS = false;
                            String formType = "";
                            String formParameters = "";
                            String charset = null;
                            if (rs3.next()) {
                                authUsername = rs3.getString("authentication_username");
                                authPassword = rs3.getString("authentication_password");
                                preferredAuthScheme = rs3.getString("preferred_authentication_scheme");
                                activeDNS = rs3.getInt("active_dns") == 1;
                                hostHeader = rs3.getString("host_header");
                                formType = rs3.getString("form_type");
                                formParameters = rs3.getString("form_parameters");
                                charset = rs3.getString("charset");
                            }
                            return new ReverseProxyWebForward(realmID, id, type, url, name, description, category, authUsername, authPassword,
                                            preferredAuthScheme, formType, formParameters, paths.toString(), hostHeader, activeDNS, autoStart,
                                            created, amended, charset);
                        } finally {
                            rs3.close();
                        }
                    } finally {
                        ps3.releasePreparedStatement();
                    }
                } finally {
                    rs2.close();
                }
            } finally {
                ps2.releasePreparedStatement();
            }


        } else if (type == WebForward.TYPE_REPLACEMENT_PROXY) {
            JDBCPreparedStatement ps3 = db.getStatement("getWebForward.replacementProxyOptions.selectById");
            try {
                ps3.setInt(1, id);
                ResultSet rs3 = ps3.executeQuery();
                try {
                    String authUsername = "";
                    String authPassword = "";
                    String preferredAuthScheme = HttpAuthenticatorFactory.BASIC;
                    String encoding = "";
                    String formType = "";
                    String formParameters = "";
                    PropertyList restrictToHosts = new PropertyList();
                    if (rs3.next()) {
                        authUsername = rs3.getString("authentication_username");
                        authPassword = rs3.getString("authentication_password");
                        preferredAuthScheme = rs3.getString("preferred_authentication_scheme");
                        encoding = rs3.getString("encoding");
                        restrictToHosts.setAsPropertyText(rs3.getString("restrict_to_hosts"));
                        formType = rs3.getString("form_type");
                        formParameters = rs3.getString("form_parameters");
                    }
                    return new ReplacementProxyWebForward(realmID, id, url, name, description, category, authUsername, authPassword,
                                    preferredAuthScheme, encoding, restrictToHosts, formType, formParameters, autoStart, created, amended);
                } finally {
                    rs3.close();
                }
            } finally {
                ps3.releasePreparedStatement();
            }


        } else {
            return new TunneledSiteWebForward(realmID, id, url, name, description, category, autoStart, created, amended);
        }

View Full Code Here

            List cachedReplacements = (List) replacementsCache.retrieve(cacheKey);
            if (replacementsCache.contains(cacheKey)) {
                return cachedReplacements;
            }
        }
        JDBCPreparedStatement ps = null;


        // global=SELECT * FROM replacements WHERE username=? AND mime_type=?
        // AND replace_type=? AND MATCHES(?,site_pattern=?) = ?
        // ORDER BY username,replace_type,mime_type,sequence ASC
        // user=SELECT * FROM replacements WHERE ( username=? OR username=? )
        // AND mime_type=? AND replace_type=? AND MATCHES(?,site_pattern=?) = ?
        // ORDER BY username,replace_type,mime_type,sequence ASC


        String sitePattern = site == null || site.equals("") ? ".*" : site;
        if (site == null || site.equals("")) {
            ps = db.getStatement("getReplacementsForContent.select.allSites");
            ps.setString(3, "");


        } else {
            ps = db.getStatement("getReplacementsForContent.select");
            ps.setString(3, sitePattern);
            ps.setString(4, sitePattern);
        }
        ps.setString(1, mimeType == null ? "" : mimeType);
        ps.setInt(2, replaceType);


        try {
            ResultSet rs = ps.executeQuery();
            CacheList v = new CacheList();
            try {
                while (rs.next()) {
                    v.add(new DefaultReplacement(rs.getString("mime_type"), replaceType, rs.getInt("sequence"), rs
                                    .getString("site_pattern"), rs.getString("match_pattern"), rs.getString("replace_pattern")));
                }
                replacementsCache.store(cacheKey, v, new Long(Long.MAX_VALUE), null);
                return v;
            } finally {
                rs.close();
            }
        } finally {
            ps.releasePreparedStatement();
        }
    }

View Full Code Here

     * (non-Javadoc)
     * 
     * @see com.adito.security.SystemDatabase#deleteReplacement(int)
     */
    public void deleteReplacement(int sequence) throws Exception {
        JDBCPreparedStatement ps = db.getStatement("deleteReplacements.delete");
        try {
            ps.setInt(1, sequence);
            ps.execute();
        } finally {
            ps.releasePreparedStatement();
        }
        replacementsCache.clear();
    }

View Full Code Here

     * (non-Javadoc)
     * 
     * @see com.adito.security.SystemDatabase#updateReplacement(com.adito.services.Replacement)
     */
    public void updateReplacement(Replacement replacement) throws Exception {
        JDBCPreparedStatement ps = db.getStatement("updateReplacements.update");
        try {
            ps.setString(1, replacement.getMimeType());
            ps.setString(2, replacement.getSitePattern());
            ps.setString(3, replacement.getMatchPattern());
            ps.setString(4, replacement.getReplacePattern());
            ps.setInt(5, replacement.getReplaceType());
            ps.setInt(6, replacement.getSequence());
            ps.execute();
        } finally {
            ps.releasePreparedStatement();
        }
        replacementsCache.clear();
    }

View Full Code Here

     * (non-Javadoc)
     * 
     * @see com.adito.security.SystemDatabase#createReplacement(com.adito.services.Replacement)
     */
    public Replacement createReplacement(Replacement replacement) throws Exception {
        JDBCPreparedStatement ps = db.getStatement("createReplacement.insert");
        try {
            ps.setInt(1, replacement.getReplaceType());
            ps.setString(2, replacement.getMimeType());
            ps.setString(3, replacement.getSitePattern());
            ps.setString(4, replacement.getMatchPattern());
            ps.setString(5, replacement.getReplacePattern());
            ps.execute();
            return new DefaultReplacement(replacement.getMimeType(), replacement.getReplaceType(), db.getLastInsertId(ps,
                "createReplacement.lastInsertId"), replacement.getSitePattern(), replacement.getMatchPattern(), replacement
                            .getReplacePattern());
        } finally {
            replacementsCache.clear();
            ps.releasePreparedStatement();
        }
    }

View Full Code Here

     * (non-Javadoc)
     * 
     * @see com.adito.security.SystemDatabase#getReplacements()
     */
    public List<Replacement> getReplacements() throws Exception {
        JDBCPreparedStatement ps = db.getStatement("getReplacements.select");
        try {
            ResultSet rs = ps.executeQuery();
            try {
                List<Replacement> v = new ArrayList<Replacement>();
                while (rs.next()) {
                    v.add(new DefaultReplacement(rs.getString("mime_type"), rs.getInt("replace_type"), rs.getInt("sequence"), rs
                                    .getString("site_pattern"), rs.getString("match_pattern"), rs.getString("replace_pattern")));
                }
                return v;
            } finally {
                rs.close();
            }
        } finally {
            ps.releasePreparedStatement();
        }
    }

View Full Code Here

     * (non-Javadoc)
     * 
     * @see com.adito.security.SystemDatabase#getReplacement(int)
     */
    public Replacement getReplacement(int sequence) throws Exception {
        JDBCPreparedStatement ps = db.getStatement("getReplacement.select");
        ps.setInt(1, sequence);
        try {
            ResultSet rs = ps.executeQuery();
            try {
                if (rs.next()) {
                    return new DefaultReplacement(rs.getString("mime_type"), rs.getInt("replace_type"), rs.getInt("sequence"), rs
                                    .getString("site_pattern"), rs.getString("match_pattern"), rs.getString("replace_pattern"));
                }
            } finally {
                rs.close();
            }
        } finally {
            ps.releasePreparedStatement();
        }
        return null;
    }

View Full Code Here

     * 
     * @see com.adito.webforwards.WebForwardDatabase#getReverseProxyWebForward(com.adito.security.User,
     *      java.lang.String)
     */
    public WebForward getReverseProxyWebForward(User user, String pathInContext) throws Exception {
        JDBCPreparedStatement ps = db.getStatement("getReverseProxyWebForward.select");
        ps.setString(1, "");
        ps.setString(2, user == null ? "" : user.getPrincipalName());
        ps.setString(3, pathInContext);


        try {
            ResultSet rs = ps.executeQuery();
            try {
                if (rs.next()) {
                    return getWebForward(rs.getInt("webforward_id"));
                }
            } finally {
                if (rs != null) {
                    rs.close();
                }
            }
        } finally {
            ps.releasePreparedStatement();
        }
        return null;
    }

View Full Code Here

     * (non-Javadoc)
     * 
     * @see com.adito.webforwards.WebForwardDatabase#getWebForward(int)
     */
    public WebForward getWebForward(int id) throws Exception {
        JDBCPreparedStatement ps = db.getStatement("getWebForward.selectById");
        ps.setInt(1, id);
        try {
            ResultSet rs = ps.executeQuery();
            try {
                if (rs.next()) {
                    return buildWebForward(rs);
                }
            } finally {
                rs.close();
            }
        } finally {
            ps.releasePreparedStatement();
        }
        return null;
    }

View Full Code Here

     * (non-Javadoc)
     * 
     * @see com.adito.webforwards.WebForwardDatabase#getWebForwards(int)
     */
    public List<WebForward> getWebForwards(int realmID) throws Exception {
        JDBCPreparedStatement ps = null;
        ps = db.getStatement("getWebForwards.realm.select");
        ps.setInt(1, realmID);
        try {
            ResultSet rs = ps.executeQuery();
            try {
                List<WebForward> v = new ArrayList<WebForward>();
                while (rs.next()) {
                    v.add(buildWebForward(rs));
                }
                return v;
            } finally {
                if (rs != null) {
                    rs.close();
                }
            }
        } finally {
            ps.releasePreparedStatement();
        }
    }

View Full Code Here

0 1 2 3

TOP

Related Classes of com.adito.jdbc.JDBCPreparedStatement

com.adito.applications.JDBCApplicationShortcutDatabase

com.adito.networkplaces.JDBCNetworkPaceDatabase

com.adito.tunnels.JDBCTunnelDatabase

com.adito.webforwards.JDBCWebForwardDatabase

java.sql.Timestamp

java.sql.SQLException

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.