view release on metacpan or  search on metacpan

examples/corpus/DBFriends2.java  view on Meta::CPAN

                                  "Phone CHAR (15), Email CHAR(30), " +
                                    "Age TINYINT (3), Married BOOL, " +
                              "NumKids TINYINT (3), Sport CHAR(20) )" 
            );
            stmt.executeQuery( 
             "CREATE TABLE SportsClub ( Name CHAR (30) PRIMARY KEY, " +
                                  "Age TINYINT (3), Sport CHAR(20), " +
                                   "Level Char(20) )" 
            );
            stmt.executeQuery( 
               "LOAD DATA LOCAL INFILE 'Friends.txt' INTO TABLE " +
                                        " Friends" ); 
            stmt.executeQuery( 
                "LOAD DATA LOCAL INFILE 'SportsClub.txt' INTO " +
                              " TABLE SportsClub" ); 

            // which of the Friends also play tennis at the club:
            ResultSet rs = stmt.executeQuery(
               "SELECT Friends.Name, SportsClub.Level FROM Friends, " 
                 + "SportsClub WHERE " 
                 + "Friends.Name = SportsClub.Name AND "
                 + "Friends.Sport = SportsClub.Sport AND "
                 + "Friends.Sport = 'tennis' " );

examples/corpus_with_java_and_cpp/DBFriends2.java  view on Meta::CPAN

                                  "Phone CHAR (15), Email CHAR(30), " +
                                    "Age TINYINT (3), Married BOOL, " +
                              "NumKids TINYINT (3), Sport CHAR(20) )" 
            );
            stmt.executeQuery( 
             "CREATE TABLE SportsClub ( Name CHAR (30) PRIMARY KEY, " +
                                  "Age TINYINT (3), Sport CHAR(20), " +
                                   "Level Char(20) )" 
            );
            stmt.executeQuery( 
               "LOAD DATA LOCAL INFILE 'Friends.txt' INTO TABLE " +
                                        " Friends" ); 
            stmt.executeQuery( 
                "LOAD DATA LOCAL INFILE 'SportsClub.txt' INTO " +
                              " TABLE SportsClub" ); 

            // which of the Friends also play tennis at the club:
            ResultSet rs = stmt.executeQuery(
               "SELECT Friends.Name, SportsClub.Level FROM Friends, " 
                 + "SportsClub WHERE " 
                 + "Friends.Name = SportsClub.Name AND "
                 + "Friends.Sport = SportsClub.Sport AND "
                 + "Friends.Sport = 'tennis' " );