[Idrs-commit] CVS: Idrs/dev/src/net/sourceforge/idrs/utils DB.java,1.10,1.11

[Marc B. <big...@us...>]

Update of /cvsroot/idrs/Idrs/dev/src/net/sourceforge/idrs/utils
In directory usw-pr-cvs1:/tmp/cvs-serv25478/dev/src/net/sourceforge/idrs/utils

Modified Files:
	DB.java 
Log Message:
completed data paging

Index: DB.java
===================================================================
RCS file: /cvsroot/idrs/Idrs/dev/src/net/sourceforge/idrs/utils/DB.java,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** DB.java	16 Sep 2002 15:19:42 -0000	1.10
--- DB.java	21 Sep 2002 16:13:03 -0000	1.11
***************
*** 155,158 ****
--- 155,159 ----
       */
      public int getCurrLocation() throws Exception {
+     	System.out.println("Here : " + cursurLocation);
          return this.cursurLocation;
      }
***************
*** 373,377 ****
       */
      public void procMethod(ObjectStore obj,String method,String[] vals,IDRSScript idrs) throws Exception {
!         System.out.println("In procmethod");
          Object[] finalVals = new Object[vals.length];
          Class[] clss = obj.getMethodTypes(method);
--- 374,378 ----
       */
      public void procMethod(ObjectStore obj,String method,String[] vals,IDRSScript idrs) throws Exception {
! //        System.out.println("In procmethod");
          Object[] finalVals = new Object[vals.length];
          Class[] clss = obj.getMethodTypes(method);
***************
*** 393,397 ****
          }
          if (direction == DB.OUTPUT) {
!             System.out.println("executing method");
              rs = (ResultSet) obj.execMethod(method,finalVals);
              
--- 394,398 ----
          }
          if (direction == DB.OUTPUT) {
! //            System.out.println("executing method");
              rs = (ResultSet) obj.execMethod(method,finalVals);
              
***************
*** 409,416 ****
      public void ProcSQL(String SQL, boolean isProc, String[] vars) throws Exception {
          int i;
! 	System.out.println("SQL : " + SQL);
! 	System.out.println("isProc : " + isProc);
! 	System.out.println("Vars : " + vars);
! 	System.out.println("Direction : " + (this.direction == DB.OUTPUT));
          if (isProc) {
              SQL = "{call " + SQL + "}";
--- 410,417 ----
      public void ProcSQL(String SQL, boolean isProc, String[] vars) throws Exception {
          int i;
! //	System.out.println("SQL : " + SQL);
! 	//System.out.println("isProc : " + isProc);
! 	//System.out.println("Vars : " + vars);
! 	//System.out.println("Direction : " + (this.direction == DB.OUTPUT));
          if (isProc) {
              SQL = "{call " + SQL + "}";
***************
*** 499,505 ****
      private void readTable() throws Exception {
          
Object key;
!         System.out.println("in read table");
          if (this.cursur == DB.CLIENT) {
!             System.out.println("In Client cursor read table");
              rows = new LinkedList();
              Iterator it;
--- 500,506 ----
      private void readTable() throws Exception {
          
Object key;
!         //System.out.println("in read table");
          if (this.cursur == DB.CLIENT) {
!             //System.out.println("In Client cursor read table");
              rows = new LinkedList();
              Iterator it;
***************
*** 510,514 ****
  				while (it.hasNext()) {
  					key = it.next();
! 					System.out.println(key + "=" + fields.get(key));
  				}
                  rows.add(this.fields);
--- 511,515 ----
  				while (it.hasNext()) {
  					key = it.next();
! 					//System.out.println(key + "=" + fields.get(key));
  				}
                  rows.add(this.fields);
***************
*** 724,731 ****
       */
      public boolean next() throws Exception {
!         System.out.println("Cursor client : ");
          if (this.cursur == DB.CLIENT) {
!             System.out.println("Cursor client : ");
!             System.out.println("Location : " + cursurLocation);
              if ((rows.size() > cursurLocation) && (cursurLocation < beginWith + numRecs)) {
                  this.fields = (HashMap) rows.get(this.cursurLocation);
--- 725,732 ----
       */
      public boolean next() throws Exception {
!         //System.out.println("Cursor client : ");
          if (this.cursur == DB.CLIENT) {
!           //  System.out.println("Cursor client : ");
!           System.out.println("Location : " + cursurLocation);
              if ((rows.size() > cursurLocation) && (cursurLocation < beginWith + numRecs)) {
                  this.fields = (HashMap) rows.get(this.cursurLocation);
***************
*** 743,747 ****
                  
                  if (rs.next()) {
!                     System.out.println("We have another one");
                      hasNext = true;
                      readFields();
--- 744,748 ----
                  
                  if (rs.next()) {
!           //          System.out.println("We have another one");
                      hasNext = true;
                      readFields();
***************
*** 749,753 ****
                  }
                  else {
!                     System.out.println("No more");
                      hasNext = false;
                      return false;
--- 750,754 ----
                  }
                  else {
!             //        System.out.println("No more");
                      hasNext = false;
                      return false;
***************
*** 806,812 ****
              	}
              	this.wasCached = (caches.get(this.name) != null);
!             	System.out.println("Cached : " + this.wasCached);
!             	System.out.println("Cache : " + caches.get(this.name));
          }
  		
  		if (this.transactionType == TRANS_BEGIN || this.transactionType == TRANS_COMPLETE) {
--- 807,816 ----
              	}
              	this.wasCached = (caches.get(this.name) != null);
!             	//System.out.println("Cached : " + this.wasCached);
!             	//System.out.println("Cache : " + caches.get(this.name));
          }
+         
+         
+         
  		
  		if (this.transactionType == TRANS_BEGIN || this.transactionType == TRANS_COMPLETE) {