The language is simple to begin with, and can
be quite straight forward to understand. Wanting to select items from a
table, you use something called an sql query.SELECT FirstName, LastName
FROM EmployeeTable
This query will look for a table called EmployeeTable from
the database on your current connection, then look in the two columns
FirstName and LastName and pull all the information from every
record. Meaning that a record equates to a row of 'data' in the table.
You can also add conditions to the query, so that you can selective pull
out the data. Maybe, you want to know last names where the name is Smith?
You would add a second line to the query as follows:
SELECT FirstName, LastName
FROM EmployeeTable
WHERE LastName = 'SMITH'
Now we get all of the employees from the table named Smith. Or,
non if there is a lack of Smiths in your employee names.
Yes. The language is very easy, when you are working with a local server
in your lab, but I am going to write about a few things when using SQL and
Java together that make you thin what you did at home, might just be wrong.
