Package java.sql

Examples of java.sql.CallableStatement.executeQuery()

211
212
213
214
215
216
217
218
219
220
221
      stmt = conn.prepareCall("call pageBookmarksLinkId(?,?,?,?)");
      stmt.setInt(1,link.getId());
      stmt.setInt(2,offset);
      stmt.setInt(3,count);
      stmt.registerOutParameter(4,Types.INTEGER);
      ResultSet rs = stmt.executeQuery();
      int size = stmt.getInt(4);
      if(size < 0){
        size = 0;
      }
      while(rs.next()){
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
      cStmt = conn.prepareCall("call pageBookmarksTagId(?,?,?,?);");     
      cStmt.setLong(1,tag.getId());
      cStmt.setLong(2,offset);
      cStmt.setInt(3,count);
      cStmt.registerOutParameter(4, Types.INTEGER);
      ResultSet rs = cStmt.executeQuery();
      int size = cStmt.getInt(4);
      if(size < 0){
        size = 0;
      }
      while(rs.next()){
View Full Code Here
359
360
361
362
363
364
365
366
367
368
369
      stmt = conn.prepareCall("call pageCommunityBookmarkSearch(?,?,?,?)");
      stmt.setString(1,searchQuery);
      stmt.setInt(2,offset);
      stmt.setInt(3,count);
      stmt.registerOutParameter(4,Types.INTEGER);
      ResultSet rs = stmt.executeQuery();
      while(rs.next()){
        Bookmark aBookmark = createBookmarkObject2(rs);
        bmarks.add(aBookmark);
        logger.debug("found: " + aBookmark);
      }
View Full Code Here
396
397
398
399
400
401
402
403
404
405
406
      stmt.setString(1,searchQuery);
      stmt.setInt(2,user.getId());
      stmt.setInt(3,offset);
      stmt.setInt(4,count);
      stmt.registerOutParameter(5,Types.INTEGER);
      ResultSet rs = stmt.executeQuery();
      while(rs.next()){
        Bookmark aBookmark = createBookmarkObject2(rs);
        bmarks.add(aBookmark);
        logger.debug("found: " + aBookmark);
      }
View Full Code Here
433
434
435
436
437
438
439
440
441
442
443
      stmt.setInt(2,offset);
      stmt.setInt(3,count);
      stmt.registerOutParameter(4, Types.INTEGER);   
      stmt.setInt(5,sortBy);
      stmt.setInt(6,order);
      ResultSet rs = stmt.executeQuery();
      int size = stmt.getInt(4);     
      if(size < 0){
        size = 0;
      }
      while(rs.next()){
View Full Code Here
473
474
475
476
477
478
479
480
481
482
483
      stmt.setLong(3,offset);
      stmt.setInt(4,count);
      stmt.registerOutParameter(5, Types.INTEGER);     
      stmt.setInt(6,sortBy);
      stmt.setInt(7,order);
      ResultSet rs = stmt.executeQuery();
      int size = stmt.getInt(5);
      if(size < 0){
        size = 0;
      }
      while(rs.next()){
View Full Code Here
507
508
509
510
511
512
513
514
515
516
517
      conn = dataSource.getConnection();
      stmt = conn.prepareCall("call getPopularBookmarks(?,?,?)");
      stmt.setTimestamp(1,new Timestamp(start.getTime()));
      stmt.setTimestamp(2,new Timestamp(end.getTime()));
      stmt.setInt(3,maxCount);
      ResultSet rs = stmt.executeQuery();
      while(rs.next()){
        Bookmark b = createBookmarkObject2(rs);
        logger.debug("found bmark="+b);
        bmarks.add(b);
      }
View Full Code Here
262
263
264
265
266
267
268
269
270
271
272
      stmt = conn.prepareCall("call pageArcBookmarkHasGeomMarker(?,?,?,?)");
      stmt.setInt(1,user.getId());
      stmt.setInt(2,offset);
      stmt.setInt(3,count);
      stmt.registerOutParameter(4,Types.INTEGER);
      ResultSet rs = stmt.executeQuery();
      int size = stmt.getInt(4);
      if(size < 0){
        size = 0;
      }
      while(rs.next()){
View Full Code Here
298
299
300
301
302
303
304
305
306
307
308
      stmt = conn.prepareCall("call pageFlrBookmarkHasGeomMarker(?,?,?,?)");
      stmt.setInt(1,folder.getId());
      stmt.setInt(2,offset);
      stmt.setInt(3,count);
      stmt.registerOutParameter(4,Types.INTEGER);
      ResultSet rs = stmt.executeQuery();
      int size = stmt.getInt(4);
      if(size < 0){
        size = 0;
      }
      while(rs.next()){
View Full Code Here
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
      stmt = conn.prepareCall("call expandTag(?,?,?)");
      for(Tag t : toTags){
        stmt.setInt(1,fromTag.getId());
        stmt.setInt(2,t.getId());
        stmt.setInt(3,user.getId());
        rs = stmt.executeQuery();
      }     
      while(rs.next()){
        Bookmark bm = BookmarkDBDao.createBookmarkObject2(rs);
        changedBookmarks.add(bm);
      }
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.