automation/tincrepo/main/mpp/common/utilities/ccl/connectivity/jdbc/TestJDBCSelectSQL.java [31:53]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
                Statement stmt = conn.createStatement();
                if (null == stmt) {
                    System.out.println("connection create statement fail");
                    System.exit(1);
                }
                System.out.println("connection create statement success");

                String sql = "SELECT a FROM jdbctable ORDER BY a";
                ResultSet rs = stmt.executeQuery(sql);
                System.out.println("statement execute success : " + sql);
            
                int num = 0;
                while (rs.next()) {
                    System.out.println(rs.getInt("a"));
                    num++;
                }
                if (num != 2) {
                    System.out.println("SELECT ERROR : " + sql);
                    System.exit(1);
                }

                rs.close();
                stmt.close();
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



automation/tincrepo/main/mpp/common/utilities/ccl/connectivity/jdbc/TestJDBCTransactionCommit.java [39:61]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
                Statement stmt = conn.createStatement();
                if (null == stmt) {
                    System.out.println("connection create statement fail");
                    System.exit(1);
                }
                System.out.println("connection create statement success");

                String sql = "SELECT a FROM jdbctable ORDER BY a";
                ResultSet rs = stmt.executeQuery(sql);
                System.out.println("statement execute success : " + sql);
            
                int num = 0;
                while (rs.next()) {
                    System.out.println(rs.getInt("a"));
                    num++;
                }
                if (num != 2) {
                    System.out.println("SELECT ERROR : " + sql);
                    System.exit(1);
                }

                rs.close();
                stmt.close();
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -