Derby client driver

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
 *
 * @author user
 */
public class DBConnect {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
    try {
        
        String host = "Jdbc:derby://localhost:1527/admin1";
        String uName = "admin1";
        String uPass = "admin1";
        Connection con = DriverManager.getConnection(host, uName, uPass);
        
        Statement stmt = con.createStatement();
        String sql = "SELECT * FROM Workers";
        ResultSet rs = stmt.executeQuery(sql);
        
    while (rs.next()) {
        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");
        
        String p = id_col + " " + first_name + " " + last_name + " " +job;
        System.out.println(p);
    }
    }
    catch (SQLException err) {
        System.out.println( err.getMessage());
    }
    }
    
}