Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(testSQL);
if (rs.next()) {
BigDecimal d = rs.getBigDecimal(1);
System.out.println("d="+d);
}
stmt.close();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(testSQL);
if (rs.next()) {
BigDecimal d = rs.getBigDecimal(1);
System.out.println("d="+d);
}
stmt.close();
Clone fragments detected by clone detection tool
File path: /sql12/plugins/dbcopy/test/adhoc/HSQLBigDecimalTest.java
|
|
File path: /sql12/plugins/dbcopy/test/adhoc/MySQLDecimalTest.java
|
Method name: void doTest()
|
|
Method name: void doTest()
|
Number of AST nodes: 6
|
|
Number of AST nodes: 6
|
|
1 | Statement stmt = con.createStatement();↵ | | 1 | Statement stmt = con.createStatement();↵
|
2 | ResultSet rs = stmt.executeQuery(testSQL);↵ | | 2 | ResultSet rs = stmt.executeQuery(testSQL);↵
|
3 | if (rs.next()) {↵ | | 3 | if (rs.next()) {↵
|
4 | BigDecimal d = rs.getBigDecimal(1);↵ | | 4 | BigDecimal d = rs.getBigDecimal(1);↵
|
5 | System.out.println("d="+d);↵ | | 5 | System.out.println("d="+d);↵
|
6 | }↵ | | 6 | }↵
|
7 | stmt.close(); | | 7 | stmt.close();
|
See real code fragment |
|
See real code fragment |
Summary
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 in different classes |
Number of node comparisons | 18 |
-
{Refactorable}
Mapping Summary
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.3 |
Clone type | Type 1 |
Mapped Statements
ID |
Statement |
|
ID |
Statement |
1 | Statement stmt = con.createStatement(); | | 1 | Statement stmt = con.createStatement(); |
2 | ResultSet rs = stmt.executeQuery(testSQL); | | 2 | ResultSet rs = stmt.executeQuery(testSQL); |
3 | if (rs.next()) | | 3 | if (rs.next()) |
4 | BigDecimal d = rs.getBigDecimal(1); | | 4 | BigDecimal d = rs.getBigDecimal(1); |
5 | System.out.println("d=" + d); | | 5 | System.out.println("d=" + d); |
6 | stmt.close(); | | 6 | stmt.close(); |
Precondition Violations (0)
Row |
Violation |