Package com.adito.jdbc

Examples of com.adito.jdbc.JDBCPreparedStatement.executeQuery()

529
530
531
532
533
534
535
536
537
538
539
       
        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) {
View Full Code Here
542
543
544
545
546
547
548
549
550
551
552
                        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;
View Full Code Here
581
582
583
584
585
586
587
588
589
590
591
        } 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 = "";
View Full Code Here
684
685
686
687
688
689
690
691
692
693
694
        }
        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")));
View Full Code Here
769
770
771
772
773
774
775
776
777
778
779
     * @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")));
View Full Code Here
794
795
796
797
798
799
800
801
802
803
804
     */
    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"));
                }
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
        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 {
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
     */
    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 {
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
    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));
                }
View Full Code Here
208
209
210
211
212
213
214
215
216
217
218
     * @see com.adito.webforwards.WebForwardDatabase#getWebForwards()
     */
    public List<WebForward> getWebForwards() throws Exception {
        JDBCPreparedStatement ps = db.getStatement("getWebForwards.select.allTypes");
        try {
            ResultSet rs = ps.executeQuery();
            try {
                List<WebForward> v = new ArrayList<WebForward>();
                while (rs.next()) {
                    v.add(buildWebForward(rs));
                }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.