Java Database Connectivity|JBDC Connectivity|Apache Netbeans Derby Connection|Derby Database

JDBC connection program using derby Database.
JDBC (Java Database Connectivity) is the Java API that manages connecting to a database, issuing queries and commands, and handling result sets obtained from the database.
Step #1: Loading Driver –Statement to load a driver: Class.forName("JDBCDriverClass");
Step #2: Establishing Connections –
Connection connection = DriverManager.getConnection(databaseURL);
Step #3: Creating and executing statements –
Creating statement: Statement statement = connection.createStatement();
Executing statement (for update, delete, insert):
 statement.executeUpdate("create table Temp (col1 char(5), col2 char(5))");
Executing statement (for select):
// Select the columns from the Student table
ResultSet resultSet = statement.executeQuery
("select firstName, mi, lastName from Student where lastName "
+ " = 'Smith'");
Step #4: Processing the resultset –
Executing statement (for select):
// Select the columns from the Student table
ResultSet resultSet = stmt.executeQuery
("select firstName, mi, lastName from Student where lastName "
+ " = 'Smith'");

Processing ResultSet (for select):
// Iterate through the result and print the student names
while (resultSet.next())
System.out.println(resultSet.getString(1) + " " + resultSet.getString(2)
+ ". " + resultSet.getString(3));
Step #5: Closing the connection – Requires explicitly closing all database resources versus relying on the JVM's garbage collection.
resultSet.close();
statement.close();
connection.close();