Package com.zosatapo.commons.store

Examples of com.zosatapo.commons.store.jResultSet.release()

694
695
696
697
698
699
700
701
702
703
704
            parentGroup);
        workflowGroup.setDepartment((WorkflowDepartment)departments.get(jrs.getString("vc_departmentid")));
        genGroupTree(workflowGroup);
      }

      jrs.release();
    }
    else
    {
      Connection conn = null;
      PreparedStatement pstmt = null;
View Full Code Here
439
440
441
442
443
444
445
446
447
448
449
          new WorkflowRankImpl(
            jrs.getString("vc_uuid"),
            jrs.getString("vc_name"),
            jrs.getString("vc_description")));
      }
      jrs.release();

      //---------------------------------------------create category
      strSQL =
        "SELECT  vc_uuid,vc_name,vc_description "
          + " FROM "
View Full Code Here
460
461
462
463
464
465
466
467
468
469
470
          new WorkflowCategoryImpl(
            jrs.getString("vc_uuid"),
            jrs.getString("vc_name"),
            jrs.getString("vc_description")));
      }
      jrs.release();

      //---------------------------------------------create role
      strSQL =
        "SELECT  vc_uuid,vc_name,vc_description "
          + " FROM "
View Full Code Here
479
480
481
482
483
484
485
486
487
488
489
        createRole(
            jrs.getString("vc_uuid"),
            jrs.getString("vc_name"),
            jrs.getString("vc_description"));
      }
      jrs.release();
     
      //---------------------------------------------create users
      strSQL =
        "SELECT vc_uuid,vc_name,vc_password,vc_fullname,vc_description,vc_rankid "
          + " "
View Full Code Here
506
507
508
509
510
511
512
513
514
515
516
            jrs.getString("vc_description"));

        participant.setRank((WorkflowRank) ranks.get(jrs.getString("vc_rankid")));
      }

      jrs.release();

      //---------------------------------------------set user administrator
      strSQL =
        "SELECT vc_userid,vc_packageId "
          + " "
View Full Code Here
532
533
534
535
536
537
538
539
540
541
542
        {
          participantImpl.addPackage(jrs.getString("vc_packageId"));
        }
      }

      jrs.release();
     
      //---------------------------------------------create departments
      genDepartmentTree(null);     

      //---------------------------------------------create groups
View Full Code Here
556
557
558
559
560
561
562
563
564
565
566
        String userid = jrs.getString("vc_userid");
        WorkflowGroup workflowGroup = findGroup(groupid);
        WorkflowParticipant workflowUser = findParticipant(userid);
        workflowGroup.addPaticipant(workflowUser);
      }
      jrs.release();

      //---------------------------------------------create user department relation
      strSQL =
        "SELECT vc_userid,vc_departmenetid FROM "
          + getSchemaContext().getTableName(SchemaContext.SCHEMA_USER_DEPARTMENT);
View Full Code Here
574
575
576
577
578
579
580
581
582
583
584
        String userid = jrs.getString("vc_userid");
        WorkflowDepartment workflowDept = findDepartment(deptid);
        WorkflowParticipant workflowUser = findParticipant(userid);
        workflowDept.addPaticipant(workflowUser);
      }
      jrs.release();

      //---------------------------------------------create user role relation
      strSQL =
        "SELECT vc_userid,vc_roleid FROM "
          + getSchemaContext().getTableName(SchemaContext.SCHEMA_USER_ROLE);
View Full Code Here
592
593
594
595
596
597
598
599
600
601
602
        String userid = jrs.getString("vc_userid");
        WorkflowRole workflowRole = findRole(roleid);
        WorkflowParticipant workflowUser = findParticipant(userid);
        workflowRole.addPaticipant(workflowUser);
      }
      jrs.release();
     
    }
    catch (SQLException sqlex)
    {
      throw new WorkflowException(sqlex);
View Full Code Here
629
630
631
632
633
634
635
636
637
638
639
            parentDept);
        workflowDepartment.setCategory((WorkflowCategory)categories.get(jrs.getString("vc_categoryid")));
        genDepartmentTree(workflowDepartment);
      }

      jrs.release();
    }
    else
    {
      Connection conn = null;
      PreparedStatement pstmt = null;
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.