DataBase Lab

For the database lab, I want you to write an application that will build at least one table and allow a user to do something with it. What to do is up to you. My only implementation concern for this lab is that you have some experience with setting up JDBC and using it. If you do cool things I could give extra points ...

Given that you have a lot of freedom here, one thing I do want is to be able to look at these without hassles. So please do the following

• I give you the name you should use for the database (specifically oracle)and the driver location, etc in this Oracle setup file (temporarily using mySQL)

  • Here is a connection to Oracle that actually works (if you give it your username and password) Employee.java

  • Another specific java file for Oracle is here, but it needs the jdbc table to be set up since it worked for a previous machine below
    • here is the same example java program that connected just fine to our machine noodle (except for the username and password). Unfortunately, noodle is no longer with us
      and a non-gui version is here for the old mysql database on the machine noodle

• For your own use, I do not care how you build your table(s), however, for me to check the lab, you should have your java code CREATE the table. See this for an example.

• Do your processing
  • If you are not sure what this particular database allows, you can always use your non-graphics java program to create a connection to the database (i.e., establish a Connection (con) and use the getMetaData() method to create a DatabaseMetaData object (which has 133 methods to choose from) to see what the Database allows DatabaseMetaData.html )
    DatabaseMetaData dma = con.getMetaData ();
    
  • then you can use this java program to ask as much as you want; (if you are behind a firewall see firewall info). If you need to telnet over, if you are not using graphics to display the answers, it should be fine to run remotely
  • This, of course means that you connect to the actual database I will be using, so an account on the database is needed.
    • Register for a MySQL account using Update your existing account (WAIT currently we are going to Update existing accounts to get MySql accounts)
  • I do not need to see all these tests, this is just so you know what you can "legally" do on this database so I won't have to see all kinds of exceptions since you will already know what is allowed
  • At this point you might (reasonably) say, well, why don't I just go ahead and make the table(s) there ahead of time and then Anne can just use it when she grades my Database with the GUI from there?
    That is fine with me...all I care about is being able to connect without hassles - but don't forget that then it is yours and I will need permissions to access it
• When finished, DROP the table(s) and close connections so I can just go on with the next lab without worrying about table name(s) (if you did not make your own and give me access as mentioned above)
• See this page for explicit grading.

When you send me your labs, you can either hard-code connection information for Oracle in it, or prompt the user for the necessary paths, etc.