Examples of DBUpdateHandler

Examples of org.milowski.db.DBUpdateHandler

153
154
155
156
157
158
159
160
161
162
163
         throw new NoSuchAlgorithmException("Algorithm "+algorithm+" is not supported.");
      }
      DBConnection connection = db.getConnection();
      try {
         connection.deleteById(AuthDB.DELETE_AUTHENTICATION_BY_USER, id);
         connection.create(AuthDB.CREATE_AUTHENTICATION, -1,new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setString(2,value);
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
   public void addRole(final Role role)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.DELETE_USER_ROLE, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,role.getId());
            }
         });
         connection.update(AuthDB.ADD_USER_ROLE, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,role.getId());
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

236
237
238
239
240
241
242
243
244
245
246
   public boolean removeRole(final Role role)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         return connection.update(AuthDB.USER_HAS_ROLE, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setInt(2,role.getId());
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
      throws SQLException
   {
      if (alias==null && this.alias!=null) {
         DBConnection connection = db.getConnection();
         try {
            connection.update(AuthDB.DELETE_USER_ALIAS, new DBUpdateHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,id);
               }
            });
         } finally {
            db.release(connection);
         }
         this.alias = null;
         db.userCache.removeByName(this.alias);
         return true;
      }
      if (alias.equals(this.alias)) {
         return true;
      }
      if (!db.isUserAliasAvailable(alias)) {
         return false;
      }
      if (this.alias!=null) {
         db.userCache.removeByName(this.alias);
         DBConnection connection = db.getConnection();
         try {
            connection.update(AuthDB.CHANGE_USER_ALIAS, new DBUpdateHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setString(1,alias);
                  s.setString(2,id+"-"+alias);
                  s.setInt(3,id);
               }
            });
         } finally {
            db.release(connection);
         }
      } else {
         DBConnection connection = db.getConnection();
         try {
            connection.update(AuthDB.CREATE_USER_ALIAS, new DBUpdateHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,id);
                  s.setString(2,alias);
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

363
364
365
366
367
368
369
370
371
372
373
   public void setName(final String name)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.CHANGE_USER_NAME, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               if (name==null) {
                  s.setNull(1,Types.VARCHAR);
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

391
392
393
394
395
396
397
398
399
400
401
   public void setEmail(final String email)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.CHANGE_USER_NAME, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               if (email==null) {
                  s.setNull(1,Types.VARCHAR);
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
      if (session!=null) {
         // delete any session authentication information first
         if (realm==null) {
            DBConnection connection = db.getConnection();
            try {
               connection.update(AuthDB.DELETE_USER_AUTHENTICATION, new DBUpdateHandler() {
                  public void prepare(PreparedStatement s)
                     throws SQLException
                  {
                     s.setInt(1,id);
                     s.setString(2,session.toString());
                  }
               });
            } finally {
               db.release(connection);
            }
         } else {
            DBConnection connection = db.getConnection();
            try {
               connection.update(AuthDB.DELETE_REALM_USER_AUTHENTICATION, new DBUpdateHandler() {
                  public void prepare(PreparedStatement s)
                     throws SQLException
                  {
                     s.setInt(1,id);
                     s.setInt(2,realm.getId());
                     s.setString(3,session.toString());
                  }
               });
            } finally {
               db.release(connection);
            }
         }
      }

      // delete any expired sessions for the user
      final Timestamp created = new Timestamp(System.currentTimeMillis());
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.DELETE_EXPIRED_SESSIONS, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setTimestamp(2,created);
            }
         });
      } finally {
         db.release(connection);
      }
     
      // check the internal password
      if (checkPassword(password)) {
         // We have the correct password
         int dbid = -1;
         if (expires>0) {
            //construct an auth record with a session id
            final UUID theSession = session==null ? UUID.randomUUID() : session;
            final Timestamp expiration = new Timestamp(created.getTime()+expires);
            connection = db.getConnection();
            try {
               connection.update(AuthDB.CREATE_AUTHENTICATED, new DBUpdateHandler() {
                  public void prepare(PreparedStatement s)
                     throws SQLException
                  {
                     s.setInt(1,id);
                     if (realm==null) {
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
      // delete any expired sessions for the user
      final Timestamp created = new Timestamp(System.currentTimeMillis());
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.DELETE_EXPIRED_SESSIONS, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1,id);
               s.setTimestamp(2,created);
            }
         });
      } finally {
         db.release(connection);
      }
     
      int dbid = -1;
      if (expires>0) {
         //construct an auth record with a session id
         final UUID session = UUID.randomUUID();
         final Timestamp expiration = new Timestamp(created.getTime()+expires);
         connection = db.getConnection();
         try {
            connection.update(AuthDB.CREATE_AUTHENTICATED, new DBUpdateHandler() {
               public void prepare(PreparedStatement s)
                  throws SQLException
               {
                  s.setInt(1,id);
                  if (realm==null) {
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

116
117
118
119
120
121
122
123
124
125
126
      if (permissions.contains(p)) {
         return true;
      }
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.CREATE_ROLE_PERMISSION, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1, id);
               s.setInt(2, p.getId());
View Full Code Here

Examples of org.milowski.db.DBUpdateHandler

136
137
138
139
140
141
142
143
144
145
146
   public boolean removePermission(final Permission p)
      throws SQLException
   {
      DBConnection connection = db.getConnection();
      try {
         connection.update(AuthDB.DELETE_ROLE_PERMISSION, new DBUpdateHandler() {
            public void prepare(PreparedStatement s)
               throws SQLException
            {
               s.setInt(1, id);
               s.setInt(2, p.getId());
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.