General Database Question - Tables in Classes

[Jim Stools]

Hopefully this will make some sense.. I have a database that has around 50
tables - I thought about putting each table in a class and the data
connection in a class then I could manage the (tables) classes with one data
connection. The business logic would open the database class then whatever
table class is needed, the close the tables and the connection.

The other way would be to open a data connection in each class. Since
mutiple tables could be open at the same time I would have one data
connection instead of multiple data connections at the same time. If I were
to open one connection for each (table) class, lets say 30 and I had 10 hits
on the web page at the same time, (30 * 10) I could have a possible 300 data
connections (with tables) open at one time. Any rough ideas would be greatly
appreciated.

class1 (open & close database connection)
class2 (table1)
class3 (table 2)
class4 (table 3)
class5 (business logic)
class6 (business logic)

class5: (most tables are needed) (business logic)
-- instances class1 (open)
-- instances class2
-- instances class3
-- instances class4
-- close all classes (tables and connection)

class6: (only 2 tables are needed) (business logic)
-- instances class1 (open)
-- instances class2
-- instances class3
-- close all classes (tables and connection)

Other way:
-- business logic class
-- class2 (open data connection & table)
-- class3 (open data connection & table)
-- class3 (open data connection & table)
-- close classes