How do SQL and Java really works together?

Question

Hello. I have a machine project at college about making a relational database in SQL with Java. The situation of the database is that there is a recruitment agency for nurses. The nurses are either trained or ready for work and something like that. The queries are that you should be able to keep track of how many nurses are in a certain hosptial etc.The case is quite common and simple. However , my professor held a seminar on how to apply Java in our SQL project and sadly I wasn't able to attend it. Please tell me , is Java really a complicated and big issue as stated in my machine problem?

yes I have already taken a basic java course but i really have no idea on how complicated will it get if applied to SQL , it wont be taught in my class (java being applied to SQL) but the professor requires it to be on our project.

Answer 1

If you want to control the SQL yourself, use JDBC.

If you want to use a framework that hides more of the complexity, investigate Hibernate.

Answer 2

Java and SQL work together using the Java Database Connectivity drivers.
A tutorial from sun is available here http://java.sun.com/docs/books/tutorial/jdbc/index.html

Note, you will need to download the appropiate JDBC driver if you don't already have one from here http://developers.sun.com/product/jdbc/drivers

P.S.
On it's complexity, SQL and setting up and handling databases and such is relatively complex. If you already know about databases and SQL however, then the Java part should be simple.

If you have ever worked with databases and SQL before you'll be fine, otherwise you should try and take a SQL tutorial like this one http://www.w3schools.com/sql/default.asp and see if you can pick it up easily.

Answer 3

Java is simple, if you tried it, otherwise it is complicated.

Answer 4

Find tutorials on JDBC.