File path: /sql12/plugins/smarttools/src/net/sourceforge/squirrel_sql/plugins/smarttools/SmarttoolsHelper.java | File path: /sql12/plugins/smarttools/src/net/sourceforge/squirrel_sql/plugins/smarttools/SmarttoolsHelper.java | |||
Method name: int checkColumnData(Statement, String)
|
Method name: int getRowCount(Statement, String)
|
|||
Number of AST nodes: 6 | Number of AST nodes: 6 | |||
1 | int resultFound = 0;↵ | 1 | int rowCount = 0;↵ | |
2 | ResultSet rs = stmt.executeQuery(sql);↵ | 2 | ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM " + tableName);↵ | |
3 | if (rs.next())↵ | 3 | if (rs.next())↵ | |
4 | {↵ | 4 | {↵ | |
5 | resultFound = rs.getInt(1);↵ | 5 | rowCount = rs.getInt(1);↵ | |
6 | }↵ | 6 | }↵ | |
7 | rs.close();↵ | 7 | rs.close();↵ | |
8 | return resultFound; | 8 | return rowCount; | |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 1 |
Number of non-refactorable cases | 0 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 0.1 |
Clones location | Clones are declared in the same class |
Number of node comparisons | 20 |
Number of mapped statements | 6 |
Number of unmapped statements in the first code fragment | 0 |
Number of unmapped statements in the second code fragment | 0 |
Time elapsed for statement mapping (ms) | 1.1 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | int resultFound = 0; |
| 1 | int rowCount = 0; | ||||||||||
2 | ResultSet rs = stmt.executeQuery(sql); |
| 2 | ResultSet rs = stmt.executeQuery("SELECT COUNT(*) FROM " + tableName); | ||||||||||
3 | if (rs.next()) | 3 | if (rs.next()) | |||||||||||
4 | resultFound = rs.getInt(1); |
| 4 | rowCount = rs.getInt(1); | ||||||||||
5 | rs.close(); | 5 | rs.close(); | |||||||||||
6 | return resultFound; |
| 6 | return rowCount; |
Row | Violation |
---|