Package l2p.database

Examples of l2p.database.ThreadConnection.prepareStatement()

113
114
115
116
117
118
119
120
121
122
123
                FiltredPreparedStatement statement = null;
                ResultSet rset = null;
                try
                {
                        con = L2DatabaseFactory.getInstance().getConnection();
                        statement = con.prepareStatement("SELECT login, access_level FROM accounts ORDER BY login ASC");
                        rset = statement.executeQuery();
                        while(rset.next())
                        {
                                System.out.println(rset.getString("login") + " -> " + rset.getInt("access_level"));
                                count++;
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
                ThreadConnection con = null;
                FiltredPreparedStatement statement = null;
                try
                {
                        con = L2DatabaseFactory.getInstance().getConnection();
                        statement = con.prepareStatement("REPLACE  accounts (login, password, access_level, comments) VALUES (?,?,?,?)");
                        statement.setString(1, account);
                        statement.setString(2, Base64.encodeBytes(newpass));
                        statement.setString(3, level);
                        statement.setString(4, comments);
                        statement.executeUpdate();
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
                ResultSet rset = null;
                try
                {
                        con = L2DatabaseFactory.getInstance().getConnection();
                        // Check Account Exist
                        statement = con.prepareStatement("SELECT COUNT(*) FROM accounts WHERE login=?;");
                        statement.setString(1, account);
                        rset = statement.executeQuery();
                        if(rset.next() && rset.getInt(1) > 0)
                        {
                                // Exist
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
                        rset = statement.executeQuery();
                        if(rset.next() && rset.getInt(1) > 0)
                        {
                                // Exist
                                // Update
                                statement = con.prepareStatement("UPDATE accounts SET access_level=? WHERE login=?;");
                                statement.setEscapeProcessing(true);
                                statement.setString(1, level);
                                statement.setString(2, account);
                                statement.executeUpdate();
                                System.out.println("Account \"" + account + "\" Updated\n");
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
                ResultSet rset = null, subRset = null;
                try
                {
                        con = L2DatabaseFactory.getInstance().getConnection();
                        // Check Account Exist
                        statement = con.prepareStatement("SELECT COUNT(*) FROM accounts WHERE login=?;");
                        statement.setString(1, account);
                        rset = statement.executeQuery();
                        if(rset.getInt(1) == 0)
                        {
                                System.out.println("Account \"" + account + "\" Not Exist\n");
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
                                return;
                        }
                        // Account exist
                        DatabaseUtils.closeDatabaseSR(statement, rset);
                        // Get Accounts ID
                        statement = con.prepareStatement("SELECT obj_Id, char_name, clanid FROM characters WHERE account_name=?;");
                        statement.setEscapeProcessing(true);
                        statement.setString(1, account);
                        rset = statement.executeQuery();
                        while(rset.next())
                        {
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
                        rset = statement.executeQuery();
                        while(rset.next())
                        {
                                System.out.println("Deleting character \"" + rset.getString("char_name") + "\"\n");
                                // Check If clan leader Remove Clan and remove all from it
                                subStatement = con.prepareStatement("SELECT COUNT(*) FROM clan_data WHERE leader_id=?;");
                                subStatement.setString(1, rset.getString("clanid"));
                                subRset = subStatement.executeQuery();
                                boolean isClanLeader = false;
                                if(subRset.next() && subRset.getInt(1) > 0)
                                {
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
                                DatabaseUtils.closeDatabaseSR(subStatement, subRset);
                                if(isClanLeader)
                                {
                                        // Clan Leader
                                        // Get Clan Name
                                        subStatement = con.prepareStatement("SELECT clan_name FROM clan_data WHERE leader_id=?;");
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subRset = subStatement.executeQuery();
                                        String clanName = null;
                                        if(subRset.next())
                                        {
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
                                                clanName = subRset.getString("clan_name");
                                        }
                                        System.out.println("Deleting clan \"" + clanName + "\"\n");
                                        DatabaseUtils.closeDatabaseSR(subStatement, subRset);
                                        // Delete Clan Wars
                                        subStatement = con.prepareStatement("DELETE FROM clan_wars WHERE clan1=? OR clan2=?;");
                                        subStatement.setEscapeProcessing(true);
                                        subStatement.setString(1, clanName);
                                        subStatement.setString(2, clanName);
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
View Full Code Here
257
258
259
260
261
262
263
264
265
266
267
                                        subStatement.setString(1, clanName);
                                        subStatement.setString(2, clanName);
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
                                        // Remove All From clan
                                        subStatement = con.prepareStatement("UPDATE characters SET clanid=0 WHERE clanid=?;");
                                        subStatement.setString(1, rset.getString("clanid"));
                                        subStatement.executeUpdate();
                                        DatabaseUtils.closeStatement(subStatement);
                                        // Delete Clan
                                        subStatement = con.prepareStatement("DELETE FROM clan_data WHERE clan_id=?;");
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.