Yes, the JDBC driver can be configured for SQL node failover (I, in fact, have set this up in production - and it works!), and load-balancing.
You simply have to tell the JDBC Driver about the additional SQL nodes in your connection URL , i.e.:
jdbc:mysql://[host],[failoverhost]/[database]?failOverReadOnly=false&[otherConnectionProperties]
Since you're using the NDB storage engine, you'll want to specify failOverReadOnly=false. The default is true because if you're using replication (not the cluster) any SQL node you failover to will be a read-only slave. But in the case of MySQL cluster, all SQL nodes are read-write, so you need to change this property to allow for this.
For load-balancing you can add this property to your connection url:
roundRobinLoadBalance=true
Check out this page for more details:
http://dev.mysql.com/doc/connector/j/en/cj-configuration-properties.html
Hope this helps,
Brian