need to design a java jdbc program with three classes and test classes using derby. the classes are to manage the "EMPLOYEE" table which have the following fields (employee Id, first name, last name, position, salary and termination flag) the first class: (I will provide sample class so u can easily see how to do it) • FITConnection Connection class The second is the mapping class to manipulate the table( I will provide sample codes so you can easily see how to do it) • Data-bean Data-bean class. The mapping is one-to-one, where columns of the mapped table are represented by members of data bean. Each instance of data bean is then stored in a row "record" at the mapped table. Each member of data bean is defined in a protected scope, and has his own public accessor "getter and setter" method. Data-bean has two constructor methods one with no parameter (initiate members with its predefined initial values) and the other with a passed parameter of type data-bean itself used for both initiate the new instance with the passed one and for copy already exist one into a new one. Data-bean also contains getter for the mapping values if exist for its members which used for mapping a static values for a specific member (i.e. Active Flag must be Yes or No) The third class is here ( I will provide sammple code to so u can easily do it) • Data-access-bean Data-access-bean class should have the following function which required implementing database, as follows: • "retrieve" method used for retrieving record from the database and return "ArrayList" of objects of type data-bean. • "insert" method used for inserting a new record for the database mapped table. • "update" method used for updating an existing record for the database mapped table. • "delete" method used for delete already existing record from the database mapped table
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
* * *This broadcast message was sent to all bidders on Saturday Oct 18, 2008 6:53:26 PM:
IF YOU NEED CLARIFICATIONS LET ME EKNOW
develop the required classes for managing the "EMPLOYEE" table which have the following fields (employee Id, first name, last name, position, salary and termination flag) and provide method that will be used to create the "EMPLOYEE" table with its fields. Also, develop a testing class that will be used for testing data-access-bean methods . Write a document and provide evidence for developed methods and describing your experience and how could you enhance the above model for better performance I HAVE SAMPLE CODE SO YOU CAN SEE HOW IT CAN BE DONE