You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@commons.apache.org by "caixiaojian (JIRA)" <ji...@apache.org> on 2010/10/23 05:27:20 UTC

[jira] Created: (DBUTILS-75) efficient usage from findbugs

efficient usage from findbugs
-----------------------------

                 Key: DBUTILS-75
                 URL: https://issues.apache.org/jira/browse/DBUTILS-75
             Project: Commons DbUtils
          Issue Type: Improvement
    Affects Versions: 1.3
         Environment: Inefficient use of keySet iterator instead of entrySet iterator
Method invokes inefficient floating-point Number constructor; use static valueOf instead
            Reporter: caixiaojian
             Fix For: 1.3


Index: src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java
===================================================================
--- src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java	(revision 1025562)
+++ src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java	(working copy)
@@ -487,7 +487,7 @@
         }
         if (getUrlInt != null && getUrlString != null) {
             assertEquals(null, getUrlInt.invoke(rs, 
-                         new Object[] { new Integer(1) } ) );
+                         new Object[] { Integer.valueOf(1) } ) );
             assertTrue(rs.wasNull());
             assertEquals(null, getUrlString.invoke(rs, 
                          new Object[] { "column" } ) );
@@ -496,7 +496,7 @@
             URL u = new URL("http://www.apache.org");
             rs2.setNullURL(u);
             assertEquals(u, getUrlInt.invoke(rs, 
-                         new Object[] { new Integer(1) } ) );
+                         new Object[] { Integer.valueOf(1) } ) );
             assertEquals(u, getUrlString.invoke(rs, 
                          new Object[] { "column" } ) );
         }
@@ -830,19 +830,19 @@
             return Boolean.FALSE;
 
         } else if (returnType.equals(Integer.TYPE)) {
-            return new Integer(0);
+            return Integer.valueOf(0);
 
         } else if (returnType.equals(Short.TYPE)) {
-            return new Short((short) 0);
+            return Short.valueOf((short) 0);
 
         } else if (returnType.equals(Double.TYPE)) {
             return new Double(0);
 
         } else if (returnType.equals(Long.TYPE)) {
-            return new Long(0);
+            return Long.valueOf(0);
 
         } else if (returnType.equals(Byte.TYPE)) {
-            return new Byte((byte) 0);
+            return Byte.valueOf((byte) 0);
 
         } else if (returnType.equals(Float.TYPE)) {
             return new Float(0);
Index: src/test/org/apache/commons/dbutils/BaseTestCase.java
===================================================================
--- src/test/org/apache/commons/dbutils/BaseTestCase.java	(revision 1025562)
+++ src/test/org/apache/commons/dbutils/BaseTestCase.java	(working copy)
@@ -56,8 +56,8 @@
             "2",
             "3",
             "  notInBean  ",
-            new Integer(1),
-            new Integer(2),
+            Integer.valueOf(1),
+            Integer.valueOf(2),
             null,
             null,
             new Date(),
@@ -69,8 +69,8 @@
             "5",
             "6",
             "  notInBean  ",
-            new Integer(3),
-            new Integer(4),
+            Integer.valueOf(3),
+            Integer.valueOf(4),
             null,
             null,
             new Date(),
Index: src/test/org/apache/commons/dbutils/MockResultSet.java
===================================================================
--- src/test/org/apache/commons/dbutils/MockResultSet.java	(revision 1025562)
+++ src/test/org/apache/commons/dbutils/MockResultSet.java	(working copy)
@@ -137,7 +137,7 @@
 
         try {
             return (obj == null)
-                ? new Byte((byte) 0)
+                ? Byte.valueOf((byte) 0)
                 : Byte.valueOf(obj.toString());
 
         } catch (NumberFormatException e) {
@@ -192,7 +192,7 @@
 
         try {
             return (obj == null)
-                ? new Integer(0)
+                ? Integer.valueOf(0)
                 : Integer.valueOf(obj.toString());
 
         } catch (NumberFormatException e) {
@@ -210,7 +210,7 @@
         this.setWasNull(obj);
 
         try {
-            return (obj == null) ? new Long(0) : Long.valueOf(obj.toString());
+            return (obj == null) ? Long.valueOf(0) : Long.valueOf(obj.toString());
 
         } catch (NumberFormatException e) {
             throw new SQLException(e.getMessage());
@@ -243,7 +243,7 @@
 
         try {
             return (obj == null)
-                ? new Short((short) 0)
+                ? Short.valueOf((short) 0)
                 : Short.valueOf(obj.toString());
 
         } catch (NumberFormatException e) {
@@ -311,7 +311,7 @@
             return this.isLast();
         
         } else if (methodName.equals("hashCode")) {
-            return new Integer(System.identityHashCode(proxy));
+            return Integer.valueOf(System.identityHashCode(proxy));
         
         } else if (methodName.equals("toString")) {
             return "MockResultSet " + System.identityHashCode(proxy);
Index: src/test/org/apache/commons/dbutils/QueryRunnerTest.java
===================================================================
--- src/test/org/apache/commons/dbutils/QueryRunnerTest.java	(revision 1025562)
+++ src/test/org/apache/commons/dbutils/QueryRunnerTest.java	(working copy)
@@ -79,12 +79,12 @@
             public Object invoke(Object proxy, Method method, Object[] args)
                     throws Throwable {
                 if (getParameterCount.equals(method)) {
-                    return new Integer(types.length);
+                    return Integer.valueOf(types.length);
                 }
                 if (getParameterType.equals(method)) {
                     if (simulateOracle) throw new SQLException("Oracle fails when you call getParameterType");
                     int arg = ((Integer)args[0]).intValue();
-                    return new Integer(types[arg-1]);
+                    return Integer.valueOf(types[arg-1]);
                 }
                 return null;
             }
Index: src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java
===================================================================
--- src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java	(revision 1025562)
+++ src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java	(working copy)
@@ -77,7 +77,7 @@
         assertEquals("6", row.getThree());
         assertEquals("not set", row.getDoNotSet());
         assertEquals(3, row.getIntTest());
-        assertEquals(new Integer(4), row.getIntegerTest());
+        assertEquals(Integer.valueOf(4), row.getIntegerTest());
         assertEquals(null, row.getNullObjectTest());
         assertEquals(0, row.getNullPrimitiveTest());
         // test date -> string handling
@@ -107,7 +107,7 @@
         assertEquals("6", b.getThree());
         assertEquals("not set", b.getDoNotSet());
         assertEquals(3, b.getIntTest());
-        assertEquals(new Integer(4), b.getIntegerTest());
+        assertEquals(Integer.valueOf(4), b.getIntegerTest());
         assertEquals(null, b.getNullObjectTest());
         assertEquals(0, b.getNullPrimitiveTest());
         // test date -> string handling
Index: src/test/org/apache/commons/dbutils/TestBean.java
===================================================================
--- src/test/org/apache/commons/dbutils/TestBean.java	(revision 1025562)
+++ src/test/org/apache/commons/dbutils/TestBean.java	(working copy)
@@ -29,7 +29,7 @@
 
     private int intTest = 0;
 
-    private Integer integerTest = new Integer(0);
+    private Integer integerTest = Integer.valueOf(0);
 
     private String doNotSet = "not set";
 
Index: src/test/org/apache/commons/dbutils/MockResultSetMetaData.java
===================================================================
--- src/test/org/apache/commons/dbutils/MockResultSetMetaData.java	(revision 1025562)
+++ src/test/org/apache/commons/dbutils/MockResultSetMetaData.java	(working copy)
@@ -64,7 +64,7 @@
         String methodName = method.getName();
 
         if (methodName.equals("getColumnCount")) {
-            return new Integer(this.columnNames.length);
+            return Integer.valueOf(this.columnNames.length);
 
         } else if (
                 methodName.equals("getColumnName")) {
@@ -79,7 +79,7 @@
                 return this.columnLabels[col];
 
         } else if (methodName.equals("hashCode")) {
-            return new Integer(System.identityHashCode(proxy));
+            return Integer.valueOf(System.identityHashCode(proxy));
 
         } else if (methodName.equals("toString")) {
             return "MockResultSetMetaData " + System.identityHashCode(proxy);
Index: src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java
===================================================================
--- src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java	(revision 1025562)
+++ src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java	(working copy)
@@ -17,8 +17,8 @@
 package org.apache.commons.dbutils.handlers;
 
 import java.sql.SQLException;
-import java.util.Iterator;
 import java.util.Map;
+import java.util.Map.Entry;
 
 import org.apache.commons.dbutils.BaseTestCase;
 import org.apache.commons.dbutils.ResultSetHandler;
@@ -33,16 +33,15 @@
         assertNotNull(results);
         assertEquals(ROWS, results.size());
 
-        Iterator<Object> iter = results.keySet().iterator();
         Map<String,Object> row = null;
-        while (iter.hasNext()) {
-            Object key = iter.next();
-            assertNotNull(key);
-            row = results.get(key);
+        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
+        {
+        	Object key = entry.getKey();
+        	assertNotNull(key);
+        	row = entry.getValue();
             assertNotNull(row);
             assertEquals(COLS, row.keySet().size());
         }
-
         row = results.get("1");
         assertEquals("1", row.get("one"));
         assertEquals("2", row.get("TWO"));
@@ -56,16 +55,15 @@
         assertNotNull(results);
         assertEquals(ROWS, results.size());
 
-        Iterator<Object> iter = results.keySet().iterator();
         Map<String,Object> row = null;
-        while (iter.hasNext()) {
-            Object key = iter.next();
-            assertNotNull(key);
-            row = results.get(key);
+        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
+        {
+        	Object key = entry.getKey();
+        	assertNotNull(key);
+        	row = entry.getValue();
             assertNotNull(row);
             assertEquals(COLS, row.keySet().size());
         }
-
         row = results.get("5");
         assertEquals("4", row.get("one"));
         assertEquals("5", row.get("TWO"));
@@ -79,16 +77,15 @@
         assertNotNull(results);
         assertEquals(ROWS, results.size());
 
-        Iterator<Object> iter = results.keySet().iterator();
         Map<String,Object> row = null;
-        while (iter.hasNext()) {
-            Object key = iter.next();
-            assertNotNull(key);
-            row = results.get(key);
-            assertNotNull(row);
-            assertEquals(COLS, row.keySet().size());
+        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
+        {
+        	Object key = entry.getKey();
+        	assertNotNull(key);
+        	row = entry.getValue();
+        	assertNotNull(row);
+        	assertEquals(COLS, row.keySet().size());
         }
-
         row = results.get("6");
         assertEquals("4", row.get("one"));
         assertEquals("5", row.get("TWO"));


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DBUTILS-75) efficient usage from findbugs

Posted by "caixiaojian (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DBUTILS-75?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

caixiaojian updated DBUTILS-75:
-------------------------------

    Attachment: commons-dbutils.patch

commons-dbutils.patch

> efficient usage from findbugs
> -----------------------------
>
>                 Key: DBUTILS-75
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-75
>             Project: Commons DbUtils
>          Issue Type: Improvement
>    Affects Versions: 1.3
>         Environment: Inefficient use of keySet iterator instead of entrySet iterator
> Method invokes inefficient floating-point Number constructor; use static valueOf instead
>            Reporter: caixiaojian
>             Fix For: 1.3
>
>         Attachments: commons-dbutils.patch
>
>
> Index: src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java	(working copy)
> @@ -487,7 +487,7 @@
>          }
>          if (getUrlInt != null && getUrlString != null) {
>              assertEquals(null, getUrlInt.invoke(rs, 
> -                         new Object[] { new Integer(1) } ) );
> +                         new Object[] { Integer.valueOf(1) } ) );
>              assertTrue(rs.wasNull());
>              assertEquals(null, getUrlString.invoke(rs, 
>                           new Object[] { "column" } ) );
> @@ -496,7 +496,7 @@
>              URL u = new URL("http://www.apache.org");
>              rs2.setNullURL(u);
>              assertEquals(u, getUrlInt.invoke(rs, 
> -                         new Object[] { new Integer(1) } ) );
> +                         new Object[] { Integer.valueOf(1) } ) );
>              assertEquals(u, getUrlString.invoke(rs, 
>                           new Object[] { "column" } ) );
>          }
> @@ -830,19 +830,19 @@
>              return Boolean.FALSE;
>  
>          } else if (returnType.equals(Integer.TYPE)) {
> -            return new Integer(0);
> +            return Integer.valueOf(0);
>  
>          } else if (returnType.equals(Short.TYPE)) {
> -            return new Short((short) 0);
> +            return Short.valueOf((short) 0);
>  
>          } else if (returnType.equals(Double.TYPE)) {
>              return new Double(0);
>  
>          } else if (returnType.equals(Long.TYPE)) {
> -            return new Long(0);
> +            return Long.valueOf(0);
>  
>          } else if (returnType.equals(Byte.TYPE)) {
> -            return new Byte((byte) 0);
> +            return Byte.valueOf((byte) 0);
>  
>          } else if (returnType.equals(Float.TYPE)) {
>              return new Float(0);
> Index: src/test/org/apache/commons/dbutils/BaseTestCase.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/BaseTestCase.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/BaseTestCase.java	(working copy)
> @@ -56,8 +56,8 @@
>              "2",
>              "3",
>              "  notInBean  ",
> -            new Integer(1),
> -            new Integer(2),
> +            Integer.valueOf(1),
> +            Integer.valueOf(2),
>              null,
>              null,
>              new Date(),
> @@ -69,8 +69,8 @@
>              "5",
>              "6",
>              "  notInBean  ",
> -            new Integer(3),
> -            new Integer(4),
> +            Integer.valueOf(3),
> +            Integer.valueOf(4),
>              null,
>              null,
>              new Date(),
> Index: src/test/org/apache/commons/dbutils/MockResultSet.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/MockResultSet.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/MockResultSet.java	(working copy)
> @@ -137,7 +137,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Byte((byte) 0)
> +                ? Byte.valueOf((byte) 0)
>                  : Byte.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -192,7 +192,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Integer(0)
> +                ? Integer.valueOf(0)
>                  : Integer.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -210,7 +210,7 @@
>          this.setWasNull(obj);
>  
>          try {
> -            return (obj == null) ? new Long(0) : Long.valueOf(obj.toString());
> +            return (obj == null) ? Long.valueOf(0) : Long.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
>              throw new SQLException(e.getMessage());
> @@ -243,7 +243,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Short((short) 0)
> +                ? Short.valueOf((short) 0)
>                  : Short.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -311,7 +311,7 @@
>              return this.isLast();
>          
>          } else if (methodName.equals("hashCode")) {
> -            return new Integer(System.identityHashCode(proxy));
> +            return Integer.valueOf(System.identityHashCode(proxy));
>          
>          } else if (methodName.equals("toString")) {
>              return "MockResultSet " + System.identityHashCode(proxy);
> Index: src/test/org/apache/commons/dbutils/QueryRunnerTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/QueryRunnerTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/QueryRunnerTest.java	(working copy)
> @@ -79,12 +79,12 @@
>              public Object invoke(Object proxy, Method method, Object[] args)
>                      throws Throwable {
>                  if (getParameterCount.equals(method)) {
> -                    return new Integer(types.length);
> +                    return Integer.valueOf(types.length);
>                  }
>                  if (getParameterType.equals(method)) {
>                      if (simulateOracle) throw new SQLException("Oracle fails when you call getParameterType");
>                      int arg = ((Integer)args[0]).intValue();
> -                    return new Integer(types[arg-1]);
> +                    return Integer.valueOf(types[arg-1]);
>                  }
>                  return null;
>              }
> Index: src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java	(working copy)
> @@ -77,7 +77,7 @@
>          assertEquals("6", row.getThree());
>          assertEquals("not set", row.getDoNotSet());
>          assertEquals(3, row.getIntTest());
> -        assertEquals(new Integer(4), row.getIntegerTest());
> +        assertEquals(Integer.valueOf(4), row.getIntegerTest());
>          assertEquals(null, row.getNullObjectTest());
>          assertEquals(0, row.getNullPrimitiveTest());
>          // test date -> string handling
> @@ -107,7 +107,7 @@
>          assertEquals("6", b.getThree());
>          assertEquals("not set", b.getDoNotSet());
>          assertEquals(3, b.getIntTest());
> -        assertEquals(new Integer(4), b.getIntegerTest());
> +        assertEquals(Integer.valueOf(4), b.getIntegerTest());
>          assertEquals(null, b.getNullObjectTest());
>          assertEquals(0, b.getNullPrimitiveTest());
>          // test date -> string handling
> Index: src/test/org/apache/commons/dbutils/TestBean.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/TestBean.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/TestBean.java	(working copy)
> @@ -29,7 +29,7 @@
>  
>      private int intTest = 0;
>  
> -    private Integer integerTest = new Integer(0);
> +    private Integer integerTest = Integer.valueOf(0);
>  
>      private String doNotSet = "not set";
>  
> Index: src/test/org/apache/commons/dbutils/MockResultSetMetaData.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/MockResultSetMetaData.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/MockResultSetMetaData.java	(working copy)
> @@ -64,7 +64,7 @@
>          String methodName = method.getName();
>  
>          if (methodName.equals("getColumnCount")) {
> -            return new Integer(this.columnNames.length);
> +            return Integer.valueOf(this.columnNames.length);
>  
>          } else if (
>                  methodName.equals("getColumnName")) {
> @@ -79,7 +79,7 @@
>                  return this.columnLabels[col];
>  
>          } else if (methodName.equals("hashCode")) {
> -            return new Integer(System.identityHashCode(proxy));
> +            return Integer.valueOf(System.identityHashCode(proxy));
>  
>          } else if (methodName.equals("toString")) {
>              return "MockResultSetMetaData " + System.identityHashCode(proxy);
> Index: src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java	(working copy)
> @@ -17,8 +17,8 @@
>  package org.apache.commons.dbutils.handlers;
>  
>  import java.sql.SQLException;
> -import java.util.Iterator;
>  import java.util.Map;
> +import java.util.Map.Entry;
>  
>  import org.apache.commons.dbutils.BaseTestCase;
>  import org.apache.commons.dbutils.ResultSetHandler;
> @@ -33,16 +33,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
>              assertNotNull(row);
>              assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("1");
>          assertEquals("1", row.get("one"));
>          assertEquals("2", row.get("TWO"));
> @@ -56,16 +55,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
>              assertNotNull(row);
>              assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("5");
>          assertEquals("4", row.get("one"));
>          assertEquals("5", row.get("TWO"));
> @@ -79,16 +77,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> -            assertNotNull(row);
> -            assertEquals(COLS, row.keySet().size());
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
> +        	assertNotNull(row);
> +        	assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("6");
>          assertEquals("4", row.get("one"));
>          assertEquals("5", row.get("TWO"));

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] [Closed] (DBUTILS-75) efficient usage from findbugs

Posted by "Henri Yandell (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DBUTILS-75?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Henri Yandell closed DBUTILS-75.
--------------------------------

    Resolution: Fixed

Looks good - thanks for the patch.

> efficient usage from findbugs
> -----------------------------
>
>                 Key: DBUTILS-75
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-75
>             Project: Commons DbUtils
>          Issue Type: Improvement
>    Affects Versions: 1.3
>         Environment: Inefficient use of keySet iterator instead of entrySet iterator
> Method invokes inefficient floating-point Number constructor; use static valueOf instead
>            Reporter: caixiaojian
>             Fix For: 1.4
>
>         Attachments: commons-dbutils.patch
>
>
> Index: src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java	(working copy)
> @@ -487,7 +487,7 @@
>          }
>          if (getUrlInt != null && getUrlString != null) {
>              assertEquals(null, getUrlInt.invoke(rs, 
> -                         new Object[] { new Integer(1) } ) );
> +                         new Object[] { Integer.valueOf(1) } ) );
>              assertTrue(rs.wasNull());
>              assertEquals(null, getUrlString.invoke(rs, 
>                           new Object[] { "column" } ) );
> @@ -496,7 +496,7 @@
>              URL u = new URL("http://www.apache.org");
>              rs2.setNullURL(u);
>              assertEquals(u, getUrlInt.invoke(rs, 
> -                         new Object[] { new Integer(1) } ) );
> +                         new Object[] { Integer.valueOf(1) } ) );
>              assertEquals(u, getUrlString.invoke(rs, 
>                           new Object[] { "column" } ) );
>          }
> @@ -830,19 +830,19 @@
>              return Boolean.FALSE;
>  
>          } else if (returnType.equals(Integer.TYPE)) {
> -            return new Integer(0);
> +            return Integer.valueOf(0);
>  
>          } else if (returnType.equals(Short.TYPE)) {
> -            return new Short((short) 0);
> +            return Short.valueOf((short) 0);
>  
>          } else if (returnType.equals(Double.TYPE)) {
>              return new Double(0);
>  
>          } else if (returnType.equals(Long.TYPE)) {
> -            return new Long(0);
> +            return Long.valueOf(0);
>  
>          } else if (returnType.equals(Byte.TYPE)) {
> -            return new Byte((byte) 0);
> +            return Byte.valueOf((byte) 0);
>  
>          } else if (returnType.equals(Float.TYPE)) {
>              return new Float(0);
> Index: src/test/org/apache/commons/dbutils/BaseTestCase.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/BaseTestCase.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/BaseTestCase.java	(working copy)
> @@ -56,8 +56,8 @@
>              "2",
>              "3",
>              "  notInBean  ",
> -            new Integer(1),
> -            new Integer(2),
> +            Integer.valueOf(1),
> +            Integer.valueOf(2),
>              null,
>              null,
>              new Date(),
> @@ -69,8 +69,8 @@
>              "5",
>              "6",
>              "  notInBean  ",
> -            new Integer(3),
> -            new Integer(4),
> +            Integer.valueOf(3),
> +            Integer.valueOf(4),
>              null,
>              null,
>              new Date(),
> Index: src/test/org/apache/commons/dbutils/MockResultSet.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/MockResultSet.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/MockResultSet.java	(working copy)
> @@ -137,7 +137,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Byte((byte) 0)
> +                ? Byte.valueOf((byte) 0)
>                  : Byte.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -192,7 +192,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Integer(0)
> +                ? Integer.valueOf(0)
>                  : Integer.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -210,7 +210,7 @@
>          this.setWasNull(obj);
>  
>          try {
> -            return (obj == null) ? new Long(0) : Long.valueOf(obj.toString());
> +            return (obj == null) ? Long.valueOf(0) : Long.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
>              throw new SQLException(e.getMessage());
> @@ -243,7 +243,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Short((short) 0)
> +                ? Short.valueOf((short) 0)
>                  : Short.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -311,7 +311,7 @@
>              return this.isLast();
>          
>          } else if (methodName.equals("hashCode")) {
> -            return new Integer(System.identityHashCode(proxy));
> +            return Integer.valueOf(System.identityHashCode(proxy));
>          
>          } else if (methodName.equals("toString")) {
>              return "MockResultSet " + System.identityHashCode(proxy);
> Index: src/test/org/apache/commons/dbutils/QueryRunnerTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/QueryRunnerTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/QueryRunnerTest.java	(working copy)
> @@ -79,12 +79,12 @@
>              public Object invoke(Object proxy, Method method, Object[] args)
>                      throws Throwable {
>                  if (getParameterCount.equals(method)) {
> -                    return new Integer(types.length);
> +                    return Integer.valueOf(types.length);
>                  }
>                  if (getParameterType.equals(method)) {
>                      if (simulateOracle) throw new SQLException("Oracle fails when you call getParameterType");
>                      int arg = ((Integer)args[0]).intValue();
> -                    return new Integer(types[arg-1]);
> +                    return Integer.valueOf(types[arg-1]);
>                  }
>                  return null;
>              }
> Index: src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java	(working copy)
> @@ -77,7 +77,7 @@
>          assertEquals("6", row.getThree());
>          assertEquals("not set", row.getDoNotSet());
>          assertEquals(3, row.getIntTest());
> -        assertEquals(new Integer(4), row.getIntegerTest());
> +        assertEquals(Integer.valueOf(4), row.getIntegerTest());
>          assertEquals(null, row.getNullObjectTest());
>          assertEquals(0, row.getNullPrimitiveTest());
>          // test date -> string handling
> @@ -107,7 +107,7 @@
>          assertEquals("6", b.getThree());
>          assertEquals("not set", b.getDoNotSet());
>          assertEquals(3, b.getIntTest());
> -        assertEquals(new Integer(4), b.getIntegerTest());
> +        assertEquals(Integer.valueOf(4), b.getIntegerTest());
>          assertEquals(null, b.getNullObjectTest());
>          assertEquals(0, b.getNullPrimitiveTest());
>          // test date -> string handling
> Index: src/test/org/apache/commons/dbutils/TestBean.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/TestBean.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/TestBean.java	(working copy)
> @@ -29,7 +29,7 @@
>  
>      private int intTest = 0;
>  
> -    private Integer integerTest = new Integer(0);
> +    private Integer integerTest = Integer.valueOf(0);
>  
>      private String doNotSet = "not set";
>  
> Index: src/test/org/apache/commons/dbutils/MockResultSetMetaData.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/MockResultSetMetaData.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/MockResultSetMetaData.java	(working copy)
> @@ -64,7 +64,7 @@
>          String methodName = method.getName();
>  
>          if (methodName.equals("getColumnCount")) {
> -            return new Integer(this.columnNames.length);
> +            return Integer.valueOf(this.columnNames.length);
>  
>          } else if (
>                  methodName.equals("getColumnName")) {
> @@ -79,7 +79,7 @@
>                  return this.columnLabels[col];
>  
>          } else if (methodName.equals("hashCode")) {
> -            return new Integer(System.identityHashCode(proxy));
> +            return Integer.valueOf(System.identityHashCode(proxy));
>  
>          } else if (methodName.equals("toString")) {
>              return "MockResultSetMetaData " + System.identityHashCode(proxy);
> Index: src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java	(working copy)
> @@ -17,8 +17,8 @@
>  package org.apache.commons.dbutils.handlers;
>  
>  import java.sql.SQLException;
> -import java.util.Iterator;
>  import java.util.Map;
> +import java.util.Map.Entry;
>  
>  import org.apache.commons.dbutils.BaseTestCase;
>  import org.apache.commons.dbutils.ResultSetHandler;
> @@ -33,16 +33,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
>              assertNotNull(row);
>              assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("1");
>          assertEquals("1", row.get("one"));
>          assertEquals("2", row.get("TWO"));
> @@ -56,16 +55,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
>              assertNotNull(row);
>              assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("5");
>          assertEquals("4", row.get("one"));
>          assertEquals("5", row.get("TWO"));
> @@ -79,16 +77,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> -            assertNotNull(row);
> -            assertEquals(COLS, row.keySet().size());
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
> +        	assertNotNull(row);
> +        	assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("6");
>          assertEquals("4", row.get("one"));
>          assertEquals("5", row.get("TWO"));

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (DBUTILS-75) efficient usage from findbugs

Posted by "Henri Yandell (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DBUTILS-75?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Henri Yandell updated DBUTILS-75:
---------------------------------

    Fix Version/s:     (was: 1.3)
                   1.4

> efficient usage from findbugs
> -----------------------------
>
>                 Key: DBUTILS-75
>                 URL: https://issues.apache.org/jira/browse/DBUTILS-75
>             Project: Commons DbUtils
>          Issue Type: Improvement
>    Affects Versions: 1.3
>         Environment: Inefficient use of keySet iterator instead of entrySet iterator
> Method invokes inefficient floating-point Number constructor; use static valueOf instead
>            Reporter: caixiaojian
>             Fix For: 1.4
>
>         Attachments: commons-dbutils.patch
>
>
> Index: src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/wrappers/SqlNullCheckedResultSetTest.java	(working copy)
> @@ -487,7 +487,7 @@
>          }
>          if (getUrlInt != null && getUrlString != null) {
>              assertEquals(null, getUrlInt.invoke(rs, 
> -                         new Object[] { new Integer(1) } ) );
> +                         new Object[] { Integer.valueOf(1) } ) );
>              assertTrue(rs.wasNull());
>              assertEquals(null, getUrlString.invoke(rs, 
>                           new Object[] { "column" } ) );
> @@ -496,7 +496,7 @@
>              URL u = new URL("http://www.apache.org");
>              rs2.setNullURL(u);
>              assertEquals(u, getUrlInt.invoke(rs, 
> -                         new Object[] { new Integer(1) } ) );
> +                         new Object[] { Integer.valueOf(1) } ) );
>              assertEquals(u, getUrlString.invoke(rs, 
>                           new Object[] { "column" } ) );
>          }
> @@ -830,19 +830,19 @@
>              return Boolean.FALSE;
>  
>          } else if (returnType.equals(Integer.TYPE)) {
> -            return new Integer(0);
> +            return Integer.valueOf(0);
>  
>          } else if (returnType.equals(Short.TYPE)) {
> -            return new Short((short) 0);
> +            return Short.valueOf((short) 0);
>  
>          } else if (returnType.equals(Double.TYPE)) {
>              return new Double(0);
>  
>          } else if (returnType.equals(Long.TYPE)) {
> -            return new Long(0);
> +            return Long.valueOf(0);
>  
>          } else if (returnType.equals(Byte.TYPE)) {
> -            return new Byte((byte) 0);
> +            return Byte.valueOf((byte) 0);
>  
>          } else if (returnType.equals(Float.TYPE)) {
>              return new Float(0);
> Index: src/test/org/apache/commons/dbutils/BaseTestCase.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/BaseTestCase.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/BaseTestCase.java	(working copy)
> @@ -56,8 +56,8 @@
>              "2",
>              "3",
>              "  notInBean  ",
> -            new Integer(1),
> -            new Integer(2),
> +            Integer.valueOf(1),
> +            Integer.valueOf(2),
>              null,
>              null,
>              new Date(),
> @@ -69,8 +69,8 @@
>              "5",
>              "6",
>              "  notInBean  ",
> -            new Integer(3),
> -            new Integer(4),
> +            Integer.valueOf(3),
> +            Integer.valueOf(4),
>              null,
>              null,
>              new Date(),
> Index: src/test/org/apache/commons/dbutils/MockResultSet.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/MockResultSet.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/MockResultSet.java	(working copy)
> @@ -137,7 +137,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Byte((byte) 0)
> +                ? Byte.valueOf((byte) 0)
>                  : Byte.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -192,7 +192,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Integer(0)
> +                ? Integer.valueOf(0)
>                  : Integer.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -210,7 +210,7 @@
>          this.setWasNull(obj);
>  
>          try {
> -            return (obj == null) ? new Long(0) : Long.valueOf(obj.toString());
> +            return (obj == null) ? Long.valueOf(0) : Long.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
>              throw new SQLException(e.getMessage());
> @@ -243,7 +243,7 @@
>  
>          try {
>              return (obj == null)
> -                ? new Short((short) 0)
> +                ? Short.valueOf((short) 0)
>                  : Short.valueOf(obj.toString());
>  
>          } catch (NumberFormatException e) {
> @@ -311,7 +311,7 @@
>              return this.isLast();
>          
>          } else if (methodName.equals("hashCode")) {
> -            return new Integer(System.identityHashCode(proxy));
> +            return Integer.valueOf(System.identityHashCode(proxy));
>          
>          } else if (methodName.equals("toString")) {
>              return "MockResultSet " + System.identityHashCode(proxy);
> Index: src/test/org/apache/commons/dbutils/QueryRunnerTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/QueryRunnerTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/QueryRunnerTest.java	(working copy)
> @@ -79,12 +79,12 @@
>              public Object invoke(Object proxy, Method method, Object[] args)
>                      throws Throwable {
>                  if (getParameterCount.equals(method)) {
> -                    return new Integer(types.length);
> +                    return Integer.valueOf(types.length);
>                  }
>                  if (getParameterType.equals(method)) {
>                      if (simulateOracle) throw new SQLException("Oracle fails when you call getParameterType");
>                      int arg = ((Integer)args[0]).intValue();
> -                    return new Integer(types[arg-1]);
> +                    return Integer.valueOf(types[arg-1]);
>                  }
>                  return null;
>              }
> Index: src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/BasicRowProcessorTest.java	(working copy)
> @@ -77,7 +77,7 @@
>          assertEquals("6", row.getThree());
>          assertEquals("not set", row.getDoNotSet());
>          assertEquals(3, row.getIntTest());
> -        assertEquals(new Integer(4), row.getIntegerTest());
> +        assertEquals(Integer.valueOf(4), row.getIntegerTest());
>          assertEquals(null, row.getNullObjectTest());
>          assertEquals(0, row.getNullPrimitiveTest());
>          // test date -> string handling
> @@ -107,7 +107,7 @@
>          assertEquals("6", b.getThree());
>          assertEquals("not set", b.getDoNotSet());
>          assertEquals(3, b.getIntTest());
> -        assertEquals(new Integer(4), b.getIntegerTest());
> +        assertEquals(Integer.valueOf(4), b.getIntegerTest());
>          assertEquals(null, b.getNullObjectTest());
>          assertEquals(0, b.getNullPrimitiveTest());
>          // test date -> string handling
> Index: src/test/org/apache/commons/dbutils/TestBean.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/TestBean.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/TestBean.java	(working copy)
> @@ -29,7 +29,7 @@
>  
>      private int intTest = 0;
>  
> -    private Integer integerTest = new Integer(0);
> +    private Integer integerTest = Integer.valueOf(0);
>  
>      private String doNotSet = "not set";
>  
> Index: src/test/org/apache/commons/dbutils/MockResultSetMetaData.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/MockResultSetMetaData.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/MockResultSetMetaData.java	(working copy)
> @@ -64,7 +64,7 @@
>          String methodName = method.getName();
>  
>          if (methodName.equals("getColumnCount")) {
> -            return new Integer(this.columnNames.length);
> +            return Integer.valueOf(this.columnNames.length);
>  
>          } else if (
>                  methodName.equals("getColumnName")) {
> @@ -79,7 +79,7 @@
>                  return this.columnLabels[col];
>  
>          } else if (methodName.equals("hashCode")) {
> -            return new Integer(System.identityHashCode(proxy));
> +            return Integer.valueOf(System.identityHashCode(proxy));
>  
>          } else if (methodName.equals("toString")) {
>              return "MockResultSetMetaData " + System.identityHashCode(proxy);
> Index: src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java
> ===================================================================
> --- src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java	(revision 1025562)
> +++ src/test/org/apache/commons/dbutils/handlers/KeyedHandlerTest.java	(working copy)
> @@ -17,8 +17,8 @@
>  package org.apache.commons.dbutils.handlers;
>  
>  import java.sql.SQLException;
> -import java.util.Iterator;
>  import java.util.Map;
> +import java.util.Map.Entry;
>  
>  import org.apache.commons.dbutils.BaseTestCase;
>  import org.apache.commons.dbutils.ResultSetHandler;
> @@ -33,16 +33,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
>              assertNotNull(row);
>              assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("1");
>          assertEquals("1", row.get("one"));
>          assertEquals("2", row.get("TWO"));
> @@ -56,16 +55,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
>              assertNotNull(row);
>              assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("5");
>          assertEquals("4", row.get("one"));
>          assertEquals("5", row.get("TWO"));
> @@ -79,16 +77,15 @@
>          assertNotNull(results);
>          assertEquals(ROWS, results.size());
>  
> -        Iterator<Object> iter = results.keySet().iterator();
>          Map<String,Object> row = null;
> -        while (iter.hasNext()) {
> -            Object key = iter.next();
> -            assertNotNull(key);
> -            row = results.get(key);
> -            assertNotNull(row);
> -            assertEquals(COLS, row.keySet().size());
> +        for(Entry<Object, Map<String, Object>> entry : results.entrySet())
> +        {
> +        	Object key = entry.getKey();
> +        	assertNotNull(key);
> +        	row = entry.getValue();
> +        	assertNotNull(row);
> +        	assertEquals(COLS, row.keySet().size());
>          }
> -
>          row = results.get("6");
>          assertEquals("4", row.get("one"));
>          assertEquals("5", row.get("TWO"));

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira