JavaConnecting2DB

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package database_console;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import java.sql.Statement;
import java.sql.ResultSet;

/**
 *
 * @author Stoyan
 */
public class DBConnect {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
//C:\Program Files\Java\jdk1.8.0_25\db\lib\derbyclient.jar
        try {
            String host = "jdbc:derby://localhost:1527/Employees";
            String uName = "stoyanUserName";
            String uPass= "password";
            Connection con = DriverManager.getConnection( host, uName, uPass );

            Statement stmt = con.createStatement( );
            String SQL = "SELECT * FROM Workers";
            ResultSet rs = stmt.executeQuery( SQL );

            while(rs.next()) {
                int id_col = rs.getInt("ID");
                String first_name = rs.getString("First_Name");
                String last_name = rs.getString("Last_Name");
                String job = rs.getString("Job_Title");
                System.out.println( id_col + " " + first_name + " " + last_name + " " + job );
            }
            // Statement stmt = con.createStatement( RecordSet.TYPE_SCROLL_SENSITIVE );
        }
        catch ( SQLException err ) {
            System.out.println( err.getMessage( ) );
        }
    }

}