| java.lang.Object org.ow2.easybeans.tests.common.helper.CreateDBCollegeHelper
CreateDBCollegeHelper | final public class CreateDBCollegeHelper (Code) | | Creates all sql queries used to create and delete all college database tables.
author: Gisele Pinheiro Souza author: Eduardo Studzinski Estima de Castro |
createTableCourse | public static String createTableCourse()(Code) | | Returns the query that creates the table course as follow.
Course (CodeCourse, NameCourse,CodeProf) Primary key: CodeCourse
the query used to create the table |
createTableCourseAllocation | public static String createTableCourseAllocation()(Code) | | Returns the query that creates the table courseallocation as follow.
CourseAllocation(CodeCourse,CodeStudent, Year) Primary key:
CodeCourse,CodeStudent
the query used to create the table |
createTablePeople | public static String createTablePeople()(Code) | | Returns the query that creates the table people as follow.
People(CodePeople, NamePeople,CodeUniversity) Primary key: CodePeople
the query used to create the table |
createTableUniversity | public static String createTableUniversity()(Code) | | Returns the query that creates the table university as follow.
University (CodeUniversity,NameUniversity) Primary key: CodeUniversity
the query used to create the table |
dropTableCourse | public static String dropTableCourse()(Code) | | Returns the query that deletes the table course.
the query used to delete the table |
dropTableCourseAllocation | public static String dropTableCourseAllocation()(Code) | | Returns the query that deletes the table courseAllocation.
the query used to delete the table |
dropTablePeople | public static String dropTablePeople()(Code) | | Returns the query that deletes the table people.
the query used to delete the table |
dropTableUniversity | public static String dropTableUniversity()(Code) | | Returns the query that deletes the table university.
the query used to delete the table |
|
|