sub foo
{
  my $class = shift;
  my $dbh   = $class->db_Main();
  my $sth   = $dbh->prepare_cached("SELECT ...");

  $sth->execute(...);
  #... usual DBI stuff
}