![]() The first one represents a column in the database – DBColumn. For the purpose of our project we have created two more classes. The classes that provide us with this information are DBConnection, which binds to the database and DBMetaData, which reads the database with the help of the DatabaseMetaData and ResultSet classes of the Java platform.Ģ. We also want the relationships in the database, with the primary and foreign keys. In general we are interested in the names of the tables, the columns in them with column name, column data type and column data size. ![]() Select upper(concat(firstname, ,lastname)) as Actor Name from actor 2a. Display the first and last name of each actor in a single column in upper case letters. SELECT firstname, lastname from actor 1b. We have created two classes for connecting to the sakila MySql database and reading the metadata. Display the first and last names of all actors from the table actor. We create several helper classes that will handle the connection to the database and re-creation of the database metadata in a format which we can use to build the DB diagram.ġ. The structure of the Class Diagram Java project. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |