Show Bid Request SQL queries using JAVA Bid Request Id: 13342 Bookmark in my 'To Do' list Posted by: otteri_10 (3 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Unverified Approved on: Apr 12, 2002 3:56:12 PM EDT Bidding Closes: Apr 14, 2002 4:06:15 PM EDT Viewed (by coders): 275 times Deadline: 4/16/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Database, Java Enter chat room for this bid request (0 active users at Sep 19, 2003 7:30:24 AM EDT) Description: ASSIGNMENT #2 1. Code a Java class suser that contains a main method that will test the s class. Do not place suser within the s_p package. Have suser test s class by: a. creating s records: S1, Jones, 10, Boston S2, Smith, 20, Paris b. using the printall method to print all the s records. c. using the select method to print the S2 record. d. changing the name of Smith to Solomon. e. using the select method to prove the name was changed. f. deleting the S1 record. g. using the printall method to prove that S1 was deleted. Make sure that you print (using println) labels in your output so I can easily identify the output in (b) - (g). 2. Code a Java class actives in the package s_p. actives extends s so that it has a new private field sp of type set.sp holds references to the p records for the parts that the supplier supplies. The constructor for actives takes as its arguments the snum,sname, status, city, of the new actives record, as well as the maximum number of parts the supplier can supply and a return code argument. The constructor then initializes the s fields of the new actives record, adds the new actives record to the s allset, and creates the sp set for the new actives record. The return code is -1 if the s allset is full, and 0 otherwise. Also, code in actives a new method insertp that takes a pnum as its argument, and then adds the indicated part to the sp set of the actives record. insertp returns -1 if the sp set is full, and 0 otherwise. Override the s print method with an actives print method that will print the s information for the actives record and then print the p information for the parts referenced in the sp set of the actives record. Code a printp method in actives that just prints the p information for the parts referenced in the sp set of the actives record. Code a deletep method in actives that takes a pnum as its argument and deletes that part from the sp set of the actives record. If the p record was found, deletep returns -1.Otherwise, deletep returns -1. Finally, code a selectp method in actives that takes a pnum as its argument and prints the p information for all the p records, referenced in the sp set of the actives record,that match the pnum argument.selectp returns the number of hits. THERE IS LITTLE MORE PART HERE BUT COULD NOT FIT IN . WILL GIVE THAT IF YOU R WILLING TO DO. Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased. Platform: Do it in the SQLPLUS environment, but will provide the tables once you are willing to do the project. Must be 100% finished and received by buyer on: Apr 16, 2002 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Special Conditions / Other: It's important to get this working. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! CodeWarrior2000 (5 ratings) in pittsburgh, Pennsylvania United States Bid id: 148,125   $30 (USD) Apr 13, 2002 2:29:51 AM EDT  10 (Excellent)     I am a sun certified java programmer. Will do this in time.           There are 1 private replies to/from CodeWarrior2000. Click here to view them.