Package com.eforce.baby.common.dao

Examples of com.eforce.baby.common.dao.QueryManager


    Connection con = this.createConnection( dsName );
    PreparedStatement pStmt=null;
    try
    {
      con.setAutoCommit(false);
      QueryManager qManager = QueryManager.getInstance();

      /* Check if there is any group with same name */
      String sql;
      sql = qManager.getDuplicateGroupUpdateQuery(dbType);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, groupVO.getId() );
      pStmt.setString( 2, groupVO.getGroupName() );
      log.debug("SQL="+sql);
      log.debug("ID="+groupVO.getId()+"  ||  "+groupVO.getGroupName());
      ResultSet rset = null;
      rset = pStmt.executeQuery();
      if( rset.next() ){
        if(rset.getInt(1)>0){
          DAOException daox = new DAOException ("Database Error");
          daox.setMessageKey(IErrorMessageKeys.KEY_ERROR_DUPLICATE_GROUP);
          throw daox;
        }
      }

      sql = qManager.getUpdateGroupQuery(dbType);
      log.debug(sql);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, groupVO.getGroupName() );
      pStmt.setString( 2, groupVO.getGroupDesc() );
      pStmt.setString( 3, groupVO.getId());

      pStmt.executeUpdate();

      //first delete old users
      sql = qManager.getDeleteGroupUserQuery(dbType);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, groupVO.getId());
      pStmt.executeUpdate();

      this.createSearchContent(con,dbType, groupVO, "TBL_GROUP", "GROUP_ID");

      String[] userIds = EEMSUtil.convertToArray(groupVO.getUserNames(),IConstants.EEMS_DELIMITER);
      if(userIds!=null)
      {
        sql = qManager.getFindCreateUserGroupQuery(dbType);
        pStmt = con.prepareStatement( sql );
        log.debug(sql);
   
        for (int i=0; i<userIds.length;i++)
        {
View Full Code Here


    GroupVO groupVO = new GroupVO();
    Connection con = this.createConnection( dsName );
    PreparedStatement pStmt=null;
    ResultSet rset = null;
   
    QueryManager qManager = QueryManager.getInstance();
    String sql = qManager.getGroupViewQuery(dbType);
    log.debug("SQL:"+sql);
    String userLoginId = null;
    String userId = null;
    try{
      pStmt = con.prepareStatement(sql);
      pStmt.setString(1, groupId);
      rset = pStmt.executeQuery();
      while(rset.next())
            {
        if(userLoginId==null)
          userLoginId += rset.getString(1);
        else
          userLoginId += (IConstants.EEMS_DELIMITER + rset.getString(1));
        if(userId==null)
          userId += rset.getString(4);
        else
          userId += (IConstants.EEMS_DELIMITER + rset.getString(4));
        groupVO.setGroupName(rset.getString(2));
        groupVO.setGroupDesc(rset.getString(3));
        groupVO.setId(groupId);
      }
      //Storing Role information separately
      sql = qManager.getGroupRoleQuery(dbType);
      pStmt = con.prepareStatement(sql);
      pStmt.setString(1,groupId);
      rset = pStmt.executeQuery();
      String roleName="NA";
      while(rset.next()){
View Full Code Here

    PreparedStatement pStmt=null;
    try
    {
      con.setAutoCommit(false);
 
      QueryManager qManager = QueryManager.getInstance();
     
      /* Checking for duplicate group */
      String sql;
      sql = qManager.getDuplicateGroupQuery(dbType);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, groupVO.getGroupName() );
      ResultSet rset = null;
      rset = pStmt.executeQuery();
      if( rset.next() ){
        if(rset.getInt(1)>0){
          DAOException daox = new DAOException ("Database Error");
          daox.setMessageKey(IErrorMessageKeys.KEY_ERROR_DUPLICATE_GROUP);
          throw daox;
        }
      }
     
     
      sql = qManager.getFetchNewGroupIdQuery(dbType);
      log.debug(sql);
      groupVO.setId(this.getCurrentSequenceValue(con,sql));
      //sql = qManager.getFetchNewGroupQuery(dbType);
      sql = qManager.getFindCreateGroupQuery(dbType);
      log.debug(sql);
      pStmt = con.prepareStatement( sql );
 
      pStmt.setString( 1, groupVO.getId() );
      pStmt.setString( 2, groupVO.getGroupName() );
      pStmt.setString( 3, groupVO.getGroupDesc());
      pStmt.executeUpdate();
     
      this.createSearchContent(con,dbType, groupVO, "TBL_GROUP", "GROUP_ID");
     
      String[] userIds = EEMSUtil.convertToArray(groupVO.getUserNames(),IConstants.EEMS_DELIMITER);
      if(userIds!=null)
      {
        sql = qManager.getFindCreateUserGroupQuery(dbType);
        pStmt = con.prepareStatement( sql );
        log.debug(sql);
       
        for (int i=0; i<userIds.length;i++)
        {
View Full Code Here

    Connection con = this.createConnection( dsName );
    PreparedStatement pStmt=null;
    try
    {
      con.setAutoCommit(false);
      QueryManager qManager = QueryManager.getInstance();
      /* Delete from tbl_User_Group table */
      String sql = qManager.getDeleteGroupUserQuery(dbType);
      log.debug(sql);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, id );
      pStmt.executeUpdate();
      pStmt.close();

      /* Select role_id from tbl_group_role table */
      sql = qManager.getFindRoleIDQuery(dbType);
      log.debug(sql);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, id );
      ResultSet rset = pStmt.executeQuery();
      String roleID = "";
      if(rset.next())
        roleID= rset.getString(1);
      pStmt.close();
     
      if(!roleID.equals("")){
      /* Delete from tbl_Group_role table */
        sql = qManager.getDeleteGroupRoleQuery(dbType);
        log.debug(sql);
        pStmt = con.prepareStatement( sql );
        pStmt.setString( 1, id );
        int numRwoDel = 0;
        numRwoDel = pStmt.executeUpdate();
        pStmt.close();

        if(numRwoDel == 1){
          /* Delete from tbl_role table */
          sql = qManager.getDelRoleQuery(dbType);
          log.debug(sql);
          pStmt = con.prepareStatement( sql );
          pStmt.setString( 1, id );
          pStmt.executeUpdate();
          pStmt.close();
        }
      }

      /* Delete from tbl_Group table */
      sql = qManager.getDeleteGroupQuery(dbType);
      log.debug(sql);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, id );
      pStmt.executeUpdate();
      pStmt.close();
View Full Code Here

    PreparedStatement pStmt=null;
    try
    {
      con.setAutoCommit(false);
 
      QueryManager qManager = QueryManager.getInstance();

      /* Check if there is any Dist group with same name */
      String sql;
      sql = qManager.getDuplicateDistGroupQuery(dbType);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, distGroupVO.getDistGroupName() );
      ResultSet rset = null;
      rset = pStmt.executeQuery();
      if( rset.next() ){
        if(rset.getInt(1)>0){
          DAOException daox = new DAOException ("Database Error");
          daox.setMessageKey(IErrorMessageKeys.KEY_ERROR_DUPLICATE_DIST_GROUP);
          throw daox;
        }
      }

      sql = qManager.getFetchNewDistGroupIdQuery(dbType);
      log.debug(sql);
      distGroupVO.setId(this.getCurrentSequenceValue(con,sql));
      sql = qManager.getFetchNewDistGroupQuery(dbType);
      log.debug(sql);
      pStmt = con.prepareStatement( sql );

      pStmt.setString( 1, distGroupVO.getId() );
      pStmt.setString( 2, distGroupVO.getDistGroupName() );
      pStmt.setString( 3, distGroupVO.getDistGroupDesc());
      pStmt.setString( 4, distGroupVO.getIsEnabled());
      pStmt.executeUpdate();
     
      this.createSearchContent(con,dbType,distGroupVO,"TBL_DISTRIBUTION_GROUP","GROUP_ID");
     
      String[] userIds = EEMSUtil.convertToArray(distGroupVO.getUserNames(),IConstants.EEMS_DELIMITER);
      if(userIds!=null)
      {
        sql = qManager.getFetchDistGroupUserQuery(dbType);
        pStmt = con.prepareStatement( sql );
        log.debug(sql);
       
        for (int i=0; i<userIds.length;i++)
        {
View Full Code Here

    Connection con = this.createConnection( dsName );
    PreparedStatement pStmt=null;
    try
    {
      con.setAutoCommit(false);
      QueryManager qManager = QueryManager.getInstance();

      /* Check if there is any Dist group with same name */
      String sql;
      sql = qManager.getDuplicateDistGroupUpdateQuery(dbType);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, distGroupVO.getId() );
      pStmt.setString( 2, distGroupVO.getDistGroupName() );
      ResultSet rset = null;
      rset = pStmt.executeQuery();
      if( rset.next() ){
        if(rset.getInt(1)>0){
          DAOException daox = new DAOException ("Database Error");
          daox.setMessageKey(IErrorMessageKeys.KEY_ERROR_DUPLICATE_DIST_GROUP);
          throw daox;
        }
      }

      sql = qManager.getUpdateDistGroupQuery(dbType);
      log.debug(sql);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, distGroupVO.getDistGroupName() );
      pStmt.setString( 2, distGroupVO.getDistGroupDesc() );
      pStmt.setString( 3, distGroupVO.getIsEnabled());
      pStmt.setString( 4, distGroupVO.getId());
     
      pStmt.executeUpdate();
        this.createSearchContent(con,dbType,distGroupVO,"TBL_DISTRIBUTION_GROUP","GROUP_ID");
      //first delete old users
      sql = qManager.getDeleteDistGroupUserQuery(dbType);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, distGroupVO.getId());
      pStmt.executeUpdate();
     
      String[] userIds = EEMSUtil.convertToArray(distGroupVO.getUserNames(),IConstants.EEMS_DELIMITER);
      if(userIds!=null)
      {
        sql = qManager.getFetchDistGroupUserQuery(dbType);
        pStmt = con.prepareStatement( sql );
        log.debug(sql);
 
        for (int i=0; i<userIds.length;i++)
        {
View Full Code Here

    Connection con = this.createConnection( dsName );
    PreparedStatement pStmt=null;
    try
    {
      con.setAutoCommit(false);
      QueryManager qManager = QueryManager.getInstance();
      /* Delete from TBL_DISTRIBUTION_GROUP */
      String sql = qManager.getDeleteDistGroupQuery(dbType);
      pStmt = con.prepareStatement( sql );
      pStmt.setString( 1, id );
      pStmt.executeUpdate();
     
      log.debug("Distribution Group Deleted ");
View Full Code Here

    PreparedStatement pStmt=null;
    try
    {
      con.setAutoCommit(false);
     
      QueryManager qManager = QueryManager.getInstance();
      String sql = qManager.getFetchNewUserIdQuery(dbType);
      log.debug(sql);
      userVO.setId(this.getCurrentSequenceValue(con,sql));
      if(!userExists(con,dbType,userVO))
      {
        sql = qManager.getFetchNewUserQuery(dbType);
        log.debug(sql);
        pStmt = con.prepareStatement( sql );
 
        pStmt.setString( 1, userVO.getId() );
        pStmt.setString( 2, userVO.getUserName() );
               
                log.debug("Before Encryption: " + userVO.getPassword());
                String password = EEMSCryptography.getInstance().encrypt(userVO.getPassword().trim());
                log.debug("After Encryption: " + password);
               
        pStmt.setString( 3, password);
               
        pStmt.executeUpdate();
       
        this.createSearchContent(con,dbType,userVO,"TBL_USER","USER_ID");
       
        /* Group list information */
        String[] groupIds = EEMSUtil.convertToArray(userVO.getGroupNameList(),IConstants.EEMS_DELIMITER);
        if(groupIds!=null)
        {
          sql = qManager.getFindCreateUserGroupQuery(dbType);
          pStmt = con.prepareStatement( sql );
          log.debug(sql);
 
          for (int i=0; i<groupIds.length;i++)
          {
View Full Code Here

    Connection con = this.createConnection( dsName );
    PreparedStatement pStmt=null;
    try
    {
      con.setAutoCommit(false);
      QueryManager qManager = QueryManager.getInstance();
      String sql = qManager.getUpdateUserQuery(dbType);
      log.debug(sql);
      if(!userExists(con,dbType,userVO))
      {
        pStmt = con.prepareStatement( sql );
        pStmt.setString( 3, userVO.getId() );
        pStmt.setString( 1, userVO.getUserName() );
       
                log.debug("Before Encryption: " + userVO.getPassword());
                String password = EEMSCryptography.getInstance().encrypt(userVO.getPassword());
                log.debug("After Encryption: " + password);
               
                pStmt.setString( 2, password);
               
        pStmt.executeUpdate();
        this.createSearchContent(con,dbType,userVO,"TBL_USER","USER_ID");
       
        /* Group list information */
        String[] groupIds = EEMSUtil.convertToArray(userVO.getGroupNameList(),IConstants.EEMS_DELIMITER);
        if(groupIds!=null)
        {
          /* delete the entries from tbl_user_group */
          sql = qManager.getUserSelectedGroupDeleteQuery(dbType);
          pStmt = con.prepareStatement( sql );
          log.debug(sql);
          pStmt.setString( 1, userVO.getId() );
          pStmt.executeUpdate();
         
          /* insert selected group */
          sql = qManager.getFindCreateUserGroupQuery(dbType);
          pStmt = con.prepareStatement( sql );
          log.debug(sql);
 
          for (int i=0; i<groupIds.length;i++)
          {
View Full Code Here

     
      PreparedStatement pStmt= null;
      ResultSet rset         = null;
      try
      {
        QueryManager qManager = QueryManager.getInstance();
        String sql = qManager.getExisitingUserQuery(dbType);
        log.debug(sql);
        pStmt = con.prepareStatement( sql );
        pStmt.setString( 1, userVO.getUserName() );
        pStmt.setString( 2, userVO.getId());
        rset = pStmt.executeQuery();
View Full Code Here

TOP

Related Classes of com.eforce.baby.common.dao.QueryManager

Copyright © 2018 www.massapicom. 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.