public Employee logEmployee(String usr, String pass) {
        System.out.println("Username = "+ usr+" Password = "+pass);
        Employee e = new Employee();
        Connection conn = cm.getConnection();
        if (conn != null) {
            ResultSet rs = null;
            PreparedStatement preparedStatement = null;
            try {
                String strQuery =
                        "SELECT employee_id, branch_id, password, firstName, lastName "
                                + "FROM employee WHERE employee_id=? AND password=?";
 
                preparedStatement = conn.prepareStatement(strQuery);
                preparedStatement.setString(1, usr);
                preparedStatement.setString(2, pass);
                rs = preparedStatement.executeQuery();
 
                while (rs.next()) {
                    e.setEmployeeID(rs.getString("employee_id"));
                    e.setBranchID(rs.getString("branch_id"));
                    e.setPassword(rs.getString("password"));
                    e.setFirstName(rs.getString("firstName"));
                    e.setLastName(rs.getString("lastName"));
                }
            }
            catch (SQLException ex) {
                ex.printStackTrace();
            }
            finally {
                try {
                    rs.close();
                    preparedStatement.close();
                }
                catch (SQLException sqle) {
                    sqle.printStackTrace();
                }
                catch (NullPointerException npe) {
                    npe.printStackTrace();
                }
                cm.putConnection(conn);
            }
        }
        return e;
    }
 
    public ArrayList<Employee> viewEmployees() {
        ArrayList<Employee> employee = new ArrayList<Employee>();
        Connection conn = cm.getConnection();
        if (conn != null) {
            ResultSet rs = null;
            PreparedStatement preparedStatement = null;
            Employee emp;
            try {
                String strQuery =
                        "SELECT employee_id, branch_id, firstName, lastName "
                                + "FROM employee ORDER BY lastName,firstName";
 
                preparedStatement = conn.prepareStatement(strQuery);
                rs = preparedStatement.executeQuery();
 
                while (rs.next()) {
                    emp = new Employee();
                    emp.setEmployeeID(rs.getString("employee_id"));
                    emp.setBranchID(rs.getString("branch_id"));
                    emp.setFirstName(rs.getString("firstName"));
                    emp.setLastName(rs.getString("lastName"));
                    employee.add(emp);
                }
            }
            catch (SQLException ex) {
                ex.printStackTrace();
            }
            finally {
                try {
                    rs.close();
                    preparedStatement.close();
                }
                catch (SQLException sqle) {
                    sqle.printStackTrace();
                }
                catch (NullPointerException npe) {
                    npe.printStackTrace();
                }
                cm.putConnection(conn);
            }
        }
        return employee;
    }

        try{
            EmployeeQueriesServiceLocator locator = new EmployeeQueriesServiceLocator();
            EmployeeQueries_PortType service = locator.getEmployeeQueries();
 
            //execution of any service method here
        }
        catch(ServiceException ex){
            ex.printStackTrace();
        }
        catch(RemoteException re){
            re.printStackTrace();
        }

Connection conn = null;
Statement stmt = null;
try {
  try {
    // do something
  } finally {
    if(stmt != null) stmt.close();
    if(conn != null) conn.close();
  }
} catch(Exception e) {
  e.printStackTrace();
}