GeoTools : How to use the MySQLConnection class

Shell for JDBC transactions of all types. This provides a base class to the
database transactional classes.

            Logger LOGGER = Logger.getLogger("com.correlane.geotools");
            
// the database mockup and the users must be created before!
            db = new MysqlConnection ("localhost","3307","mockup");
            db.setLogin("mockuplog","mockuppass");
	    Connection dbConnection = db.getConnection();
	    LOGGER.info("connected");
		
	    java.sql.Statement statement = dbConnection.createStatement();
	    statement.executeUpdate("CREATE TABLE Con_Test(a int, b varchar(50))");
	    statement.executeUpdate("INSERT INTO Con_Test values(5, 'road')");
	    ResultSet rs = statement.executeQuery("SELECT * FROM Con_Test");
	    
	    rs.next();
	    statement.executeUpdate("DROP TABLE Con_Test");
	    rs.close();
	    statement.close();
	    LOGGER.info("disconnected");