wood burning stoves 2.0*
The moose likes Developer Certification (SCJD/OCMJD) and the fly likes UrlyBird :  Queries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Certification » Developer Certification (SCJD/OCMJD)
Bookmark "UrlyBird :  Queries" Watch "UrlyBird :  Queries" New topic
Author

UrlyBird : Queries

Yogesh Chhawasaria
Ranch Hand

Joined: Apr 02, 2004
Posts: 53
I got lotsa queries in my urlybird asignment

1.
Per DB description
4 byte numeric, magic cookie value. Identifies this as a data file
Q. Magic Cookie Value - What should be my role in that?? Do I need to Hardcode this somewhere and check everytime the program is executed whether the db file has this cookie ??

2.
Per Instructions,
It must allow the user to search the data for all records, or for records where the name and/or location fields exactly match values specified by the user.

Q. Does all records mean the deleted ones too.
Do i have to provide search facility for all the columns possible like smoking,price etc or only name/location

3.
Flag indicating if smoking is permitted. Valid values are "Y" indicating a smoking room, and "N" indicating a non-smoking room
Q . Smoking Y/N
When a user opts for non smoking room Do i need to display Ones with 'Y' flag too As (Practicaly)its upto customer not smoking in a room but booking one that allows smoking.

4.
public void update(int recNo, String[] data, long lockCookie)
and delete

Assignment only describes that we should alow CSR to provide booking facility But these two methods in interfaces does it suggest that CSR can also Update and Delete a particualr record
Should the gui for the same be provided

5. public String[] read(int recNo) throws RecordNotFoundException;
thers no unique recordid in my db schema what does the int recno refer to???

Thanks in Advance


When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
Anton Golovin
Ranch Hand

Joined: Jul 02, 2004
Posts: 476
I got lotsa queries in my urlybird asignment

1.
Per DB description
4 byte numeric, magic cookie value. Identifies this as a data file
Q. Magic Cookie Value - What should be my role in that?? Do I need to Hardcode this somewhere and check everytime the program is executed whether the db file has this cookie ??

- Yes, since the program must allow users to change data files or to find data files, it needs to know which file is a data file.

2.
Per Instructions,
It must allow the user to search the data for all records, or for records where the name and/or location fields exactly match values specified by the user.

Q. Does all records mean the deleted ones too.
Do i have to provide search facility for all the columns possible like smoking,price etc or only name/location

- No, deleted ones are gone. What it may mean, depending on how you write your application, is all records or only bookable records. I chose to show all bookable records. It cuts off records that can never be used, and it cuts down network traffic.

3.
Flag indicating if smoking is permitted. Valid values are "Y" indicating a smoking room, and "N" indicating a non-smoking room
Q . Smoking Y/N
When a user opts for non smoking room Do i need to display Ones with 'Y' flag too As (Practicaly)its upto customer not smoking in a room but booking one that allows smoking.

- Since there is no search option for smoking or non-smoking fields, both will be shown.


4.
public void update(int recNo, String[] data, long lockCookie)
and delete

Assignment only describes that we should alow CSR to provide booking facility But these two methods in interfaces does it suggest that CSR can also Update and Delete a particualr record
Should the gui for the same be provided

- To book a record, the update method will need to be used. The delete method should be implemented, but it is not used for this application.

5. public String[] read(int recNo) throws RecordNotFoundException;
thers no unique recordid in my db schema what does the int recno refer to???

- The recNo refers to the sequential record numbering of records found in the data file.

Thanks in Advance[/QB]


Anton Golovin (anton.golovin@gmail.com) SCJP, SCJD, SCBCD, SCWCD, OCEJWSD, SCEA/OCMJEA [JEE certs from Sun/Oracle]
Yogesh Chhawasaria
Ranch Hand

Joined: Apr 02, 2004
Posts: 53
Originally posted by Anton Golovin:

- Since there is no search option for smoking or non-smoking fields, both will be shown.


There are seven fields in my database schema
name,location,size,smoking,rate,date,owner

Am I not supposed to provide search option (GUI Widgets) for all these columns like name, location,size,smoking,rate

As per Intructions,
The new application, using the existing data file format, must allow the CSRs to generate a list of accomodations that match a customer's criteria.
...
...
It must allow the user to search the data for all records, or for records where the name and/or location fields exactly match values specified by the user.

So is searching should be caried out only on name/location and not on any other option???
How can we define "criteria"

Anton Golovin
Ranch Hand

Joined: Jul 02, 2004
Posts: 476
In my project, it was only for name and location. I did not provide anything outside the assignment's scope.
 
Don't get me started about those stupid light bulbs.
 
subject: UrlyBird : Queries
 
Similar Threads
NX:[URLyBird]How to use the specified Data File Format?
URLyBird - Maybe my database file come messed !! Helpp me
How to start with Data File - URLyBird 1.3.3
NX: URLyBird questions about database
URLyBird Data File Format