Package java.sql

Examples of java.sql.CallableStatement.addBatch()

108
109
110
111
112
113
114
115
116
117
118
        stat = conn.createStatement();
        stat.execute("CREATE ALIAS updatePrices FOR \"" + getClass().getName() + ".updatePrices\"");
        CallableStatement call = conn.prepareCall("{call updatePrices(?, ?)}");
        call.setString(1, "Hello");
        call.setFloat(2, 1.4f);
        call.addBatch();
        call.setString(1, "World");
        call.setFloat(2, 3.2f);
        call.addBatch();
        int[] updateCounts = call.executeBatch();
        int total = 0;
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
        call.setString(1, "Hello");
        call.setFloat(2, 1.4f);
        call.addBatch();
        call.setString(1, "World");
        call.setFloat(2, 3.2f);
        call.addBatch();
        int[] updateCounts = call.executeBatch();
        int total = 0;
        for (int t : updateCounts) {
            total += t;
        }
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
      conn = dataSource.getConnection();
      cStmt = conn.prepareCall("{call addImportFolder(?,?)};");     
      for(Folder folder : folders){
        cStmt.setInt(1,subscription.getId());
        cStmt.setInt(2,folder.getId());       
        cStmt.addBatch();       
      }     
      int result[] = cStmt.executeBatch();
      for(int i = 0; i < result.length; i++){
        if(result[i] >= 0 ){
          numUpdated++;
View Full Code Here
281
282
283
284
285
286
287
288
289
290
291
      cstmt = conn.prepareCall("call removeImportFolder(?,?)");
      int feedId = subscription.getId();   
      for(Folder folder : folders){
        cstmt.setInt(1,feedId);
        cstmt.setInt(2,folder.getId());       
        cstmt.addBatch();
      }
      int result[] = cstmt.executeBatch();
      for(int i = 0; i < result.length; i++){
        if(result[i] > 0){
          numUpdated++;         
View Full Code Here
409
410
411
412
413
414
415
416
417
418
419
      conn = dataSource.getConnection();
      stmt = conn.prepareCall("call deleteForUserById(?,?)");
      for(int id : ids){
        stmt.setInt(1,user.getId());
        stmt.setInt(2,id);
        stmt.addBatch();
      }
      stmt.executeBatch();
      return true;
    } catch (SQLException e) {
      logger.fatal(e);
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
      Timestamp tsmp = new Timestamp(timestamp.getTime());
      for(Bookmark bm : bookmarks){
        cStmt.setInt(1,folder.getId());
        cStmt.setInt(2,bm.getId());
        cStmt.setTimestamp(3,tsmp);
        cStmt.addBatch();       
      }     
      int result[] = cStmt.executeBatch();
      for(int i = 0; i < result.length; i++){
        if(result[i] >= 0 ){
          opOkay[i] = true;
View Full Code Here
294
295
296
297
298
299
300
301
302
303
304
      cstmt = conn.prepareCall("call removeBookmarkFromFolder(?,?)");
      int folderId = folder.getId();   
      for(Bookmark bm : bookmarks){
        cstmt.setInt(1,folderId);
        cstmt.setInt(2,bm.getId());       
        cstmt.addBatch();
      }
      int result[] = cstmt.executeBatch();
      for(int i = 0; i < result.length; i++){
        if(result[i] >= 0){
          opOkay[i] = true;
View Full Code Here
940
941
942
943
944
945
946
947
948
949
950
      for(Tag tag : tags){
        stmt.setInt(1,tag.getId());
        stmt.setInt(2,user.getId());
        stmt.setInt(3,link.getId());
        stmt.setInt(4,bookmark.getId());
        stmt.addBatch();
      }
      int result[] = stmt.executeBatch();
      for(int i = 0; i < result.length; i++){
        if(result[i] >= 0){
          opOkay[i] = true;
View Full Code Here
976
977
978
979
980
981
982
983
984
985
986
      for(Tag tag: tags){
        stmt.setInt(1,tag.getId());
        stmt.setInt(2,user.getId());
        stmt.setInt(3,link.getId());
        stmt.setInt(4,bookmark.getId());
        stmt.addBatch();
      }   
      int result[] = stmt.executeBatch();
      for(int i = 0; i < result.length; i++){
        if(result[i] >= 0){
          opOkay[i] = true;
View Full Code Here
432
433
434
435
436
437
438
439
440
441
442
      int subjectTagId = subjectTag.getId();
      for(int i = 0; i < objectTag.length; i++){
        cstmt.setInt(1,userId);
        cstmt.setInt(2,subjectTagId);
        cstmt.setInt(3,objectTag[i].getId());
        cstmt.addBatch();
      }
      int result[] = cstmt.executeBatch();
      for(int i = 0; i < result.length; i++){
        if(result[i] < 0){
          isOkay = false;
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.