public static List<Player> getAllBowler() {
        List<Player> bowler = new ArrayList<Player>();

        try {

           // PreparedStatement getBatsmanstmt = con.prepareStatement("  SELECT * FROM iplteam_player_battingstatistics,iplteam_player WHERE iplteam_player.PlayerID = 1 	AND (iplteam_player_battingstatistics.PlayerID = iplteam_player.PlayerID AND iplteam_player_battingstatistics.TeamID =  iplteam_player.IPLTeamID) " );
           PreparedStatement getBowlerstmt = con.prepareStatement("SELECT * FROM iplteam_player_battingstatistics b,iplteam_player_bowlingstatistics bo,iplteam_player_fieldingstatistics fi,player p WHERE b.PlayerID=bo.PlayerID AND fi.PlayerID=bo.PlayerID  AND fi.PlayerID=b.PlayerID AND p.ID=b.PlayerID AND p.ID=fi.PlayerID AND p.ID=bo.PlayerID AND p.Speciality='Bowler'");
           ResultSet rs = getBowlerstmt.executeQuery();
          
            while (rs.next()) {

                Player pl=new Player();
                PlayerStatistic stat = new PlayerStatistic();
                
                stat.setBattingAvg(Double.parseDouble(rs.getString("Average")));
                stat.setBattingstrkRate(Double.parseDouble(rs.getString("StrikeRate")));
              //??????? bat.setBowlingAvg(Double.parseDouble(rs.getString("Average")));
                stat.setBowlingeconomy(Double.parseDouble(rs.getString("Economy")));
              //??????? bat.setBowlingstrkRate(Double.parseDouble(rs.getString("Average")));
//  give not null values f nt throwing an error               stat.setCatches(Integer.parseInt(rs.getString("Catches")));
//   give not null values f nt throwing an error             stat.setStumpings(Integer.parseInt(rs.getString("Stumpings")));
                
                
                pl.setPlayerStatistic(stat);
                pl.setId(rs.getString("PlayerID"));
                pl.setName(rs.getString("Name"));
                pl.setSpeciality(rs.getString("Speciality"));
                pl.setAge(Integer.parseInt(rs.getString("Age")) );
                bowler.add(pl);

            }
        } catch (SQLException ex) {
            throw new RuntimeException();
        }
        return bowler;


    }