Package java.sql

Examples of java.sql.CallableStatement.executeQuery()

380
381
382
383
384
385
386
387
388
389
390
    try{           
      conn = dataSource.getConnection();
      cStmt = conn.prepareCall("call findAutoImportSubscription(?);");     
      cStmt.setInt(1,ageHour);
      cStmt.execute();
      ResultSet rs = cStmt.executeQuery();
      while(rs.next()){
        FeedSubscription feed = createFeedSubscriptionObject(rs);       
        feeds.add(feed);
      }   
      logger.debug("DaoResult: feeds="+feeds);
View Full Code Here
439
440
441
442
443
444
445
446
447
448
449
      cStmt.setInt(1,user.getId());
      cStmt.setInt(2,sender.getId());
      cStmt.setInt(3,offset);
      cStmt.setInt(4,count);     
      cStmt.registerOutParameter(5,Types.INTEGER);     
      ResultSet rs = cStmt.executeQuery();
      int size = cStmt.getInt(5);
      if(size < 0){
        size = 0;
      } 
      while(rs.next()){
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
      cStmt = conn.prepareCall("call pageFoldersByOwnerId(?,?,?,?);");
      cStmt.setInt(1,owner.getId());
      cStmt.setInt(2,offset);
      cStmt.setInt(3,count);
      cStmt.registerOutParameter(4,Types.INTEGER);
      ResultSet rs = cStmt.executeQuery();
      while(rs.next()){
        Folder folder = createFolderObject(rs);       
        folders.add(folder);
      }
      int size = cStmt.getInt(4);
View Full Code Here
266
267
268
269
270
271
272
273
274
275
276
    int upCnt = 0;
    try {
      conn = dataSource.getConnection();
      cstmt = conn.prepareCall("call removeAllBookmarksFromFolder(?)");
      cstmt.setInt(1,folder.getId());
      ResultSet rs = cstmt.executeQuery();
      if(rs.next()){
        upCnt = rs.getInt(1);
      }
    }catch(SQLException e){
      logger.fatal(e);     
View Full Code Here
365
366
367
368
369
370
371
372
373
374
375
      cStmt = conn.prepareCall("call pageContainedInFolders(?,?,?,?);");
      cStmt.setInt(1,bookmark.getId());
      cStmt.setInt(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
407
408
409
410
411
412
413
414
415
416
417
      cStmt.setInt(2,offset);
      cStmt.setInt(3,count);
      cStmt.registerOutParameter(4,Types.INTEGER);     
      cStmt.setInt(5,sortBy);
      cStmt.setInt(6,order);
      ResultSet rs = cStmt.executeQuery();
      int size = cStmt.getInt(4);
      if(size < 0){
        size = 0;
      } 
      while(rs.next()){
View Full Code Here
445
446
447
448
449
450
451
452
453
454
455
      cStmt.setInt(3,offset);
      cStmt.setInt(4,count);
      cStmt.registerOutParameter(5,Types.INTEGER);     
      cStmt.setInt(6,sortBy);
      cStmt.setInt(7,order);
      ResultSet rs = cStmt.executeQuery();
      int size = cStmt.getInt(5);
      if(size < 0){
        size = 0;
      } 
      while(rs.next()){
View Full Code Here
478
479
480
481
482
483
484
485
486
487
488
    try {
      conn = dataSource.getConnection();
      cStmt = conn.prepareCall("{call hasFolderTag(?,?)}");
      cStmt.setInt(1,folder.getId());
      cStmt.setInt(2,tag.getId());
      ResultSet rs = cStmt.executeQuery();     
      if(rs.next()){
        exists = true;
      }
    } catch (Exception e) {
      logger.fatal(e);     
View Full Code Here
506
507
508
509
510
511
512
513
514
515
516
      cStmt = conn.prepareCall("call findAllTagsInFolder(?,?,?,?);");
      cStmt.setInt(1,folder.getId());
      cStmt.setInt(2,minFreq);
      cStmt.setInt(3,sortBy);
      cStmt.setInt(4,order);     
      ResultSet rs = cStmt.executeQuery();
      while(rs.next()){
        FolderTag ft = new FolderTag();
        Tag t = TagDBDao.createTagObject(rs);
        ft.setTag(t);
        ft.setCount(rs.getInt(FolderTagSchema.COUNT));
View Full Code Here
551
552
553
554
555
556
557
558
559
560
561
      cStmt = conn.prepareCall("call findTagGroupsInFolder(?,?,?,?);");
      cStmt.setInt(1,folder.getId());
      cStmt.setInt(2,minFreq);
      cStmt.setInt(3,sortBy);
      cStmt.setInt(4,order);     
      ResultSet rs = cStmt.executeQuery();
      while(rs.next()){
        FolderTag ft = new FolderTag();
        Tag memTag = TagDBDao.createNamedTagObject(MEMBER_TAG_COL, rs, true);
        Tag grpTag = TagDBDao.createNamedTagObject(GROUP_TAG_COL, rs, true);
        ft.setTag(memTag);
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.