Package de.kilobyte22.app.kibibyte

Examples of de.kilobyte22.app.kibibyte.Database.prepareStatement()

139
140
141
142
143
144
145
146
147
148
149
            if (bot.useYaml) {
                HashMap<String, String> perms_ = bot.yamlEngine.load(new File("permissions.yaml"));
                perms_.put(nick, tmpperms);
                bot.yamlEngine.writeYaml(new File("permissions.yaml"), perms_);
            } else {
                PreparedStatement s = database.prepareStatement("SELECT * FROM permissions WHERE server = ? AND nickserv = ?");
                s.setString(1, bot.getServer());
                s.setString(2, nick);
                try {
                    //s.executeQuery().next();
                    s = database.prepareStatement("UPDATE permissions SET permissions=? WHERE server = ? AND nickserv = ?");
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
                PreparedStatement s = database.prepareStatement("SELECT * FROM permissions WHERE server = ? AND nickserv = ?");
                s.setString(1, bot.getServer());
                s.setString(2, nick);
                try {
                    //s.executeQuery().next();
                    s = database.prepareStatement("UPDATE permissions SET permissions=? WHERE server = ? AND nickserv = ?");
                    s.setString(1, tmpperms);
                    s.setString(2, bot.getServer());
                    s.setString(3, nick);
                    if (!s.execute())
                        throw new Exception("");
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
                        throw new Exception("");
                    logger.log(s.toString());
                } catch (Exception ex) {
                    //logger.log(ex);
                    //s.executeQuery().next();
                    s = database.prepareStatement("INSERT INTO permissions (server, nickserv, permissions) VALUES (?, ?, ?)");
                    s.setString(1, bot.getServer());
                    s.setString(2, nick);
                    s.setString(3, tmpperms);
                    s.execute();
                }
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.