Java - Do I need classes in my front end that match my database tables?

[Corwin Moyne]

Hello. I am a little confused. Up to now my Java college projects have not been connected to a database. Last semester we serialized the data we wanted to keep.

I have been asked to do a class diagram for a new project that will have a database backend and a Java frontend. The project is for a cinema and will store movies etc in a database. If all the relevant info is in the database, do I need classes in the frontend that match the tables are do I just use the frontend to manipulate the info using sql?

[edgeworks]

Yes, you need movie class. Store the data reading from database and display as and when it is required. Query database only when data is not available in memory.

[rishiraj88]

You just use the frontend to manipulate the info using sql, if you are very clear about which columns of database table to map to which data members of java objects. No need to create similar hierarchies or relations in database and java frontend.

Hope it helps.

[rishiraj88]

You just use the frontend to manipulate the info using sql, if you are very clear about which columns of database table to map to which data members of java objects. No need to create similar hierarchies or relations in database and java frontend.

Hope it helps.