The Cassandra Driver from Datastax very much mirrors the Java JDBC MySQL driver.
PreparedStatement are present in both drivers.
The Singleton Connection is from this question and answer: http://stackoverflow.com/a/24691456/671896
Feature wise, Cassandra 2 and 3 are identical. Cassandra 3 introduced a complete rewrite of the data storage system.